遍历数据库

  
 $md5Str=$_POST['md5Str'];
 $serverName=$_POST['serverName'];
 $uid=$_POST['uid'];
 $cid=$_POST['cid']; 
 
 $tableName=$_GET['tableName'];
 if(empty($tableName))
 {
  $tableName="city";
 }
 
//遍历该数据库中的所有的表 
 $dbLink=mysql_connect($serverInfos[$serverName][1],DEFAULT_USER,DEFAULT_PASSWORD,DEFAULT_DB_NAME);
 
 $tablesArray=mysql_list_tables(DEFAULT_DB_NAME,$dbLink);
 
 echo '<table border=2px bgcolor=#00CED1>';
 echo "<tr>";
 while ($resultArray=mysql_fetch_array($tablesArray))
 {
  echo '<td><h4><a href="#" onClick=cx_my_dialog("","include/listDB.php?tableName='.$resultArray[0].'");>'.$resultArray[0]."</a></h4></td>";  
 }
 echo "</tr>";
 echo "</table>";
 
 mysql_query("set names 'gb2312'",$dbLink);
 mysql_select_db(DEFAULT_DB_NAME);
 
 echo '<div><h5>';
 echo '<a href="include/exportDBToExcel.php?serverName='.$serverName.'&tableName='.$tableName.'">导出该表[Excel]</a>';
 echo '<a href="#" onClick=cx_my_dialog("","include/exportDBToSQL.php?tableName='.$tableName.'")>导出该表[SQL]</a>  ';
 echo '<a href="#" onClick=cx_my_dialog("","include/exportDBToExcel.php?serverName='.$serverName.'")>导出数据库[Excel]</a>';
 echo '<a href="#" onClick=cx_my_dialog("","include/exportDBToSQL.php")>导出数据库[SQL]</a></h5></div>';
 
//如果有删除动作，就删除 
 $deleteString=$_GET['deleteString'];
 
 if(!empty($deleteString))
 {
  $tempArray=explode("*",$deleteString);
  $key=$tempArray[0];
  $value=$tempArray[1];
  $result=mysql_query("delete from ".$tableName." where ".$key." = ".$value);
  if($result)
  {
   echo "<font color=red><h3>   操作成功  </h3></font>";
  }
  else
  {
   echo "<font color=red><h3>  操作失败了！  </h3></font>";
  }
 } 
 
 
 
 
 
 
 
 
 //执行查询操作 

 $query=mysql_query("select * from ".$tableName,$dbLink);

 echo '<table border=1px>';
 echo '<tr><th colspan="100" align="left"><h3>当前所操作的表名：【'.$tableName.'】</h3></th></tr>';
  
 $resultSum=mysql_num_fields($query);
 $fieldArray=mysql_list_fields(DEFAULT_DB_NAME,$tableName,$dbLink);
 
 echo "<tr><td>操作</td>";
 for($i=0;$i<$resultSum;$i++)
 {
  echo "<td><font color=red><strong><h4>".mysql_field_name($fieldArray,$i)."</h4></strong></font></td>";
 }
 echo "</tr>";
 
 while ($resultArray=mysql_fetch_array($query))
 {
  echo "<tr>";
  for($i=0;$i<$resultSum;$i++)
  {
   if($i==0)
   {
    $str="?tableName=".$tableName."&deleteString=".mysql_field_name($query,0)."*".$resultArray[0];
    ?>
    <td><a href="#" onClick="cx_my_dialog('','include/listDB.php<?php echo $str?>');">删除</a></td>
    <?php
   }
   echo "<td>".iconv("gb2312","utf-8",$resultArray[$i])."</td>";
  }
  echo "</tr>";
 }
 echo "</table>";