本文整理汇总了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;未经允许,请勿转载。 |
请发表评论