mrsgoofy98 Posted August 6, 2004 Posted August 6, 2004 Well, I am completely ignorant as to how to setup a database for my website. Can someone please please help? I don't even know where to begin. I have a website that I want to get people to sign up with their email address. I also want them to fill out a form and then have it notify me that someone signed up. I don't know if I am asking too much, but if someone could help me I would be eternally greatful!!!! Thanks, Donna Quote
DarqFlare Posted August 6, 2004 Posted August 6, 2004 Moving to a better forum for better exposure... Quote
LisaJill Posted August 6, 2004 Posted August 6, 2004 Do you already have a script that does that and you just need to create the database? Or are you actually trying to build this from the ground up? Hopefully the former, since by your own acknowledgement this is new to you. =) If the former go to cpanel, in the lower right column click "mysql databases" - Create a database and then create a user. After you have done both you'll see two drop downs to choose the database and user - choose them then click "add user to database". After that the database details will be: Username: cpanelname_usernamename Password: password you chose when creating user Database server: localhost Databasename: cpanelname_dbname Hope that helps. =) Quote
mrsgoofy98 Posted August 8, 2004 Author Posted August 8, 2004 I figured out how to setup the database, but I'll be darned if I know what to do next. I know that I somehow have to determine what information/fields are in the database, but I don't know how to put the database together. Maybe this is too much for me. I actually want to put together a database that collects the names and email addresses for potential customers. I don't even know where to begin. I called my database "clients", but I don't know where to put the fields in. Is this stuff as hard as it seems? Thanks, Donna Quote
LisaJill Posted August 8, 2004 Posted August 8, 2004 Donna, mysql programming is a huge step and it would be impossible to teach it to you in a short post here - you would need a script (probably php) that would take the information in a form and write it to the database - and then some way to extract and read that information. Then, possibly a way to utilize that if you wanted to use it as a mailing list. I would suggest that you peruse hotscripts.com for some way of doing this - they have thousands of scripts and installation instructions/demos for most of them. I think going from not knowing how to set up a databaes at all to outright building one from scratch may be a bit of a big jump. Perhaps at least looking at the coding behind already existing scripts could give you a huge head start. At least, that's how I tend to try to learn this stuff. =) Quote
TCH-Rob Posted August 8, 2004 Posted August 8, 2004 Donna, Hotscripts.com, I will second that. Many free scripts to look over and see if it will do what you are looking for. It is not in the scope of these forums to be able to teach everything one would need to know to build it from scratch. Oh, and welcome to the family. Quote
TCH-Bruce Posted August 8, 2004 Posted August 8, 2004 Welcome to the family, Donna. Gllad to have you here. Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.