所有的数据查询满足数组查询和字符串查询,举例:
//三个等价 $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'));