工具类源码
<?php
class sqltools
{
private $mysqli;
//构造函数初始化连接
function __construct($local, $user, $pwd, $dbs)
{
$this->mysqli = new mysqli($local, $user, $pwd, $dbs);
$this->mysqli->set_charset("utf8");
}
//执行sql
function excmd($sqls)
{
$result = $this->mysqli->query($sqls);
return $result;
}
}
?>
测试代码:
<?php
include "sqltools.php";
$s = new sqltools("localhost", "root", "", "books");
$result = $s->excmd("select * from bookinfo");
while (! ! $row = $result->fetch_row()) {
echo $row[1] . "<br>";
}
?>