create table in mysql from php forms

Kid · 10-19-2009, 12:04 PM

hi to all.. i wanna know if this is possible. Can we create a table in mysql database with a name based on user's input from a form? for example in a form a user must enter their names and password, lets say the name is Timo and pass 1234. Then when Timo click the submit button, automatically Timo's table are created in the db with Timo's name. So now there's a table named Timo in db. Of course Timo's name and password are saved in other table in the same db. If it's possible, can you guys share some examples.

Thnx for viewing and x1000000000 thnx if you reply.

jthayne · 10-20-2009, 05:36 PM

Yes you can do it. It is a simple SQL query to do it:

CREATE TABLE "Timo"

This should be a simple thing if you know how to run SELECT or INSERT queries using PHP.

Kid · 10-21-2009, 04:17 AM

Thank you very much. I'm new to php, js and html. Still need to learn a lot. Thnx again.

10-19-2009, 12:04 PM	#1
Kid New Member Join Date: Oct 2009 Webmaster Discussions: 4 Rep Power: 6	create table in mysql from php forms hi to all.. i wanna know if this is possible. Can we create a table in mysql database with a name based on user's input from a form? for example in a form a user must enter their names and password, lets say the name is Timo and pass 1234. Then when Timo click the submit button, automatically Timo's table are created in the db with Timo's name. So now there's a table named Timo in db. Of course Timo's name and password are saved in other table in the same db. If it's possible, can you guys share some examples. Thnx for viewing and x1000000000 thnx if you reply.

10-20-2009, 05:36 PM	#2
jthayne Join Date: Aug 2008 Location: Texas Webmaster Discussions: 501 Rep Power: 21	Re: create table in mysql from php forms Yes you can do it. It is a simple SQL query to do it: CREATE TABLE "Timo" This should be a simple thing if you know how to run SELECT or INSERT queries using PHP. __________________ Be sure to click the reputation icon to give rep to the person who helped you. For web design/development services, check Silentium Designs.

10-21-2009, 04:17 AM	#3
Kid New Member Join Date: Oct 2009 Webmaster Discussions: 4 Rep Power: 6	Re: create table in mysql from php forms Thank you very much. I'm new to php, js and html. Still need to learn a lot. Thnx again.

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Webmaster Discussions
Thread	Webmaster Discussion Starter	Forum	Replies	Last Post
To create table in photoshop	kajun	CSS Forum	3	06-22-2009 01:25 AM
Inserting Multiple value of '<input>' to a table in PHP/MySQL	JPhilS	PHP Forum	0	01-29-2008 01:09 AM
create a table along the width of the sheet	laks	General Discussion	1	02-15-2004 01:24 PM
This is about a create database table?	knightjt02	PHP Forum	1	08-07-2003 04:42 PM