PHP与数据库连接的方式有哪些?
2个回答
展开全部
1.最简单的方式
<?php$con = mysql_connect("localhost"衡团,"root","");if (!$con) { die('Could not connect: ' . mysql_error()); }mysql_close($con);?>
2.面向对象mysqli(详细教程)
<?php$mysqli = new mysqli('localhost','root','','volunteer');if (mysqli_connect_errno()){ die('Unable to connect!'). mysqli_connect_error();}?>
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);}?>
<?php$con = mysql_connect("localhost"衡团,"root","");if (!$con) { die('Could not connect: ' . mysql_error()); }mysql_close($con);?>
2.面向对象mysqli(详细教程)
<?php$mysqli = new mysqli('localhost','root','','volunteer');if (mysqli_connect_errno()){ die('Unable to connect!'). mysqli_connect_error();}?>
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);}?>
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询