淘宝网女装新款秋装连衣裙裤子外套上衣_2012时尚女装新款 Ecmall二次开发-PHP技术

一个读取MYSQL数据库及表名的简单PHP代码

代码:
<?php
        //连接数据库
        $link=mysql_connect("localhost","root","wutianshen");
        //获得数据库名
        $db_list=mysql_list_dbs($link);
        while($row = mysql_fetch_object($db_list)){
                $db=$row->Database;
                echo "数据库:".$db."<br>";
                //获得每个数据库的表名
                $result = mysql_list_tables($db);
                while($tb = mysql_fetch_array($result,MYSQL_NUM)){
                        echo "表名:".$tb[0]."<br>";
                        //获得表中的字段
                        $rel = mysql_query("select * from $tb[0]");
                        for($i=0;$i<mysql_num_fields($rel);$i++){
                                //读出字段信息
                                echo "第 $i 个字段：";
                                $meta = mysql_fetch_field($rel);
                                if($meta){
                                        echo "<pre>
                                        字段名称: $meta->name
                                        字段数据类型: $meta->type
                                        字段的长度: $meta->max_length
                                        </pre>";
                                }
                        }
                }

        }
        //清空内存
        mysql_free_result($result);
        //关闭数据库
        mysql_close();
?>

作者：noel@淘宝网女装新款秋装连衣裙裤子外套上衣_2012时尚女装新款 Ecmall二次开发-PHP技术
地址：http://www.laohucheng.com/post/199/
版权所有©转载时必须以链接形式注明作者和原始出处及本声明！