MySQL PHP Exampler

   mysql_connect("localhost", "username", "password") or die(mysql_error());
   mysql_select_db("test") or die(mysql_error());
 
   echo " Step 1. Insert data
";
   $sql = "INSERT INTO users (name,city,web,age) VALUES ('Tom','Vegas','www.tom.com',5)";
   $result = mysql_query($sql);
 
   if ($result){
      echo "Data was inserted! ";   
   } else {
      echo "An error occured during insert! ";   
   }
 
   $result = mysql_query("SELECT * FROM users");   
 
   while($row = mysql_fetch_assoc($result)){
      echo "ID: ".$row['id'].", Name:".$row['name']
          .", City:".$row['city'].", Age:".$row['age']." ";
   }
 
   echo " Step 2. Update data
";
   $sql = "UPDATE users SET age=45 WHERE name='Tom'";
   $result = mysql_query($sql);
 
   if ($result){
      echo "Data was updated! ";   
   } else {
      echo "An error occured during update! ";   
   }
 
   $result = mysql_query("SELECT * FROM users");   
 
   while($row = mysql_fetch_assoc($result)){
      echo "ID: ".$row['id'].", Name:".$row['name']
          .", City:".$row['city'].", Age:".$row['age']." ";
   }
 
   echo " Step 3. Remove data
";
   $sql = "DELETE FROM users WHERE name='Tom'";
   $result = mysql_query($sql);
 
   if ($result){
      echo "Data was removed! ";   
   } else {
      echo "An error occured during remove! ";   
   }
 
   $result = mysql_query("SELECT * FROM users");   
 
   while($row = mysql_fetch_assoc($result)){
      echo "ID: ".$row['id'].", Name:".$row['name']
          .", City:".$row['city'].", Age:".$row['age']." ";
   }
 
?>