PHP connects to MYSQL database instance

The project I am working on now requires PHP to connect to the MySQL database. Although I have learned it before, I have basically forgotten it now. I found the solution by searching for relevant information. The editor will share the specific method on the Script Home platform. Everyone learns

The specific code is as follows:

<?php
//设置字符集
header(&#39;Content-Type: text/html; charset=utf8&#39;);
//连接数据库
$link = mysql_connect("localhost","root","123456");
if(!$link){
echo &#39;数据库连接失败...<br>&#39;;
exit(-1);
}else{
echo "数据库连接成功...<br>";
}
//选择一个数据库作为默认数据库
mysql_select_db(&#39;php_sjk&#39;);
//执行sql插入语句
$sql = "INSERT INTO zh VALUES (NULL,&#39;王杰&#39;,&#39;123456&#39;)";
$cr = mysql_query($sql);
//判断是否插入成功
if(!$cr){
echo "数据插入失败。<br>";
}else{
echo "数据插入成功。<br>";
}
//执行sql查询语句
$sql = "select * from zh";
$cr = mysql_query($sql);
//得到返回的结果集,并循环输出
echo "数据展示：<br><br><br>";
while($a = mysql_fetch_row($cr)){
echo "{$a[0]}——{$a[1]}——{$a[2]}<br>";
}
//关闭数据库连接
mysql_close($link);
?>

This is all about the code for PHP to connect to the MYSQL database. Everyone is welcome to collect, thank you!

Related recommendations:

A case of php connecting to mysql using PDO query operation

php mysql connection topic: The most complete php connection to mysql Database tutorial summary

Detailed steps for php to connect to mysql database (pictures and text)

The above is the detailed content of PHP connects to MYSQL database instance. For more information, please follow other related articles on the PHP Chinese website!