PHP和MySQL交互
1.mysql_connect()连接数据库
mysql_connect($servername, $username, $password)
- 前三个参数分别代表服务器主机地址,访问数据库的用户名,访问数据库的密码
<?php
header("content-type:text/html;charset=utf-8");
$servername = "127.0.0.1";
$username = "root";
$password = "root";
$conn = mysql_connect($servername, $username,$password);
if (!$conn) {
die("Connection failed: " . mysql_connect_error());
连接。
}
echo "连接成功";
mysql_close($conn);
?>
2.mysql_query()对数据库操作
mysql_query($sql,$conn)
<?php
header("content-type:text/html;charset=utf-8");
$servername = "www.Sunlight.com";
$username = "root";
$password = "7777777";
$conn = mysql_connect($servername, $username,$password);
if (!$conn) {
die("Connection failed: " . mysql_connect_error());
}
echo "连接成功";
echo "</br>";
$sql = "CREATE DATABASE zhubajie";
$dingpa = mysql_query($sql,$conn);
if (!$dingpa) {
die("创建数据库失败:".mysql_error());
}
echo "创建成功";
mysql_close($conn);
?>
- 利用这个函数,可以进行其他的所有操作,只要sql语句有效,操作就有效。
- 点这里,和这里,不再详细赘述