Example #1
0
            $limit = '';
        }
        $sql = trim(sprintf($sql, TH_DB_PREFIX, $table, $set, $where));
        $smt = self::getHandle()->prepare($sql);
        if (!$smt) {
            self::logQuery(microtime(true) - $start, $sql);
            throw new Exception(self::getHandle()->errorInfo());
            return false;
        }
        if ($smt->execute(array_merge($binds, $prepare))) {
            self::logQuery(microtime(true) - $start, $sql);
            return $smt->rowCount();
        }
    }
}
class DB extends Database
{
}
try {
    global $database, $db_username, $db_password, $db_prefix;
    // create the pdo object
    DB::setHandle(new PDO($database, $db_username, $db_password));
    define('TH_DB_PREFIX', $db_prefix);
    // remove now unused vars
    unset($database);
    unset($db_password);
    unset($db_username);
    unset($db_prefix);
} catch (PDOException $e) {
    die('DB ERROR: ' . $e);
}
Example #2
0
        $smt = self::getHandle()->prepare($sql);
        if (!$smt) {
            print_r(self::getHandle()->errorInfo());
            debug_print_backtrace();
            return false;
        }
        if ($smt->execute(array_merge($binds, $prepare))) {
            return $smt->rowCount();
        } else {
            if (HR_DB_DEBUG) {
                echo '<h1>DB Error:</h1>';
                print_r(self::getHandle()->errorInfo());
                echo "<h2>SQL Statement</h2><pre>{$sql}</pre>";
                die;
            } else {
                // OH NOES ¬_¬
                die('A database error occurred whilst processing this page.
					Please contact the site administrator!');
            }
        }
    }
}
class_alias('Database', 'DB');
try {
    if (HR_DB_ENABLE) {
        // create the pdo object
        DB::setHandle(new PDO(HR_DSN, HR_DBUSR, HR_DBPASS));
    }
} catch (PDOException $e) {
    die('DB ERROR: ' . $e);
}