PHP db_DoFetch Examples

Example #1

File: db_mysql.php Project: LastResortGames/ludumdare

function db_DoFetchFirst($query, ...$args)
{
    $ret = db_DoFetch($query, ...$args);
    if (isset($ret[0])) {
        return $ret[0];
    }
    return null;
}

Example #2

File: theme.php Project: LastResortGames/ludumdare

function theme_GetScoredIdeaList($node, $limit = 80)
{
    $ret = db_DoFetch("SELECT id,theme,score FROM " . CMW_TABLE_THEME_IDEA . " \n\t\tWHERE node=? AND parent=0\n\t\tORDER BY score DESC\n\t\tLIMIT " . $limit, $node);
    return $ret;
}

Example #3

File: access.php Project: LastResortGames/ludumdare

function access_GetIP($ip)
{
    db_connect();
    return db_DoFetch("SELECT id,user," . (defined('CMW_USING_MARIADB') ? "INET6_NTOA(ip)" : "INET_NTOA(ip)") . " AS ip,first_timestamp,last_timestamp,total FROM " . CMW_TABLE_USER_ACCESS . " \n\t\tWHERE ip=" . (defined('CMW_USING_MARIADB') ? "INET6_ATON(?)" : "INET_ATON(?)"), $ip);
}

Example #4

File: user_strike.php Project: LastResortGames/ludumdare

function theme_GetStrikes($user)
{
    return db_DoFetch("SELECT id,node,reason,`timestamp` FROM " . CMW_TABLE_USER_STRIKE . " \n\t\tWHERE user=?", $user);
}