PHP连接MySQL

数据库

假设数据库为以下：

1. PHP连接数据库

<?php
//$con =mysqli_connect(主机名,用户名,密码,库名,端口);
$con =mysqli_connect('localhost','demo','123456','demo','3306');
?>

2. 执行SQL语句

<?php
mysqli_query($con,$sql); 
//$con为连接的数据库
//$sql为要执行的SQL语句，每次一条
?>

3. 设置编码

mysqli_query($con,"set sql_mode = ''");
mysqli_query($con,"set character set 'utf8'");
mysqli_query($con,"set names 'utf8'");

4. 关闭数据库连接

<?php
mysqli_close($con);
?>