PHP Database::db_query Examples

Example #1

File: Admin.php Project: runningjack/RobertJohnson

 public static function find_by_sql($sql = "")
 {
     $database = new Database();
     $result_set = $database->db_query($sql);
     $object_array = array();
     while ($row = $database->fetch_array($result_set)) {
         $object_array[] = self::instantiate($row);
     }
     return $object_array;
 }

Example #2

File: database.php Project: briancline/spire

 function queryIdList($query, $log = false)
 {
     $res = Database::db_query($query, $log);
     $err = mysql_errno();
     $arr = false;
     if ($res) {
         $arr = array();
         while ($rec = mysql_fetch_array($res)) {
             $arr[] = $rec[0];
         }
     }
     return $arr;
 }

Example #3

File: ticketreply.php Project: runningjack/RobertJohnson

 public function create()
 {
     $database = new Database();
     $attributes = $this->attributes();
     $sql = "INSERT INTO " . self::$table_name . "  (";
     $sql .= join(", ", array_keys($attributes));
     $sql .= ")VALUES('";
     $sql .= join("', '", array_values($attributes));
     $sql .= "')";
     if ($database->db_query($sql)) {
         $this->id = $database->insert_id();
         return true;
     } else {
         return false;
     }
 }

Example #4

File: index.php Project: suxinde2009/www

} else {
    $ip = $_SERVER["REMOTE_ADDR"];
    if (is_array($hosts) and in_array($ip, $hosts) == true) {
        define("SESSION_TABLE", "core_sessions");
        require_once "../core/include/base/system/events/event.class.php";
        require_once "../core/include/base/system/events/delete_event.class.php";
        require_once "../core/include/base/system/system_handler.class.php";
        require_once "../core/include/base/system/transaction.class.php";
        require_once "../core/include/base/security/security.class.php";
        require_once "../core/include/base/security/session.class.php";
        require_once "../core/include/base/system/template.class.php";
        require_once "../core/include/base/system/html_template.class.php";
        $transaction = new Transaction();
        Security::protect_session(true);
        $template = new HTMLTemplate("header.html", "install/template");
        $template->output();
        try {
            $sql = "SELECT id FROM core_base_includes";
            $res = @$db->db_query($sql);
            require_once "classes/install.io.php";
            InstallIO::update();
        } catch (DatabaseQueryFailedException $e) {
            require_once "classes/install.io.php";
            InstallIO::install();
        }
        $template = new HTMLTemplate("footer.html", "install/template");
        $template->output();
    } else {
        die("Access not allowed from your IP-Adress, check hosts.config.php");
    }
}

Example #5

File: functions.php Project: runningjack/RobertJohnson

function count_table($table)
{
    $database = new Database();
    $result = $database->db_query('SELECT COUNT(*) FROM ' . $table . "");
    $row = $database->fetch_row($result);
    return $row[0];
}