cjk
1.最简单的方式
"font-family:'微软雅黑', 'Microsoft YaHei';font-size:14px;color:rgb(0,0,0);">$con = mysql_connect("localhost","root","");if (!$con) { die('Could not connect: ' . mysql_error()); }mysql_close($con);?>
"font-family:'微软雅黑', 'Microsoft YaHei';font-size:14px;color:rgb(0,0,0);"
>
$con
= mysql_connect(
"localhost"
,
"root"
""
);
if
(!
) {
die
(
'Could not connect: '
. mysql_error()); }mysql_close(
);?>
2.面向对象mysqli
"font-family:'微软雅黑', 'Microsoft YaHei';font-size:14px;color:rgb(0,0,0);">$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();}?>
$db
=
new
PDO(
'mysql:host=localhost;dbname=test'
'root'
''
try
{
foreach
->query(
'select * from user'
)
as
$row
){ print_r(
); }
= null;
//关闭数据库} catch (PDOException $e) {echo $e->getMessage();}?>
3.pdo连接mysql
"font-family:'微软雅黑', 'Microsoft YaHei';font-size:14px;color:rgb(0,0,0);">$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();}?>
//关闭数据库} catch (PDOException $e) { echo $e->getMessage();}?>
4.ADODB连接mysql
"font-family:'微软雅黑', 'Microsoft YaHei';font-size:14px;color:rgb(0,0,0);">require_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);}?>
require_once
'./adodb5/adodb.inc.php'
;
$conn
= &ADONewConnection(
'mysql'
->connect(
'localhost'
'test'
->Execute(
"set names utf8"
$res
"select * from user"
){
echo
->ErrorMsg();}
else
{ var_dump(
);}?>