PHP connection MYSQL database instance code, phpmysql database instance_PHP tutorial

PHP connection MYSQL database instance code, phpmysql database instance

The project I am doing now requires PHP to connect 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 Bangkejia platform for everyone to learn from.

The specific code is as follows:

<&#63;php
//设置字符集
header('Content-Type: text/html; charset=utf8');
//连接数据库
$link = mysql_connect("localhost","root","123456");
if(!$link){
echo '数据库连接失败...<br>';
exit(-1);
}else{
echo "数据库连接成功...<br>";
}
//选择一个数据库作为默认数据库
mysql_select_db('php_sjk');
//执行sql插入语句
$sql = "INSERT INTO zh VALUES (NULL,'王杰','123456')";
$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);
&#63;>

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

Articles you may be interested in:

• php code to connect mysql database
• PHP connection database prompt under IIS mysql undefined function mysql_connect()
• php cannot Connecting to the database php error Can''t connect to local MySQL server
• Getting started with php: A class for connecting to the mysql database
• How to connect to the database after php opens the mysqli extension
• PHP connection Simple example of LAN MYSQL database
• PHP connects to multiple mysql databases at the same time sample code
• php basics of connecting mysql database and querying data
• Php connection, reading and writing Commonly used codes for mysql database
• Basic tutorial on PHP connection and operation of MySQL database
• Comparative analysis of database connection methods pdo and mysqli in php