提高mysql数据库设计的效率
PHP 代码:
<?
$dbset[dbname]='dbname';//换成你的数据库名
$dbset[user]='root';//换成你的用户名
$dbset[password]='123456';//换成你的密码
$dbset[host]='localhost';//换成你的连接主机名，一般为localhost
$db=mysql_connect($dbset[host],$dbset[user],$dbset[password]);
$alltbl=array();
$res=mysql_list_tables($dbset[dbname],$db);
while ($row=mysql_fetch_array($res)) {
array_push($alltbl,$row[0]);
}
//print_r($alltbl);exit;
$pre="";//字段前缀
$spc=",";//分隔符
foreach ($alltbl as $tbl) {
$res=mysql_list_fields($dbset[dbname],$tbl,$db);
$tbllen=mysql_num_fields($res);
$fielda0=array();$fielda1=array();$fielda2=array();$fielda3=array();$fielda4=array();$fieldatmp=array();
for ($i=0;$i<$tbllen ;$i++ ) {
$fieldname=mysql_field_name($res,$i);
array_push($fielda0,$pre.$fieldname);
array_push($fielda1,$fieldname);
array_push($fielda2,"$".$fieldname);
array_push($fielda3,$fieldname."='$".$fieldname."'");
array_push($fielda4,"'$".$fieldname."'");
array_push($fieldatmp,"{".$fieldname."}");
}
echo "<b>数据表：</b>".$tbl."<BR>";
$fielda1=join($spc,$fielda1);$fielda2=join($spc,$fielda2);
$fielda3=join($spc,$fielda3);$fielda4=join($spc,$fielda4);
$fielda0=join($spc,$fielda0);
$fieldatmp=join(" ",$fieldatmp);
echo " $fieldatmp <BR>";
echo "\$res=mysql_query(\""."SELECT $fielda0 FROM $tbl WHERE ORDER BY "."\",\$this->db);<BR>";
echo "mysql_query(\""."INSERT INTO $tbl ($fielda1) VALUES ($fielda4) "."\",\$this->db);<BR>";
echo "mysql_query(\""."UPDATE $tbl SET $fielda3 WHERE "."\",\$this->db);<br><br>";
}
?>
平板模式
