zhu zhu's List: PHP And MySQL tutorial

• PHPMyAdmin
• There are a wide variety of fields and attributes available in MySQL
• The final field entered should not have a comma after it.
• You may be wondering why I have used VARCHAR fields for the phone/fax numbers even though they are made up of digits.
• prefer to use VARCHAR as it will allow dashes and spaces in the number, as well as textual numbers
• The id field will also be set as PRIMARY, INDEX, UNIQUE and will be set to auto_increment (found under Extra in PH
   PMyAdmin). The reason for this is that this will be the field identifier
• mysql_query($query);

  • For other type of SQL statements, INSERT, UPDATE, DELETE, DROP, etc, mysql_query() returns TRUE on success or FALSE on error.

5 more annotations...

• the main reson for learning a scripting language like PHP is because of the interaction with databases it can offer.
• Banner Rotation.
• Forums
• Databases.
• Websites.
• need three things to run PHP scripts which access MySQL databases.
• Firstly,
• need a webserver.
• PHP also needs to be installed on the server.
• Finally, you will also require MySQL.
• PHPMyAdmin on your server

  • on the database server
• basics of using PHP and MySQL together

10 more annotations...