/** * Initializes a database connection. * It returns the connection, if successful. * * @param string $db_server * @param string $db_name * @param string $db_user * @param string $db_passwd * @param string $db_prefix * @param mixed[] $db_options * * @return resource */ public static function initiate($db_server, $db_name, $db_user, $db_passwd, $db_prefix, $db_options = array()) { global $mysql_set_mode; // Initialize the instance... if not done already! if (self::$_db === null) { self::$_db = new self(); } // Non-standard port if (!empty($db_options['port'])) { $db_port = (int) $db_options['port']; } else { $db_port = 0; } // Select the database. Maybe. if (empty($db_options['dont_select_db'])) { $connection = @mysqli_connect((!empty($db_options['persist']) ? 'p:' : '') . $db_server, $db_user, $db_passwd, $db_name, $db_port); } else { $connection = @mysqli_connect((!empty($db_options['persist']) ? 'p:' : '') . $db_server, $db_user, $db_passwd, '', $db_port); } // Something's wrong, show an error if its fatal (which we assume it is) if (!$connection) { if (!empty($db_options['non_fatal'])) { return null; } else { display_db_error(); } } // This makes it possible to automatically change the sql_mode and autocommit if needed. if (isset($mysql_set_mode) && $mysql_set_mode === true) { self::$_db->query('', 'SET sql_mode = \'\', AUTOCOMMIT = 1', array(), false); } self::$_db->_connection = $connection; // Few databases still have not set UTF-8 as their default input charset self::$_db->query('', ' SET NAMES UTF8', array()); return $connection; }
Jeremy's Blog Website <br /> <br /> <?php //include 'sql.php'; $id = 10001; //$db = new Database; //$default = Database::instance(); $query = Database_MySQL::query(Database::SELECT, 'SELECT * FROM posts');