【php】连接mysql的几种方法

1.最简单的方式

<?php$con = mysql_connect("localhost","root","");if (!$con)  {  die('Could not connect: ' . mysql_error());  }mysql_close($con);

2.面向对象mysqli（详细教程）

<?php$con = mysql_connect("localhost","root","");if (!$con)  {  die('Could not connect: ' . mysql_error());  }mysql_close($con);

3.pdo连接mysql（详细教程）

<?php  $db = new PDO('mysql:host=localhost;dbname=test', 'root', '');try {foreach ($db->query('select * from user') as $row){print_r($row);}$db = null;  //关闭数据库} catch (PDOException $e) {echo $e->getMessage();}?>

4.ADODB连接mysql（详细教程）

<?phprequire_once './adodb5/adodb.inc.php';$conn = &ADONewConnection('mysql');$conn->connect('localhost','root','','test');$conn->Execute("set names utf8");$res = $conn->Execute("select * from user");if (!$res){echo $conn->ErrorMsg();}else{var_dump($res);}?>