1、普通方法，就是利用PHP面向过旯皱镢涛程的方式，写代码。$mysql_server="localhost";$mysql_username="数据库用户名";$mysql_password="数据库密码";$mysql_database="数据库名";//建立数据库链接$conn = mysql_connect($mysql_server,$mysql_username,$mysql_password) or die("数据库链接错误");//选择某个数据库mysql_select_db($mysql_database,$conn);mysql_query("set names 'utf8'");//执行MySQL语句$result=mysql_query("SELECT id,name FROM 数据库表");//提取数据$row=mysql_fetch_row($result);
2、第二个是对象方法，将代码写成对象模式。$db=new mysqli($dbhost,$username,$userpass,$dbdatabase);if(mysqli_connect_error()){echo 'Could not connect to database.';exit;}$result=$db->query("SELECT id,name FROM user");$row=$result->fetch_row();
3、第三种是写成pdo模式$dsn='mysql:host='.$dbhost.';dbname='.$dbdatabase.';'$dbh=new PDO($dsn,$username,$userpass);$stmt=$dbh->query('SELECT id,name FROM user');$row=$stmt->fetch();