PHP与数据库连接的方式有哪些?

如题所述

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);}?>
温馨提示:答案为网友推荐,仅供参考
第1个回答  2015-06-01
<?php
mysql_connect("localhost","root","123")or die("数据库连接失败!");
mysql_query("set names utf-8");
mysql_select_db("004online");
?>本回答被网友采纳

相关了解……

你可能感兴趣的内容

本站内容来自于网友发表,不代表本站立场,仅表示其个人看法,不对其真实性、正确性、有效性作任何的担保
相关事宜请发邮件给我们
© 非常风气网