Help setting up MySQL database
By android
@android (894)
April 6, 2009 9:14pm CST
My website runs on a server that has MySQL and PHPMyAdmin and I need to set up a database to collect data. I have the HTML code for the form and the PHP script to send the data to MySQL, I just need to change the appropriate values (user, password, etc).
The part I'm having difficulty with is actually setting up the database. I go into MySQL and I'm asked how many fields and tables I want, whether I want null setting for each field, etc and it's basically just confusing the hell out of me! All I want to collect is three fields of data from each user. I thought it would be much simpler than this. Can anyone give me any advice?
2 responses
@felelis (96)
• Thailand
7 Jun 09
Well, what is the main thing that your system will do? Maybe I could help you if I know that.
But I suggest you that before doing anything with your Database, write down the outline of your system in papers. Include the database out line. Decide what will be the name of your Database, the amount and name of your table, fields in each table.
Hope that I am not too late.
@android (894)
•
13 Jun 09
Thanks for that. This looks like it's going to be quite time consuming. I have come up with a temporary short term solution, but this needs to be done in the long run, so I'm definitely still interested in learning about it. Basically I need an automated commenting and rating system that can record the results in the database and then display them on the site in real-time.
@cahyorini (315)
• Indonesia
20 Apr 09
Are you running on a project or something ? can i join ? ehhehehe
if your website already go online you can check it at yourdomain/phpmyadmin
or if you site still on your local server used localhost/phpmyadmin, from this you can chose the database and then the table you want to edit the content. Hope this help
