Forum Moderators: mack

Message Too Old, No Replies

Needing help with a database

Making a registration database

         

traylor1

2:38 pm on Apr 3, 2005 (gmt 0)

10+ Year Member



Hi. I am needing to make a registration page for an upcoming conference. I have experience making forms, but never connecting it to a server, because I have never had access to one.

The thing is, I am doing this for an Instructor of mine and I do not have access to uploading or anything at the university. So far, I have only made her basic pages.

So, the main question is this, can I make a registration form for her that would connect even though I do not have access to the server? If so, is there anywhere that would have a good clear explanation of how to get the form to connect to the server?

Thanks

Randy

Matt Probert

4:47 pm on Apr 3, 2005 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



In short:

FORM METHOD=post ACTION="http://www.myserver.com/deal_with_my_form_data.pl"

You don't have to use Perl to handle the data, but basically the form submits the data to a CGI program at the server, that program receives the data and deals with it.

The HTML page with the form can be on any remote PC, so long as that computer has a network connection to the server (eg: an Internet connection)

Matt

wheel

8:50 pm on Apr 3, 2005 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



Your post isn't quite clear....you don't have access to the server, but somehow you are already uploading the html forms? So it seems like you should be able to upload a form script the same way.(in terms of the upload, a form/program looks pretty much like an html page)

Anyway, to do what you're thinking, you're going to have to create a program that accepts input (as in the post above), process it into a database, then respond with a 'thank you' page. Plus clean the data, etc. etc.

I suggest you forget the database idea. Instead, just have the form sent to you by email. You can do this with a 'form to email' program. The difference is, these form to email programs are a dime a dozen all over the internet. Find one and get it installed on your website.

When someone completes the form, you'll get an email. Cut and paste the information into Excel, and away you go.

I think that way will be much easier than getting up to speed on how to create and upload a program to manage a form and a database. (your way is more flexible, but a much steeper learning curve).

traylor1

2:07 am on Apr 4, 2005 (gmt 0)

10+ Year Member



>>>Your post isn't quite clear....you don't have access to the server, but somehow you are already uploading the html forms?

I suggest you forget the database idea. Instead, just have the form sent to you by email. You can do this with a 'form to email' program. The difference is, these form to email programs are a dime a dozen all over the internet. Find one and get it installed on your website.<<<

I am making pages for her, shipping them to her and she is uploading them to the server. Does that make more sense?

I have done the e-mail route before.This would be my preferred method. However, this is for a class and the teacher would like for it to be submitted to a database, so I don't have any choice.

wheel

2:12 pm on Apr 4, 2005 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



Then the upload method for a program that handles the form information is the same as the upload method for an html page.

You've got a whole host of things to find out, what database is available, your database login informatin, what programming languages are available to you. Plus you'll have to develop the script/program to read the data from the from (which will be passed to the form using the method described above) and do all that database connection stuff.

Plus, once it's in the database you've got to write a program to retrieve the data in some format too probably.

I'm not sure if anything like this is available for free download - I would typically design this in as part of a larger system.

This isn't a very tough job, but it's not an immediate thing either if you are a newb. If you're class is programming, you've got some homework to do. If it's not a programming/web class, it may be more than you want to tackle.

traylor1

7:52 pm on Apr 4, 2005 (gmt 0)

10+ Year Member



I wrote my instructor asking her the type of server that this is being uploaded to, she responded with "Unix OS running an Apache web server is what we use for our web pages." But there needs to be a databse also on here doesn't there?

I am afraid that this is too big of an undertaking for everything she is wanting and my experience.

Randy

wheel

12:15 am on Apr 5, 2005 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



Yes there does. Chances are good that you have access to mysql (a database) and php (a scripting language). So the first thing you need to do is find out from the hosting company - no way but to ask - what the name of your database is as well as userid and password.

I think you're right, this is likely a bit much for you. Stick to the form to email thing.

Someone mentioned in a thread in the site supporters area I think something about a program that scraped info from emails and dumped it into excel.