PHP Operation MySQL Database basic class Code _php instance

Copy Code code as follows:

<?php
$dbhost = ' localhost ';
$dbuser = ' root ';
$dbpass = ' 123456 ';
$dbname = ' products ';
$connect =mysql_connect ($dbhost, $dbuser, $dbpass);
if (! $connect) exit (' Database connection failed! ');
mysql_select_db ($dbname, $connect);
mysql_query (' Set names UTF8 ');
Inquire
$sql = "SELECT * from ' Category '";
$result =mysql_query ($sql);
while ($row =mysql_fetch_array ($result)) {
echo $row [' id '];
}
Insert
$sql = INSERT into ' category ' (' id ', ' name ') VALUES (NULL, ' ". $name.") ";
$result =mysql_query ($sql);
if (Mysql_affected_rows ()) {
Echo ' Insert succeeded, insert ID: ', mysql_insert_id ();
}else{
Echo ' Insert failed: ', mysql_error ();
}
Modify
$sql = "UPDATE ' category ' SET ' name ' = '". $name. "' WHERE ' id ' = '. $id. "'";
$result =mysql_query ($sql);
if (Mysql_affected_rows ()) {
Echo ' modified successfully! ';
}
Delete
$sql = "DELETE from ' category ' WHERE ' id ' = '". $id. "'";
$result =mysql_query ($sql);
if (Mysql_affected_rows ()) {
Echo ' Delete success! ';
}
Close connection
Mysql_close ($connect);
?>