本文整理汇总了PHP中mysql_num_fields函数的典型用法代码示例。如果您正苦于以下问题：PHP mysql_num_fields函数的具体用法？PHP mysql_num_fields怎么用？PHP mysql_num_fields使用的例子？那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了mysql_num_fields函数的20个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于我们的系统推荐出更棒的PHP代码示例。
示例1: mysql_query_cache
function mysql_query_cache($sql, $linkIdentifier = false, $timeout = 4)
{
//首先调用上面的getCache函数，如果返回值不为false的话，就说明是从memcached服务器获取的数据
//如果返回false，此时就需要直接从数据库中获取数据了。
//需要注意的是这里使用操作的命令加上sql语句的md5码作为一个特定的key，可能大家觉得使用数据项的
//名称作为key会比较自然一点。运行memcached加上"-vv"参数，并且不作为daemon运行的话，可以看见
//memcached处理时输出的相关信息
if (!($cache = getCache(md5("mysql_query" . $sql)))) {
$cache = false;
$r = $linkIdentifier != false ? mysql_query($sql, $linkIdentifier) : mysql_query($sql);
//读取数据库，并将结果放入$cache数组中
if (is_resource($r) && ($rows = mysql_num_rows($r)) != 0) {
for ($i = 0; $i < $rows; $i++) {
$fields = mysql_num_fields($r);
$row = mysql_fetch_array($r);
for ($j = 0; $j < $fields; $j++) {
if ($i == 0) {
$columns[$j] = mysql_field_name($r, $j);
}
$cache[$i][$columns[$j]] = $row[$j];
}
}
//将数据放入memcached服务器中，如果memcached服务器没有开的话，此语句什么也不会做
//如果开启了服务器的话，数据将会被缓存到memcached服务器中
if (!setCache(md5("mysql_query" . $sql), $cache, $timeout)) {
# If we get here, there isn’t a memcache daemon running or responding
}
}
}
return $cache;
}
开发者ID:siriushr，项目名称:hustoj，代码行数:31，代码来源:memcache.php
示例2: 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;
}
开发者ID:BellyWong，项目名称:razor，代码行数:27，代码来源:generate.php
示例3: showQuery
/**
Show the result data from a SQL SELECT query
@param $result The result set from the last SELECT query. (optional)
*/
function showQuery($result = 0)
{
if (!$result) {
$result = $this->result;
}
if (!$result) {
$this->_handleError("No result set to show!");
return;
}
// Convert column names to table headings
$html = "<table border>\n";
$html .= "<tr>\n";
$count = mysql_num_fields($result);
for ($i = 0; $i < $count; $i++) {
$html .= "<th>" . mysql_field_name($result, $i) . "</th>\n";
}
$html .= "</tr>\n";
// Convert data to table cells
@mysql_data_seek($result, 0);
$count = 0;
while ($row = mysql_fetch_row($result)) {
$html .= "<tr>\n";
foreach ($row as $item) {
$html .= "<td> {$item}</td>\n";
}
$html .= "</tr>\n";
$count++;
}
echo $html;
}
开发者ID:JohnLeMieux，项目名称:CellStore，代码行数:35，代码来源:db.php
示例4: update_emp_values
function update_emp_values($emp_type, $emp_id, $fname, $lname, $contact, $address, $salary, $sex, $bdate, $join_date)
{
$dbc = mysql_connect('localhost', 'root', 'rishi');
if (!$dbc) {
die('NOT CONNECTED:' . mysql_error());
}
$db_selected = mysql_select_db("restaurant", $dbc);
if (!$db_selected) {
die('NOT CONNECTED TO DATABASE:' . mysql_error());
}
$emp_type_id = $emp_type . "_id";
$query = "Select * from {$emp_type}";
$emp = mysql_query($query);
$num_fields = mysql_num_fields($emp);
if ($emp_type == "COOK") {
$val_arrays = array("{$emp_id}", $fname, $lname, $contact, $address, $salary, $sex, $bdate, $join_date, $_POST["Specialization"]);
} else {
$val_arrays = array("{$emp_id}", $fname, $lname, $contact, $address, $salary, $sex, $bdate, $join_date);
}
$values = "";
for ($i = 1; $i < $num_fields; $i++) {
$values = $values . mysql_field_name($emp, $i) . " = " . "\"{$val_arrays[$i]}\"";
if ($i != $num_fields - 1) {
$values = $values . " , ";
}
}
$query = "UPDATE {$emp_type} SET " . $values . " WHERE {$emp_type_id} = {$emp_id};";
mysql_query($query);
}
开发者ID:tjanh123，项目名称:Restaurant-Management-Ordering-System，代码行数:29，代码来源:update_employee_values.php
示例5: update_restaurant
function update_restaurant()
{
$dbc = mysql_connect('localhost', 'root', 'rishi');
if (!$dbc) {
die('NOT CONNECTED:' . mysql_error());
}
$db_selected = mysql_select_db("restaurant", $dbc);
if (!$db_selected) {
die('NOT CONNECTED TO DATABASE:' . mysql_error());
}
echo "<form name = \"form1\" action = \"update_restaurant_values.php\" method =\"post\" align=\"center\" onsubmit=\"return checkscript()\">" . "\n";
echo "<table style=\"text-align:center;\" align=\"center\" width=\"400\">" . "\n";
$query = "SELECT * from RESTAURANT;";
$rest = mysql_query($query);
$num_fields = mysql_num_fields($rest);
for ($i = 0; $i < $num_fields; $i++) {
echo "<tr>" . "\n";
echo "<td>" . "\n";
$field = mysql_field_name($rest, $i);
echo "<b>" . $field . "</b>" . "\n";
echo "</td>" . "\n";
echo "<td>" . "\n";
$res = mysql_result($rest, 0, $i);
if ($i) {
echo "<input type = \"text\" name = \"{$field}\" value=\"{$res}\">";
} else {
echo "<input type = \"text\" name = \"{$field}\" value=\"{$res}\" readonly=\"readonly\">";
}
echo "</td>" . "\n";
echo "</tr>" . "\n";
}
echo "</table>" . "\n" . "<br/>";
echo "<input type=\"submit\" name=\"submitbutton\" value=\"Update\">" . "\n";
echo "</form>" . "\n";
}
开发者ID:tjanh123，项目名称:Restaurant-Management-Ordering-System，代码行数:35，代码来源:update_restaurant.php
示例6: formatJSON
function formatJSON($result)
{
$str = "[";
$numRows = 0;
while ($row = mysql_fetch_array($result)) {
if ($numRows > 0) {
$str = $str . ", ";
}
$numRows++;
$n = mysql_num_fields($result);
for ($i = 0; $i < $n; $i++) {
$fld = mysql_field_name($result, $i);
$val = addslashes($row[$fld]);
$val = str_replace("\t", "", $val);
$val = str_replace("'", "\\'", $val);
$val = str_replace("\r\n", "", $val);
if ($i == 0) {
$str = $str . "{\"{$fld}\":\"{$val}\"";
} else {
$str = $str . ", \"{$fld}\":\"{$val}\"";
}
}
$str = $str . "}\r\n";
}
$str = $str . "]";
return $str;
}
开发者ID:Allvee，项目名称:Softswitch，代码行数:27，代码来源:utils.php
示例7: tabledump
function tabledump($result)
{
if ($result == 0) {
echo "<b>Error " . mysql_errno() . ": " . mysql_error() . "</b>";
} else {
if (@mysql_num_rows($result) == 0) {
echo "<b>Query completed. Empty result.</b><br>";
} else {
$nf = mysql_num_fields($result);
$nr = mysql_num_rows($result);
echo "<table border='1'> <thead>";
echo "<tr>";
for ($i = 0; $i < $nf; $i++) {
echo "<th>" . mysql_field_name($result, $i) . "</th>";
}
echo "</tr>";
echo "</thead><tbody>";
for ($i = 0; $i < $nr; $i++) {
echo "<tr>";
$row = mysql_fetch_array($result);
for ($j = 0; $j < $nf; $j++) {
echo "<td>" . $row[$j] . "</td>";
}
echo "</tr>";
}
echo "</tbody></table>";
}
}
return $row;
}
开发者ID:theemj，项目名称:CS407，代码行数:30，代码来源:includeMe.php
示例8: display_db_query
function display_db_query($query_string, $connection, $header_bool, $table_params)
{
// perform the database query
$result_id = mysql_query($query_string, $connection) or die("display_db_query:" . mysql_error());
// find out the number of columns in result
$column_count = mysql_num_fields($result_id) or die("display_db_query:" . mysql_error());
// Here the table attributes from the $table_params variable are added
print "<TABLE {$table_params} >\n";
// optionally print a bold header at top of table
if ($header_bool) {
print "<TR>";
for ($column_num = 0; $column_num < $column_count; $column_num++) {
$field_name = mysql_field_name($result_id, $column_num);
print "<TH>{$field_name}</TH>";
}
print "</TR>\n";
}
// print the body of the table
while ($row = mysql_fetch_row($result_id)) {
print "<TR ALIGN=LEFT VALIGN=TOP>";
for ($column_num = 0; $column_num < $column_count; $column_num++) {
print "<TD>{$row[$column_num]}</TD>\n";
}
print "</TR>\n";
}
print "</TABLE>\n";
}
开发者ID:venomslair，项目名称:venomslair，代码行数:27，代码来源:gamesold.php
示例9: database_query
/**
* Database query
* @param $sql
* @param $return_type
* @param $first_row_only
* @param $fetch_func
* @param $debug
*/
function database_query($sql, $return_type = DATA_ONLY, $first_row_only = ALL_ROWS, $fetch_func = FETCH_ASSOC, $debug = false)
{
$data_array = array();
$num_rows = 0;
$fields_len = 0;
$result = mysql_query($sql);
if ($debug == true) {
echo $sql . '-' . mysql_error();
}
if ($result) {
if ($return_type == 0 || $return_type == 2) {
while ($row_array = $fetch_func($result)) {
if (!$first_row_only) {
array_push($data_array, $row_array);
} else {
$data_array = $row_array;
break;
}
}
}
$num_rows = mysql_num_rows($result);
$fields_len = mysql_num_fields($result);
mysql_free_result($result);
}
switch ($return_type) {
case DATA_ONLY:
return $data_array;
case ROWS_ONLY:
return $num_rows;
case DATA_AND_ROWS:
return array($data_array, $num_rows);
case FIELDS_ONLY:
return $fields_len;
}
}
开发者ID:mozdial，项目名称:Directory，代码行数:43，代码来源:functions.database.inc.php
示例10: DB_dump_result
function DB_dump_result($result, $print = 0)
{
if (!$result) {
return false;
}
if (!($fields_nb = mysql_num_fields($result))) {
return false;
}
$output = "<!-- Starting query result dump -->\n";
//$output.="<p>\n"; //PAS XHTML VALIDE !!
$output .= " <table border=\"1\" cellpadding=\"2\" cellspacing=\"0\">\n";
$output .= " <tr>\n";
for ($i = 0; $i < $fields_nb; $i++) {
$field_names[$i] = mysql_field_name($result, $i);
$output .= " <th>{$field_names[$i]}</th>\n";
}
$output .= " </tr>\n";
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
$output .= " <tr>\n";
foreach ($field_names as $this_field) {
// foreach($row) does not work here without "MYSQL_ASSOC"
$output .= $row[$this_field] ? " <td>{$row[$this_field]}</td>\n" : "<td> </td>\n";
}
$output .= " </tr>\n";
}
$output .= " </table>\n";
// $output.="</p>\n"; // PAS XHTML VALIDE !
$output .= "<!-- End query result dump -->\n";
// Finally output the result, with either method, based
// on the coder's choice.
if ($print) {
echo $output;
}
return $output;
}
开发者ID:BackupTheBerlios，项目名称:jasmine-svn，代码行数:35，代码来源:libDB_mysql.php
示例11: WriteHistoryFromSQL
/**
* INPUT: $apikey
* OUTPUT: XML file
**/
function WriteHistoryFromSQL($sql)
{
$req = mysql_query($sql) or die('SQL Error !<br>' . $sql . '<br>' . mysql_error());
$f = mysql_num_fields($req);
for ($i = 0; $i < $f; $i++) {
$previous[$i] = "";
$xmltab[$i] = "";
}
while ($data = mysql_fetch_array($req)) {
for ($i = 0; $i < $f; $i++) {
if (mysql_field_name($req, $i) != 'cid' && mysql_field_name($req, $i) != 'date' && $data[$i] != $previous[$i]) {
$previous[$i] = $data[$i];
$xmltab[$i] .= "<" . mysql_field_name($req, $i) . " date=\"" . $data['date'] . "\">" . $data[$i] . "</" . mysql_field_name($req, $i) . ">";
}
}
}
for ($i = 0; $i < $f; $i++) {
$tag_name = mysql_field_name($req, $i);
if ($tag_name != 'cid' && $tag_name != 'date') {
if ($xmltab[$i] != "") {
print "<" . $tag_name . "_history>" . $xmltab[$i] . "</" . $tag_name . "_history>";
}
}
}
}
开发者ID:phantase，项目名称:ARMA，代码行数:29，代码来源:character_history_xml.inc.php
示例12: display_db_query
function display_db_query($query_string, $connection)
{
$result_id = mysql_query($query_string, $connection) or die(mysql_error());
$column_count = mysql_num_fields($result_id) or die(mysql_error());
echo "<table class=\"sortable\" border=\"1\" style=\"width:auto;margin-top:1em;\">\n<tr>";
for ($column_num = 0; $column_num < $column_count - 1; $column_num++) {
echo "<th>", mysql_field_name($result_id, $column_num), "</th>";
}
echo "</tr>\n";
while ($row = mysql_fetch_row($result_id)) {
echo "<tr>";
for ($column_num = 0; $column_num < $column_count - 1; $column_num++) {
echo "<td class=\"c{$column_num}\">";
if ($column_num == 2) {
echo "<a href=\"hebconj.php?verb_root=", urlencode($row[$column_num]), "&tense_id={$row[4]}\">";
}
if ($column_num == 1 && empty($row[5])) {
echo '<del>';
}
echo $row[$column_num];
if ($column_num == 1 && empty($row[5])) {
echo '</del>';
}
if ($column_num == 2) {
echo "</a>";
}
echo "</td>";
}
echo "</tr>\n";
}
echo "</table>\n";
}
开发者ID:hftf，项目名称:hebconj，代码行数:32，代码来源:hebconj-list.php
示例13: display_db_query
function display_db_query($query_string, $connection, $names)
{
$result_id = mysql_query($query_string, $connection) or die("display_db_query:" . mysql_error());
$column_count = mysql_num_fields($result_id) or die("display_db_query:" . mysql_error());
print "<thead>\n";
print "<tr>\n";
for ($column_number = 0; $column_number < $column_count; $column_number++) {
$field_name = $names[$column_number];
print "<th>{$field_name}</th>\n";
}
print "</tr>\n";
print "</thead>\n";
print "<tbody>\n";
while ($row = mysql_fetch_row($result_id)) {
print "<tr class=\"gradeA\">";
for ($column_number = 0; $column_number < $column_count; $column_number++) {
print "<td>{$row[$column_number]}</td>\n";
}
print "</tr>\n";
}
print "</tbody>\n";
print "<tfoot>\n";
print "<tr>\n";
for ($column_number = 0; $column_number < $column_count; $column_number++) {
$field_name = $names[$column_number];
print "<th>{$field_name}</th>\n";
}
print "</tr>\n";
print "</tfoot>\n";
}
开发者ID:rogerlzp，项目名称:android-acra-server，代码行数:30，代码来源:core.php
示例14: loadFromResult
function loadFromResult($mysqlresult, $dblink)
{
$this->numRows = @mysql_num_rows($mysqlresult);
$this->numFields = @mysql_num_fields($mysqlresult);
$this->result = $mysqlresult;
return parent::load($dblink);
}
开发者ID:simplef，项目名称:simpleframework，代码行数:7，代码来源:MySqlResult.class.php
示例15: get_content
function get_content($database, $table, $fp)
{
// get content of data
global $delimiter;
$result = mysql_db_query($database, "SELECT * FROM {$table}") or die("Cannot get content of table");
while ($row = mysql_fetch_row($result)) {
$insert = "INSERT INTO {$table} VALUES (";
// command for later SQL-restore
for ($j = 0; $j < mysql_num_fields($result); $j++) {
// content for later SQL-restore
if (!isset($row[$j])) {
$insert .= "NULL,";
} elseif (isset($row[$j])) {
$insert .= "'" . addslashes($row[$j]) . "',";
} else {
$insert .= "'',";
}
}
$insert = ereg_replace(",\$", "", $insert);
$insert .= "){$delimiter}\n";
// create row delimiter
gzwrite($fp, $insert);
// now write the complete content into backup file
}
gzwrite($fp, "\n\n");
mysql_free_result($result);
}
开发者ID:pwh，项目名称:scrutiny，代码行数:27，代码来源:db_backup.php
示例16: make_table
function make_table($result)
{
while ($row = mysql_fetch_array($result)) {
// get all the records based on the selection statement determined in the range_type function
print "<tr>";
for ($k = 0; $k < mysql_num_fields($result); $k++) {
// Go through all the fields
$option = "checked" . $k;
global ${$option};
if (${$option} == "yes") {
// If the user opted to see that field
$field = "field" . $k;
//Fix: The number after arw should not be hard-coded here, but put in a for loop for future compatibility
global $arabiccolumn, $arw0, ${$field};
// dynamically declare the field variables
//Fix: The number after arw should not be hard-coded here, but put in a for loop for future compatibility
if ($arabiccolumn != "" && $arabiccolumn == ${$field}) {
// && $arw0 != "" (if problem with no width being specified--but then need to deal with dir="rtl" for non-Arabic) -- print the cells with right-to-left directionality and column-width; Fix: make columns variable not only for Arabic
//Fix: The number after arw should not be hard-coded here, but put in a for loop for future compatibility
print "<td width='{$arw0}' valign='top' dir='rtl'>" . $row[${$field}] . "</td>";
} else {
// print the cells with regular (left-to-right) directionality and no special width
print "<td valign='top'>" . $row[${$field}] . "</td>";
}
// } else {
// } //////// end else remove this if removing above
}
//end if (if the user opted to see the given field)
}
//end for to go through all the fields
print "</tr>\n";
}
//end while to get all the records
}
开发者ID:brettz9，项目名称:textbrowser，代码行数:34，代码来源:browse9.php
示例17: RunFreeQuery
function RunFreeQuery()
{
global $cnInfoCentral;
global $aRowClass;
global $rsQueryResults;
global $sSQL;
global $iQueryID;
//Run the SQL
$rsQueryResults = RunQuery($sSQL);
if (mysql_error() != "") {
echo gettext("An error occured: ") . mysql_errno() . "--" . mysql_error();
} else {
$sRowClass = "RowColorA";
echo "<table align=\"center\" cellpadding=\"5\" cellspacing=\"0\">";
echo "<tr class=\"" . $sRowClass . "\">";
//Loop through the fields and write the header row
for ($iCount = 0; $iCount < mysql_num_fields($rsQueryResults); $iCount++) {
echo "<td align=\"center\"><b>" . mysql_field_name($rsQueryResults, $iCount) . "</b></td>";
}
echo "</tr>";
//Loop through the recordsert
while ($aRow = mysql_fetch_array($rsQueryResults)) {
$sRowClass = AlternateRowStyle($sRowClass);
echo "<tr class=\"" . $sRowClass . "\">";
//Loop through the fields and write each one
for ($iCount = 0; $iCount < mysql_num_fields($rsQueryResults); $iCount++) {
echo "<td align=\"center\">" . $aRow[$iCount] . "</td>";
}
echo "</tr>";
}
echo "</table>";
echo "<br><p class=\"ShadedBox\" style=\"border-style: solid; margin-left: 50px; margin-right: 50 px; border-width: 1px;\"><span class=\"SmallText\">" . str_replace(Chr(13), "<br>", htmlspecialchars($sSQL)) . "</span></p>";
}
}
开发者ID:vikingkarwur，项目名称:smjgpib，代码行数:34，代码来源:QuerySQL.php
示例18: echo_row_prodotti_amm
function echo_row_prodotti_amm($query)
{
$num_colonne = mysql_num_fields($query);
$i = 0;
$row = mysql_fetch_row($query);
while ($i < $num_colonne) {
echo "<form action=\"php/updateproduct.php\" method=\"post\"> <fieldset>";
echo "<tr>";
echo "<td style= \"font-style: italic;\">" . mysql_field_name($query, $i) . ":</td>";
echo "<td>" . $row[$i] . "</td>";
echo "<td>";
if ($i != 0) {
echo "<input type=\"text\" id=\"modifica\" name=\"modifica\">";
}
echo "</td>";
echo "<td style= \"text-align: center;\">";
if ($i != 0) {
echo "<input style=\"border:0; width:25px;\" type=\"image\" src=\"images/ok.jpg\">";
}
echo "</td>";
echo "</tr>";
echo "<input type=\"hidden\" name=\"codiceID\" value=\"" . $row[0] . "\">";
echo "<input type=\"hidden\" name=\"nomeCampo\" value=\"" . mysql_field_name($query, $i) . "\"> </fieldset> </form>";
$i = $i + 1;
}
}
开发者ID:nicolac18，项目名称:eShop，代码行数:26，代码来源:lib.php
示例19: get_field_names
function get_field_names($table){
$result = mysql_query("SELECT * FROM ".$table);
for($x = 0; $x < mysql_num_fields($result); $x++){
$arr[$x] = mysql_field_name($result,$x);
}
return $arr;
}
开发者ID:bernhardkircher，项目名称:installation-kircher-old，代码行数:7，代码来源:func.inc.php
示例20: getAccessInfo
function getAccessInfo($sql_fields, $sql_table, $sql_conditions = "1", $cond = NULL)
{
$access['Data'] = array();
$access['Headers'] = 0;
$access['Sql_Fields'] = $sql_fields;
$access['Sql_Table'] = $sql_table;
$access['Sql_Conditions'] = $sql_conditions;
$sql = "Select {$sql_fields} from {$sql_table} where {$sql_conditions}";
$result = sql_query_read($sql) or dieLog(mysql_error() . " ~ " . "<pre>{$sql}</pre>");
if (mysql_num_rows($result) < 1) {
return -1;
}
$row = mysql_fetch_row($result);
$fields = mysql_num_fields($result);
for ($i = 0; $i < $fields; $i++) {
$type = mysql_field_type($result, $i);
$name = mysql_field_name($result, $i);
$len = mysql_field_len($result, $i);
$flags = mysql_field_flags($result, $i);
$table = mysql_field_table($result, $i);
$useName = $name;
if (array_key_exists($useName, $access['Data'])) {
$useName = $name . $i;
}
if ($name == 'access_header') {
$access['Headers']++;
}
$access['Data'][$useName] = getAttrib($name, $type, $len, $flags, $table, $row[$i], &$cond);
}
return $access;
}
开发者ID:juliogallardo1326，项目名称:proc，代码行数:31，代码来源:____updateAccess.old.php
注：本文中的mysql_num_fields函数示例整理自Github/MSDocs等源码及文档管理平台，相关代码片段筛选自各路编程大神贡献的开源项目，源码版权归原作者所有，传播和使用请参考对应项目的License；未经允许，请勿转载。 |
客服电话
APP下载
官方微信
请发表评论