要用此函数需要引入:
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();//事务回滚