Exemplos de mysql_query_exec em PHP

Exemplo n.º 1

Arquivo: ts-auth-db.php Projeto: ThreeScript/ThreeScriptTools

function update_confirmed_user($link, $nickname, $email, $key)
{
    $ok = mysql_query_exec($link, "\n      UPDATE users set\n         confirmkey = '{$key}',\n         confirmdate = NOW()\n      WHERE (nickname = '{$nickname}') AND (email = '{$email}')");
    return $ok;
}

Exemplo n.º 2

Arquivo: login.01b.php Projeto: ThreeScript/ThreeScriptTools

function create_new_user($link, $nickname, $firstname, $lastname, $email, $password)
{
    $password_crypt = cryptPassword($nickname, $password);
    $ok = mysql_query_exec($link, "\n      INSERT INTO users (\n         nickname,\n         firstname,\n         lastname,\n         email,\n         password,\n         creationdate)\n      VALUES (\n         '{$nickname}',\n         '{$firstname}',\n         '{$lastname}',\n         '{$email}',\n         '{$password_crypt}',\n         NOW())");
    if ($ok && !is_dir("users/{$nickname}")) {
        $ok = mkdir("users/{$nickname}");
    }
    return $ok;
}

Exemplo n.º 3

Arquivo: login.01a.php Projeto: ThreeScript/ThreeScriptTools

function create_new_hybridauth_user($link, $email, $firstname, $last_name, $provider, $provider_user_id)
{
    $password = md5(str_shuffle("0123456789abcdefghijklmnoABCDEFGHIJ"));
    mysql_query_exec($link, "\n      INSERT INTO users (\n         email,\n         password,\n         firstname,\n         last_name,\n         hybridauth_provider_name,\n         hybridauth_provider_uid,\n         created_at)\n      VALUES (\n         '{$email}',\n         '{$password}',\n         '{$firstname}',\n         '{$last_name}',\n         {$provider},\n         {$provider_user_id},\n         NOW())");
}