Ejemplos de BaseDB::getLastId en PHP

Ejemplo n.º 1

Archivo: GCM_Functions.php Proyecto: beingsane/ClashOfClans-1

function storePlayer($name, $email, $gcm_regid)
{
    $db = new BaseDB();
    // insert user into database
    $sql = "INSERT INTO gcm_users(name, email, gcm_regid, created_at) VALUES('{$name}', '{$email}', '{$gcm_regid}', GETDATE())";
    $result = $db->dbQuery($sql);
    // check for successful store
    if ($result) {
        // get user details
        $id = $db->getLastId('gcm_users');
        // last inserted id
        $result = $db->dbQuery("SELECT * FROM gcm_users WHERE id = {$id}") or die(dbGetErrorMsg());
        // return user details
        $NumRecords = sqlsrv_num_rows($result);
        if ($NumRecords > 0) {
            return sqlsrv_fetch_array($result, SQLSRV_FETCH_BOTH);
        } else {
            return false;
        }
    } else {
        return false;
    }
}