PHP dbArray Examples

Example #1

File: post_funcs.php Project: nilvisa/litter

function findHashtag($str)
{
    return dbArray("SELECT * FROM litter_posts\n\t\tINNER JOIN litter_users\n\t\tON litter_posts.user_id = litter_users.user_id\n\t\tWHERE post LIKE '%{$str}%'\n\t\tORDER BY litter_posts.time_stamp DESC");
}

Example #2

File: profile_funcs.php Project: nilvisa/litter

function getFollowingPosts()
{
    $id = $_SESSION['user_id'];
    $result = dbOneArray("SELECT following FROM litter_following\n\t\t\t\t\tWHERE user_id = '{$id}'");
    if ($result) {
        $following = implode(',', $result);
        return dbArray("SELECT * FROM litter_posts\n\t\t\tINNER JOIN litter_users\n\t\t\tON litter_posts.user_id = litter_users.user_id\n\t\t\tWHERE litter_posts.user_id IN ({$following})\n\t\t\tORDER BY litter_posts.time_stamp DESC");
    }
}

Example #3

File: funcs.php Project: nilvisa/litter

function getAllUsers()
{
    return dbArray("SELECT * FROM litter_users\n\t\t\t\tORDER BY active DESC");
}

Example #4

File: funcs.php Project: nilvisa/WaterWeave

function getAllNews()
{
    return dbArray("SELECT * FROM news\n\t\tORDER BY news_date DESC");
}