php操作mysql类库_php db类库进行数据库操作

require_once "DB.php"; //包含类库文件

$conn = DB::connect("mysql://root:1981427@localhost/test"); //连接数据库

if (!DB::isError($conn)) { //判断是否连接成功

print "数据库连接成功";

}

else

{

echo "数据库连接失败！";

}

?>

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]
";

print "姓名：$rows[1]
";

print "密码：$rows[2]
";

print "

---

";

}

?>

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]
";

print "姓名：$rows[1]
";

print "密码：$rows[2]
";

print "

---

";

}

?>

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

}

?>