PHP operating the MySQL database basic class code

This article mainly introduces the PHP operation of the MySQL database basic class code, need friends can refer to the

The code is 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 '); Query $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 ' deleted successfully! '; }//Close connection mysql_close ($connect);?>