This article mainly introduces the link between mysql and php, which has certain reference value. Now I share it with everyone. Friends in need can refer to it
mysql establishment link:
Problem Solving
php.ini loads the mysql component
1.extension=php_mysql.dl prefix: remove
2.extension_dir=" "Is the path correct
php link mysql function
mysql_connect: open mysql link
mysql_sqlselect_db: open a database
Link format
mysql_connect("host","host Name", "Password"):
mysql_select_db ("Open database", link identifier): Link identifier, generally defaults to the last opened link
Whether the link is successful
<?
$conn=@mysql_connect("localhost","root","123456")
if($conn)
echo"成功";
?><?
$conn=@mysql_connect("localhost","root","123456")or dir("链接错误");
?>Open the database
<?
$conn=@mysql_connect("localhost","root","123456")or die("链接错误");
mysql_select_db("new",$conn);
?>Execute sql statement:
Insert
<?
$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);
?>Query
<?
$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];
?>Multiple query display
<?
$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]可以是数组下标也可以是域名
}
?>Solution Chinese garbled characters
mysql_query("set names'gbk');Related recommendations:
Key points of connection operation between MySQL and php
The above is the detailed content of Mysql and php link. For more information, please follow other related articles on the PHP Chinese website!
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
