PHP connection MYSQL database instance code, phpmysql database instance

PHP connection MYSQL database instance code, phpmysql database instance_PHP tutorial

WBOY

Release： 2016-07-12 09:00:10

Original

1693 people have browsed it

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;>

Copy after login

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