Source for file mysqli.php
Documentation is available at mysqli.php
// +----------------------------------------------------------------------+
// | PHP versions 4 and 5 |
// +----------------------------------------------------------------------+
// | Copyright (c) 1998-2004 Manuel Lemos, Tomas V.V.Cox, |
// | Stig. S. Bakken, Lukas Smith |
// | All rights reserved. |
// +----------------------------------------------------------------------+
// | MDB2 is a merge of PEAR DB and Metabases that provides a unified DB |
// | API as well as database abstraction for PHP applications. |
// | This LICENSE is in the BSD license style. |
// | Redistribution and use in source and binary forms, with or without |
// | modification, are permitted provided that the following conditions |
// | Redistributions of source code must retain the above copyright |
// | notice, this list of conditions and the following disclaimer. |
// | Redistributions in binary form must reproduce the above copyright |
// | notice, this list of conditions and the following disclaimer in the |
// | documentation and/or other materials provided with the distribution. |
// | Neither the name of Manuel Lemos, Tomas V.V.Cox, Stig. S. Bakken, |
// | Lukas Smith nor the names of his contributors may be used to endorse |
// | or promote products derived from this software without specific prior|
// | written permission. |
// | THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS |
// | "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT |
// | LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS |
// | FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE |
// | REGENTS OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, |
// | INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, |
// | BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS|
// | OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED |
// | AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT |
// | LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY|
// | WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE |
// | POSSIBILITY OF SUCH DAMAGE. |
// +----------------------------------------------------------------------+
// | Author: Lukas Smith <smith@backendmedia.com> |
// +----------------------------------------------------------------------+
// $Id: mysqli.php,v 1.9 2005/04/21 15:29:23 lsmith Exp $
require_once 'MDB2/Driver/Reverse/Common.php';
* MDB2 MySQL driver for the schema reverse engineering module
* @author Lukas Smith <smith@backendmedia.com>
* Array for converting MYSQLI_*_FLAG constants to text values
* @since Property available since Release 1.6.5
MYSQLI_NOT_NULL_FLAG => 'not_null',
MYSQLI_PRI_KEY_FLAG => 'primary_key',
MYSQLI_UNIQUE_KEY_FLAG => 'unique_key',
MYSQLI_MULTIPLE_KEY_FLAG => 'multiple_key',
MYSQLI_BLOB_FLAG => 'blob',
MYSQLI_UNSIGNED_FLAG => 'unsigned',
MYSQLI_ZEROFILL_FLAG => 'zerofill',
MYSQLI_AUTO_INCREMENT_FLAG => 'auto_increment',
MYSQLI_TIMESTAMP_FLAG => 'timestamp',
MYSQLI_SET_FLAG => 'set',
// MYSQLI_NUM_FLAG => 'numeric', // unnecessary
// MYSQLI_PART_KEY_FLAG => 'multiple_key', // duplicatvie
MYSQLI_GROUP_FLAG => 'group_by'
* Array for converting MYSQLI_TYPE_* constants to text values
* @since Property available since Release 1.6.5
MYSQLI_TYPE_DECIMAL => 'decimal',
MYSQLI_TYPE_TINY => 'tinyint',
MYSQLI_TYPE_SHORT => 'int',
MYSQLI_TYPE_LONG => 'int',
MYSQLI_TYPE_FLOAT => 'float',
MYSQLI_TYPE_DOUBLE => 'double',
// MYSQLI_TYPE_NULL => 'DEFAULT NULL', // let flags handle it
MYSQLI_TYPE_TIMESTAMP => 'timestamp',
MYSQLI_TYPE_LONGLONG => 'bigint',
MYSQLI_TYPE_INT24 => 'mediumint',
MYSQLI_TYPE_DATE => 'date',
MYSQLI_TYPE_TIME => 'time',
MYSQLI_TYPE_DATETIME => 'datetime',
MYSQLI_TYPE_YEAR => 'year',
MYSQLI_TYPE_NEWDATE => 'date',
MYSQLI_TYPE_ENUM => 'enum',
MYSQLI_TYPE_SET => 'set',
MYSQLI_TYPE_TINY_BLOB => 'tinyblob',
MYSQLI_TYPE_MEDIUM_BLOB => 'mediumblob',
MYSQLI_TYPE_LONG_BLOB => 'longblob',
MYSQLI_TYPE_BLOB => 'blob',
MYSQLI_TYPE_VAR_STRING => 'varchar',
MYSQLI_TYPE_STRING => 'char',
MYSQLI_TYPE_GEOMETRY => 'geometry',
// {{{ getTableFieldDefinition()
* get the stucture of a field into an array
* @param string $table name of table that should be used in method
* @param string $field_name name of field that should be used in method
* @return mixed data array on success, a MDB2 error on failure
$db = & $GLOBALS['_MDB2_databases'][$this->db_index];
$result = $db->loadModule ('Datatype');
if (PEAR ::isError ($result)) {
if ($field_name == $db->dummy_primary_key ) {
'getTableFieldDefinition: '. $db->dummy_primary_key. ' is an hidden column');
if (PEAR ::isError ($columns)) {
foreach ($columns as $column) {
if ($field_name == $column['field']) {
list ($types, $length) = $db->datatype ->mapNativeDatatype ($column);
if (isset ($column['null']) && $column['null'] != 'YES') {
if (isset ($column['default'])) {
$default = $column['default'];
foreach ($types as $key => $type) {
$definition[0 ][$key] = array ('type' => $type);
$definition[0 ][$key]['notnull'] = true;
$definition[0 ][$key]['default'] = $default;
$definition[0 ][$key]['length'] = $length;
if (isset ($column['extra']) && $column['extra'] == 'auto_increment') {
$implicit_sequence = array ();
$implicit_sequence['on'] = array ();
$implicit_sequence['on']['table'] = $table;
$implicit_sequence['on']['field'] = $field_name;
$definition[1 ]['name'] = $table;
$definition[1 ]['definition'] = $implicit_sequence;
if (isset ($column['key']) && $column['key'] == 'PRI') {
// check that its not just a unique field
$query = " SHOW INDEX FROM $table";
if (PEAR ::isError ($indexes)) {
foreach ($indexes as $index) {
$index['column_name'] = strtolower($index['column_name']);
if ($index['key_name'] == 'PRIMARY' && $index['column_name'] == $field_name) {
$implicit_index = array ();
$implicit_index['unique'] = true;
$implicit_index['fields'][$field_name] = '';
$definition[2 ]['name'] = $field_name;
$definition[2 ]['definition'] = $implicit_index;
'getTableFieldDefinition: it was not specified an existing table column');
// {{{ getTableIndexDefinition()
* get the stucture of an index into an array
* @param string $table name of table that should be used in method
* @param string $index_name name of index that should be used in method
* @return mixed data array on success, a MDB2 error on failure
$db = & $GLOBALS['_MDB2_databases'][$this->db_index];
if ($index_name == 'PRIMARY') {
'getTableIndexDefinition: PRIMARY is an hidden index');
$result = $db->query (" SHOW INDEX FROM $table" );
if (PEAR ::isError ($result)) {
$key_name = $row['key_name'];
if ($index_name == $key_name) {
if (!$row['non_unique']) {
$definition['unique'] = true;
$column_name = $row['column_name'];
$definition['fields'][$column_name] = array ();
if (isset ($row['collation'])) {
$definition['fields'][$column_name]['sorting'] = ($row['collation'] == 'A'
? 'ascending' : 'descending');
if (!isset ($definition['fields'])) {
'getTableIndexDefinition: it was not specified an existing table index');
* Returns information about a table or a result set
* @param object|string $result MDB2_result object from a query or a
* string containing the name of a table.
* While this also accepts a query result
* resource identifier, this behavior is
* @param int $mode a valid tableInfo mode
* @return array an associative array with the information requested.
* A MDB2_Error object on failure.
* @see MDB2_common::setOption()
$db = & $GLOBALS['_MDB2_databases'][$this->db_index];
* Probably received a table name.
* Create a result resource identifier.
$id = $db->_doQuery (" SELECT * FROM $result LIMIT 0" );
if (PEAR ::isError ($id)) {
* Probably received a result object.
* Extract the result resource identifier.
$id = $result->getResource ();
* Probably received a result resource identifier.
* Deprecated. Here for compatibility only.
if (!is_a($id, 'mysqli_result')) {
$case_func = 'strtolower';
$res['num_fields'] = $count;
for ($i = 0; $i < $count; $i++ ) {
foreach ($this->flags as $const => $means) {
if ($tmp->flags & $const) {
'table' => $case_func($tmp->table ),
'name' => $case_func($tmp->name ),
'type' => isset ($this->types[$tmp->type ])
? $this->types[$tmp->type ]
'len' => $tmp->max_length ,
$res['order'][$res[$i]['name']] = $i;
$res['ordertable'][$res[$i]['table']][$res[$i]['name']] = $i;
// free the result only if we were called on a table
Documentation generated on Mon, 11 Mar 2019 14:20:21 -0400 by phpDocumentor 1.4.4. PEAR Logo Copyright © PHP Group 2004.
|