Bad Wolf PHP Learning Counter Example Code_PHP Tutorial

Then create the file as follows, the first step is to connect to the database, then write, then read.

Copy the code The code is as follows:

< ;!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
< ?
$mysql_server_name = "localhost";
$mysql_username = "root";
$mysql_password = "";
$mysql_database = "db";
// Capture ip
$ip = getenv ("REMOTE_ADDR");
//Establish a connection--through (server location, user name, user password)
$conn = mysql_connect($mysql_server_name,$mysql_username,$ mysql_password);
// Prepare sql syntax This syntax is new information
$sql = "INSERT INTO `num` (`name`,`ip`, `new`) VALUES ('badwolf',' $ip','1');";
//Select the database you want to process
mysql_select_db($mysql_database,$conn);
//Perform query
$result = mysql_query ($sql);
//Result and release the connection
mysql_close($conn);
//--------------------- ---------------------------------------------
// The following is the printed information

//Establish a connection through (server location, user name, user password)
$conn = mysql_connect($mysql_server_name,$mysql_username,$mysql_password);
//Get ready sql syntax This syntax is for reading data
$sql = "SELECT COUNT(*) FROM `num` WHERE name='badwolf' ";
//Perform query
$result = mysql_db_query($mysql_database,$sql,$conn);
//Fetch the query results
$row = mysql_fetch_row($result);
//Print out all fields of the data
//print_r($row);
//Clear the results of the query
mysql_free_result($result);
?>

Bad Wolf Safety Network php counter

"STYLE3">Persons

http://www.bkjia.com/PHPjc/319109.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/319109.htmlTechArticleThen create the file as follows. The first step is to connect to the database, then write, then read. Copy the code as follows: !DOCTYPEhtmlPUBLIC "-//W3C//DTDXHTML1.0Transitional//EN""http://www.w3.org/TR/xhtml1/D...