library db_explorer

shankarbala33/db_explorer

Complete Database Explorer

DB Explorer

Tool for extraxting and analysing the database structure., _(*1)

Inatalling

Command Line Installation:, _(*2)

  $ composer require shankarbala33/db_explorer

Available Schemas, _(*3)

Currently available database schema's are,, _(*4)

1. MySQL

Sample Code :, _(*5)

"use shankarbala33\db_explorer\OTF_DB;"

Basic DB Connection [MySQL] :, _(*6)

$db_schema = (
 "name" => "mysql",
 "host" => "localhost",
 "username" => "root",
 "password" => "root",
 "database" => "wordpress"
); 

Scan Database :, _(*7)

 $database = new OTF_DB()     
 $schema = $database->scanDatabase($db_schema); 
 dd($schema);

Sample Output :, _(*8)

array:12 [▼
  "wp_commentmeta" => array:4 [▼
     0 => {#239 ▼
        +"TABLE_CATALOG": "def"
        +"TABLE_SCHEMA": "wordpress"
        +"TABLE_NAME": "wp_commentmeta"
        +"COLUMN_NAME": "meta_id"
        +"ORDINAL_POSITION": 1
        +"COLUMN_DEFAULT": null
        +"IS_NULLABLE": "NO"
        +"DATA_TYPE": "bigint"
        +"CHARACTER_MAXIMUM_LENGTH": null
        +"CHARACTER_OCTET_LENGTH": null
        +"NUMERIC_PRECISION": 20
        +"NUMERIC_SCALE": 0
        +"DATETIME_PRECISION": null
        +"CHARACTER_SET_NAME": null
        +"COLLATION_NAME": null
        +"COLUMN_TYPE": "bigint(20) unsigned"
        +"COLUMN_KEY": "PRI"
        +"EXTRA": "auto_increment"
        +"PRIVILEGES": "select,insert,update,references"
        +"COLUMN_COMMENT": ""
       }
1 => {#240 ▶}
2 => {#241 ▶}
3 => {#242 ▶}
    ]
"wp_comments" => array:15 [▶]
"wp_links" => array:13 [▶]
"wp_options" => array:4 [▶]
"wp_postmeta" => array:4 [▶]
"wp_posts" => array:23 [▶]
"wp_term_relationships" => array:3 [▶]
"wp_term_taxonomy" => array:6 [▶]
"wp_termmeta" => array:4 [▶]
"wp_terms" => array:4 [▶]
"wp_usermeta" => array:4 [▶]
"wp_users" => array:10 [▶]
] 

License

MIT License, _(*9)