PHP DataBase::fetchAll Beispiele

Beispiel #1

Datei: GroupProcess.php Projekt: huashihongfeng/demo-server-php

/**
* 获取全部群信息
* @UserFunction(method = GET)
*/
function get_all_group()
{
    $db = new DataBase(DB_DNS, DB_USER, DB_PASSWORD);
    $group_list = $db->fetchAll('SELECT * FROM `group`');
    return $group_list;
}

Beispiel #2

Datei: FriendProcess.php Projekt: huashihongfeng/demo-server-php

/**
* 获取好友列表
* @UserFunction(method = GET|POST)
* @CheckLogin
*/
function get_friend()
{
    $db = new DataBase(DB_DNS, DB_USER, DB_PASSWORD);
    $friends = $db->fetchAll('SELECT A.`id`,`email`,`username`,`portrait`,`status` FROM `friend` INNER JOIN `user` AS A ON `friend_id`=A.`id` WHERE `user_id`=?;', getCurrentUserId());
    return $friends;
}

Beispiel #3

Datei: UserProcess.php Projekt: huashihongfeng/demo-server-php

/**
* 获取全部个人资料
* @UserFunction(method = GET)
* @CheckLogin
*/
function friends()
{
    $db = new DataBase(DB_DNS, DB_USER, DB_PASSWORD);
    $result = $db->fetchAll('SELECT `id`, `username`, `portrait` FROM `user`');
    return $result;
}