本文整理汇总了PHP中mysql_tablename函数的典型用法代码示例。如果您正苦于以下问题:PHP mysql_tablename函数的具体用法?PHP mysql_tablename怎么用?PHP mysql_tablename使用的例子?那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了mysql_tablename函数的20个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于我们的系统推荐出更棒的PHP代码示例。
示例1: step_2
function step_2($connect, $select, $chat, $fpconfig)
{
$configtpl = "../conf/config.php-tpl";
$fpconfigtpl = fopen($configtpl, "r");
$inhalt = fread($fpconfigtpl, filesize($configtpl));
foreach ($chat as $key => $value) {
$inhalt = str_replace("%{$key}%", addslashes($value), $inhalt);
}
fwrite($fpconfig, $inhalt, strlen($inhalt));
echo "<table width=\"100%\" cellspacing=\"0\" cellpadding=\"2\" border=\"0\" align=\"center\">\n" . "<tr bgcolor=\"#007ABE\"><td style=\"font-size:15px; text-align:center;color:White;\"><b>Konfigurationsdatei</b></td></tr>\n" . "<tr><td > Im Verzeichnis conf wurde folgende Konfigurationsdatei angelegt: <br>\n";
$config = "../conf/config.php";
if (!file_exists($config)) {
echo "<span style=\"color:red\">Anlegen der <b>config.php</b> misslungen</span></td></tr>\n";
} else {
echo "<b>config.php</b></td></tr>\n";
}
$mysqldatei = "../dok/mysql.def";
$mysqlfp = fopen($mysqldatei, "r");
$mysqlinhalt = fread($mysqlfp, filesize($mysqldatei));
$mysqlarray = explode(';', $mysqlinhalt);
foreach ($mysqlarray as $key => $value) {
mysql_query($value);
}
echo "<tr><td colspan=\"2\"><br><br></td></tr>\n" . "<tr bgcolor=\"#007ABE\"><td style=\"font-size:15px; text-align:center;color:White;\"><b>Datenbank</b></td></tr>\n" . "<tr><td>In der Datenbank " . $chat['dbase'] . " (Datenbankuser: " . $chat['user'] . ") wurden folgende Tabellen " . "angelegt: <br>\n";
$tables = mysql_listtables($chat['dbase']);
for ($i = 0; $i < mysql_num_rows($tables); $i++) {
$table = mysql_tablename($tables, $i);
echo "<b>" . $table . "</b>, \n";
}
echo "</td></tr>" . "<tr><td colspan=\"2\"><br><br></td></tr>\n";
echo "<tr><td> Mit <b>Nickname admin und Passwort admin</b> können Sie sich beim ersten Mal anmelden!<br>\n" . "<a href=\"../index.php\">zum Chat</a></tr></td></table>\n";
}
开发者ID:netzhuffle,项目名称:mainchat,代码行数:32,代码来源:functions.php-install.php
示例2: GetTables
function GetTables()
{
$xmlOutput = "";
$result = mysql_list_tables($this->database, $this->connectionId);
if ($result) {
$xmlOutput = "<RESULTSET><FIELDS>";
// Columns are referenced by index, so Schema and
// Catalog must be specified even though they are not supported
$xmlOutput .= "<FIELD><NAME>TABLE_CATALOG</NAME></FIELD>";
// column 0 (zero-based)
$xmlOutput .= "<FIELD><NAME>TABLE_SCHEMA</NAME></FIELD>";
// column 1
$xmlOutput .= "<FIELD><NAME>TABLE_NAME</NAME></FIELD>";
// column 2
$xmlOutput .= "</FIELDS><ROWS>";
$tableCount = mysql_num_rows($result);
for ($i = 0; $i < $tableCount; $i++) {
$xmlOutput .= "<ROW><VALUE/><VALUE/><VALUE>";
$xmlOutput .= mysql_tablename($result, $i);
$xmlOutput .= "</VALUE></ROW>";
}
$xmlOutput .= "</ROWS></RESULTSET>";
}
return $xmlOutput;
}
开发者ID:Himy1118,项目名称:2015FinalTestProject,代码行数:25,代码来源:mysql.php
示例3: makedump
function makedump($table_select, $what, $db, $crlf = "\n")
{
global $dump_buffer, $tmp_buffer;
$tables = mysql_list_tables($db);
$num_tables = mysql_numrows($tables);
$dump_buffer = '';
$tmp_buffer = '';
$i = 0;
while ($i < $num_tables) {
$table = mysql_tablename($tables, $i);
if (!isset($table_select[$table])) {
$i++;
continue;
}
if ($what != 'dataonly') {
$dump_buffer .= PMA_getTableDef($db, $table, $crlf) . ';' . $crlf . $crlf;
}
if ($what == 'data' || $what == 'dataonly') {
$tmp_buffer = '';
PMA_getTableContent($db, $table, 0, 0, 'PMA_myHandler', $crlf);
$dump_buffer .= $tmp_buffer . $crlf;
}
$i++;
}
return $dump_buffer;
}
开发者ID:BackupTheBerlios,项目名称:qsf-svn,代码行数:26,代码来源:dump_functions.php
示例4: list_tables
function list_tables()
{
$res = mysql_list_tables($this->db['dbName']);
for ($i = 0; $i < $this->num_rows($res); $i++) {
$fields[$i] = mysql_tablename($res, $i);
}
return $fields;
}
开发者ID:BackupTheBerlios,项目名称:sitexs,代码行数:8,代码来源:mysql.class.php
示例5: _getTableList
function _getTableList($dbName)
{
$tableList = array();
$result = mysql_list_tables($dbName, $this->_mysql_link_id);
for ($i = 0; $i < mysql_num_rows($result); $i++) {
array_push($tableList, mysql_tablename($result, $i));
}
mysql_free_result($result);
return $tableList;
}
开发者ID:ekdd1987,项目名称:panda,代码行数:10,代码来源:dbbak.php
示例6: listTables
public function listTables()
{
$tableNames = array();
if ($this->_link) {
$result = mysql_query('SHOW TABLES');
for ($i = 0; $i < mysql_num_rows($result); $i++) {
$tableNames[$i] = mysql_tablename($result, $i);
}
}
return $tableNames;
}
开发者ID:DustySheep,项目名称:TEST_PMT1,代码行数:11,代码来源:ConnectMySQL.class.php
示例7: TableExists
function TableExists($tablename, $db)
{
$result = mysql_list_tables($db);
$rcount = mysql_num_rows($result);
for ($i = 0; $i < $rcount; $i++) {
if (mysql_tablename($result, $i) == $tablename) {
return true;
}
}
return false;
}
开发者ID:rodoabad,项目名称:amxx-bans,代码行数:11,代码来源:setup.php
示例8: getTables
function getTables()
{
global $MYSQL_SERVER, $MYSQL_USERNAME, $MYSQL_PASSWORD, $MYSQL_DBNAME;
$result = mysql_list_tables($MYSQL_DBNAME);
$num_rows = mysql_num_rows($result);
for ($i = 0; $i < $num_rows; $i++) {
//here
$tables[$i] = mysql_tablename($result, $i);
}
return $tables;
}
开发者ID:lovebomb,项目名称:linkwithweb,代码行数:11,代码来源:library.fndb.inc.php
示例9: mysql_list_dbs
function &MetaDatabases()
{
$qid = mysql_list_dbs($this->_connectionID);
$arr = array();
$i = 0;
$max = mysql_num_rows($qid);
while ($i < $max) {
$arr[] = mysql_tablename($qid, $i);
$i += 1;
}
return $arr;
}
开发者ID:qoire,项目名称:portal,代码行数:12,代码来源:adodb-mysql.inc.php
示例10: ListTables
function ListTables($db, $cnx)
{
$list = array();
$_res = mysql_list_tables($db, $cnx);
$i = 0;
$ntables = $_res ? @mysql_num_rows($_res) : 0;
while ($i < $ntables) {
array_push($list, mysql_tablename($_res, $i));
$i++;
}
return $list;
}
开发者ID:BackupTheBerlios,项目名称:nxwcms-svn,代码行数:12,代码来源:execbackup.php
示例11: dump
function dump()
{
/**
* Increase time limit for script execution and initializes some variables
*/
set_time_limit(0);
$hostname = "";
if (isset($_SERVER["HTTP_HOST"])) {
$hostname = $_SERVER["HTTP_HOST"];
}
### IE need specific headers
#if(getBrowserAgent() == 'IE') {
# #header('Content-Disposition: inline; filename="' . $filename . '.' . $ext . '"');
# header('Expires: 0');
# header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
# header('Pragma: public');
#}
### Builds the dump
$tables = mysql_list_tables($this->db_name);
if (!($num_tables = mysql_numrows($tables))) {
echo "mysql-error:<pre>" . mysql_error() . "</pre>";
trigger_error("no tables found", E_USER_ERROR);
exit(0);
}
$dump_buffer = "# slim phpMyAdmin MySQL-Dump\n";
for ($i = 0; $i < $num_tables; $i++) {
$table_name = mysql_tablename($tables, $i);
$dump_buffer .= $this->crlf . '#' . $this->crlf . '#' . $this->backquote($table_name) . $this->crlf . '#' . $this->crlf . $this->crlf . $this->getTableDef($table_name) . ';' . $this->crlf . $this->getTableContentFast($table_name);
}
$dump_buffer .= $this->crlf;
### Displays the dump as gzip-file
if (function_exists('gzencode')) {
$filename = $hostname . "_" . $this->db_name . '_' . date("Y-m-d_H:i") . '.gzip';
$mime_type = 'application/x-gzip';
### Send headers
header('Content-Type: ' . $mime_type);
header('Content-Disposition: attachment; filename="' . $filename . '"');
header('Expires: 0');
header('Pragma: no-cache');
echo gzencode($dump_buffer);
# without the optional parameter level because it bugs
} else {
$filename = $hostname . "_" . $this->db_name . '_' . date("Y-m-d_H:i") . '.sql';
### Send headers
header('Content-Type: ' . $mime_type);
header('Content-Disposition: attachment; filename="' . $filename . '"');
header('Expires: 0');
header('Pragma: no-cache');
#trigger_error("gzencode() not defined. Saving backup failed", E_USER_ERROR);
echo "<pre>" . $dump_buffer . "</pre>";
}
}
开发者ID:Bremaweb,项目名称:streber-1,代码行数:52,代码来源:mysqldump.php
示例12: TableExists
function TableExists($tablename, $db)
{
// Get a list of tables contained within the database.
$result = mysql_list_tables($db);
$rcount = mysql_num_rows($result);
// Check each in list for a match.
for ($i = 0; $i < $rcount; $i++) {
if (mysql_tablename($result, $i) == $tablename) {
return true;
}
}
return false;
}
开发者ID:Atropin,项目名称:4SWeb,代码行数:13,代码来源:cron-eve-ships.php
示例13: isTable
function isTable($s)
{
global $sSqlDB;
if ($sSqlDB != '') {
$dTables = mysql_list_tables($sSqlDB);
for ($i = 0; $i < mysql_numrows($dTables); $i++) {
if (mysql_tablename($dTables, $i) == $s) {
return true;
}
}
}
return false;
}
开发者ID:prymribb,项目名称:starter,代码行数:13,代码来源:data.php
示例14: checkTableExist
/**
* checkTableExist = Check whether the table exists,
* param $must_table = the table to be check if it exists
* param $default_table = default table
* return = $must_table if exist, otherwise $default_table
*/
function checkTableExist($must_table, $default_table)
{
global $dbname, $link;
$all_table = mysql_list_tables($dbname, $link);
$i = 0;
while ($i < mysql_num_rows($all_table)) {
if ($must_table == mysql_tablename($all_table, $i)) {
$default_table = $must_table;
break;
}
$i++;
}
return $default_table;
}
开发者ID:patmark,项目名称:care2x-tz,代码行数:20,代码来源:inc_db_fx.php
示例15: dumpDatabase
/**
* Dump data and structure from MySQL database
*
* @param string $database
* @return string
*/
function dumpDatabase($database, $link)
{
// Connect to database
$db = mysql_select_db($database, $link);
if (!empty($db)) {
// Get all table names from database
$c = 0;
$result = mysql_list_tables($database, $link);
for ($x = 0; $x < mysql_num_rows($result); $x++) {
$table = mysql_tablename($result, $x);
if (!empty($table)) {
$arr_tables[$c] = mysql_tablename($result, $x);
$c++;
}
}
// List tables
$dump = '';
for ($y = 0; $y < count($arr_tables); $y++) {
// DB Table name
$table = $arr_tables[$y];
// Dump data
unset($data);
$result = mysql_query("SELECT * FROM `{$table}`", $link);
$num_rows = mysql_num_rows($result);
$num_fields = mysql_num_fields($result);
for ($i = 0; $i < $num_rows; $i++) {
$row = mysql_fetch_object($result);
$data .= "INSERT INTO `{$table}` (";
// Field names
for ($x = 0; $x < $num_fields; $x++) {
$field_name = mysql_field_name($result, $x);
$data .= "`{$field_name}`";
$data .= $x < $num_fields - 1 ? ", " : false;
}
$data .= ") VALUES (";
// Values
for ($x = 0; $x < $num_fields; $x++) {
$field_name = mysql_field_name($result, $x);
$data .= "'" . str_replace('\\"', '"', mysql_escape_string($row->{$field_name})) . "'";
$data .= $x < $num_fields - 1 ? ", " : false;
}
$data .= ");\n";
}
$data .= "\n";
$dump .= $structure . $data;
$dump .= "-- --------------------------------------------------------\n\n";
}
return $dump;
}
}
开发者ID:BackupTheBerlios,项目名称:redaxo-addons,代码行数:56,代码来源:class.MySQLDump.inc.php
示例16: delarray
private function delarray($array)
{
//处理传入进来的数组
foreach ($array as $tables) {
if ($tables == '*') {
//所有的表(获得表名时不能按常规方式来组成一个数组)
$newtables = mysql_list_tables($this->dbName, $this->mysql_link);
$tableList = array();
for ($i = 0; $i < mysql_numrows($newtables); $i++) {
array_push($tableList, mysql_tablename($newtables, $i));
}
$tableList = $tableList;
} else {
$tableList = $array;
break;
}
}
return $tableList;
}
开发者ID:daolei,项目名称:grw,代码行数:19,代码来源:Backup.php
示例17: ddtables
function ddtables($dbname)
{
global $sel_table;
if (!empty($dbname)) {
$result = mysql_list_tables($dbname);
$i = 0;
echo "\nTables: <select name=\"sel_table\">\n";
echo "<option value=\"\">select table ....</option>\n";
while ($i < mysql_num_rows($result)) {
$tb_names[$i] = mysql_tablename($result, $i);
if ($tb_names[$i] == "{$sel_table}") {
echo "<option value=\"{$tb_names[$i]}\" selected>{$tb_names[$i]}</option>\n";
} else {
echo "<option value=\"{$tb_names[$i]}\">{$tb_names[$i]}</option>\n";
}
$i++;
}
echo "</select>";
}
}
开发者ID:alexzita,项目名称:alex_blog,代码行数:20,代码来源:dataman_functions.php
示例18: mysqlTable
function mysqlTable($action)
{
global $pmb_set_time_limit, $dbh;
if (SESSrights & ADMINISTRATION_AUTH) {
$result = array();
if ($action) {
@set_time_limit($pmb_set_time_limit);
$db = DATA_BASE;
$tables = mysql_list_tables($db);
$num_tables = @mysql_num_rows($tables);
$i = 0;
while ($i < $num_tables) {
$table[$i] = mysql_tablename($tables, $i);
$i++;
}
while (list($cle, $valeur) = each($table)) {
$requete = $action . " TABLE " . $valeur . " ";
$res = @mysql_query($requete, $dbh);
$nbr_lignes = @mysql_num_rows($res);
if ($nbr_lignes) {
for ($i = 0; $i < $nbr_lignes; $i++) {
$row = mysql_fetch_row($res);
$tab = array();
foreach ($row as $dummykey => $col) {
if (!$col) {
$col = " ";
}
$tab[$dummykey] = $col;
}
$result[] = $tab;
}
}
}
}
return $result;
} else {
return array();
}
}
开发者ID:bouchra012,项目名称:PMB,代码行数:39,代码来源:pmbesMySQL.class.php
示例19: Savedb
function Savedb()
{
// init the var
$copyr = null;
$dbname = null;
$newfile = null;
$tables = mysql_list_tables($this->dbname,$this->conn);
$num_tables = @mysql_num_rows($tables);
$i = 0;
while($i < $num_tables)
{
$table = mysql_tablename($tables, $i);
$table = ltrim($table);
$newfile .= $this->get_def($dbname,$table);
$newfile .= "\n\n";
$newfile .= $this->get_content($dbname,$table);
$newfile .= "\n\n";
$i++;
}
echo $newfile;
}
开发者ID:BackupTheBerlios,项目名称:eshop,代码行数:23,代码来源:class.dbbackup.php
示例20: ImportCreateTable
function ImportCreateTable()
{
global $sql, $lang, $db, $config;
$tbl = array();
$tabellen = mysql_list_tables($db, $config['dbconnection']);
$num_tables = mysql_num_rows($tabellen);
for ($i = 0; $i < $num_tables; $i++) {
$tbl[] = strtolower(mysql_tablename($tabellen, $i));
}
$i = 0;
$sql['import']['table'] = $sql['import']['table'] . $i;
while (in_array($sql['import']['table'], $tbl)) {
$sql['import']['table'] = substr($sql['import']['table'], 0, strlen($sql['import']['table']) - 1) . ++$i;
}
$create = "CREATE TABLE `" . $sql['import']['table'] . "` (" . ($sql['import']['createindex'] == 1 ? '`import_id` int(11) unsigned NOT NULL auto_increment, ' : '');
if ($sql['import']['namefirstline']) {
for ($i = 0; $i < count($sql['import']['first_zeile']); $i++) {
$create .= '`' . $sql['import']['first_zeile'][$i] . '` VARCHAR(250) NOT NULL, ';
}
} else {
for ($i = 0; $i < count($sql['import']['first_zeile']); $i++) {
$create .= '`FIELD_' . $i . '` VARCHAR(250) NOT NULL, ';
}
}
if ($sql['import']['createindex'] == 1) {
$create .= 'PRIMARY KEY (`import_id`) ';
} else {
$create = substr($create, 0, strlen($create) - 2);
}
$create .= ') ' . (MSD_NEW_VERSION ? 'ENGINE' : 'TYPE') . "=MyISAM COMMENT='imported at " . date("l dS of F Y H:i:s A") . "'";
$res = mysql_query($create, $config['dbconnection']) || die(SQLError($create, mysql_error()));
return 1;
}
开发者ID:BackupTheBerlios,项目名称:oos-svn,代码行数:33,代码来源:functions_sql.php
注:本文中的mysql_tablename函数示例整理自Github/MSDocs等源码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。 |
请发表评论