PHP code/libraries for creating MySQL databases

It now appears that the problem your were asking this newsgroup to solve was
totally unrelated to the subject line.

"PHP code/libraries for creating MySQL databases" is about CREATING
databases, not maintaining the contents of databases.

If you do not ask the right question then how are we supposed to supply the
right answer?

If you want to look at the method I have created for automating this process
then take a look at the following articles:

http://www.tonymarston.co.uk/php-mys...seobjects.html
http://www.tonymarston.co.uk/php-mys...eobjects2.html
http://www.tonymarston.co.uk/php-mys...structure.html
http://www.tonymarston.co.uk/php-mys...plication.html

The last article contains a link where you can run my sample application
online, with another to download the source code to see how it's done.

Hope this helps.

--
Tony Marston

http://www.tonymarston.net



"Jerry Gitomer" <jgitomer@verizon.net> wrote in message
news:sTkId.7849$hC2.6999@trndny04...
> Joshua Beall wrote:
>> "Geoff Berrow" <bl@ckdog.co.uk> wrote in message
>> news:ohl2v01en4uj0nqcuusobanmgcef8lu3l7@4ax.com...
>>
>>>>Do you have another suggestion? I couldn't think of any other way to do
>>>>it,
>>>>since the information collected for each event will be different
>>>>(possibly
>>>>*very* different).
>>>
>>>Ah I see what you mean. So an event is like a conference and you want
>>>to store delegate details. Some events may just want name and address
>>>some may want name address, flight details, nationality and so on?
>>
>>
>> Right, exactly.
>>
>>
>>>I still don't see why you can't use phpMyadmin to create the tables...
>>
>>
>> Well, I *could*, I'm just wondering if there is a way I could automate
>> the process. See, my end goal is to just be able to write up an XML file
>> that describes the conference (name, fields, what fields are required,
>> etc), and then be able to run a script that will generate the form to
>> collect the information and the table where that info will be stored.
>>
>> But I think where I'm landing for now is to just do make the table by
>> hand. Some time down the road I may try and make it more automated.
> I have found that cut and paste is my friend. For me it is faster and
> easier to create model procedures and then modify them to suit individual
> applications/tables. Use your favorite editor to build three php
> programs, one to create a table with a primary key and one to generate a
> form to collect the data to be used in populating the table and one to
> process and store the data.
>
> To handle a new event copy the three progams, edit, execute, test and
> verify the results. You should be able to add a new event in less than
> ten minutes.
>
> HTH
> Jerry