Basic php code for mysql database operations

Basic php code for mysql database operations

This article mainly introduces the basic class code for php operations on mysql databases. For more information, see

The Code is as follows:

<? Php

$ Dbhost = 'localhost ';

$ Dbuser = 'root ';

$ Dbpass = '20140901 ';

$ 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 successful, insert ID: ', mysql_insert_id ();

} Else {

Echo 'insertion failed: ', mysql_error ();

}

// Modify

$ SQL = "UPDATE 'category' SET 'name' = '". $ name. "'where' id' ='". $ id ."'";

$ Result = mysql_query ($ SQL );

If (mysql_affected_rows ()){

Echo 'modification successful! ';

}

// Delete

$ SQL = "DELETE FROM 'category' WHERE 'id' = '". $ id ."'";

$ Result = mysql_query ($ SQL );

If (mysql_affected_rows ()){

Echo 'deleted! ';

}

// Close the connection

Mysql_close ($ connect );

?>