php访问mysql

步骤

1. 连接mysql服务器
2. 选择mysql数据库
3. 执行sql语句
4. 关闭结果集
5. 关闭mysql服务器

连接服务器

<?php

header("Content-type:text/html; charset=utf-8");
$servername = "localhost";
$username = "root";
$password = "123456";
 
// 创建连接
$conn = mysql_connect($servername, $username, $password);
 
// 检测连接
if ($conn->connect_error) {
    print_r("连接失败: " . $conn->connect_error);
} else{
    echo "连接成功";
}

?>

选择mysql数据库

$db_selected = mysql_select_db('library',$conn);

if ($db_selected){
  print_r ("connect success");
}else{
    print_r(mysql_error);
}

执行sql语句

sql = "INSERT INTO books(`name`,`img`,`author`,`contents`,`Introduction`,`status`,`ishot`)VALUES('致lahoo情史','img/img1.png','gakiw','lalala~','hahaha~',0,0)";

$retval = mysql_query( $sql ,$conn );
if(! $retval )
{
  die('无法插入数据: ' . mysql_error($conn));
}
echo "数据插入成功\n";

关闭结果集

数据库操作完成后，需要关闭结果集，已释放系统资源

mysql_free_result($result);

关闭mysql服务器

mysql_close($conn);