Cacher is the code snippet organizer for pro developers

<?php
/ 需要注意的是，返回的数组的键值为用户的uid
$user = pdo_fetchall("SELECT username, uid FROM ".tablename('users'), array(), 'uid');
?>
//array | boolean pdo_fetchall($sql, $params = array(), $keyfield = '');

<?php
// :uid 是参数的一个占位符，没有使用引号，传入的第二个参数中要与SQL中的占位名称相同
$user = pdo_fetch("SELECT username, uid FROM ".tablename('users')."WHERE uid = :uid LIMIT 1", array(':uid' => 1));
// LIKE 占位的使用方法
$user = pdo_fetch("SELECT * FROM ".tablename('users')." WHERE username LIKE :username", array(':username' => '%mizhou%'));
?>
//array | boolean pdo_fetch($sql, $params = array());赋值的

<?php
//获取全部启用的用户
//生成的SQL等同于：SELECT * FROM ims_users WHERE status = '1'
$user = pdo_getall('users', array('status' => 1));
?>
//array | boolean pdo_getall($tablename, $condition = array(), $fields = array(), $keyfield = '');

//更uid等于2的用户的用户名
<?php
$user_data = array(
    'username' => 'mizhou2',
);
$result = pdo_update('users', $user_data, array('id' => 2));
if (!empty($result)) {
    message('更新成功');
}
?>
//$glue 参数指定前面 $condition 数组条件的关联字 AND 或是 OR
//array | boolean pdo_update($tablename, $data = array(), $condition, $glue = 'AND')