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
- How to Create an Image in PHP
- How to Prevent Email Injection in Your PHP Form to Mail Scripts
- Writing Your First PHP Script: Feedback Form Script
- Creating a Simple PHP Cache Script
- How to write a simple scraper in PHP without Regex
- PHP cURL functions tutorial
- Submitting forms using PHP cURL
- Two way encryption
- How to Add Data in a MySQL table
- PHP Nested Loop Tutorial
- 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
