function mysql_field_seek($result, $field)
{
if (\Dshafik\MySQL::checkValidResult($result, __FUNCTION__)) {
// @codeCoverageIgnoreStart
return false;
// @codeCoverageIgnoreEnd
}
return mysqli_field_seek($result, $field);
}
var_dump($tmp2);
}
if ($tmp1 != $fields['res'][$pos]) {
printf("[030] Field info differs, dumping data\n");
var_dump($tmp1);
var_dump($fields['res'][$pos]);
}
$pos++;
if ($pos !== ($tmp = mysqli_field_tell($res))) {
printf("[031] Expecting %s/%s got %s/%s\n", gettype($pos), $pos, gettype($tmp), $tmp);
}
if ($pos !== ($tmp = mysqli_field_tell($res_meta))) {
printf("[032] Expecting %s/%s got %s/%s\n", gettype($pos), $pos, gettype($tmp), $tmp);
}
} else {
if (false !== @mysqli_field_seek($res, $pos)) {
printf("[033] field_seek(%d) did not fail\n", $pos);
}
if (false !== @mysqli_field_seek($res_meta, $pos)) {
printf("[034] field_seek(%d) did not fail\n", $pos);
}
}
}
$res->free_result();
mysqli_free_result($res_meta);
var_dump(mysqli_fetch_field($res));
mysqli_stmt_close($stmt);
var_dump(mysqli_fetch_field($res));
mysqli_close($link);
var_dump(mysqli_fetch_field($res));
print "done!";
function db_fieldname($lhandle, $fnumber) {
@mysqli_field_seek($lhandle, $fnumber);
$field = @mysqli_fetch_field($lhandle);
return $field ? $field->name : FALSE;
}
/**
* Devuelve el nombre de un campo en el resultado de un select
*
* @param int $number
* @param resource $result_query
* @return string
*/
public function field_name($number, $result_query = '')
{
if (!$this->id_connection) {
return false;
}
if (!$result_query) {
$result_query = $this->last_result_query;
if (!$result_query) {
return false;
}
}
if (($fieldName = mysqli_field_seek($result_query, $number)) !== false) {
$field = mysqli_fetch_field($result_query);
return $field->name;
} else {
throw new KumbiaException($this->error());
}
return false;
}
var_dump(mysqli_field_seek($res, -1));
var_dump(mysqli_fetch_field($res));
var_dump(mysqli_field_seek($res, 0));
var_dump(mysqli_fetch_field($res));
var_dump(mysqli_field_seek($res, 1));
$field = mysqli_fetch_field($res);
var_dump($field);
/* label column, result set charset */
if ($field->charsetnr != $charsetInfo->number) {
printf("[004] Expecting charset %s/%d got %d\n", $charsetInfo->charset, $charsetInfo->number, $field->charsetnr);
}
if ($field->length != $charsetInfo->max_length) {
printf("[005] Expecting length %d got %d\n", $charsetInfo->max_length, $field->max_length);
}
var_dump(mysqli_field_tell($res));
var_dump(mysqli_field_seek($res, 2));
var_dump(mysqli_fetch_field($res));
var_dump(mysqli_field_seek($res, PHP_INT_MAX + 1));
mysqli_free_result($res);
if (!($res = mysqli_query($link, "SELECT NULL as _null", MYSQLI_STORE_RESULT))) {
printf("[005] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
}
var_dump(mysqli_field_seek($res, 0));
var_dump(mysqli_fetch_field($res));
mysqli_free_result($res);
var_dump(mysqli_field_seek($res, 0));
mysqli_close($link);
print "done!";
error_reporting(0);
$test_table_name = 'test_mysqli_field_seek_table_1';
require_once "clean_table.inc";
/**
* Get the name of the specified field in a result
* @param Mixed qHanle The query handle
* @param Number offset
* @return String
*/
public function field_name($qHanle, $offset)
{
@mysqli_field_seek($qHanle, $offset);
$field = @mysqli_fetch_field($qHanle);
return $field ? $field->name : "";
}
printf("[009] Expecting object, got %s/%s, [%d] %s\n", gettype($field0_direct), $field0_direct, mysqli_errno($link), mysqli_error($link));
}
if ($field0_fetch != $field0_direct) {
printf("[010] mysqli_fetch_field() differs from mysqli_fetch_field_direct()\n");
var_dump($field0_fetch);
var_dump($field0_direct);
}
var_dump($field0_fetch);
if (!is_array($tmp = mysqli_fetch_fields($res))) {
printf("[011] Expecting array, got %s/%s, [%d] %s\n", gettype($tmp), $tmp, mysqli_errno($link), mysqli_error($link));
}
if (empty($tmp[0]) || empty($tmp[1]) || $tmp[0] != $field0_direct) {
printf("[012] mysqli_fetch_fields() return value is suspicious\n");
var_dump($tmp);
}
if (!mysqli_field_seek($res, 1)) {
printf("[013] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
}
if (!is_object($field1_direct = mysqli_fetch_field_direct($res, 1))) {
printf("[014] Expecting object, got %s/%s, [%d] %s\n", gettype($field1_direct), $field1_direct, mysqli_errno($link), mysqli_error($link));
}
if ($tmp[1] != $field1_direct) {
printf("[015] mysqli_fetch_field_direct() differs from mysqli_fetch_fields()\n");
var_dump($field1_direct);
var_dump($tmp);
}
if (1 !== ($tmp = mysqli_field_tell($res))) {
printf("[016] Expecting int/1, got %s/%s, [%d] %s\n", gettype($tmp), $tmp, mysqli_errno($link), mysqli_error($link));
}
mysqli_free_result($res);
mysqli_stmt_close($stmt);
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;
}
function mysql_field_seek($result, $offset)
{
return mysqli_field_seek($result, $offset);
}
function mysql_compat_field_seek($result, $field_offset)
{
return mysqli_field_seek($result, $field_offset);
}
case 'postgres':
$cols = pg_num_fields($DB->_result);
for ($i = 0; $i < $cols; $i++) {
$colnames[] = pg_field_name($DB->_result, $i);
}
break;
case 'mysql':
$cols = mysql_num_fields($DB->_result);
for ($i = 0; $i < $cols; $i++) {
$colnames[] = mysql_field_name($DB->_result, $i);
}
break;
case 'mysqli':
$cols = mysqli_num_fields($DB->_result);
for ($i = 0; $i < $cols; $i++) {
mysqli_field_seek($DB->_result, $i);
$finfo = mysqli_fetch_field($DB->_result);
$colnames[] = $finfo->name;
}
break;
}
if ($_GET['print']) {
$classes = array(0 => 'grey', 1 => 'white');
} else {
$classes = array(0 => 'light', 1 => 'lucid');
}
$i = 0;
while ($row = $DB->_driver_fetchrow_assoc()) {
$i++;
if ($i > $start && $i < $start + $pagelimit + 1) {
$result .= '<TR CLASS="' . $classes[$i % 2] . '"><TD CLASS="BLEND">' . $i . '</TD>';
function FetchField($fieldOffset = -1)
{
$fieldnr = $fieldOffset;
if ($fieldOffset != -1) {
$fieldOffset = @mysqli_field_seek($this->_queryID, $fieldnr);
}
$o = @mysqli_fetch_field($this->_queryID);
if (!$o) {
return false;
}
//Fix for HHVM
if (!isset($o->flags)) {
$o->flags = 0;
}
/* Properties of an ADOFieldObject as set by MetaColumns */
$o->primary_key = $o->flags & MYSQLI_PRI_KEY_FLAG;
$o->not_null = $o->flags & MYSQLI_NOT_NULL_FLAG;
$o->auto_increment = $o->flags & MYSQLI_AUTO_INCREMENT_FLAG;
$o->binary = $o->flags & MYSQLI_BINARY_FLAG;
// $o->blob = $o->flags & MYSQLI_BLOB_FLAG; /* not returned by MetaColumns */
$o->unsigned = $o->flags & MYSQLI_UNSIGNED_FLAG;
/*
* Trivial method to cast class to ADOfieldObject
*/
$a = new ADOFieldObject();
foreach (get_object_vars($o) as $key => $name) {
$a->{$key} = $name;
}
return $a;
}
$con = conectar();
$sql = " SELECT * FROM funcionario WHERE usuario = '{$_POST['NOMBRE_F']}' AND pw ='" . md5($_POST[PW]) . "'";
//código MySQL
$q = mysqli_query($con, $sql);
//enviar código MySQL
while ($row = mysqli_fetch_array($q)) {
//Bucle para ver todos los registros
$_SESSION["id_funcionario"] = $row['id_Funcionario'];
$_SESSION["nombre"] = $row['nombre_f'];
$_SESSION["apellido"] = $row['apellido_f'];
$_SESSION["password"] = $row['pw'];
$_SESSION['tipo'] = $row['tipo'];
$_SESSION['ccp'] = $row['ccp'];
}
try {
if (mysqli_field_seek($q, 0)) {
if ($_SESSION['tipo'] == "administrador") {
echo "<script language='Javascript'>\n\t\t\t\t\t\talert('Bienvenido " . ucwords($_SESSION['nombre']) . " " . ucwords($_SESSION['apellido']) . "');\n\t\t\t\t\t\tdocument.location=('../procesar/iniciar.php');\n\t\t\t\t\t\t</script>";
} else {
echo "<script language='Javascript'>\n\t\t\t\t\t\t\talert('Bienvenido " . ucwords($_SESSION['nombre']) . " " . ucwords($_SESSION['apellido']) . "');\n\t\t\t\t\t\t\tdocument.location=('../procesar/iniciar.php');\n\t\t\t\t\t\t\t</script>";
}
} else {
echo "<script language='Javascript'>\n\t\t\t\t\talert('Usuario y/o Contraseña Erronea');\n\t\t\t\t\tdocument.location=('../index.php');\n\t\t\t\t\t</script>";
}
} catch (Exception $error) {
}
mysqli_close($con);
} else {
echo "<script language='javascript'>\n\t\t\t\talert('Debe Llenar Todos los Campos');\n\t\t\t\tdocument.location=('../index.php');\n\t\t\t</script>";
}
} else {
function mysql_field_seek($result, $offset)
{
if (!is_myresource($result, true)) {
$msg = sprintf('expects parameter 1 to be mysql result object, %s given', gettype($result));
trigger_error(mysql_trigger_msg($msg, current(debug_backtrace())), E_USER_WARNING);
return false;
}
if (!isset($offset)) {
$msg = sprintf('expects parameter 2 to be offset value');
trigger_error(mysql_trigger_msg($msg, current(debug_backtrace())), E_USER_WARNING);
return false;
}
if ($offset < 0 || $offset >= mysqli_num_fields($result)) {
$msg = sprintf('Unable to jump to field %ld on MySQL result index %d', $offset, $result);
trigger_error(mysql_trigger_msg($msg, current(debug_backtrace())), E_USER_WARNING);
return false;
}
return mysqli_field_seek($result, $offset);
}
/**
* Метод, преднязначенный для получения названия указанной колонки результата запроса
*
* @param int $i - индекс колонки
* @return string
* @access public
*/
function FieldName($i)
{
if (is_array($this->_result)) {
$a = current($this->_result);
$b = array_keys($a);
return $b[$i];
}
mysqli_field_seek($this->_result, $i);
$field = mysqli_fetch_field($this->_result);
return $field->name;
}
function db_dump_result($res, $show_table_names = 0) {
echo("<table>\n<tr>");
while (($finfo = $res->fetch_field())) {
echo('<th>');
if ($show_table_names) echo($finfo->table.'<br>');
echo($finfo->name.'</th>');
}
while (($row = mysqli_fetch_array($res, MYSQLI_NUM))) {
echo('<tr>');
foreach ($row as $data) {
if ($data === NULL) echo('<td><i>NULL</i></td>');
else echo('<td>'.$data.'</td>');
}
echo("<tr>\n");
}
echo("</table>\n");
// reset result, so that it can be traversed again
mysqli_field_seek($res, 0);
mysqli_data_seek($res, 0);
}
function getFieldType($vid, $field)
{
$q = "SELECT f" . $field . "t from " . TB_PREFIX . "fdata where vref = {$vid}";
$result = mysqli_query($this->sqli_connection, $q);
return mysqli_field_seek($result, 0);
}
function &FetchField($fieldOffset = -1)
{
$fieldnr = $fieldOffset;
if ($fieldOffset != -1) {
$fieldOffset = mysqli_field_seek($this->_queryID, $fieldnr);
}
$o = mysqli_fetch_field($this->_queryID);
return $o;
}
case 'postgres':
$cols = pg_num_fields($DB->GetResult());
for ($i = 0; $i < $cols; $i++) {
$colnames[] = pg_field_name($DB->GetResult(), $i);
}
break;
case 'mysql':
$cols = mysql_num_fields($DB->GetResult());
for ($i = 0; $i < $cols; $i++) {
$colnames[] = mysql_field_name($DB->GetResult(), $i);
}
break;
case 'mysqli':
$cols = mysqli_num_fields($DB->GetResult());
for ($i = 0; $i < $cols; $i++) {
mysqli_field_seek($DB->GetResult(), $i);
$finfo = mysqli_fetch_field($DB->GetResult());
$colnames[] = $finfo->name;
}
break;
}
if ($_GET['print']) {
$classes = array(0 => 'grey', 1 => 'white');
} else {
$classes = array(0 => 'light', 1 => 'lucid');
}
$i = 0;
while ($row = $DB->_driver_fetchrow_assoc()) {
$i++;
if ($i > $start && $i < $start + $pagelimit + 1) {
$result .= '<TR CLASS="' . $classes[$i % 2] . '"><TD CLASS="BLEND">' . $i . '</TD>';
function FetchField($fieldOffset = -1)
{
$fieldnr = $fieldOffset;
if ($fieldOffset != -1) {
$fieldOffset = @mysqli_field_seek($this->_queryID, $fieldnr);
}
$o = @mysqli_fetch_field($this->_queryID);
if (!$o) {
return false;
}
/* Properties of an ADOFieldObject as set by MetaColumns */
$o->primary_key = $o->flags & MYSQLI_PRI_KEY_FLAG;
$o->not_null = $o->flags & MYSQLI_NOT_NULL_FLAG;
$o->auto_increment = $o->flags & MYSQLI_AUTO_INCREMENT_FLAG;
$o->binary = $o->flags & MYSQLI_BINARY_FLAG;
// $o->blob = $o->flags & MYSQLI_BLOB_FLAG; /* not returned by MetaColumns */
$o->unsigned = $o->flags & MYSQLI_UNSIGNED_FLAG;
return $o;
}
function driver_db_result($result, $offset)
{
return mysqli_field_seek($result, $offset);
}
