沧州网站建设时使用PHP访问MySQL数据库
这里要讲的就是用mysql_*函数组和mysqli_*函数组来访问MySQL数据库。
<?php
$conn=mysql_connect("hostname","username","password") or die("链接数据库失败");
mysql_select_db("<database>");
$sql="<SQL statements>";
$rs=mysql_query($sql,$conn);
mysql_free_result($rs);
mysql_close($conn);
?>
使用PHP的mysqli_*函数组访问MySQL数据库
<?php
$mysqli=mysqli_connect("hostname","username","password","database");
if(mysqli_connect_errno()){
printf("Connect failed:%s\n",mysqli_connect_error());
exit();
}else{
$sql="<SQL statements>";
$rs=mysqli_query($mysqli,$sql);
if($rs===TRUE){
echo "sucessfully!";
}else{
echo "failed!";
}
mysqli_close($mysqli);
}
?>