下面是php里连接My SQL 红色字为关键语句;
mysql_connect([string server[,string username[,string password[,bool new_link[,int client_flags]]]]])
<?php
$host="127.0.0.1";
$userName="root";
$password="ssss";
if($connID=mysql_connect($host,$userName,$password)){
echo"<script language='javascript'>alert('数据库连接成功!');</script>";
}else{
echo"<script language='javascript'>alert('数据库连接失败!');</script>";
}
if(mysql_select_db($dbName,$connID)){
echo"数据库选择成功!";
}else{
echo"数据库选择失败!";}
mysql_query("set names gbk");
echo"<table border=\"1px\"align=\"center\">
<tr>
<td>名字</td>
<td>工作</td>
<td>工资</td>
</tr>";
$query=mysql_query("select name,work,salary from tb_name",$connID);
while($result=mysql_fetch_array($query))
{
echo"<tr>
<td>".$result["name"]."</td>
<td>".$result["work"]."</td>
<td>".$result["salary"]."</td>
</tr>";
}
echo"</table>";
?>
效果图