Hoho, just learned, record it~

1. First create a new database, create a new data table test in it, and insert two records as shown in the picture

2. Create a new php file.

Code to connect to the database:

$conn=mysql_connect("localhost","root","");//連接數(shù)據(jù)庫(kù)服務(wù)器
	if (!$conn){
	  	die('Could not connect: ' . mysql_error());
	}
	mysql_select_db("mytest",$conn);//選擇數(shù)據(jù)庫(kù)mytetst
	mysql_query("set names utf8");//設(shè)置編碼格式

mysql_connect(servername,username,password);

3. Execute database statements, such as query statements

$arr=mysql_query("select * from test",$conn);

Output query results

       while($row = mysql_fetch_array($arr)){
		echo $row['id'] . " " . $row['num'];
		echo "<br />";
	}

—————————————————————————— ——————————————

Implementation results:

When you click to find all, it displays:

When you search by id, enter 1 and it displays:

Complete code:

	
		

			

				
			
			

				按id號(hào)查找：
			

				
			
		
	

";

	echo "