PHP Operation MySQL Database basic class Code _php tutorial

Copy CodeThe code is as follows:
$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 succeeded! ';
}
Close connection
Mysql_close ($connect);
?>

http://www.bkjia.com/PHPjc/736854.html www.bkjia.com true http://www.bkjia.com/PHPjc/736854.html techarticle Copy the code as follows: Php $dbhost = ' localhost '; $dbuser = ' root '; $dbpass = ' 123456 '; $dbname = ' products '; $connect =mysql_connect ($dbhost, $dbuser, $dbpass); if (! $connect) exit (' Data ...

