php db类库进行数据库操作

2015-01-24信息快讯网

<?php 
require_once "DB.php"; //包含类库文件 
$conn = DB::connect("mysql://root:1981427@localhost/test"); //连接数据库 
if (!DB::isError($conn)) { //判断是否连接成功 
print "数据库连接成功"; 
} 
else 
{ 
echo "数据库连接失败!"; 
} 
?>

<?php 
require_once "DB.php"; 
$conn = DB::connect("mysql://root:1981427@localhost/test"); //调用connect连接数据库 
if (DB::isError($conn)) //如果连接出错则报错 
{ 
print "数据库连接失败"; 
} 
$rs = $conn->query("select id,username, password from tablename1"); //执行SQL语句 
if (DB::isError($rs)) //判断是否执行成功 
{ 
print "数据查询失败"; 
} 
while ($rs->fetchInto($rows)) //循环输出查询结果 
{ 
print "编号号:$rows[0]<BR>"; 
print "姓名:$rows[1]<BR>"; 
print "密码:$rows[2]<BR>"; 
print "<HR>"; 
} 
?>

<?php 
require_once "DB.php"; 
$conn = DB::connect("mysql://root:1981427@localhost/test"); //调用connect连接数据库 
if (DB::isError($conn)) //如果连接出错则报错 
{ 
print "数据库连接失败"; 
} 
//执行SQL语句,从第0条开始返回1条记录 
$rs = $conn->limitQuery("select id,username, password from tablename1",2,5); //查询出记录集中第三个到第六个数据 
if (DB::isError($rs)) //如果查询出错则报错 
{ 
print "数据查询失败"; 
} 
while ($rs->fetchInto($rows)) //循环输出查询结果 
{ 
print "编号:$rows[0]<BR>"; 
print "姓名:$rows[1]<BR>"; 
print "密码:$rows[2]<BR>"; 
print "<HR>"; 
} 
?>

<?php 
require_once "DB.php"; 
$conn = DB::connect("mysql://root:1981427@localhost/test"); //连接数据库 
if (DB::isError($conn)) 
{ 
print "数据库连接失败"; 
} 
//使用prepare函数准备SQL语句 
$rs = $conn->prepare("update tablename1 set password = 'Susan' where id = '1'"); 
if (DB::isError($rs)) 
{ 
print "数据更新失败"; 
} 
else 
{ 
$conn->execute($rs); //执行SQL语句更新数据库 
print "数据更新成功"; 
} 
?> 

©2014-2024 dbsqp.com