Administering MySQL Databases on the Web Using PHP

"Because the price is stored in the database as a float, you don't want to put slashes into it. You can achieve the same effect of filtering out any odd characters on this numerical field by calling doubleval(), which we discussed in Chapter 1, "PHP Crash Course. " This also takes care of any currency symbols that the user might have typed into the form.

"Again, you connect to the database by instantiating the mysqli object and setting up a query to send to the database. In this case, the query is an SQL INSERT:"

Complete Story

Related Stories:

• Installing Cherokee Web Server With PHP 5 & MySQL 5 Support On Ubuntu 8.10(Dec 04, 2008)
• Using Spawner To Populate SQL Database(Dec 03, 2008)
• MySQL 5.1 Released With Crashing Bugs(Dec 03, 2008)
• MySQL Founder Warns 5.1 Not Ready(Dec 01, 2008)
• Accessing Your MySQL Database from the Web with PHP(Nov 26, 2008)
• Book Review: SQL Hacks(Nov 21, 2008)