<?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 "数据更新成功"; } ?>