PHP select_from_db Examples

Example #1

File: menu.php Project: eva-chaunm/paraflow

function getMenu()
{
    if (!isset($_SESSION['user_id'])) {
        $getMenu = select_from_db(array('id,name'), array('menus'), array('id = 1'));
    } else {
        $getMenu = select_from_db(array('id,name'), array('menus'), array('id = 2'));
    }
    $results = select_from_db(array('id,parent_id,label,link,level'), array('menu_items'), array('menu_id = ' . $getMenu[0]['id']), "", "id");
    $menuName = $getMenu[0]["name"];
    $menuSelections = getMenuSelection($results, "0", "-1");
    if (!empty($menuSelections)) {
        $menu = '{"' . $menuName . '":[' . $menuSelections . '] }';
    }
    echo $menu;
}

Example #2

File: form_handler_ajax.php Project: eva-chaunm/paraflow

function createEvent($params)
{
    $event_name = $params['eventName'];
    $user_id = $_SESSION['user_id'];
    $event_info = select_from_db(array('name'), array('events'), array("name='{$event_name}'"));
    if (isset($event_info[0]['name'])) {
        echo '{"added":"none"}';
    } else {
        $membershipRules = $params['membershipRules'];
        //    	$groupId = isset($params['groupId'])?$params['groupId']:'0';
        $event_id = insert_to_db(array('access' => $membershipRules, 'name' => $event_name), 'events');
        insert_to_db(array('user_id' => $user_id, 'event_id' => $event_id), 'user__has__event');
        echo '{"added":"event"}';
    }
}

Example #3

File: get_page.php Project: eva-chaunm/paraflow

function getAllPublicGroupsExeptTheOnesUserHas($params)
{
    $events = select_from_db(array('name,id'), array('events, user__has__event'), array("events.id = user__has__event.event_id AND user__has__event.user_id = 1"), "", "name");
    echo json_encode($events);
}

Example #4

File: db_oop.php Project: eva-chaunm/paraflow

function select_id_name_where_parent_mediatype($parent, $mediatype)
{
    return select_from_db(array('id', 'name'), array('parent' => $parent, 'mediatype' => $mediatype));
}

Example #5

File: form_handler.php Project: eva-chaunm/paraflow

function login($values)
{
    $email = $values['email']['value'];
    $password = $values['password']['value'];
    if ($email && $password) {
        $userinfo = select_from_db(array('password', 'id'), array('users'), array("email='{$email}'"));
        //hämtar hem användaruppgifter från angiven email
        if ($password == $userinfo[0]['password']) {
            //Kontrollerar om lösenordet stämmer
            $_SESSION['user_id'] = $userinfo[0]['id'];
            //Sätter anändarid i en session
            $_SESSION['user_name'] = $email;
            header('Location: ../index.php');
        } else {
            header('Location: ../index.php?msg=1');
            //Användarnamnet och lösenordet stämmer inte överens
        }
    } else {
        header('Location: ../index.php?msg=2');
        //Inget användarnamn eller lösenord angvet
    }
}

Example #6

File: menu.php Project: eva-chaunm/paraflow

function get_users_in_game_but_not_in_this_chat($params)
{
    $game_id = $params['game_id'];
    $chat_room_id = $params['chat_room_id'];
    $user_id = $_SESSION['user_id'];
    $result = select_from_db(array('alias,users.id'), array('users,users__got__games'), array("users__got__games.game_id = {$game_id} AND \n\t\t\t\t\t\t\tusers__got__games.user_id = users.id AND users.id NOT IN (\n\t\t\t\t\t\t\tSELECT users.id FROM users,chat_rooms__got__users\n\t\t\t\t\t\t\tWHERE chat_rooms__got__users.chat_room_id = {$chat_room_id} AND\n\t\t\t\t\t\t\tchat_rooms__got__users.user_id = users.id )"));
    echo json_encode($result);
}

Example #7

File: page.php Project: eva-chaunm/paraflow

function get_category($categori_id)
{
    $category_selection = "<select name='category' id='category'>";
    $categorys = select_from_db(array('id', 'category'), array('categories'));
    foreach ($categorys as $categori) {
        $category_selection = $category_selection . "<option value='" . $categori['id'] . "'";
        if ($categori['id'] == $categori_id) {
            $category_selection = $category_selection . "selected";
        }
        $category_selection = $category_selection . ">" . $categori['category'] . "</option>";
    }
    $category_selection = $category_selection . "</select>";
    return $category_selection;
}

Example #8

File: form_handler.php Project: eva-chaunm/paraflow

function login($values)
{
    $email = $values['email']['value'];
    $password = $values['password']['value'];
    if ($email && $password) {
        $userinfo = select_from_db(array('password', 'id'), array('users'), array("email='{$email}'"));
        //hämtar hem användaruppgifter från angiven email
        $blogs = select_from_db(array('blogs.id', 'blogs.name', 'users__has__blogs.accesslevel'), array('blogs', 'users__has__blogs'), array('users__has__blogs.blogs_id = blogs.id', 'users__has__blogs.users_id =' . $userinfo[0]['id']));
        //print_r(blogs);
        if ($password == $userinfo[0]['password']) {
            //Kontrollerar om lösenordet stämmer
            $_SESSION['user_id'] = $userinfo[0]['id'];
            //Sätter anändarid i en session
            $_SESSION['user_name'] = $email;
            $_SESSION['blog_list'] = serialize($blogs);
            header('Location: ../index.php');
        } else {
            header('Location: ../index.php?msg=1');
            //Användarnamnet och lösenordet stämmer inte överens
        }
    } else {
        header('Location: ../index.php?msg=2');
        //Inget användarnamn eller lösenord angvet
    }
}