PHP SQLObject::last_insert_id Exemples

Exemple #1

Fichier : auth.mod.php Projet : jankuca/smog-cms

 public function getChallenge()
 {
     $salt = rand(100, 999);
     $cookie = rand(100, 999);
     $sql = new SQLObject();
     if ($sql->exec("\r\nINSERT INTO " . $sql->table('auth_challenges') . "\r\n(challenge_id,challenge_ip,challenge_salt,challenge_cookie)\r\nVALUES\r\n(NULL,'" . $_SERVER['REMOTE_ADDR'] . "'," . $salt . "," . $cookie . ")")) {
         setcookie('AUTH_COOKIE', $cookie);
         TPL::add('AUTH_CHALLENGE', $sql->last_insert_id());
         TPL::add('AUTH_SALT', $salt);
     }
 }