PHP MySQL Tutorial

By Angela Bradley, About.com Guide

We can use the same method of using SQL commands to populate our database as we did to create it. Here is an example:

 <?php 
 // Connects to your Database 
 mysql_connect("your.hostaddress.com", "username", "password") or die(mysql_error()); mysql_select_db("Database_Name") or die(mysql_error()); 
 mysql_query("INSERT INTO tablename VALUES ( 'Bill', 29, 'Ford' ), ( 'Mike', 16, 'Beetle' ), ( 'Alisa', 36, 'Van' )"); 
 Print "Your table has been populated"; 
 ?> 

Previous

• Connect to MySQL
• Retrieve Data
• SQL Queries with PHP
• Create Tables
• Insert Into Tables

Next