Page 1 of 1

Create Dynamic table

Posted: Wed Mar 12, 2008 12:00 am
by yooreen
Hello there.
i'm urm, having trouble here. i need to create a code which will allow user to create table in database and then the user can insert data into that table.

example:

a user will create material table. e.g : Electrical. and in this so-called electrical table, there will be a few fields such as id, types, etc.

then, the user can view a page that will display all items in this electrical table.
pls somebody tell me how to do this :(

Re: Create Dynamic table

Posted: Wed Mar 12, 2008 11:23 am
by andym01480
http://www.tizag.com/mysqlTutorial/ is a good tutorial on php and mysql.

You'll need user privileges in mysql to create tables from a script - sounds pretty dangerous to me on a live site without user authentication!

Come back and post some code and ask a question if you are having trouble

Re: Create Dynamic table

Posted: Wed Mar 12, 2008 11:23 am
by RobertGonzalez
Can this be done differently? Users creating tables leads to a maintenance nightmare down the road.

Re: Create Dynamic table

Posted: Wed Mar 12, 2008 11:24 am
by Zoxive
You could just use phpmyadmin which already does all of which you want and more.

I would not recommend using this for clients though, unless they have computer smarts. :lol: