Unable to run the class

Hi I have tried to use this class on my local m/c but I have no success in extracting the tables and columns in class format as you suggest.

I am doing the following

define('FILENAME','Tables.php'); // Insert Here File Name
define('SERVERNAME','localhost'); // insert here host name
define('USERNAME','root'); // Insert here the username
define('PASS','root'); // Insert here user password
define ('SCHEMA',''); // Insert Here The Schema That You would like to generate table info to
define('NEWLINE',"\r\n");

Please could you explain me what do I define in the schema? Also my db name is mysql_select_db('testdb');

Do I need to create an empty file Tables.php or is it generated automatically? Appreciate your suggestions

hi,

A database is a collection of schemas, each schema has a collection of tables and some other stuff...

the db name is the same as the schema name, in your case 'testdb'

the file will be generated automatically in the class folder.

my class wanna know what is the name of the db you want to work with,
this is why u need to specify the schema\dbname.

*don't forget to create an instance of this class so it will generate the Tabes.php file.

*every database contains a schema(db name) that called 'information schema' this db contains description of all other schemas that u created.