常用函数

要用此函数需要引入：

require_once(MO_LIB_DIR . '/db.class.php');

lkt_execute( ),数据更新操作，返回影响行数。

$sql="insert into lkt_record (user_id,event) values (?,?) ";
lkt_execute($sql,array($name,'登录密码错误'));

lkt_row( ),获取单行数组。

$sql = "select id,name,password,admin_type,permission,status from lkt_admin where BINARY name = ? and password = ? ";
$result = lkt_row($sql,array($name,$password));
echo $result['id'];

lkt_rows( ),获取多行数组。

$sql = "select * from lkt_banner order by sort,id";
$rows = lkt_rows($sql);
foreach ($rows as $k => $v) {
        echo $v['id']; // 轮播图id
}

lkt_get( ),获取单行对象。

$sql = "select id,name,password,admin_type,permission,status from lkt_admin where BINARY name = ? and password = ? ";
$result = lkt_get($sql,array($name,$password));
echo $result->id;

lkt_gets( ),获取多行对象。

$sql = "select * from lkt_banner order by sort,id";
$rows = lkt_gets($sql);
foreach ($rows as $k => $v) {
       echo $v->id; // 轮播图id
}

事物机制相关方法:lkt_start()、lkt_commit()、lkt_rollback()

lkt_start();//事务开启
lkt_commit();//事务提交
lkt_rollback();//事务回滚