HadSky轻论坛所有的表都会被提前加载和实例化为对象操作,所有的表满足id为主键,id为主要操作对象。所有的数据查询满足数组查询和字符串查询,举例://三个等价 $getid=$_G['T
HadSky轻论坛所有的表都会被提前加载和实例化为对象操作,所有的表满足id为主键,id为主要操作对象。
所有的数据查询满足数组查询和字符串查询,举例:
//三个等价
$getid=$_G['TABLE']['USER'] -> getId(array('username'=>'admin'));
$getid=$_G['TABLE']['USER'] -> getId("where `username`='admin'");
$getid=$_G['TABLE']['USER'] -> getId('username','admin');
建议使用数组形式。
getId 获取符合条件的记录id值,若多个符合条件只返回一个id
$r = $_G['TABLE'][TABLENAME] -> getId($sql);
举例,获取用户名为admin的id值:
$getid = $_G['TABLE']['USER'] -> getId(array('username'=>'admin'));
getData 返回指定条件记录的所有字段键名及键值,若多个符合条件只返回一个
$r = $_G['TABLE'][TABLENAME] -> getData($id);
举例:
//下面三句等价
$userdata = $_G['TABLE']['USER'] -> getData(1);
$userdata = $_G['TABLE']['USER'] -> getData(arrray('id'=>1));
$userdata = $_G['TABLE']['USER'] -> getData('id',1);
//获取满足条件的用户数据
//判断是否存在用户名为admin和密码为123456的用户,若存在将用户数据存入$userdata,反之返回false
$userdata = $_G['TABLE']['USER'] -> getData(array('username'=>'admin','password'=>md5('123456')));
getDatas($pos = 0, $rnum = 10, $sql) 获取满足条件的记录集,返回形式为数组形式,$pos读取记录开始位置,$rnum读取记录的条数,$sql条件语句
$rs = $_G['TABLE'][TABLENAME] -> getDatas(0,10,$sql);
举例:
//下面3句等价,获取所有昵称为admin的用户
$userdatas = $_G['TABLE']['USER'] -> getDatas(0,0,array('nickname'=>'admin'));
$userdatas = $_G['TABLE']['USER'] -> getDatas(0,0,'nickname','admin');
$userdatas = $_G['TABLE']['USER'] -> getDatas(0,0,"where `nickname`='admin'");
//循环输出所有满足条件的用户id
foreach($userdatas as $userdata){
echo $userdata['id'];
}
getColumns 获取指定表的字段名称集
$rs = $_G['TABLE'][TABLENAME] -> getColumns();
举例:
$rs = $_G['TABLE']['USER'] -> getColumns();
print_r($rs);
getCount 获取满足条件的记录的总数
$count = $_G['TABLE'][TABLENAME] -> getCount($sql);
举例:
//2句等价,获取昵称为admin的用户数量
$count = $_G['TABLE']['USER'] -> getCount(array('nickname'=>'admin'));
$count = $_G['TABLE']['USER'] -> getCount('nickname','admin');
newData(array $array) 写入或更新记录,$array带有id键值则为更新数据,反之则为写入数据
$_G['TABLE'][TABLENAME] -> newData($sql);
举例:
//更新id=1的用户的昵称和性别数据
$_G['TABLE']['USER'] -> newData(array('id'=>1,'nickname'=>'admin2','sex'=>'b'));
//新建一个用户
$_G['TABLE']['USER'] -> newData(array('username'=>'nihao','nickname'=>'admin','password'=>md5('123456'),'sex'=>'b'));
delData 删除满足条件的记录
$_G['TABLE'][TABLENAME] -> delData($sql);
举例:
//删除id=1的用户,下面4句等价
$_G['TABLE']['USER'] -> delData(1);
$_G['TABLE']['USER'] -> delData(array('id'=>1));
$_G['TABLE']['USER'] -> delData('id',1);
$_G['TABLE']['USER'] -> delData('where `id`=1');
//删除所有昵称为admin的用户,下面3句等价
$_G['TABLE']['USER'] -> delData(array('nickname'=>'admin'));
$_G['TABLE']['USER'] -> delData('nickname','admin');
$_G['TABLE']['USER'] -> delData("where `nickname`='admin'");
//删除所有昵称为admin的男用户,下面2句等价
$_G['TABLE']['USER'] -> delData("where `nickname`='admin' and `sex`='b'");
$_G['TABLE']['USER'] -> delData(array('nickname'=>'admin','sex'=>'b'));
粉丝
0
关注
0
收藏
0