框架数据库操作方法

所有的数据查询满足数组查询和字符串查询，举例：

//三个等价
$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'));