1,连接数据库参数配置

$mysql_server_name='localhost';//改成自己的mysql数据库服务器
$mysql_username='root';//改成自己的mysql数据库用户名
$mysql_password='';//改成自己的mysql数据库密码
$mysql_database='dbname';//改成自己的mysql数据库名

$conn=mysql_connect($mysql_server_name,$mysql_username,$mysql_password) or die("error connecting") ;//连接数据库
mysql_query("set names 'utf8'");//数据库输出编码 
mysql_select_db($mysql_database);//打开数据库
$sql="select * from children ";//SQL语句
$result= mysql_query($sql,$conn);//查询

while($row= mysql_fetch_array($result)){
echo "<div style=\"height:24px; line-height:24px; font-weight:bold;\">";//排版代码
echo $row['title'] ."<br/>";
echo "</div>";//排版代码
}

$conn=mysql_connect($mysql_server_name,$mysql_username,$mysql_password);//连接数据库
mysql_query("set names 'utf8'");//数据库输出编码
mysql_select_db($mysql_database);//打开数据库
$sql="insert into messageboard (Topic,Content,Enabled,Date) values ('$Topic','$Content','1','2011-01-12')";
mysql_query($sql);
mysql_close();//关闭MySQL连接

从一个数据表导出数据到另一个数据表

<?php
header('Content-Type: text/html; charset=utf-8');
// MySQLi - 面向过程
$servername = "localhost";
$username = "root";
$password = "qwe`123";
$database = "database1";
$database2 = "database2";
// 创建连接
$conn = mysqli_connect($servername, $username, $password, $database);
$conn2 = mysqli_connect($servername, $username, $password, $database2);
// 检测连接
if (!$conn) {
    die("连接失败：" . mysqli_connect_error());
}
if (!$conn2) {
    die("连接失败：" . mysqli_connect_error());
}
// 修改数据库连接字符集为 utf8
mysqli_set_charset($conn,"utf8");
mysqli_set_charset($conn2,"utf8");
// 查询
$sql = "select * from zht_datas where catId=13 order by id asc"; //SQL语句
$result = mysqli_query($conn, $sql); //查询
//var_dump(mysqli_fetch_array($result)); // 调试输出结果
//exit;
while ($row = mysqli_fetch_array($result)) {
    echo $row['dataName'] . "<br/>";
$jianjie = str_ireplace("'", "''", $row['jianjie']); //简介中有单引号，导致插入数据错误，需要一个单引号'替换为两个单引号''
	$sql2 = "insert into zht_datas(dataName,dataVal,catId) values('" . $row['dataName'] . "','" . $row['dataVal'] . "',7)";
	mysqli_query($conn2, $sql2);
//20191204如果执行过程出错，返回错误信息
if(!$rs){echo '错误：' . mysqli_error($conn2) . '<br>';}
} 
mysqli_close($conn);

错误举例：错误：You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Microsoft Yahei', Arial, Helvetica, sans-serif; line-height: 28px; text-align: c' at line 1