function single_edit($tbl, $col, $id) { $result = getSingle($tbl, $col, $id); $getResult = mysqli_fetch_array($result); echo "<form action=\"edit.php\" method=\"POST\">"; echo "<input type=\"hidden\" name=\"tbl\" value=\"{$tbl}\">"; echo "<input type=\"hidden\" name=\"col\" value=\"{$col}\">"; echo "<input type=\"hidden\" name=\"id\" value=\"{$id}\">"; for ($i = 0; $i < mysqli_num_fields($result); $i++) { $dataType = mysqli_fetch_field_direct($result, $i); //expects two arguments $fieldName = $dataType->name; //like an associative array - allows you to dig into the object and look for "name" (seen as the label in the object with the ->) //$title = explode('_', $fieldName); $fieldType = $dataType->type; //returns a number that can be used if ($fieldName != $col) { echo "<label>{$fieldName}</label><br>"; if ($fieldType != 252) { echo "<input type=\"text\" name=\"{$fieldName}\" value=\"{$getResult[$i]}\">"; } else { echo "<textarea name=\"{$fieldName}\">{$getResult[$i]}</textarea>"; } } } echo "<input type=\"submit\" value=\"Save Content\">"; echo "</form>"; }
/** Custom SQL Query **/ function query($query, $singleResult = 0) { //$query = mysqli_real_escape_string($this->_dbHandle,$query); //var_dump($query); $this->_result = mysqli_query($this->_dbHandle, $query); if (preg_match("/select/i", $query)) { $result = array(); $table = array(); $field = array(); $tempResults = array(); $numOfFields = mysqli_num_fields($this->_result); for ($i = 0; $i < $numOfFields; ++$i) { $table_name = mysqli_fetch_field_direct($this->_result, $i); array_push($table, $table_name->table); $fld = mysqli_fetch_field_direct($this->_result, $i); array_push($field, $fld->name); } while ($row = mysqli_fetch_row($this->_result)) { for ($i = 0; $i < $numOfFields; ++$i) { $table[$i] = trim(ucfirst($table[$i]), "s"); $tempResults[$table[$i]][$field[$i]] = $row[$i]; } if ($singleResult == 1) { mysqli_free_result($this->_result); return $tempResults; } array_push($result, $tempResults); } mysqli_free_result($this->_result); return $result; } }
function buatKode($tabel, $inisial) { //Mencari nama dan panjang kolom pertama (kode) $hsl1 = querydb("SELECT * FROM {$tabel} LIMIT 1"); $klm1 = mysqli_fetch_field_direct($hsl1, 0); //$hsl1 = $msysqli->query("SELECT * FROM $tabel LIMIT 1"); //$klm1 = $hsl1->fetch_fields_direct(0); $klmNama1 = $klm1->name; $klmLenght1 = $klm1->length; $hsl22 = querydb("SELECT max(" . $klmNama1 . ") FROM " . $tabel); //$hsl22 = querydb($qry2); $row = arraydb($hsl22); if (empty($row[0])) { $angka = 0; } else { $angka = substr($row[0], strlen($inisial)); //$angka = $row[0];; } $angka = $angka + 1; $angka = strval($angka); //Membuat angka 0 untuk mengisi digit yang kosong $tmp = ""; for ($i = 1; $i <= $klmLenght1 - strlen($inisial) - strlen($angka); $i++) { $tmp = $tmp . "0"; } return $inisial . $tmp . $angka; //return $klmLenght1; }
function mysqli_field_flags($result, $field_offset) { static $flags; $flags_num = mysqli_fetch_field_direct($result, $field_offset)->flags; if (!isset($flags)) { $flags = array(); $constants = get_defined_constants(true); foreach ($constants['mysqli'] as $c => $n) { if (preg_match('/MYSQLI_(.*)_FLAG$/', $c, $m)) { if (!array_key_exists($n, $flags)) { $flags[$n] = $m[1]; } } } } $result = array(); foreach ($flags as $n => $t) { if ($flags_num & $n) { $result[] = $t; } } $return = implode(' ', $result); $return = str_replace('PRI_KEY', 'PRIMARY_KEY', $return); $return = strtolower($return); return $return; }
function ExportTable($conn, $title, $filter, $dbtable, $dbjoin = "", $joinfield = "") { $query = "SELECT * FROM {$dbtable}"; if ($dbjoin) { $query .= " INNER JOIN {$dbjoin} ON {$dbtable}.{$joinfield}={$dbjoin}.{$joinfield}"; } if ($filter) { $query .= " WHERE {$filter}"; } $result = mysqli_query($conn, $query); $nrcampos = mysqli_field_count($conn); echo "<h2>{$title}</h2>"; echo "{$dbtable}"; if ($dbjoin) { echo "| <a href=\"dbshow.php?dbtable={$dbjoin}\" target=\"_blank\">{$dbjoin}</a>"; } echo "| " . mysqli_num_rows($result) . " row(s)"; echo "<p><table cellspacing=\"0\" cellpadding=\"5\" border=\"1\">"; echo "<tr>"; for ($i = 0; $i < $nrcampos; $i++) { $finfo = mysqli_fetch_field_direct($result, $i); echo "<td>" . $finfo->name . "</td>"; } echo "</tr>"; while ($row = mysqli_fetch_array($result)) { echo "<tr>"; for ($i = 0; $i < $nrcampos; $i++) { echo "<td>" . $row[$i] . "</td>"; } echo "</tr>"; } echo "</table></p><br> "; }
/** * Check imptotal * * @return bool */ public function check_imptotal() { $sql = 'SELECT `imptotal` FROM `' . $GLOBALS['xoopsDB']->prefix('banner') . '` WHERE `bid` = 1'; if ($result = $GLOBALS['xoopsDB']->queryF($sql)) { $fieldInfo = mysqli_fetch_field_direct($result, 0); $length = $fieldInfo->length; return $length != 8; } return null; }
function dumpMySQL() { global $dbc; $connexion = $dbc; $entete = "-- ----------------------\n"; $entete .= "-- dump de la base " . $base . " au " . date("d-M-Y") . "\n"; $entete .= "-- ----------------------\n\n\n"; $creations = ""; $insertions = "\n\n"; $listeTables = mysqli_query($connexion, "show tables"); while ($table = mysqli_fetch_array($listeTables)) { // si l'utilisateur a demande la structure ou la totale //if ( $table[0] == "cahiertxt" || $table[0] == "onglets" ) if (mb_ereg("^cahiertxt", $table[0]) || mb_ereg("^onglets", $table[0])) { $creations .= "-- -----------------------------\n"; $creations .= "-- creation de la table " . $table[0] . "\n"; $creations .= "-- -----------------------------\n"; $creations .= "DROP TABLE IF EXISTS `" . $table[0] . "`;\n"; $listeCreationsTables = mysqli_query($connexion, "show create table " . $table[0]); while ($creationTable = mysqli_fetch_array($listeCreationsTables)) { $creations .= $creationTable[1] . ";\n\n"; } //donnees $donnees = mysqli_query($GLOBALS["___mysqli_ston"], "SELECT * FROM " . $table[0] . " WHERE login='******'login'] . "'"); $insertions .= "-- -----------------------------\n"; $insertions .= "-- insertions dans la table " . $table[0] . "\n"; $insertions .= "-- -----------------------------\n"; while ($nuplet = mysqli_fetch_array($donnees)) { $insertions .= "INSERT INTO " . $table[0] . " VALUES("; for ($i = 0; $i < (($___mysqli_tmp = mysqli_num_fields($donnees)) ? $___mysqli_tmp : false); $i++) { if ($i != 0) { $insertions .= ", "; } if ((is_object($___mysqli_tmp = mysqli_fetch_field_direct($donnees, 0)) && !is_null($___mysqli_tmp = $___mysqli_tmp->type) ? ($___mysqli_tmp = (string) substr(($___mysqli_tmp == MYSQLI_TYPE_STRING || $___mysqli_tmp == MYSQLI_TYPE_VAR_STRING ? "string " : "") . (in_array($___mysqli_tmp, array(MYSQLI_TYPE_TINY, MYSQLI_TYPE_SHORT, MYSQLI_TYPE_LONG, MYSQLI_TYPE_LONGLONG, MYSQLI_TYPE_INT24)) ? "int " : "") . (in_array($___mysqli_tmp, array(MYSQLI_TYPE_FLOAT, MYSQLI_TYPE_DOUBLE, MYSQLI_TYPE_DECIMAL, defined("MYSQLI_TYPE_NEWDECIMAL") ? constant("MYSQLI_TYPE_NEWDECIMAL") : -1)) ? "real " : "") . ($___mysqli_tmp == MYSQLI_TYPE_TIMESTAMP ? "timestamp " : "") . ($___mysqli_tmp == MYSQLI_TYPE_YEAR ? "year " : "") . ($___mysqli_tmp == MYSQLI_TYPE_DATE || $___mysqli_tmp == MYSQLI_TYPE_NEWDATE ? "date " : "") . ($___mysqli_tmp == MYSQLI_TYPE_TIME ? "time " : "") . ($___mysqli_tmp == MYSQLI_TYPE_SET ? "set " : "") . ($___mysqli_tmp == MYSQLI_TYPE_ENUM ? "enum " : "") . ($___mysqli_tmp == MYSQLI_TYPE_GEOMETRY ? "geometry " : "") . ($___mysqli_tmp == MYSQLI_TYPE_DATETIME ? "datetime " : "") . (in_array($___mysqli_tmp, array(MYSQLI_TYPE_TINY_BLOB, MYSQLI_TYPE_BLOB, MYSQLI_TYPE_MEDIUM_BLOB, MYSQLI_TYPE_LONG_BLOB)) ? "blob " : "") . ($___mysqli_tmp == MYSQLI_TYPE_NULL ? "null " : ""), 0, -1)) == "" ? "unknown" : $___mysqli_tmp : false) == "string" || (is_object($___mysqli_tmp = mysqli_fetch_field_direct($donnees, 0)) && !is_null($___mysqli_tmp = $___mysqli_tmp->type) ? ($___mysqli_tmp = (string) substr(($___mysqli_tmp == MYSQLI_TYPE_STRING || $___mysqli_tmp == MYSQLI_TYPE_VAR_STRING ? "string " : "") . (in_array($___mysqli_tmp, array(MYSQLI_TYPE_TINY, MYSQLI_TYPE_SHORT, MYSQLI_TYPE_LONG, MYSQLI_TYPE_LONGLONG, MYSQLI_TYPE_INT24)) ? "int " : "") . (in_array($___mysqli_tmp, array(MYSQLI_TYPE_FLOAT, MYSQLI_TYPE_DOUBLE, MYSQLI_TYPE_DECIMAL, defined("MYSQLI_TYPE_NEWDECIMAL") ? constant("MYSQLI_TYPE_NEWDECIMAL") : -1)) ? "real " : "") . ($___mysqli_tmp == MYSQLI_TYPE_TIMESTAMP ? "timestamp " : "") . ($___mysqli_tmp == MYSQLI_TYPE_YEAR ? "year " : "") . ($___mysqli_tmp == MYSQLI_TYPE_DATE || $___mysqli_tmp == MYSQLI_TYPE_NEWDATE ? "date " : "") . ($___mysqli_tmp == MYSQLI_TYPE_TIME ? "time " : "") . ($___mysqli_tmp == MYSQLI_TYPE_SET ? "set " : "") . ($___mysqli_tmp == MYSQLI_TYPE_ENUM ? "enum " : "") . ($___mysqli_tmp == MYSQLI_TYPE_GEOMETRY ? "geometry " : "") . ($___mysqli_tmp == MYSQLI_TYPE_DATETIME ? "datetime " : "") . (in_array($___mysqli_tmp, array(MYSQLI_TYPE_TINY_BLOB, MYSQLI_TYPE_BLOB, MYSQLI_TYPE_MEDIUM_BLOB, MYSQLI_TYPE_LONG_BLOB)) ? "blob " : "") . ($___mysqli_tmp == MYSQLI_TYPE_NULL ? "null " : ""), 0, -1)) == "" ? "unknown" : $___mysqli_tmp : false) == "blob" || (is_object($___mysqli_tmp = mysqli_fetch_field_direct($donnees, 0)) && !is_null($___mysqli_tmp = $___mysqli_tmp->type) ? ($___mysqli_tmp = (string) substr(($___mysqli_tmp == MYSQLI_TYPE_STRING || $___mysqli_tmp == MYSQLI_TYPE_VAR_STRING ? "string " : "") . (in_array($___mysqli_tmp, array(MYSQLI_TYPE_TINY, MYSQLI_TYPE_SHORT, MYSQLI_TYPE_LONG, MYSQLI_TYPE_LONGLONG, MYSQLI_TYPE_INT24)) ? "int " : "") . (in_array($___mysqli_tmp, array(MYSQLI_TYPE_FLOAT, MYSQLI_TYPE_DOUBLE, MYSQLI_TYPE_DECIMAL, defined("MYSQLI_TYPE_NEWDECIMAL") ? constant("MYSQLI_TYPE_NEWDECIMAL") : -1)) ? "real " : "") . ($___mysqli_tmp == MYSQLI_TYPE_TIMESTAMP ? "timestamp " : "") . ($___mysqli_tmp == MYSQLI_TYPE_YEAR ? "year " : "") . ($___mysqli_tmp == MYSQLI_TYPE_DATE || $___mysqli_tmp == MYSQLI_TYPE_NEWDATE ? "date " : "") . ($___mysqli_tmp == MYSQLI_TYPE_TIME ? "time " : "") . ($___mysqli_tmp == MYSQLI_TYPE_SET ? "set " : "") . ($___mysqli_tmp == MYSQLI_TYPE_ENUM ? "enum " : "") . ($___mysqli_tmp == MYSQLI_TYPE_GEOMETRY ? "geometry " : "") . ($___mysqli_tmp == MYSQLI_TYPE_DATETIME ? "datetime " : "") . (in_array($___mysqli_tmp, array(MYSQLI_TYPE_TINY_BLOB, MYSQLI_TYPE_BLOB, MYSQLI_TYPE_MEDIUM_BLOB, MYSQLI_TYPE_LONG_BLOB)) ? "blob " : "") . ($___mysqli_tmp == MYSQLI_TYPE_NULL ? "null " : ""), 0, -1)) == "" ? "unknown" : $___mysqli_tmp : false) == "timestamp" || (is_object($___mysqli_tmp = mysqli_fetch_field_direct($donnees, 0)) && !is_null($___mysqli_tmp = $___mysqli_tmp->type) ? ($___mysqli_tmp = (string) substr(($___mysqli_tmp == MYSQLI_TYPE_STRING || $___mysqli_tmp == MYSQLI_TYPE_VAR_STRING ? "string " : "") . (in_array($___mysqli_tmp, array(MYSQLI_TYPE_TINY, MYSQLI_TYPE_SHORT, MYSQLI_TYPE_LONG, MYSQLI_TYPE_LONGLONG, MYSQLI_TYPE_INT24)) ? "int " : "") . (in_array($___mysqli_tmp, array(MYSQLI_TYPE_FLOAT, MYSQLI_TYPE_DOUBLE, MYSQLI_TYPE_DECIMAL, defined("MYSQLI_TYPE_NEWDECIMAL") ? constant("MYSQLI_TYPE_NEWDECIMAL") : -1)) ? "real " : "") . ($___mysqli_tmp == MYSQLI_TYPE_TIMESTAMP ? "timestamp " : "") . ($___mysqli_tmp == MYSQLI_TYPE_YEAR ? "year " : "") . ($___mysqli_tmp == MYSQLI_TYPE_DATE || $___mysqli_tmp == MYSQLI_TYPE_NEWDATE ? "date " : "") . ($___mysqli_tmp == MYSQLI_TYPE_TIME ? "time " : "") . ($___mysqli_tmp == MYSQLI_TYPE_SET ? "set " : "") . ($___mysqli_tmp == MYSQLI_TYPE_ENUM ? "enum " : "") . ($___mysqli_tmp == MYSQLI_TYPE_GEOMETRY ? "geometry " : "") . ($___mysqli_tmp == MYSQLI_TYPE_DATETIME ? "datetime " : "") . (in_array($___mysqli_tmp, array(MYSQLI_TYPE_TINY_BLOB, MYSQLI_TYPE_BLOB, MYSQLI_TYPE_MEDIUM_BLOB, MYSQLI_TYPE_LONG_BLOB)) ? "blob " : "") . ($___mysqli_tmp == MYSQLI_TYPE_NULL ? "null " : ""), 0, -1)) == "" ? "unknown" : $___mysqli_tmp : false) == "date") { $insertions .= "'"; } $insertions .= addslashes($nuplet[$i]); if ((is_object($___mysqli_tmp = mysqli_fetch_field_direct($donnees, 0)) && !is_null($___mysqli_tmp = $___mysqli_tmp->type) ? ($___mysqli_tmp = (string) substr(($___mysqli_tmp == MYSQLI_TYPE_STRING || $___mysqli_tmp == MYSQLI_TYPE_VAR_STRING ? "string " : "") . (in_array($___mysqli_tmp, array(MYSQLI_TYPE_TINY, MYSQLI_TYPE_SHORT, MYSQLI_TYPE_LONG, MYSQLI_TYPE_LONGLONG, MYSQLI_TYPE_INT24)) ? "int " : "") . (in_array($___mysqli_tmp, array(MYSQLI_TYPE_FLOAT, MYSQLI_TYPE_DOUBLE, MYSQLI_TYPE_DECIMAL, defined("MYSQLI_TYPE_NEWDECIMAL") ? constant("MYSQLI_TYPE_NEWDECIMAL") : -1)) ? "real " : "") . ($___mysqli_tmp == MYSQLI_TYPE_TIMESTAMP ? "timestamp " : "") . ($___mysqli_tmp == MYSQLI_TYPE_YEAR ? "year " : "") . ($___mysqli_tmp == MYSQLI_TYPE_DATE || $___mysqli_tmp == MYSQLI_TYPE_NEWDATE ? "date " : "") . ($___mysqli_tmp == MYSQLI_TYPE_TIME ? "time " : "") . ($___mysqli_tmp == MYSQLI_TYPE_SET ? "set " : "") . ($___mysqli_tmp == MYSQLI_TYPE_ENUM ? "enum " : "") . ($___mysqli_tmp == MYSQLI_TYPE_GEOMETRY ? "geometry " : "") . ($___mysqli_tmp == MYSQLI_TYPE_DATETIME ? "datetime " : "") . (in_array($___mysqli_tmp, array(MYSQLI_TYPE_TINY_BLOB, MYSQLI_TYPE_BLOB, MYSQLI_TYPE_MEDIUM_BLOB, MYSQLI_TYPE_LONG_BLOB)) ? "blob " : "") . ($___mysqli_tmp == MYSQLI_TYPE_NULL ? "null " : ""), 0, -1)) == "" ? "unknown" : $___mysqli_tmp : false) == "string" || (is_object($___mysqli_tmp = mysqli_fetch_field_direct($donnees, 0)) && !is_null($___mysqli_tmp = $___mysqli_tmp->type) ? ($___mysqli_tmp = (string) substr(($___mysqli_tmp == MYSQLI_TYPE_STRING || $___mysqli_tmp == MYSQLI_TYPE_VAR_STRING ? "string " : "") . (in_array($___mysqli_tmp, array(MYSQLI_TYPE_TINY, MYSQLI_TYPE_SHORT, MYSQLI_TYPE_LONG, MYSQLI_TYPE_LONGLONG, MYSQLI_TYPE_INT24)) ? "int " : "") . (in_array($___mysqli_tmp, array(MYSQLI_TYPE_FLOAT, MYSQLI_TYPE_DOUBLE, MYSQLI_TYPE_DECIMAL, defined("MYSQLI_TYPE_NEWDECIMAL") ? constant("MYSQLI_TYPE_NEWDECIMAL") : -1)) ? "real " : "") . ($___mysqli_tmp == MYSQLI_TYPE_TIMESTAMP ? "timestamp " : "") . ($___mysqli_tmp == MYSQLI_TYPE_YEAR ? "year " : "") . ($___mysqli_tmp == MYSQLI_TYPE_DATE || $___mysqli_tmp == MYSQLI_TYPE_NEWDATE ? "date " : "") . ($___mysqli_tmp == MYSQLI_TYPE_TIME ? "time " : "") . ($___mysqli_tmp == MYSQLI_TYPE_SET ? "set " : "") . ($___mysqli_tmp == MYSQLI_TYPE_ENUM ? "enum " : "") . ($___mysqli_tmp == MYSQLI_TYPE_GEOMETRY ? "geometry " : "") . ($___mysqli_tmp == MYSQLI_TYPE_DATETIME ? "datetime " : "") . (in_array($___mysqli_tmp, array(MYSQLI_TYPE_TINY_BLOB, MYSQLI_TYPE_BLOB, MYSQLI_TYPE_MEDIUM_BLOB, MYSQLI_TYPE_LONG_BLOB)) ? "blob " : "") . ($___mysqli_tmp == MYSQLI_TYPE_NULL ? "null " : ""), 0, -1)) == "" ? "unknown" : $___mysqli_tmp : false) == "blob" || (is_object($___mysqli_tmp = mysqli_fetch_field_direct($donnees, 0)) && !is_null($___mysqli_tmp = $___mysqli_tmp->type) ? ($___mysqli_tmp = (string) substr(($___mysqli_tmp == MYSQLI_TYPE_STRING || $___mysqli_tmp == MYSQLI_TYPE_VAR_STRING ? "string " : "") . (in_array($___mysqli_tmp, array(MYSQLI_TYPE_TINY, MYSQLI_TYPE_SHORT, MYSQLI_TYPE_LONG, MYSQLI_TYPE_LONGLONG, MYSQLI_TYPE_INT24)) ? "int " : "") . (in_array($___mysqli_tmp, array(MYSQLI_TYPE_FLOAT, MYSQLI_TYPE_DOUBLE, MYSQLI_TYPE_DECIMAL, defined("MYSQLI_TYPE_NEWDECIMAL") ? constant("MYSQLI_TYPE_NEWDECIMAL") : -1)) ? "real " : "") . ($___mysqli_tmp == MYSQLI_TYPE_TIMESTAMP ? "timestamp " : "") . ($___mysqli_tmp == MYSQLI_TYPE_YEAR ? "year " : "") . ($___mysqli_tmp == MYSQLI_TYPE_DATE || $___mysqli_tmp == MYSQLI_TYPE_NEWDATE ? "date " : "") . ($___mysqli_tmp == MYSQLI_TYPE_TIME ? "time " : "") . ($___mysqli_tmp == MYSQLI_TYPE_SET ? "set " : "") . ($___mysqli_tmp == MYSQLI_TYPE_ENUM ? "enum " : "") . ($___mysqli_tmp == MYSQLI_TYPE_GEOMETRY ? "geometry " : "") . ($___mysqli_tmp == MYSQLI_TYPE_DATETIME ? "datetime " : "") . (in_array($___mysqli_tmp, array(MYSQLI_TYPE_TINY_BLOB, MYSQLI_TYPE_BLOB, MYSQLI_TYPE_MEDIUM_BLOB, MYSQLI_TYPE_LONG_BLOB)) ? "blob " : "") . ($___mysqli_tmp == MYSQLI_TYPE_NULL ? "null " : ""), 0, -1)) == "" ? "unknown" : $___mysqli_tmp : false) == "timestamp" || (is_object($___mysqli_tmp = mysqli_fetch_field_direct($donnees, 0)) && !is_null($___mysqli_tmp = $___mysqli_tmp->type) ? ($___mysqli_tmp = (string) substr(($___mysqli_tmp == MYSQLI_TYPE_STRING || $___mysqli_tmp == MYSQLI_TYPE_VAR_STRING ? "string " : "") . (in_array($___mysqli_tmp, array(MYSQLI_TYPE_TINY, MYSQLI_TYPE_SHORT, MYSQLI_TYPE_LONG, MYSQLI_TYPE_LONGLONG, MYSQLI_TYPE_INT24)) ? "int " : "") . (in_array($___mysqli_tmp, array(MYSQLI_TYPE_FLOAT, MYSQLI_TYPE_DOUBLE, MYSQLI_TYPE_DECIMAL, defined("MYSQLI_TYPE_NEWDECIMAL") ? constant("MYSQLI_TYPE_NEWDECIMAL") : -1)) ? "real " : "") . ($___mysqli_tmp == MYSQLI_TYPE_TIMESTAMP ? "timestamp " : "") . ($___mysqli_tmp == MYSQLI_TYPE_YEAR ? "year " : "") . ($___mysqli_tmp == MYSQLI_TYPE_DATE || $___mysqli_tmp == MYSQLI_TYPE_NEWDATE ? "date " : "") . ($___mysqli_tmp == MYSQLI_TYPE_TIME ? "time " : "") . ($___mysqli_tmp == MYSQLI_TYPE_SET ? "set " : "") . ($___mysqli_tmp == MYSQLI_TYPE_ENUM ? "enum " : "") . ($___mysqli_tmp == MYSQLI_TYPE_GEOMETRY ? "geometry " : "") . ($___mysqli_tmp == MYSQLI_TYPE_DATETIME ? "datetime " : "") . (in_array($___mysqli_tmp, array(MYSQLI_TYPE_TINY_BLOB, MYSQLI_TYPE_BLOB, MYSQLI_TYPE_MEDIUM_BLOB, MYSQLI_TYPE_LONG_BLOB)) ? "blob " : "") . ($___mysqli_tmp == MYSQLI_TYPE_NULL ? "null " : ""), 0, -1)) == "" ? "unknown" : $___mysqli_tmp : false) == "date") { $insertions .= "'"; } } $insertions .= ");\n"; } $insertions .= "\n"; } } is_null($___mysqli_res = mysqli_close($connexion)) ? false : $___mysqli_res; $rep_tmp = "/tmp/" . $_SESSION['login']; mkdir($rep_tmp); $fichierDump = fopen($rep_tmp . "/dump.sql", "wb"); fwrite($fichierDump, $entete); fwrite($fichierDump, $creations); fwrite($fichierDump, $insertions); fclose($fichierDump); }
function mysqli_field_type($result, $field_offset) { static $types; $type_id = mysqli_fetch_field_direct($result, $field_offset)->type; if (!isset($types)) { $types = array(); $constants = get_defined_constants(true); foreach ($constants['mysqli'] as $c => $n) { if (preg_match('/^MYSQLI_TYPE_(.*)/', $c, $m)) { $types[$n] = $m[1]; } } } return array_key_exists($type_id, $types) ? $types[$type_id] : NULL; }
case "mysql": $ret = mysql_field_len($result, $offset); break; case "mysqli": $tmp = mysqli_fetch_field_direct($result, $offset); $ret = $tmp->length; break; } return $ret; } function yog_mysql_field_flags($result, $offset) { //Get the flags associated with the specified field in a result $ret = 0; switch (DB_EXTENSION) { case "mysql":
/** * Parse resource into array * * @param resource $resource * @return array */ public function parse($resource) { $result = array(); $fieldcnt = mysqli_num_fields($resource); $fields_transform = array(); for ($i = 0; $i < $fieldcnt; $i++) { $finfo = mysqli_fetch_field_direct($resource, $i); if (isset(self::$mysqli_type[$finfo->type])) { $fields_transform[$finfo->name] = self::$mysqli_to_php[self::$mysqli_type[$finfo->type]]; } } while ($row = mysqli_fetch_assoc($resource)) { foreach ($fields_transform as $fieldname => $fieldtype) { settype($row[$fieldname], $fieldtype); } $result[] = $row; } return $result; }
function field_name($offset, $query_id = 0) { global $db_type; if (!$query_id) { $query_id = $this->query_result; } if ($query_id) { switch ($db_type) { case 'mysql': $result = @mysql_field_name($query_id, $offset); break; case 'mysqli': $finfo = @mysqli_fetch_field_direct($query_id, $offset); $result = $finfo->name; } return $result; } else { return false; } }
function TableShow($result) { echo "<table>"; echo "<tr>"; // print headers for ($i = 0; $i < mysqli_num_fields($result); $i++) { $field_info = mysqli_fetch_field_direct($result, $i); echo "<th>{$field_info->name}</th>"; } echo "</tr>"; // print data while ($tableRow = mysqli_fetch_assoc($result)) { echo "<tr>"; foreach ($tableRow as $key => $value) { echo "<td>" . $tableRow[$key] . "</td>"; //echo $key; } echo "</tr>"; } echo "</table>"; }
/** * Returns metadata for all columns in a result set. * @return array */ public function getResultColumns() { static $types; if ($types === NULL) { $consts = get_defined_constants(TRUE); $types = []; foreach (isset($consts['mysqli']) ? $consts['mysqli'] : [] as $key => $value) { if (strncmp($key, 'MYSQLI_TYPE_', 12) === 0) { $types[$value] = substr($key, 12); } } $types[MYSQLI_TYPE_TINY] = $types[MYSQLI_TYPE_SHORT] = $types[MYSQLI_TYPE_LONG] = 'INT'; } $count = mysqli_num_fields($this->resultSet); $columns = []; for ($i = 0; $i < $count; $i++) { $row = (array) mysqli_fetch_field_direct($this->resultSet, $i); $columns[] = ['name' => $row['name'], 'table' => $row['orgtable'], 'fullname' => $row['table'] ? $row['table'] . '.' . $row['name'] : $row['name'], 'nativetype' => isset($types[$row['type']]) ? $types[$row['type']] : $row['type'], 'type' => $row['type'] === MYSQLI_TYPE_TIME ? Dibi\Type::TIME_INTERVAL : NULL, 'vendor' => $row]; } return $columns; }
/** * Retrieve the names of columns returned by the DBMS in a query result. * * @return mixed Array variable that holds the names of columns as keys * or an MDB2 error on failure. * Some DBMS may not return any columns when the result set * does not contain any rows. * @access private */ function _getColumnNames() { $columns = array(); $numcols = $this->numCols(); if (PEAR::isError($numcols)) { return $numcols; } for ($column = 0; $column < $numcols; $column++) { $column_info = @mysqli_fetch_field_direct($this->result, $column); $columns[$column_info->name] = $column; } if ($this->db->options['portability'] & MDB2_PORTABILITY_FIX_CASE) { $columns = array_change_key_case($columns, $this->db->options['field_case']); } return $columns; }
/** * returns concatenated string of human readable field flags * * @param mysqli_result $result result set identifier * @param int $i field * * @return string field flags */ public function fieldFlags($result, $i) { $f = mysqli_fetch_field_direct($result, $i); $type = $f->type; $charsetnr = $f->charsetnr; $f = $f->flags; $flags = array(); foreach ($GLOBALS['pma_mysqli_flag_names'] as $flag => $name) { if ($f & $flag) { $flags[] = $name; } } // See http://dev.mysql.com/doc/refman/6.0/en/c-api-datatypes.html: // to determine if a string is binary, we should not use MYSQLI_BINARY_FLAG // but instead the charsetnr member of the MYSQL_FIELD // structure. Watch out: some types like DATE returns 63 in charsetnr // so we have to check also the type. // Unfortunately there is no equivalent in the mysql extension. if (($type == MYSQLI_TYPE_TINY_BLOB || $type == MYSQLI_TYPE_BLOB || $type == MYSQLI_TYPE_MEDIUM_BLOB || $type == MYSQLI_TYPE_LONG_BLOB || $type == MYSQLI_TYPE_VAR_STRING || $type == MYSQLI_TYPE_STRING) && 63 == $charsetnr) { $flags[] = 'binary'; } return implode(' ', $flags); }
/** * returns concatenated string of human readable field flags * * @uses MYSQLI_UNIQUE_KEY_FLAG * @uses MYSQLI_NUM_FLAG * @uses MYSQLI_PART_KEY_FLAG * @uses MYSQLI_TYPE_SET * @uses MYSQLI_TIMESTAMP_FLAG * @uses MYSQLI_AUTO_INCREMENT_FLAG * @uses MYSQLI_TYPE_ENUM * @uses MYSQLI_BINARY_FLAG * @uses MYSQLI_ZEROFILL_FLAG * @uses MYSQLI_UNSIGNED_FLAG * @uses MYSQLI_BLOB_FLAG * @uses MYSQLI_MULTIPLE_KEY_FLAG * @uses MYSQLI_UNIQUE_KEY_FLAG * @uses MYSQLI_PRI_KEY_FLAG * @uses MYSQLI_NOT_NULL_FLAG * @uses mysqli_fetch_field_direct() * @uses PMA_convert_display_charset() * @param object mysqli result $result * @param integer $i field * @return string field flags */ function PMA_DBI_field_flags($result, $i) { $f = mysqli_fetch_field_direct($result, $i); $f = $f->flags; $flags = ''; if ($f & MYSQLI_UNIQUE_KEY_FLAG) { $flags .= 'unique '; } if ($f & MYSQLI_NUM_FLAG) { $flags .= 'num '; } if ($f & MYSQLI_PART_KEY_FLAG) { $flags .= 'part_key '; } if ($f & MYSQLI_TYPE_SET) { $flags .= 'set '; } if ($f & MYSQLI_TIMESTAMP_FLAG) { $flags .= 'timestamp '; } if ($f & MYSQLI_AUTO_INCREMENT_FLAG) { $flags .= 'auto_increment '; } if ($f & MYSQLI_TYPE_ENUM) { $flags .= 'enum '; } // @TODO seems to be outdated if ($f & MYSQLI_BINARY_FLAG) { $flags .= 'binary '; } if ($f & MYSQLI_ZEROFILL_FLAG) { $flags .= 'zerofill '; } if ($f & MYSQLI_UNSIGNED_FLAG) { $flags .= 'unsigned '; } if ($f & MYSQLI_BLOB_FLAG) { $flags .= 'blob '; } if ($f & MYSQLI_MULTIPLE_KEY_FLAG) { $flags .= 'multiple_key '; } if ($f & MYSQLI_UNIQUE_KEY_FLAG) { $flags .= 'unique_key '; } if ($f & MYSQLI_PRI_KEY_FLAG) { $flags .= 'primary_key '; } if ($f & MYSQLI_NOT_NULL_FLAG) { $flags .= 'not_null '; } return PMA_convert_display_charset(trim($flags)); }
/** * Returns the last query as a JSON document * * @return string JSON containing all records listed */ public function GetJSON() { if ($this->last_result) { if ($this->RowCount() > 0) { for ($i = 0, $il = mysqli_field_count($this->mysql_link); $i < $il; $i++) { $field = mysqli_fetch_field_direct($this->last_result, $i); $types[$i] = $field->type; } $json = '['; $this->MoveFirst(); while ($member = mysqli_fetch_object($this->last_result)) { $json .= json_encode($member) . ","; } $json .= ']'; $json = str_replace("},]", "}]", $json); } else { $json = 'null'; } } else { $this->active_row = -1; $json = 'null'; } return $json; }
/** * returns concatenated string of human readable field flags * * @param mysqli_result $result result set identifier * @param int $i field * * @return string field flags */ function PMA_DBI_field_flags($result, $i) { // This is missing from PHP 5.2.5, see http://bugs.php.net/bug.php?id=44846 if (!defined('MYSQLI_ENUM_FLAG')) { define('MYSQLI_ENUM_FLAG', 256); // see MySQL source include/mysql_com.h } $f = mysqli_fetch_field_direct($result, $i); $type = $f->type; $charsetnr = $f->charsetnr; $f = $f->flags; $flags = ''; if ($f & MYSQLI_UNIQUE_KEY_FLAG) { $flags .= 'unique '; } if ($f & MYSQLI_NUM_FLAG) { $flags .= 'num '; } if ($f & MYSQLI_PART_KEY_FLAG) { $flags .= 'part_key '; } if ($f & MYSQLI_SET_FLAG) { $flags .= 'set '; } if ($f & MYSQLI_TIMESTAMP_FLAG) { $flags .= 'timestamp '; } if ($f & MYSQLI_AUTO_INCREMENT_FLAG) { $flags .= 'auto_increment '; } if ($f & MYSQLI_ENUM_FLAG) { $flags .= 'enum '; } // See http://dev.mysql.com/doc/refman/6.0/en/c-api-datatypes.html: // to determine if a string is binary, we should not use MYSQLI_BINARY_FLAG // but instead the charsetnr member of the MYSQL_FIELD // structure. Watch out: some types like DATE returns 63 in charsetnr // so we have to check also the type. // Unfortunately there is no equivalent in the mysql extension. if (($type == MYSQLI_TYPE_TINY_BLOB || $type == MYSQLI_TYPE_BLOB || $type == MYSQLI_TYPE_MEDIUM_BLOB || $type == MYSQLI_TYPE_LONG_BLOB || $type == MYSQLI_TYPE_VAR_STRING || $type == MYSQLI_TYPE_STRING) && 63 == $charsetnr) { $flags .= 'binary '; } if ($f & MYSQLI_ZEROFILL_FLAG) { $flags .= 'zerofill '; } if ($f & MYSQLI_UNSIGNED_FLAG) { $flags .= 'unsigned '; } if ($f & MYSQLI_BLOB_FLAG) { $flags .= 'blob '; } if ($f & MYSQLI_MULTIPLE_KEY_FLAG) { $flags .= 'multiple_key '; } if ($f & MYSQLI_UNIQUE_KEY_FLAG) { $flags .= 'unique_key '; } if ($f & MYSQLI_PRI_KEY_FLAG) { $flags .= 'primary_key '; } if ($f & MYSQLI_NOT_NULL_FLAG) { $flags .= 'not_null '; } return trim($flags); }
/** * @see DBManager::getFieldsArray() */ public function getFieldsArray(&$result, $make_lower_case = false) { $field_array = array(); if (!isset($result) || empty($result)) { return 0; } $i = 0; while ($i < mysqli_num_fields($result)) { $meta = mysqli_fetch_field_direct($result, $i); if (!$meta) { return 0; } if ($make_lower_case == true) { $meta->name = strtolower($meta->name); } $field_array[] = $meta->name; $i++; } return $field_array; }
/** * Enter description here... * * @param unknown_type $results */ function resultSet(&$results) { if (isset($this->results) && is_resource($this->results) && $this->results != $results) { mysqli_free_result($this->results); } $this->results =& $results; $this->map = array(); $numFields = mysqli_num_fields($results); $index = 0; $j = 0; while ($j < $numFields) { $column = mysqli_fetch_field_direct($results, $j); if (!empty($column->table)) { $this->map[$index++] = array($column->table, $column->name); } else { $this->map[$index++] = array(0, $column->name); } $j++; } }
$search_pool_sqlsafe = "SELECT * FROM Participants " . $status_sqlsafe . $join_inst_sqlsafe . $benchmarks_sqlsafe . $date_join_sqlsafe . $organizer_join_sqlsafe . $member_type_join_sqlsafe . "LEFT JOIN Participants_Properties ON Participants.Participant_ID=Participants_Properties.Participant_ID\r\n WHERE Participants.Participant_ID IS NOT NULL " . $institution_sqlsafe . $type_sqlsafe . $step_sqlsafe . $step_done_sqlsafe . $start_sqlsafe . $end_sqlsafe . $lag_sqlsafe . $organizer_sqlsafe . $first_name_sqlsafe . $last_name_sqlsafe . $email_sqlsafe . $phone_sqlsafe . $notes_sqlsafe . $date_of_birth_sqlsafe . $gender_sqlsafe . $has_itin_sqlsafe . $ward_sqlsafe . $language_spoken_sqlsafe; //echo $search_pool . "<p>"; include "../include/dbconnopen.php"; $search_results = mysqli_query($cnnSWOP, $search_pool_sqlsafe); ?> <table class="all_projects"> <caption>Choose the columns you would like to view and export for this query:</caption> <?php $num_columns = mysqli_field_count($cnnSWOP); //echo $num_columns; //this is brought over from PAWS. I'm trying to give Sarah what she wants in terms of checkboxes to determine which search fields will be //returned. $table = ''; for ($k = 0; $k < $num_columns; $k++) { $get_column_names = mysqli_fetch_field_direct($search_results, $k); //skip Name_Middle field if ($get_column_names->name == "Name_Middle") { continue; } if ($get_column_names->table != 'progress' && $get_column_names->table != 'laststatus') { if ($get_column_names->table != $table) { $table = $get_column_names->table; ?> <tr class="note"><th colspan="4"><a href="javascript:;" onclick=" $('.<?php echo $table; ?> _row').toggle(); "><?php echo $table;
require_once "connect.inc"; /*** test mysqli_connect 127.0.0.1 ***/ $link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket); mysqli_select_db($link, $db); mysqli_query($link, "DROP TABLE IF EXISTS test_047_table_1"); mysqli_query($link, "CREATE TABLE test_047_table_1 (foo int, bar varchar(10) character set latin1) ENGINE=" . $engine); mysqli_query($link, "INSERT INTO test_047_table_1 VALUES (1, 'Zak'),(2, 'Greant')"); $stmt = mysqli_prepare($link, "SELECT * FROM test_047_table_1"); mysqli_stmt_execute($stmt); $result = mysqli_stmt_result_metadata($stmt); echo "\n=== fetch_fields ===\n"; var_dump(mysqli_fetch_fields($result)); echo "\n=== fetch_field_direct ===\n"; var_dump(mysqli_fetch_field_direct($result, 0)); var_dump(mysqli_fetch_field_direct($result, 1)); echo "\n=== fetch_field ===\n"; while ($field = mysqli_fetch_field($result)) { var_dump($field); } print_r(mysqli_fetch_lengths($result)); mysqli_free_result($result); mysqli_stmt_close($stmt); mysqli_query($link, "DROP TABLE IF EXISTS test_047_table_1"); mysqli_close($link); print "done!"; require_once "connect.inc"; if (!($link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket))) { printf("[c001] [%d] %s\n", mysqli_connect_errno(), mysqli_connect_error()); } if (!mysqli_query($link, "DROP TABLE IF EXISTS test_047_table_1")) {
function testStatement($offset, $link, $sql, $expected_lib, $expected_mysqlnd, $check_mysqlnd, $compare) { if (!($stmt = mysqli_stmt_init($link))) { printf("[%04d - %s] [%d] %s\n", $offset, $sql, mysqli_errno($link), mysqli_error($link)); return false; } if (!@mysqli_stmt_prepare($stmt, $sql)) { /* Not all server versions will support all statements */ /* Failing to prepare is OK */ return true; } if (empty($expected_lib) && false !== $res) { printf("[%04d - %s] No metadata expected\n", $offset + 1, $sql); return false; } else { if (!empty($expected_lib) && false == $res) { printf("[%04d - %s] Metadata expected\n", $offset + 2, $sql); return false; } } if (!empty($expected_lib)) { if (!is_object($res)) { printf("[%04d - %s] [%d] %s\n", $offset + 3, $sql, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); return false; } if (get_class($res) != 'mysqli_result') { printf("[%04d - %s] Expecting object/mysqli_result got object/%s\n", $offset + 4, $sql, get_class($res)); return false; } $meta = array('num_fields' => mysqli_num_fields($res), 'fetch_field' => mysqli_fetch_field($res), 'fetch_field_direct0' => mysqli_fetch_field_direct($res, 0), 'fetch_field_direct1' => @mysqli_fetch_field_direct($res, 1), 'fetch_fields' => count(mysqli_fetch_fields($res)), 'field_count' => $res->field_count, 'field_seek-1' => @mysqli_field_seek($res, -1), 'field_seek0' => mysqli_field_seek($res, 0), 'field_tell' => mysqli_field_tell($res)); if (is_object($meta['fetch_field'])) { $meta['fetch_field']->charsetnr = 'ignore'; $meta['fetch_field']->flags = 'ignore'; } if (is_object($meta['fetch_field_direct0'])) { $meta['fetch_field_direct0']->charsetnr = 'ignore'; $meta['fetch_field_direct0']->flags = 'ignore'; } if (is_object($meta['fetch_field_direct1'])) { $meta['fetch_field_direct1']->charsetnr = 'ignore'; $meta['fetch_field_direct1']->flags = 'ignore'; } mysqli_free_result($res); if ($meta != $expected_lib) { printf("[%04d - %s] Metadata differs from expected values\n", $offset + 5, $sql); var_dump($meta); var_dump($expected_lib); return false; } } if (function_exists('mysqli_stmt_get_result')) { /* mysqlnd only */ if (!mysqli_stmt_execute($stmt)) { printf("[%04d - %s] [%d] %s\n", $offset + 6, $sql, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); return false; } $res = mysqli_stmt_get_result($stmt); if (false === $res && !empty($expected_mysqlnd)) { printf("[%04d - %s] Expecting resultset [%d] %s\n", $offset + 7, $sql, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); return false; } else { if (empty($expected_mysqlnd) && false !== $res) { printf("[%04d - %s] Unexpected resultset [%d] %s\n", $offset + 8, $sql, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); return false; } } if (!is_object($res)) { printf("[%04d - %s] [%d] %s\n", $offset + 9, $sql, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); return false; } if ('mysqli_result' != get_class($res)) { printf("[%04d - %s] Expecting object/mysqli_result got object/%s\n", $offset + 10, $sql, get_class($res)); return false; } $meta_res = array('num_fields' => mysqli_num_fields($res), 'fetch_field' => mysqli_fetch_field($res), 'fetch_field_direct0' => mysqli_fetch_field_direct($res, 0), 'fetch_field_direct1' => @mysqli_fetch_field_direct($res, 1), 'fetch_fields' => count(mysqli_fetch_fields($res)), 'field_count' => mysqli_field_count($link), 'field_seek-1' => @mysqli_field_seek($res, -1), 'field_seek0' => mysqli_field_seek($res, 0), 'field_tell' => mysqli_field_tell($res)); if (is_object($meta_res['fetch_field'])) { $meta_res['fetch_field']->charsetnr = 'ignore'; $meta_res['fetch_field']->flags = 'ignore'; } if (is_object($meta_res['fetch_field_direct0'])) { $meta_res['fetch_field_direct0']->charsetnr = 'ignore'; $meta_res['fetch_field_direct0']->flags = 'ignore'; } if (is_object($meta_res['fetch_field_direct1'])) { $meta_res['fetch_field_direct1']->charsetnr = 'ignore'; $meta_res['fetch_field_direct1']->flags = 'ignore'; } mysqli_free_result($res); if ($check_mysqlnd && $meta_res != $expected_mysqlnd) { printf("[%04d - %s] Metadata differs from expected\n", $offset + 11, $sql); var_dump($meta_res); var_dump($expected_mysqlnd); } else { if ($meta_res['field_count'] < 1) { printf("[%04d - %s] Metadata seems wrong, no fields?\n", $offset + 12, $sql); var_dump($meta_res); var_dump(mysqli_fetch_assoc($res)); } } if ($compare && $meta_res != $meta) { printf("[%04d - %s] Metadata returned by mysqli_stmt_result_metadata() and mysqli_stmt_get_result() differ\n", $offset + 13, $sql); var_dump($meta_res); var_dump($meta); } } mysqli_stmt_close($stmt); return true; }
/** * Returns metadata for all columns in a result set. * @return array */ public function getResultColumns() { static $types; if (empty($types)) { $consts = get_defined_constants(TRUE); foreach ($consts['mysqli'] as $key => $value) { if (strncmp($key, 'MYSQLI_TYPE_', 12) === 0) { $types[$value] = substr($key, 12); } } $types[MYSQLI_TYPE_TINY] = $types[MYSQLI_TYPE_SHORT] = $types[MYSQLI_TYPE_LONG] = 'INT'; } $count = mysqli_num_fields($this->resultSet); $columns = array(); for ($i = 0; $i < $count; $i++) { $row = (array) mysqli_fetch_field_direct($this->resultSet, $i); $columns[] = array('name' => $row['name'], 'table' => $row['orgtable'], 'fullname' => $row['table'] ? $row['table'] . '.' . $row['name'] : $row['name'], 'nativetype' => $types[$row['type']], 'vendor' => $row); } return $columns; }
function loadFieldFromTable($data) { $num = mysqli_num_fields($data); $result = array(); while ($row = mysqli_fetch_assoc($data)) { $j = 0; while ($j < $num) { $value = $row[mysqli_fetch_field_direct($data, $j)->name]; $field = mysqli_fetch_field_direct($data, $j)->name; $result[$field] = $value; $j++; } } return $result; }
function FieldName($iCol) { $fieldInfo = mysqli_fetch_field_direct($this->result, $iCol); return $fieldInfo->name; }
<?php require_once "connect.inc"; $tmp = NULL; $link = NULL; $test_table_name = 'test_mysqli_fetch_field_direct_table_1'; require 'table.inc'; if (!($res = mysqli_query($link, "SELECT id AS ID, label FROM test_mysqli_fetch_field_direct_table_1 AS TEST ORDER BY id LIMIT 1"))) { printf("[004] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); } var_dump(mysqli_fetch_field_direct($res, -1)); var_dump(mysqli_fetch_field_direct($res, 0)); var_dump(mysqli_fetch_field_direct($res, 2)); mysqli_free_result($res); if (NULL !== ($tmp = mysqli_fetch_field_direct($res, 0))) { printf("Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); } mysqli_close($link); print "done!"; error_reporting(0); $test_table_name = 'test_mysqli_fetch_field_direct_table_1'; require_once "clean_table.inc";
function db_field_name($result, $field_offset) { $finfo = @mysqli_fetch_field_direct($result, $field_offset); if ($finfo != NULL) { return $finfo->name; } else { return NULL; } }
<?php if (!isset($buscar)) { echo "Debe especificar una cadena a bucar"; echo "</html></body> \n"; exit; } //$link = mysql_connect("localhost", "nobody"); //mysql_select_db("mydb", $link); require_once "../handyq/includes/mysql.php"; $db = new MySQL(); $result = mysqli_query($mysqli, "SELECT * FROM enlaces WHERE titulo LIKE '%{$buscar}%' ORDER BY titulo"); if ($row = mysqli_fetch_array($result)) { echo "<table border = '1'> \n"; //Mostramos los nombres de las tablas echo "<tr> \n"; while ($field = ($___mysqli_tmp = mysqli_fetch_field_direct($result, mysqli_field_tell($result))) && is_object($___mysqli_tmp) ? !is_null($___mysqli_tmp->primary_key = $___mysqli_tmp->flags & MYSQLI_PRI_KEY_FLAG ? 1 : 0) && !is_null($___mysqli_tmp->multiple_key = $___mysqli_tmp->flags & MYSQLI_MULTIPLE_KEY_FLAG ? 1 : 0) && !is_null($___mysqli_tmp->unique_key = $___mysqli_tmp->flags & MYSQLI_UNIQUE_KEY_FLAG ? 1 : 0) && !is_null($___mysqli_tmp->numeric = (int) ($___mysqli_tmp->type <= MYSQLI_TYPE_INT24 || $___mysqli_tmp->type == MYSQLI_TYPE_YEAR || (defined("MYSQLI_TYPE_NEWDECIMAL") ? $___mysqli_tmp->type == MYSQLI_TYPE_NEWDECIMAL : 0))) && !is_null($___mysqli_tmp->blob = (int) in_array($___mysqli_tmp->type, array(MYSQLI_TYPE_TINY_BLOB, MYSQLI_TYPE_BLOB, MYSQLI_TYPE_MEDIUM_BLOB, MYSQLI_TYPE_LONG_BLOB))) && !is_null($___mysqli_tmp->unsigned = $___mysqli_tmp->flags & MYSQLI_UNSIGNED_FLAG ? 1 : 0) && !is_null($___mysqli_tmp->zerofill = $___mysqli_tmp->flags & MYSQLI_ZEROFILL_FLAG ? 1 : 0) && !is_null($___mysqli_type = $___mysqli_tmp->type) && !is_null($___mysqli_tmp->type = $___mysqli_type == MYSQLI_TYPE_STRING || $___mysqli_type == MYSQLI_TYPE_VAR_STRING ? "type" : "") && !is_null($___mysqli_tmp->type = "" == $___mysqli_tmp->type && in_array($___mysqli_type, array(MYSQLI_TYPE_TINY, MYSQLI_TYPE_SHORT, MYSQLI_TYPE_LONG, MYSQLI_TYPE_LONGLONG, MYSQLI_TYPE_INT24)) ? "int" : $___mysqli_tmp->type) && !is_null($___mysqli_tmp->type = "" == $___mysqli_tmp->type && in_array($___mysqli_type, array(MYSQLI_TYPE_FLOAT, MYSQLI_TYPE_DOUBLE, MYSQLI_TYPE_DECIMAL, defined("MYSQLI_TYPE_NEWDECIMAL") ? constant("MYSQLI_TYPE_NEWDECIMAL") : -1)) ? "real" : $___mysqli_tmp->type) && !is_null($___mysqli_tmp->type = "" == $___mysqli_tmp->type && $___mysqli_type == MYSQLI_TYPE_TIMESTAMP ? "timestamp" : $___mysqli_tmp->type) && !is_null($___mysqli_tmp->type = "" == $___mysqli_tmp->type && $___mysqli_type == MYSQLI_TYPE_YEAR ? "year" : $___mysqli_tmp->type) && !is_null($___mysqli_tmp->type = "" == $___mysqli_tmp->type && ($___mysqli_type == MYSQLI_TYPE_DATE || $___mysqli_type == MYSQLI_TYPE_NEWDATE) ? "date " : $___mysqli_tmp->type) && !is_null($___mysqli_tmp->type = "" == $___mysqli_tmp->type && $___mysqli_type == MYSQLI_TYPE_TIME ? "time" : $___mysqli_tmp->type) && !is_null($___mysqli_tmp->type = "" == $___mysqli_tmp->type && $___mysqli_type == MYSQLI_TYPE_SET ? "set" : $___mysqli_tmp->type) && !is_null($___mysqli_tmp->type = "" == $___mysqli_tmp->type && $___mysqli_type == MYSQLI_TYPE_ENUM ? "enum" : $___mysqli_tmp->type) && !is_null($___mysqli_tmp->type = "" == $___mysqli_tmp->type && $___mysqli_type == MYSQLI_TYPE_GEOMETRY ? "geometry" : $___mysqli_tmp->type) && !is_null($___mysqli_tmp->type = "" == $___mysqli_tmp->type && $___mysqli_type == MYSQLI_TYPE_DATETIME ? "datetime" : $___mysqli_tmp->type) && !is_null($___mysqli_tmp->type = "" == $___mysqli_tmp->type && in_array($___mysqli_type, array(MYSQLI_TYPE_TINY_BLOB, MYSQLI_TYPE_BLOB, MYSQLI_TYPE_MEDIUM_BLOB, MYSQLI_TYPE_LONG_BLOB)) ? "blob" : $___mysqli_tmp->type) && !is_null($___mysqli_tmp->type = "" == $___mysqli_tmp->type && $___mysqli_type == MYSQLI_TYPE_NULL ? "null" : $___mysqli_tmp->type) && !is_null($___mysqli_tmp->type = "" == $___mysqli_tmp->type ? "unknown" : $___mysqli_tmp->type) && !is_null($___mysqli_tmp->not_null = $___mysqli_tmp->flags & MYSQLI_NOT_NULL_FLAG ? 1 : 0) : false ? $___mysqli_tmp : false) { echo "<td>{$field->name}</td> \n"; } echo "</tr> \n"; do { echo "<tr> \n"; echo "<td>" . $row["id"] . "</td> \n"; echo "<td>" . $row["titulo"] . "</td> \n"; echo "<td><a href='http://" . $row["link"] . "'>" . $row["link"] . "</a></td> \n"; echo "</tr> \n"; } while ($row = mysqli_fetch_array($result)); echo "</table> \n"; } else { echo "¡ No se ha encontrado ningún registro !"; } ?>
die; } } $result = executeQuery($con, $query); if ($result == false) { reportError(mysqli_error($con)); die; } ?> <table class="bordered"> <thead> <?php $numFields = mysqli_num_fields($result); echo '<tr>'; for ($i = 0; $i < $numFields; $i++) { $field = mysqli_fetch_field_direct($result, $i); echo '<th>' . $field->name . '</th>'; } echo '</tr>'; ?> </thead> <?php $rows = array(); while ($resultRow = mysqli_fetch_assoc($result)) { $rows[] = $resultRow; } foreach ($rows as $row) { echo '<tr>'; foreach ($row as $col) { echo '<td>' . $col . '</td>';