Php connection to MySQL database operations and application code

The following articles mainly introduce the actual operation process of connecting php to the MySQL database, as well as the description of the Code needed for actual operations, the following article describes the actual procedure of connecting php to the MySQL database and the actual application code.

 
 

  
  
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> 
 
 

PHP for MySQL

Open extension = php_MySQL.dll

 
 

  
  
<?php 
  
  
$servername = "127.0.0.1";  
  
  
$username = "root";  
  
  
$password = "123456";  
  
  
$conn = MySQL_connect($servername, $username, $password);  
 
 

Create a MySQL connection

 
 

  
  
If ($ conn ){
  
  
Echo "connection successful ";
  
  
}
  
  
// MySQL_select_db ("easytoo ");
 
 

Select to connect to the MySQL database

Or

 
 

  
  
MySQL_query("use easytoo",$conn); 
 
 

Select to connect to the MySQL database

 
 

  
  
MySQL_query("SET NAMES utf8");  
  
  
$rs = MySQL_query("select id from et_category"); 
 
 

Query and obtain a dataset

 
 

  
  
MySQL_num_rows($rs);  
 
 

Obtain the total number of record sets.

 
 

  
  
while($row= mysql _fetch_array($rs))  
 
 

Cyclic Dataset

 
 

  
  
{  
  
  
echo "$row[0]<br>";  
  
  
}  
  
  
mysql_free_result($rs);  
 
 

Release rs

 
 

  
  
mysql_close($conn); 
 
 

Close connection

 

 
 

  
  
?> 
 
 

The above content is an introduction to the connection of php to the MySQL database. I hope you will have some gains.