Discussion Locked

Searching SQL DB thru web forms

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hello,
I am studnet and I'm looking to expand my knowledge on SQL some.

What I'm looking to do is just add a simple search box (say search for customer) to my website and have that search thru my customer table in my SQL DB.

I'd also like to look into adding data thru web forms such as adding a customer to the Customer table.

I am familiar with making tables and select quereies and so forht in SQL. And I am also familiar with making forms on the web.

Anyhelp would be appreaciated, websites with walkthrus would help also.

Thanks in advance,
Brian Wright
http://www.wright-onthe-web.com

3 replies

by raffi_

With some knowledge of both SQL and HTML forms the only thing you are missing is how to connect the two!

You will have a few decisions to make such as what scripting language to use ASP & VB or ColdFusion or . . .? A lot will depend on what type of server your site is on. Chances are if it is on a Linux or Unix box then you will not be able to use ASP. You will probably have a CGI or PHP option.

One of the best site for this sort of thing is 4guysfromrolla.com:

http://www.4guysfromrolla.com/webtech/111698-1.shtml

About DB Connections
http://www.asp101.com/articles/john/connstring/default.asp

This stuff is the most fun you can have with a computer!! (IMHO of course)

Regards
Raffi_

by lump_16

Teh sites didn't help me as I am going to be using PHP and MySQL on a linux box for the moment. I'll make a new post.

This discussion is closed to new replies.