Home >Backend Development >PHP Tutorial >PHP connection to MYSQL database example code
The project I am working on now requires PHP to connect to the MySQL database. Although I have learned it before, I have basically forgotten it now. Later, I found the solution by searching for relevant information. The editor will share the specific method on this website for everyone to learn.
The specific code is as follows:
<?php //设置字符集 header('Content-Type: text/html; charset=utf8'); //连接数据库 $link = mysql_connect("localhost","root","123456"); if(!$link){ echo '数据库连接失败...<br>'; exit(-1); }else{ echo "数据库连接成功...<br>"; } //选择一个数据库作为默认数据库 mysql_select_db('php_sjk'); //执行sql插入语句 $sql = "INSERT INTO zh VALUES (NULL,'王杰','123456')"; $cr = mysql_query($sql); //判断是否插入成功 if(!$cr){ echo "数据插入失败。<br>"; }else{ echo "数据插入成功。<br>"; } //执行sql查询语句 $sql = "select * from zh"; $cr = mysql_query($sql); //得到返回的结果集,并循环输出 echo "数据展示:<br><br><br>"; while($a = mysql_fetch_row($cr)){ echo "{$a[0]}——{$a[1]}——{$a[2]}<br>"; } //关闭数据库连接 mysql_close($link); ?>
This is all about the code for PHP to connect to the MYSQL database. You are welcome to collect it, thank you!
The above introduces the example code of PHP connecting to MYSQL database, including the relevant content. I hope it will be helpful to friends who are interested in PHP tutorials.