function get_table_fields($table)
 {
     $result = $this->select_from_table($table);
     $i = 0;
     $fields = array();
     while ($i < mysql_num_fields($result)) {
         $fields[$i] = mysql_fetch_field($result, $i);
         /*
             PROPERTIES
             $field->blob
             $field->max_length
             $field->multiple_key
             $field->name
             $field->not_null
             $field->numeric
             $field->primary_key
             $field->table
             $field->type
             $field->def
             $field->unique_key
             $field->unsigned
             $field->zerofill
         */
         $i++;
     }
     return $fields;
 }

 function readfield()
 {
     $this->error = '';
     $result = @mysql_fetch_field($this->result);
     $this->catcherror();
     return $result;
 }

function mysql2json($mysql_result, $name)
{
    $json = "{\n\"{$name}\": [\n";
    $field_names = array();
    $fields = mysql_num_fields($mysql_result);
    for ($x = 0; $x < $fields; $x++) {
        $field_name = mysql_fetch_field($mysql_result, $x);
        if ($field_name) {
            $field_names[$x] = $field_name->name;
        }
    }
    $rows = mysql_num_rows($mysql_result);
    for ($x = 0; $x < $rows; $x++) {
        $row = str_replace('"', '\\"', mysql_fetch_array($mysql_result));
        $json .= "{\n";
        for ($y = 0; $y < count($field_names); $y++) {
            $json .= "\"{$field_names[$y]}\" :\t\"{$row[$y]}\"";
            if ($y == count($field_names) - 1) {
                $json .= "\n";
            } else {
                $json .= ",\n";
            }
        }
        if ($x == $rows - 1) {
            $json .= "\n}\n";
        } else {
            $json .= "\n},\n";
        }
    }
    $json .= "]\n};";
    return $json;
}

function returnValues($sql_result)
{
    $x = 0;
    $controlNumber = 0;
    global $field;
    global $return;
    if (mysql_num_rows($sql_result) > 0) {
        $return = true;
        while ($fieldName = mysql_fetch_field($sql_result)) {
            $name[$x] = $fieldName->name;
            $x++;
            $controlNumber++;
        }
        $x = 0;
        while ($row = mysql_fetch_assoc($sql_result)) {
            while ($controlNumber > 0) {
                $field[$name[$x]] = $row[$name[$x]];
                //echo $name[$x].": ".$field[$name[$x]]."<br> ";
                $x++;
                $controlNumber--;
            }
        }
    } else {
        $return = false;
    }
}

function SQL_GetResultFields($sql)
{
    global $conn, $db;
    if (!($res = mysql_db_query($db, $sql))) {
        echo mysql_error();
        exit;
    }
    $col = 0;
    while ($field_obj = mysql_fetch_field($res)) {
        $field_arr[$col] = $field_obj->name;
        $col++;
    }
    $record = 0;
    while ($row = mysql_fetch_array($res)) {
        $col = 0;
        while (isset($row[$col])) {
            $result_fields[$record][$field_arr[$col]] = $row[$col];
            $result_fields[$record][$col] = $row[$col];
            $col++;
        }
        $record++;
    }
    //mysql_close($conn);
    return $result_fields;
}

function show_db_results($result)
{
    if ($result || mysql_errno == 0) {
        echo 'Query Info: ' . mysql_info();
        echo '<table class="eb_table">';
        if (mysql_num_rows($result) > 0) {
            $fields_num = mysql_num_fields($result);
            echo "<tr>";
            // printing table headers
            for ($i = 0; $i < $fields_num; $i++) {
                $field = mysql_fetch_field($result);
                echo "<th class='eb_th1'>{$field->table}<br/>{$field->name}</td>";
            }
            echo "</tr>";
            // printing table rows
            while ($row = mysql_fetch_row($result)) {
                echo "<tr>";
                // $row is array... foreach( .. ) puts every element
                // of $row to $cell variable
                foreach ($row as $cell) {
                    echo "<td class='eb_td'>{$cell}</td>";
                }
                echo "</tr>";
            }
        } else {
            echo "<tr><td colspan='" . ($i + 1) . "'>No Results found!</td></tr>";
        }
        echo "</table>";
    } else {
        echo "Error in running query :" . mysql_error();
    }
}

 public function scaffold($table_name, $class_name = '', $prefix = '_')
 {
     $db_name = Database::get_main_database();
     $sql = "SELECT * FROM `{$db_name}`.`{$table_name}` LIMIT 1";
     $fields = array();
     $unique_fields = array();
     $rs = Database::query($sql, null, __FILE__);
     while ($field = mysql_fetch_field($rs)) {
         $fields[] = $field;
         if ($field->primary_key) {
             /**
              * Could move that to an array to support multiple keys
              */
             $id_name = $field->name;
         }
         if ($field->unique_key | $field->primary_key) {
             $keys[] = $field->name;
         }
     }
     $name = $table_name;
     $class_name = ucfirst($table_name);
     ob_start();
     include dirname(__FILE__) . '/template/model.php';
     $result = ob_get_clean();
     return $result;
 }

 function query_start($query)
 {
     // For reg expressions
     $query = trim($query);
     // Query was an insert, delete, update, replace
     if (preg_match("/^(insert|delete|update|replace)\\s+/i", $query)) {
         return false;
     }
     $this->savedqueries[] = $query;
     // Flush cached values..
     $this->flush();
     // Log how the function was called
     $this->func_call = "\$db->query_start(\"{$query}\")";
     // Keep track of the last query for debug..
     $this->last_query = $query;
     // Perform the query via std mysql_query function..
     $this->result = @mysql_query($query, $this->dbh);
     $this->num_queries++;
     // If there is an error then take note of it..
     if (mysql_error()) {
         $this->print_error();
         return false;
     }
     // Take note of column info
     $i = 0;
     while ($i < @mysql_num_fields($this->result)) {
         $this->col_info[$i] = @mysql_fetch_field($this->result);
         $i++;
     }
     $this->last_result = array();
     $this->num_rows = 0;
     // If debug ALL queries
     $this->trace || $this->debug_all ? $this->debug() : null;
     return true;
 }

function export_table2sql($result, $file)
{
    $handle = fopen($file . ".sql", "wb");
    $data = "";
    $i = 0;
    while ($i < mysql_num_fields($result) - 1) {
        $field = mysql_fetch_field($result, $i);
        $data .= $field->name . ";";
        $i++;
    }
    $field = mysql_fetch_field($result, $i);
    $data .= $field->name . "\n";
    //    fwrite($handle, $data);
    $data = "";
    $num_rows = mysql_num_rows($result);
    if ($num_rows == 0) {
    } else {
        for ($j = 0; $j < $num_rows; $j++) {
            $i = 0;
            $resultrow = mysql_fetch_assoc($result);
            fwrite($handle, "INSERT INTO {$file} VALUES (");
            while ($i < mysql_num_fields($result) - 1) {
                $field = mysql_fetch_field($result, $i);
                $data .= "'" . trim($resultrow[$field->name]) . "', ";
                $i++;
            }
            $field = mysql_fetch_field($result, $i);
            $data .= "'" . trim($resultrow[$field->name]) . "');\n";
            fwrite($handle, $data);
            $data = "";
        }
    }
    fclose($handle);
}

 function getJSON($resultSet, $affectedRecords)
 {
     $numberRows = 0;
     $arrfieldName = array();
     $i = 0;
     $json = "";
     while ($i < mysql_num_fields($resultSet)) {
         $meta = mysql_fetch_field($resultSet, $i);
         if ($meta) {
             $arrfieldName[$i] = $meta->name;
         }
         $i++;
     }
     $i = 0;
     $json = "{\"status\":\"OK\",\"data\": [";
     while ($row = mysql_fetch_array($resultSet, MYSQL_NUM)) {
         $i++;
         $json .= "{";
         for ($r = 0; $r < count($arrfieldName); $r++) {
             $json .= "\"{$arrfieldName[$r]}\":\"" . str_replace("\"", "\\\"", $row[$r]) . "\"";
             if ($r < count($arrfieldName) - 1) {
                 $json .= ",";
             } else {
                 $json .= "";
             }
         }
         if ($i != $affectedRecords) {
             $json .= "},";
         } else {
             $json .= "}";
         }
     }
     $json .= "]}";
     return $json;
 }

 public function getColumnMeta($column)
 {
     if ($column >= $this->columnCount()) {
         return false;
     }
     $info = mysql_fetch_field($this->_result, $column);
     $result = array();
     if ($info->def) {
         $result['mysql:def'] = $info->def;
     }
     $result['native_type'] = $info->type;
     $result['flags'] = explode(' ', mysql_field_flags($this->_result, $column));
     $result['table'] = $info->table;
     $result['name'] = $info->name;
     $result['len'] = mysql_field_len($this->_result, $column);
     $result['precision'] = 0;
     switch ($result['native_type']) {
         // seems like pdo_mysql treats everything as a string
         /*
          * case 'int': case 'real': $pdo_type =
          * EhrlichAndreas_Pdo_Abstract::PARAM_INT; break; case 'blob': $pdo_type =
          * EhrlichAndreas_Pdo_Abstract::PARAM_LOB; break; case 'null': $pdo_type =
          * EhrlichAndreas_Pdo_Abstract::PARAM_NULL; break;
          */
         default:
             $pdo_type = EhrlichAndreas_Pdo_Abstract::PARAM_STR;
             break;
     }
     $result['pdo_type'] = $pdo_type;
     return $result;
 }

function get_gift_code_table()
{
    require_once 'mysqldb_lib.php';
    $query = "SELECT * FROM gift_type";
    $result = mysql_query($query);
    $table = "<table border=\"1\">\n";
    $table_header = "<tr>";
    for ($i = 0; $i < mysql_num_fields($result); $i++) {
        $meta = mysql_fetch_field($result, $i);
        $table_header .= "<th>" . $meta->name . "</th>";
    }
    $table_header .= "<th>Get Code</th>";
    $table_header .= "</tr>\n";
    $table_rows = "";
    while ($row = mysql_fetch_assoc($result)) {
        $table_rows .= "<tr>";
        foreach ($row as $field_value) {
            $table_rows .= "<td>{$field_value}</td>";
        }
        $table_rows .= "<td><a href=\"get_button_code.php?id={$row['type_id']}&name={$row['type_name']}&price={$row['price']}\" target=\"_blank\">[Get]</a></td>";
        $table_rows .= "</tr>\n";
    }
    $table .= $table_header . $table_rows;
    $table .= "</table>\n";
    return $table;
}

 function htmlitize($showFields = true)
 {
     $content = "";
     if ($showFields) {
         $fields = "";
         for ($i = 0; $i < $this->fieldCnt; ++$i) {
             $fields .= "<td><b>" . mysql_fetch_field($this->result, $i)->name . "</b></td>";
         }
         $content .= "<tr>{$fields}</tr>";
     }
     mysql_data_seek($this->result, 0);
     while (true) {
         $rowData = mysql_fetch_row($this->result);
         if ($rowData === false) {
             break;
         }
         $row = "";
         foreach ($rowData as $value) {
             $row .= "<td>{$value}</td>";
         }
         $content .= "<tr>{$row}</tr>";
     }
     // restore previous iterator position
     mysql_data_seek($this->result, $this->rowIter);
     return "<table border=\"1\" class=\"pure-table pure-table-bordered\">{$content}</table>";
 }

 function getFieldsInfo()
 {
     $result = array();
     while (($fInfo = mysql_fetch_field($this->rs)) != NULL) {
         $result[$fInfo->name] = $fInfo;
     }
     return $result;
 }

function PMA_mysql_fetch_field($result, $field_offset = FALSE)
{
    if ($field_offset != FALSE) {
        return PMA_convert_display_charset(mysql_fetch_field($result, $field_offset));
    } else {
        return PMA_convert_display_charset(mysql_fetch_field($result));
    }
}

 /**
  * Fetch Field Names
  *
  * Generates an array of column names
  *
  * @access	public
  * @return	array
  */
 function list_fields()
 {
     $field_names = array();
     while ($field = mysql_fetch_field($this->result_id)) {
         $field_names[] = $field->name;
     }
     return $field_names;
 }

 public function get_style_id()
 {
     if ($this->is_logged()) {
         $result = mysql_query("SELECT estilo FROM usuarios_opciones WHERE usuario = " . $this->get_user_id());
         return mysql_fetch_field($result);
     }
     return NULL;
 }

 function db_col_props($table)
 {
     $result = $this->db_query("SELECT * FROM `{$table}`");
     $array = array();
     while ($filed = mysql_fetch_field($result)) {
         $array[] = $filed;
     }
     return $array;
 }

 function getFieldType($name, $res)
 {
     $len = mysql_num_fields($res);
     for ($i = 0; $i < $len; $i++) {
         if (($meta = mysql_fetch_field($res, $i)) && $meta->name == $name) {
             return $meta->type;
         }
     }
 }

/**
 * The MysqlExportXls function is used to export mysql query result into an .xls file.
 * @param MysqlExportXlsConnectOptions $connectOptions
 * @param MysqlExportXlsFileOptions $fileOptions
 * @return error message. Return empty string on success.
 */
function MysqlExportXls($connectOptions, $fileOptions, $query)
{
    $objPHPExcel = new PHPExcel();
    $objPHPExcel->getProperties()->setCreator($fileOptions->creator);
    $objPHPExcel->getProperties()->setLastModifiedBy($fileOptions->lastModifiedBy);
    $objPHPExcel->getProperties()->setTitle($fileOptions->title);
    $objPHPExcel->getProperties()->setSubject($fileOptions->subject);
    $objPHPExcel->getProperties()->setDescription($fileOptions->description);
    $objPHPExcel->setActiveSheetIndex(0);
    $activeSheet = $objPHPExcel->getActiveSheet();
    $activeSheet->setTitle($fileOptions->title);
    // connect to mysql
    $link = mysql_connect($connectOptions->host, $connectOptions->userName, $connectOptions->password);
    if (!$link) {
        return __FILE__ . ":" . __FUNCTION__ . ':' . 'Could not connect: ' . mysql_error($link);
    }
    // use database
    $selectDb = mysql_select_db($connectOptions->useDatabase, $link);
    if (!$selectDb) {
        return __FILE__ . ":" . __FUNCTION__ . ':' . 'Could not select database' . mysql_error($link);
    }
    // PHPExcel use utf-8 encoding to save file only !!!
    $setCharset = mysql_set_charset("utf8", $link);
    if (!$setCharset) {
        return __FILE__ . ":" . __FUNCTION__ . ':' . 'Could not set charset' . mysql_error($link);
    }
    // execute sql
    $result = mysql_query($query, $link);
    if (!$result) {
        return __FILE__ . ":" . __FUNCTION__ . ':' . 'Query failed: ' . mysql_error($link);
    }
    // field names
    $columnIndex = 0;
    while ($field = mysql_fetch_field($result)) {
        $activeSheet->SetCellValue(PHPExcel_Cell::stringFromColumnIndex($columnIndex) . '1', $field->name);
        ++$columnIndex;
    }
    $rowIndex = 2;
    // 1 based, the firset row is for field names.
    while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
        $columnIndex = 0;
        foreach ($line as $key => $col_value) {
            $activeSheet->SetCellValue(PHPExcel_Cell::stringFromColumnIndex($columnIndex) . $rowIndex, $col_value === null ? "" : $col_value, PHPExcel_Cell_DataType::TYPE_STRING2);
            ++$columnIndex;
        }
        ++$rowIndex;
    }
    // free mysql resource
    mysql_free_result($result);
    mysql_close($link);
    // write data into file
    $objWriter = new PHPExcel_Writer_Excel5($objPHPExcel);
    $objWriter->setPreCalculateFormulas(FALSE);
    // Why true by default ? oh god damn it!
    $objWriter->save($fileOptions->name);
    return "";
}