Exemplos de std_query em PHP

Exemplo n.º 1

Arquivo: crews.php Projeto: RPIA/WebCom

function display_crew_member($user_id)
{
    if ($user_id == -1) {
        echo "&nbsp &nbsp <a href=crews/signup>Sign up</a>";
    } else {
        $result = std_query("SELECT * FROM `users` WHERE `users`.`id`='" . quote_smart($user_id) . "'");
        $userInfo = mysql_fetch_assoc($result);
        $firstInit = substr($userInfo[firstName], 0, 1);
        echo "&nbsp &nbsp <a href=\"mailto:{$userInfo['email']}\"> {$firstInit}. {$userInfo['lastName']}</a>";
    }
}

Exemplo n.º 2

Arquivo: user.php Projeto: RPIA/WebCom

function delete_user($userid)
{
    if (check_officer_user()) {
        $delete_user = std_query("DELETE FROM `users` WHERE `userid` = '" . quote_smart($userid) . "' LIMIT 1");
    } else {
        return "You do not have sufficient privileges to modify this user. ";
    }
}