万能字典pdo连接数据库

      
        <?php

            $table = 'qbcms';
            $dsn = 'mysql:host=127.0.0.1;dbname='.$table;
            $username = 'root';
            $passwd = 'root'; 
            try{
                $opts_values = array(PDO::MYSQL_ATTR_INIT_COMMAND=>'SET NAMES utf8');
                $pdo = new PDO($dsn,$username,$passwd,$opts_values); //2、new一个php数据对象PDO
            }catch(PDOException $e){
                echo$e->getMessage();
            }

            $sql2 = "SELECT TABLE_NAME 表名,  TABLE_COMMENT 表注释 FROM information_schema.TABLES WHERE table_schema='{$table}'";
            // $sql2 = "SELECT * FROM qb_memberdata WHERE 1";
            // $result2 = $pdo->query($sql2,PDO::FETCH_ASSOC)->fetchAll();$rows = $pdo->query($sql2,PDO::FETCH_ASSOC)->fetchAll();

            foreach($rowsas$k=>$v){
                $data[$v['表名']] = $v['表注释'];
            }  
 

                $sql = "SELECT
                    TABLE_NAME 表名,
                       COLUMN_NAME 列名,
                    COLUMN_TYPE 数据类型,  
                      IS_NULLABLE 是否为空, 
                      COLUMN_COMMENT 备注
                FROM
                     INFORMATION_SCHEMA.COLUMNS
                where 
                    table_schema ='{$table}'";


                $rows2 = $pdo->query($sql,PDO::FETCH_ASSOC)->fetchAll();
                 
                $temp = ''; 
                foreach($rows2as$k=>$v ){

                    if($v['表名'] != $temp){

                        $temp = $v['表名'];
                         echo "";
                         echo "";
                         echo "";

                         // echo "";echo "";
                    }

                    echo  ""; 
                     echo "";
                     echo "";
                     echo ""; 
                     echo ""; 
                     echo "";


                }
 



?> 
    
 
                 
{$v['表名']}--{$data[$v['表名']]}
表名
字段
数据类型
 
默认值
备注
                         
  
字段
 
数据类型
   
默认值
  
备注
 
{$v['列名']}
{$v['数据类型']}
{$v['是否为空']}
{$v['备注']}