Displaying mySQL table structures in PHP
| Published on 6/30/2008 by Dotnetindex More articles in PHP
|
You can get information about tables using SHOW TABLE STATUS query. This query gives you a detailed info about all tables in your database. We can loop results:
We can re-write this query to find only structure about a tables: SHOW TABLE STATUS LIKE ’products’ If you wish to learn AutoIndex number, here's the comple code written in PHP: <?php
|
no comments submitted
Latest Posts
- Image manipulation and watermarking in PHP with GD2
- Making A Cool Login System With PHP, MySQL & jQuery
- Build a customizable RSS feed aggregator in PHP
- Custom RSS 2.0 Content Feeds using OOP
- PHP Development: Getting Started
- How to Count all elements in an array
- Making A Cool Login System With PHP, MySQL & jQuery
- Screen capture with PHP and GD
- Database driven web counter with PHP/mySQL



