Sr. Web Developer
mediabistro.com
US-NY-New York

Justtechjobs.com Post A Job | Post A Resume

Comments for: alex20010129

Message # 1009181:
Date: 01/18/02 22:57
By: Matthew Black Profile
Subject: RE: Automatic Database Creation

It is possible, what you would have to do is simply create a query based on the input from the user.

like $query = "CREATE TABLE $table blah blah";

ofcourse I didnt go through the whole statement of the query but that gives you the idea :)

Now lets say you want a user to look at Models and go from there, and assuming models are the dynamic tables in the database.

Now here is a link to a mysql function that'll help you with the rest of the process.

http://www.php.net/manual/en/function.mysql-list-tables.php

following that, and the above should allow you to get the results you want.

Lastly, as far as I know, you cant create the database and enter in values unless they are like default values. You would have to send two queries, one to create the table then enter in the information.

Previous Message | Next Message


Comments:
Text files conversionkaruna07/29/05 06:24
connection à BD oracle8iahmed12/17/04 10:06
Licensing (RE: Duplicate project)James01/02/04 15:30
Nice idea, wouldn't use it commercially tho..Icerunner09/18/02 16:49
"make depend" problemOzgur07/17/02 06:20
about php nafiseh shabib04/02/02 04:39
Binary to text convertionabhay03/26/02 09:27
RE: Automatic Database CreationMatthew Black01/18/02 22:57
RE: phpShop ripoff?Alex Black03/31/01 18:07
Error at the beginnig..Tony03/20/01 07:25
RE: databaseAlex Black03/09/01 03:33
Automatic Database Creationcarlos urbieta03/07/01 21:35
databasecarlos urbieta03/07/01 21:25
RE: Instalation problemMarcel03/01/01 09:09
install problempavlos02/27/01 22:39
RE: Support for IIS John02/26/01 15:36
phpShop ripoff?Brian Quentin 02/23/01 08:37
RE: Support for IIS R.Talis02/20/01 11:11
install.php stuckChuck02/20/01 05:55
Licensing (RE: Duplicate project)Alex Black02/17/01 18:57
Licensing (RE: Duplicate project)Cameron S Watters02/15/01 12:17
RE: ugh.. still why?Alex Black02/14/01 14:35
RE: Why BinaryCloud versus PHPLib?Alex Black02/14/01 14:34
RE: Worked, but didn't work...Angel Hernandez02/13/01 16:55
RE: Support for IIS David Stubbs02/12/01 14:51
ugh.. still why?soellman02/08/01 20:37
Why BinaryCloud versus PHPLib?David Phillips02/08/01 09:08
Grumpin' before testin'Jared Smith02/08/01 07:03
RE: Too soonAlex Black02/05/01 16:48
RE: Workaround for auto_prependAlex Black02/05/01 16:44
RE: Coder vs. marketingAlex Black02/05/01 16:39
Coder vs. marketingJan Lehnardt02/03/01 04:06
RE: Worked, but didn't work...Alex Black02/02/01 21:09
RE: Too soonStephen VanDyke02/02/01 16:10
Workaround for auto_prependled_belly02/02/01 14:11
RE: Sounds Great... uhhhRick02/02/01 13:27
Worked, but didn't work...Angel Hernandez02/02/01 01:25
RE: Sounds Great... uhhhAlex Black02/01/01 13:44
RE: Show me it works, Please.Alex Black02/01/01 13:40
RE: separating markup and codeAlex Black02/01/01 13:38
RE: Too soonAlex Black02/01/01 13:36
RE: separating markup and codeDavid Fischer02/01/01 11:58
separating markup and codebrian01/31/01 15:46
RE: Sounds Great... uhhhDerek Piper01/31/01 14:09
Show me it works, Please.Ocedeco01/31/01 12:52
Too soonBrian Quentin 01/31/01 11:01
RE: Instalation problemAlex Black01/30/01 20:13
RE: FreeBSD+php+OracleAlex Black01/30/01 20:11
RE: Sounds Great... uhhhAlex Black01/30/01 20:08
RE: Duplicate projectAlex Black01/30/01 20:07
RE: Support for IIS Alex Black01/30/01 20:04
RE: Instalation problemAlex Black01/30/01 20:03
RE: Any samples? Showing too early?Alex Black01/30/01 20:02
RE: Instalation problemSam Barnum01/30/01 16:58
FreeBSD+php+OracleSteffen01/30/01 16:20
RE: Duplicate projectmadbilly01/30/01 14:43
RE: Instalation problemIgnacio Galmarino01/30/01 11:35
Sounds Great... uhhhOcedeco01/30/01 09:24
Duplicate projectSeek3r01/29/01 19:01
Support for IIS Ciaran01/29/01 16:18
Instalation problemIgnacio Galmarino01/29/01 15:14
Any samples? Showing too early?Brian Quentin01/29/01 13:32
 

If you are looking for help, please post on the appropriate forum here. Your questions will be answered much more quickly.

Add A Comment:

Name:

Email:

Subject:

Message:

To reduce spam posts, messages are now manually approved

You are not [logged in]. That means your account will not get credit for this post.