mysql与php的链接

mysql建立链接：

问题解决

php.ini加载mysql组件

1.extension=php_mysql.dl   的前缀：去掉

2.extension_dir=" "路径是否正确

php链接mysql函数

mysql_connect：开启mysql链接

mysql_sqlselect_db:打开一个数据库

链接格式

mysql_connect("主机",“主机名”,“密码”):

mysql_select_db("打开数据库"，链接标识符):       链接标识符，一般默认上次打开的链接

链接是否成功

<?

$conn=@mysql_connect("localhost","root","123456")

if($conn)

echo"成功";

?>

<?

$conn=@mysql_connect("localhost","root","123456")or dir("链接错误");

?>

打开数据库

<?

$conn=@mysql_connect("localhost","root","123456")or die("链接错误");

mysql_select_db("new",$conn);

?>

执行sql语句：

插入

<?

$conn=@mysql_connect("localhost","root","123456") or die("链接错误");

mysql_select_db("new",$conn);

$sql="INSERT INTO test (id,name)"values(‘4’,'zhang');

mysql_query($sql,$conn);

?>

查询

<?

$conn=@mysql_connect("localhost","root","123456") or die("链接错误");

mysql_select_db("new",$conn);

$sql="SELECT * FORM  ‘test’";

$stt = mysql_query ($sql,$conn);

$row=mysql_fetch_array($stt);

echo $row[name];

?>

多条查询显示

<?

$conn=@mysql_connect("localhost","root","123456") or die("链接错误");

mysql_select_db("new",$conn);

$sql="SELECT * FORM  ‘test’";

$stt = mysql_query ($sql,$conn);

$row=mysql_fetch_array($stt);

while($row=mysql_fetch_array($stt));{

echo$row[name],"<dir>";               [name]可以是数组下标也可以是域名

}

?>

解决中文乱码

mysql_query("set names'gbk');