Preserved Topic: guest book

Ok kids- I wasn't sure where to stick this, but I'm sure javascript can aid me with this problemo.

In the "contact us" page, my client wants to set up a standard form asking for name, address, blah, blah,....

Upon submit, he wants to information to get sent to a database, AND send him an email notifying him of another form entry.

I know how to set up the email portion, but the database part? Not quite. I would prefer to figure it out on my own, but need a little nudge in the right direction.

Oh- here is the page http://www.hotfrogdesign.com/new_contactus.htm

muchas gracias!

hey there... I am not sure if javascript is capable of writing to a database... what I think you need is a cgi script to handle it for you... you should be able to find a cgi script that you can customise out on the web

try these links for scripts that can be used
http://www.worldwidemart.com/scripts/
http://www.cgi-resources.com/
http://www.cgi101.com/ (this one is a great learning source)

hope that helps... there might be a way to do this with javascript but I am not an expert

hope this helps

~Vp~

Correct.

The cgi can handle both ends, the email and also the database.

There are never easy ways to do the database bit (for me at least).

I know that you could do it using MySQL, but I wouldn't know how.

I would recommend using PERL to do this.

It would be relitively simple.

Check out "the PERL you need to know"
http://wdvl.com/Authoring/Languages/Perl/PerlfortheWeb/toc.html

That will teach you just what you need to know. I would be a simple print to a .txt file opperation. Which should be relitively simple.

You would just need to append the orrigional document with the information.

Awright! Cool links, I will get going on this as soon as possible and will keep you posted on my progress.

Thanks.

CRO8,

I have been writing perl scripts to access MySQL and Sybase for an ISP for the past several months. If you have any specific questions about how to write those scripts, let me know.

Perl is a good solution and might I offer another option, PHP with a MySQL database. I don't know anything about your server, but if these tools are available to you then there is a wealth of free scripts out there using them.

Here is a good link for PHP: http://www.php.net/

Here is a great resource for all sorts of scripting and database issues: http://www.freshmeat.net/

Thanks everyone.

You'll hear from me soon. . . .