<?php
header("Content-Type:text/html;charset=utf-8");
/*
作者:zengwenjie
功能:根据tablename取得对应的所有数据
*/
require_once ("config.php");
;
set_time_limit(0);
error_reporting(E_ERROR);
session_start();
$tablename = $_REQUEST["tablename"];
$tablename = addslashes(trim($tablename));
$whiteArray = array("tbl1", "tbl2");
if (!in_array($tablename, $whiteArray)) {
print "error tablename!";
return;
}
$link = mysql_connect($ops_cfg_db_host_rw, $ops_cfg_db_user_rw, $ops_cfg_db_pass_rw) or die("connection failed");
mysql_query("set names 'utf8'", $link);
mysql_select_db($ops_cfg_db_db, $link);
$sql = "SHOW FIELDS FROM " . $tablename;
$result = mysql_query($sql, $link);
$arrFields = array();
while ($rows = mysql_fetch_array($result)) {
$arrFields[] = $rows["Field"];
}
mysql_free_result($result);
$sql = "select * from " . $tablename;
$values = implode(",", $arrFields);
$result = mysql_query($sql, $link);
$sqlarr = array();
if ($result) {
while ($row = mysql_fetch_array($result)) {
$realvalues = "";
foreach ($arrFields as $field) {
if (!empty($realvalues))
$realvalues .= ",";
$realvalues .= "'" . $row[$field] . "'";
}
$sqlarr[] = "replace into $tablename($values ) values ( $realvalues )";
}
mysql_free_result($result);
foreach ($sqlarr as $sql) {
$sql = str_replace("\r\n", "\\r\\n", $sql);
print $sql . ";\r\n";
}
}
mysql_close($link);
?>
根据tablename取得对应的所有数据
最新推荐文章于 2023-07-07 10:30:27 发布