• 设为首页
  • 点击收藏
  • 手机版
    手机扫一扫访问
    迪恩网络手机版
  • 关注官方公众号
    微信扫一扫关注
    迪恩网络公众号
登陆 注册
描述文字

PHP mysql_list_fields函数代码示例

原作者: [db:作者] 来自: [db:来源] 收藏 邀请

本文整理汇总了PHP中mysql_list_fields函数的典型用法代码示例。如果您正苦于以下问题：PHP mysql_list_fields函数的具体用法？PHP mysql_list_fields怎么用？PHP mysql_list_fields使用的例子？那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。



在下文中一共展示了mysql_list_fields函数的20个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于我们的系统推荐出更棒的PHP代码示例。

示例1: dumpData

function dumpData($link, $mdb_name, $live_link)
{
    $result = mysql_list_tables($mdb_name, $link);
    while ($row = mysql_fetch_row($result)) {
        $getdata = mysql_query("SELECT * FROM {$row['0']}", $link);
        while ($row1 = mysql_fetch_array($getdata)) {
            $thesql = "INSERT INTO `{$row['0']}` VALUES (";
            $getcols = mysql_list_fields($mdb_name, $row[0], $link);
            for ($c = 0; $c < mysql_num_fields($getcols); $c++) {
                $thesql .= "'" . mysql_format($row1[$c]) . "'";
                if ($c < mysql_num_fields($getcols) - 1) {
                    $thesql .= ",";
                }
            }
            $thesql .= ")";
            mysql_query("{$thesql}", $live_link);
            unset($err);
            $err = mysql_error();
            if ($err) {
                print "Query: " . $tok . "<br>";
                print "Error: " . $err . "<br>";
            } else {
                print ".";
                ob_flush();
                flush();
            }
            $thesql = "";
        }
    }
    return true;
}
开发者ID:BackupTheBerlios，项目名称:redaxo-addons，代码行数:31，代码来源:db_dump.inc.php


示例2: check_database

function check_database()
{
    # Initial table setup
    /* Entries table */
    if (!mysql_query("SELECT 1 FROM entries LIMIT 0")) {
        mysql_query("\n  CREATE TABLE `entries` (\n  `entry_id` int(11) NOT NULL auto_increment,\n  `startdate` date default NULL,\n  `project_id` int(11) default NULL,\n  `person_id` int(11) default NULL,\n  PRIMARY KEY  (`entry_id`)\n  ) ENGINE=MyISAM AUTO_INCREMENT=191 DEFAULT CHARSET=latin1\n  ");
    }
    /* People table */
    if (!mysql_query("SELECT 1 FROM people LIMIT 0")) {
        mysql_query("\n  CREATE TABLE `people` (\n  `person_id` int(11) NOT NULL auto_increment,\n  `person_name` varchar(100) default NULL,\n  `person_role` varchar(11) default NULL,\n  PRIMARY KEY  (`person_id`)\n) ENGINE=MyISAM AUTO_INCREMENT=22 DEFAULT CHARSET=latin1\n  ");
    }
    /* Projects table */
    if (!mysql_query("SELECT 1 FROM projects LIMIT 0")) {
        mysql_query("\n  CREATE TABLE `projects` (\n  `project_id` int(11) NOT NULL auto_increment,\n  `project_name` varchar(100) default NULL,\n  `sort_order` int(11) default NULL,\n  `parked` varchar(20) default NULL,\n  PRIMARY KEY  (`project_id`)\n) ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=latin1\n  ");
    }
    /* Changes table */
    if (!mysql_query("SELECT 1 FROM changes LIMIT 0")) {
        mysql_query("\n  CREATE TABLE `changes` (\n  `change_id` int(11) NOT NULL auto_increment,\n  `timestamp` datetime default NULL,\n  `instigator` varchar(100) default NULL,\n  `verb` varchar(100) default NULL,\n  `person_id` int(11) default NULL,\n  `preposition` varchar(100) default NULL,\n  `project_id` int(11) default NULL,\n  `week` varchar(100) default NULL,\n  PRIMARY KEY  (`change_id`)\n) ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=latin1\n  ");
    }
    /* Options table */
    if (!mysql_query("SELECT 1 FROM options LIMIT 0")) {
        mysql_query("\n  CREATE TABLE `options` (\n  `option_id` int(11) NOT NULL auto_increment,\n  `option_name` varchar(100) default NULL,\n  `option_value` text default NULL,\n  PRIMARY KEY  (`option_id`)\n) ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=latin1\n  ");
    }
    #
    # add "project_url" field to projects table */
    #
    $fields = mysql_list_fields(DB_NAME, 'projects');
    $columns = mysql_num_fields($fields);
    for ($i = 0; $i < $columns; $i++) {
        $field_array[] = mysql_field_name($fields, $i);
    }
    if (!in_array('project_url', $field_array)) {
        $result = mysql_query('ALTER TABLE projects ADD project_url text');
    }
    # end project_url
    #
    # add "person_long_name" field to people table */
    #
    $fields = mysql_list_fields(DB_NAME, 'people');
    $columns = mysql_num_fields($fields);
    for ($i = 0; $i < $columns; $i++) {
        $field_array[] = mysql_field_name($fields, $i);
    }
    if (!in_array('person_long_name', $field_array)) {
        $result = mysql_query('ALTER TABLE people ADD person_long_name VARCHAR(200)');
    }
    # end project_url
    #
    # Versions after 0.3
    #
    /* Assuming all went well, bump DB # */
    $q = mysql_query('SELECT option_value FROM options WHERE option_name = "db_version"');
    $r = mysql_fetch_row($q);
    if (!$r) {
        mysql_query('INSERT INTO options (option_name, option_value) VALUES ("db_version", ' . CODE_VERSION . ')');
    } else {
        mysql_query('UPDATE options SET option_value = "' . CODE_VERSION . '" where option_name = "db_version"');
    }
}
开发者ID:nickgrossman，项目名称:TheBoard，代码行数:59，代码来源:setup.php


示例3: list_fields

 function list_fields($tableName)
 {
     $fields = mysql_list_fields($this->db_name, $tableName, $this->connect);
     $columns = mysql_num_fields($fields);
     $f = array();
     for ($i = 0; $i < $columns; $i++) {
         array_push($f, mysql_field_name($fields, $i));
     }
     return $f;
 }
开发者ID:phpmicrocore，项目名称:php-micro-core，代码行数:10，代码来源:Db.php


示例4: getTableField

 function getTableField($table)
 {
     $this->connect();
     $fields = mysql_list_fields($this->Database, $table, $this->Link_ID);
     $columns = mysql_num_fields($fields);
     for ($i = 0; $i < $columns; $i++) {
         $result[] = array('name' => mysql_field_name($fields, $i), 'type' => mysql_field_type($fields, $i));
     }
     return $result;
 }
开发者ID:austinliniware，项目名称:tsci-rota，代码行数:10，代码来源:mysql.class.php


示例5: name_fields

 function name_fields($table)
 {
     $vet = array();
     $campi = mysql_list_fields($this->database, $table, $this->link_id);
     $colonne = mysql_num_fields($campi);
     for ($i = 0; $i < $colonne; $i++) {
         $vet[] = mysql_field_name($campi, $i);
     }
     return $vet;
 }
开发者ID:acomai，项目名称:Biciedintorni，代码行数:10，代码来源:db_mysql_old.php


示例6: readTables

 function readTables()
 {
     $link = mysql_connect('localhost', 'root', 'M2oNa3D9');
     $result = mysql_list_tables('test', $link);
     $tables = array();
     while ($row = mysql_fetch_row($result)) {
         $name = $row[0];
         $columns = self::readColumns(mysql_list_fields('album', $name, $link));
         $keys = self::readKeys(mysql_list_fields('album', $name, $link));
         $tables[$name] = array('columns' => $columns, 'keys' => $keys);
     }
     return $tables;
 }
开发者ID:iwater，项目名称:kissphp，代码行数:13，代码来源:Database.php


示例7: getTablePrimeKey

 function getTablePrimeKey($pTable)
 {
     $this->connectDB();
     $fields = mysql_list_fields($this->mDatabaseName, $pTable, $this->mLink);
     $columns = mysql_num_fields($fields);
     for ($i = 0; $i < $columns; $i++) {
         $field_name = mysql_field_name($fields, $i);
         if (in_array("primary_key", explode(" ", mysql_field_flags($fields, $i)))) {
             $return[] = $field_name;
         }
     }
     return $return;
 }
开发者ID:iwater，项目名称:kissphp，代码行数:13，代码来源:PDO_MySqlCommand.php


示例8: st_check_field

 function st_check_field($tableName, $columnName)
 {
     //Getting table fields through mysql built in function, passing db name and table name
     $tableFields = mysql_list_fields(DB_DATABASE, $tableName);
     //loop to traverse tableFields result set
     for ($i = 0; $i < mysql_num_fields($tableFields); $i++) {
         //Using mysql_field_name function to compare with column name passed. If they are same function returns 1
         if (mysql_field_name($tableFields, $i) == $columnName) {
             return true;
         }
     }
     //end of loop
     return false;
 }
开发者ID:Zen4All-nl，项目名称:Zen-Cart-Supertracker，代码行数:14，代码来源:supertracker.php


示例9: db_insert

 function db_insert($table, $array)
 {
     //插入数据 数组array是传递过来的，要求字符串下标必须与数据库中字段名称相同
     $head = mysql_list_fields("{$this->dbname}", "{$table}", $this->hwnd);
     $count = mysql_num_fields($head);
     $field = mysql_field_name($head, 1);
     $value = "\"" . $array[mysql_field_name($head, 1)] . "\"";
     for ($i = 2; $i < $count; $i++) {
         $field = $field . "," . mysql_field_name($head, $i);
         $value = $value . "," . "\"" . $array[mysql_field_name($head, $i)] . "\"";
     }
     $chaxun = "insert into {$table}({$field}) values({$value})";
     $resu = mysql_query($chaxun, $this->hwnd);
     return $resu;
 }
开发者ID:dalinhuang，项目名称:hnaust-1，代码行数:15，代码来源:class.php


示例10: meta

	function meta($table, $schema = "DEFAULT") {
		$db = $GLOBALS["CFG_DB"]->CON[$schema]->DB;
		$link = MysqlDriver::connect($schema);
		$result = mysql_list_fields($db, $table, $link);
		$count = mysql_num_fields($result);
		$fields = array();
		for($i = 0; $i < $count; $i++) {
			$field["name"] = mysql_field_name($result, $i);
			$field["length"] = mysql_field_len($result, $i);
			$field["type"] = mysql_field_type($result, $i);
			$field["flags"] = mysql_field_flags($result, $i);
			$fields[] = $field;
		}
		mysql_free_result($result);
		return $fields;
	}
开发者ID:reekoheek，项目名称:php-fw，代码行数:16，代码来源:MysqlDriver.php


示例11: get_table_metadata

 /**
  * All information about a table columns
  *
  * @return array di nomi di colonne e relative info in formato mysql
  */
 public function get_table_metadata($table_name)
 {
     $metadata = null;
     $list_fields = mysql_list_fields($this->user_db, $table_name);
     if (!$list_fields) {
         $this->set_error("DB Error, could not get metadata.");
         return $metadata;
     }
     $num_fields = mysql_num_fields($list_fields);
     for ($i = 0; $i < $num_fields && ($info_field = mysql_fetch_field($list_fields, $i)); $i++) {
         // aggiungi field flags e salva table metadata
         $info_field->field_flags = mysql_field_flags($list_fields, $i);
         $metadata[$info_field->name] = $info_field;
     }
     return $metadata;
 }
开发者ID:lupaelma，项目名称:jenti，代码行数:21，代码来源:DBEManagerSql.1.1.php


示例12: find_db_column

function find_db_column($table, $column)
{
    // Better return values than SHOW COLUMNS but mysql_ commands are being depreciated. Migrate to mysqli_ commands instead.
    $connectstr = @parse_url(MYACTIVERECORD_CONNECTION_STR) or trigger_error("MyActiveRecord::Connection() - could not parse connection string: " . MYACTIVERECORD_CONNECTION_STR, E_USER_ERROR);
    $dbname = trim($connectstr['path'], ' /');
    $fields = mysql_list_fields($dbname, $table);
    $columns = mysql_num_fields($fields);
    for ($i = 0; $i < $columns; $i++) {
        $field_array[] = mysql_field_name($fields, $i);
    }
    if (in_array($column, $field_array)) {
        return true;
    } else {
        return false;
    }
}
开发者ID:highchair，项目名称:hcd-trunk，代码行数:16，代码来源:utility.php


示例13: GetFields

/**
 * Function: GetFields
 * Purpose: Returns an array of the fields
 */
function GetFields($table_name)
{
    $result = mysql_list_fields($GLOBALS[dbname], "{$GLOBALS['prefix']}_{$table_name}");
    $total = mysql_num_fields($result);
    for ($i = 0; $i < $total; $i++) {
        // name
        $field_name = mysql_field_name($result, $i);
        // type & size
        $result2 = mysql_query("desc {$GLOBALS['prefix']}_{$table_name}");
        while ($row = mysql_fetch_array($result2)) {
            if ($row[Field] == $field_name) {
                $field_type = $row[Type];
                $field_default = $row['Default'];
            }
        }
        if (strstr($field_type, '(')) {
            $data = explode('(', $field_type);
            $data2 = explode(')', $data[1]);
            $field_type = $data[0];
            $field_size = $data2[0];
        } else {
            $field_size = mysql_field_len($result, $i);
        }
        // flags
        $field_flags = '';
        $flags = explode(' ', mysql_field_flags($result, $i));
        foreach ($flags as $k => $v) {
            // just makes things easer :-)
            $field_flags[$v] = true;
        }
        // put it all together
        $fields[$field_name] = array('type' => $field_type, 'def' => $field_default, 'auto_increment' => $field_flags[auto_increment], 'binary' => $field_flags[binary], 'blob' => $field_flags[blob], 'enum' => $field_flags[enum], 'multiple_key' => $field_flags[multiple_key], 'not_null' => $field_flags[not_null], 'primary_key' => $field_flags[primary_key], 'timestamp' => $field_flags[timestamp], 'unique_key' => $field_flags[unique_key], 'unsigned' => $field_flags[unsigned], 'zerofill' => $field_flags[zero_fill]);
        switch ($field_type) {
            // need to add enum/set code someday
            case 'float':
            case 'decimal':
                $fsize = explode(',', $field_size);
                $fields[$field_name][size] = $fsize[0];
                $fields[$field_name][fraction] = $fsize[1];
                break;
            default:
                $fields[$field_name][size] = $field_size;
                break;
        }
    }
    return $fields;
}
开发者ID:BackupTheBerlios，项目名称:freshwind-svn，代码行数:51，代码来源:update_functions.php


示例14: mid_sqlparaexcel

 function mid_sqlparaexcel($banco, $tabela, $sql, $arquivo)
 {
     $arquivo = trim($arquivo);
     // define nome do arquivo
     $this->nomeDoArquivoXls = $arquivo;
     $this->nomeDoArquivoXls = $arquivo;
     //Pega campos da tabela
     $consTable = mysql_list_fields($banco, $tabela);
     $linTable = mysql_num_fields($consTable);
     echo mysql_error();
     // Colsulta
     $consReg = mysql_query($sql);
     $linReg = mysql_num_rows($consReg);
     // quantidade de colunas da tabela
     $qtdColunas = $linTable;
     // quadro 1, primeira linha, da primeira coluna X/Y
     $excel_linha = 0;
     $excel_coluna = 0;
     for ($e = 0; $e < $qtdColunas; $e++) {
         $vCampo = mysql_field_name($consTable, $e);
         $vCampox = trim(ucwords(str_replace("_", " ", $vCampo)));
         $this->MontaConteudo(0, $e, $vCampox);
     }
     // linha em branco
     $this->MontaConteudo(1, 0, "   ");
     $this->MontaConteudo(1, 1, "   ");
     // Monta Colunas
     for ($excel_coluna = 0; $excel_coluna < $qtdColunas; $excel_coluna++) {
         // nome da coluna
         $nome_coluna = mysql_field_name($consTable, $excel_coluna);
         // Monta Linhas
         for ($i = 0; $i < $linReg; $i++) {
             //pega registros
             $valorCelula = mysql_result($consReg, $i, $nome_coluna);
             //linhas, começa depos do cabecario
             //$excel_linha = ($i + 2);
             $excel_linha = $i + 2;
             $this->MontaConteudo($excel_linha, $excel_coluna, $valorCelula);
         }
         // fecha for 'Linhas'
     }
     // fecha for 'Colunas'
     // Cria arquivo
     $this->GeraArquivo();
 }
开发者ID:alexlqi，项目名称:adminte_git，代码行数:45，代码来源:excel_lib.php


示例15: getConfig

function getConfig()
{
    global $conf_mysql_db;
    $query = "SELECT * FROM config WHERE 1 LIMIT 1;";
    $result = mysql_query($query) or die("Cannot query {$query} !!!" . mysql_error());
    $num_rows = mysql_num_rows($result);
    if ($num_rows != 1) {
        die("No config values in table !!!");
    }
    $row = mysql_fetch_array($result);
    $fields = mysql_list_fields($conf_mysql_db, "config");
    $columns = mysql_num_fields($fields);
    for ($i = 0; $i < $columns; $i++) {
        $field_name = mysql_field_name($fields, $i);
        $toto = "conf_" . $field_name;
        global ${$toto};
        ${$toto} = $row["{$field_name}"];
    }
}
开发者ID:jeremy-cayrasso，项目名称:dtc，代码行数:19，代码来源:autoSQLconfig.php


示例16: metadata

 function metadata($table = "", $full = false)
 {
     $count = 0;
     $id = 0;
     $res = array();
     /*
      * Due to compatibility problems with Table we changed the behavior
      * of metadata();
      * depending on $full, metadata returns the following values:
      *
      * - full is false (default):
      * $result[]:
      *   [0]["table"]  table name
      *   [0]["name"]   field name
      *   [0]["type"]   field type
      *   [0]["len"]    field length
      *   [0]["flags"]  field flags
      *
      * - full is true
      * $result[]:
      *   ["num_fields"] number of metadata records
      *   [0]["table"]  table name
      *   [0]["name"]   field name
      *   [0]["type"]   field type
      *   [0]["len"]    field length
      *   [0]["flags"]  field flags
      *   ["meta"][field name]  index of field named "field name"
      *   This last one could be used if you have a field name, but no index.
      *   Test:  if (isset($result['meta']['myfield'])) { ...
      */
     // if no $table specified, assume that we are working with a query
     // result
     if ($table) {
         $this->connect();
         $id = mysql_list_fields($this->Database, $table);
         if (!$id) {
             $this->halt("Metadata query failed.");
             return false;
         }
     } else {
         $id = $this->Query_ID;
         if (!$id) {
             $this->halt("No query specified.");
             return false;
         }
     }
     $count = mysql_num_fields($id);
     // made this IF due to performance (one if is faster than $count if's)
     if (!$full) {
         for ($i = 0; $i < $count; $i++) {
             $res[$i]["table"] = mysql_field_table($id, $i);
             $res[$i]["name"] = mysql_field_name($id, $i);
             $res[$i]["type"] = mysql_field_type($id, $i);
             $res[$i]["len"] = mysql_field_len($id, $i);
             $res[$i]["flags"] = mysql_field_flags($id, $i);
         }
     } else {
         // full
         $res["num_fields"] = $count;
         for ($i = 0; $i < $count; $i++) {
             $res[$i]["table"] = mysql_field_table($id, $i);
             $res[$i]["name"] = mysql_field_name($id, $i);
             $res[$i]["type"] = mysql_field_type($id, $i);
             $res[$i]["len"] = mysql_field_len($id, $i);
             $res[$i]["flags"] = mysql_field_flags($id, $i);
             $res["meta"][$res[$i]["name"]] = $i;
         }
     }
     // free the result only if we were called on a table
     if ($table) {
         #mysql_free_result($id);
         $this->free();
     }
     return $res;
 }
开发者ID:aydancoskun，项目名称:octobercms，代码行数:75，代码来源:Class_DB.inc.php


示例17: mysql_select_db

 // or die ('I cannot connect to the database because: ' . mysql_error());
 mysql_select_db($database);
 switch ($type) {
     case "export_csv_kws":
         $date_field = "timestamp";
         $table = "kw_log";
         break;
     case "export_csv_cost":
         $date_field = "int_date";
         $table = "cost";
         break;
 }
 $result = mysql_query("select * from {$table} WHERE `{$date_field}` >= '{$start_time}' AND `{$date_field}` <= '{$end_time}'");
 $out = '';
 // Get all fields names in table "name_list" in database "tutorial".
 $fields = mysql_list_fields($database, $table);
 // Count the table fields and put the value into $columns.
 $columns = mysql_num_fields($fields);
 // Put the name of all fields to $out.
 for ($i = 0; $i < $columns; $i++) {
     $l = mysql_field_name($fields, $i);
     $out .= '"' . $l . '",';
 }
 $out .= "\n";
 // Add all values in the table to $out.
 while ($l = mysql_fetch_array($result)) {
     for ($i = 0; $i < $columns; $i++) {
         $out .= '"' . $l["{$i}"] . '",';
     }
     $out .= "\n";
 }
开发者ID:jprecht，项目名称:ppc-coach-tracker，代码行数:31，代码来源:reports.php


示例18: GetTableFields

 function GetTableFields($tbname, $id = "me")
 {
     global $dsql;
     if (!$dsql->isInit) {
         $this->Init($this->pconnect);
     }
     $this->result[$id] = mysql_list_fields($this->dbName, $tbname, $this->linkID);
 }
开发者ID:stonelf，项目名称:mcgmh，代码行数:8，代码来源:dedesql.class.php


示例19: db_list_fields

function db_list_fields($database, $table, $dbh)
{
    return mysql_list_fields($database, $table, $dbh);
}
开发者ID:kktsvetkov，项目名称:1double.com，代码行数:4，代码来源:db_body.inc.php


示例20: MySQL_List_Fields_Test

 /**
  * Test mysql_list_fields
  *
  * @return boolean
  */
 public function MySQL_List_Fields_Test()
 {
     // Select Db
     $this->_selectDb();
     $query1 = mysql_list_fields(TEST_DB, TEST_TABLE);
     $query2 = $this->_object->mysql_list_fields(TEST_DB, TEST_TABLE);
     $list1 = array();
     $list2 = array();
     // Our object gives us num_rows, something that we can't do in mysql_*
     $cnt = $this->_object->mysql_num_rows($query2);
     $i = 0;
     while ($i < $cnt) {
         $list1[] = mysql_field_name($query1, $i);
         $i++;
     }
     $i = 0;
     while ($i < $cnt) {
         $list2[] = $this->_object->mysql_field_name($query2, $i);
         $i++;
     }
     return $list1 === $list2;
 }
开发者ID:ReKungPaw，项目名称:mysql，代码行数:27，代码来源:MySQL_Test.php



注：本文中的mysql_list_fields函数示例整理自Github/MSDocs等源码及文档管理平台，相关代码片段筛选自各路编程大神贡献的开源项目，源码版权归原作者所有，传播和使用请参考对应项目的License；未经允许，请勿转载。

鲜花
握手
雷人
路过
鸡蛋
该文章已有0人参与评论

请发表评论

全部评论

专题导读
More+
上一篇：
PHP mysql_list_tables函数代码示例发布时间：2022-05-15
下一篇：
PHP mysql_list_dbs函数代码示例发布时间：2022-05-15
热门推荐
More+
热门话题
More+
阅读排行榜

扫描微信二维码

查看手机版网站

随时了解更新最新资讯

139-2527-9053

在线客服（服务时间 9:00～18:00）

在线QQ客服
地址：深圳市南山区西丽大学城创智工业园
电邮：jeky_zhao#qq.com
移动电话：139-2527-9053

Powered by 互联科技 X3.4© 2001-2213 极客世界.|Sitemap