本文整理汇总了PHP中mysql_fetch_field函数的典型用法代码示例。如果您正苦于以下问题:PHP mysql_fetch_field函数的具体用法?PHP mysql_fetch_field怎么用?PHP mysql_fetch_field使用的例子?那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了mysql_fetch_field函数的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: get_table_fields
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;
}
示例2: readfield
function readfield()
{
$this->error = '';
$result = @mysql_fetch_field($this->result);
$this->catcherror();
return $result;
}
示例3: mysql2json
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;
}
示例4: returnValues
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;
}
}
示例5: SQL_GetResultFields
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;
}
示例6: show_db_results
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();
}
}
示例7: scaffold
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;
}
示例8: query_start
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;
}
示例9: export_table2sql
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);
}
示例10: getJSON
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;
}
示例11: getColumnMeta
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;
}
示例12: get_gift_code_table
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;
}
示例13: htmlitize
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>";
}
示例14: getFieldsInfo
function getFieldsInfo()
{
$result = array();
while (($fInfo = mysql_fetch_field($this->rs)) != NULL) {
$result[$fInfo->name] = $fInfo;
}
return $result;
}
示例15: PMA_mysql_fetch_field
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));
}
}