1.最简单的方式-mysql(面向过程)
<?php$con = mysql_connect("localhost","root","password");$select_db = mysql_select_db('test');if (!$select_db) { die("could not connect to the db:\n" . mysql_error()); }//查询代码$sql = "select * from db_table";$res = mysql_query($sql);if (!$res) { die("could get the res:\n" . mysql_error()); }while ($row = mysql_fetch_assoc($res)) { print_r($row); }//查询代码//关闭数据库连接mysql_close($con);?>123456789101112131415161718192021
2.新的方式-mysqli(面向过程)
$mysql_server_name = 'localhost'; //改成自己的mysql数据库服务器$mysql_username = 'root'; //改成自己的mysql数据库用户名$mysql_password = 'password'; //改成自己的mysql数据库密码$mysql_database = 'test'; //改成自己的mysql数据库名$conn=mysqli_connect($mysql_server_name,$mysql_username,$mysql_password,$mysql_database); //连接数据库//连接数据库错误提示if (mysqli_connect_errno($conn)) { die