General discussion

  • Creator
    Topic
  • #2107285

    Searching SQL DB thru web forms

    Locked

    by lump_16 ·

    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

All Comments

  • Author
    Replies
    • #3679775

      Searching SQL DB thru web forms

      by raffi_ ·

      In reply to Searching SQL DB thru web forms

      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_

      • #3819168

        Searching SQL DB thru web forms

        by lump_16 ·

        In reply to Searching SQL DB thru web forms

        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.

    • #3819167

      Searching SQL DB thru web forms

      by lump_16 ·

      In reply to Searching SQL DB thru web forms

      This question was closed by the author

Viewing 1 reply thread