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');