5 Replies Latest reply on Nov 22, 2008 9:55 PM by Newsgroup_User

    Search database fields using single text field

    Level 7
      Kindly advise on how to develop a database search page such that there is
      single text field to enter serach string and the results are shown on the
      same page.
      ALso guide if there is any extension available for achieving the above.


        • 1. Search database fields using single text field
          Level 7
          advise on how to develop a database search page such that there is single
          text field to enter search string and the results are shown on the same
          page.
          Also guide if there is any extension available for achieving the above.


          • 2. Re: Search database fields using single text field
            malcster2 Level 1
            the simplest way of doing it is to have an input box and a submit button in a form,

            when the submit button is pressed, the text in side the input box is posted to a variable.

            the variable is then inserted into a mysql select statement, and the results are then echoed to the screen.

            all of this using php.

            • 3. Re: Search database fields using single text field
              Level 7
              I understand what you say.
              What I am looking for is a wizard or an extension which creates the form, as
              well as writes the SQL string and also generates the results page
              (preferably on the sarch page itself).
              I am looking for a google like solution where the site homepage has one text
              field, and users can search for all the fields of a database to give results
              on the same page.

              Please help.

              "malcster2" <webforumsuser@macromedia.com> wrote in message
              news:gg9g8b$lf9$1@forums.macromedia.com...
              > the simplest way of doing it is to have an input box and a submit button
              > in a
              > form,
              >
              > when the submit button is pressed, the text in side the input box is
              > posted to
              > a variable.
              >
              > the variable is then inserted into a mysql select statement, and the
              > results
              > are then echoed to the screen.
              >
              > all of this using php.
              >
              >
              >
              >


              • 4. Re: Search database fields using single text field
                Level 7

                "S" <uandme72@yahoo.com> wrote in message
                news:gg9h9e$mns$1@forums.macromedia.com...
                >I understand what you say.
                > What I am looking for is a wizard or an extension which creates the form,
                > as well as writes the SQL string and also generates the results page
                > (preferably on the sarch page itself).
                > I am looking for a google like solution where the site homepage has one
                > text field, and users can search for all the fields of a database to give
                > results on the same page.

                then why not just use Google's search tool on the site?


                • 5. Re: Search database fields using single text field
                  Level 7
                  Google search does search only the text portion of the site pages. What we
                  want is searching all the fields of the database which can be done only by
                  search page.



                  "Hunter Elliott" <nospam@gatewaycity.com> wrote in message
                  news:gg9p02$2ig$1@forums.macromedia.com...
                  >
                  > "S" <uandme72@yahoo.com> wrote in message
                  > news:gg9h9e$mns$1@forums.macromedia.com...
                  >>I understand what you say.
                  >> What I am looking for is a wizard or an extension which creates the form,
                  >> as well as writes the SQL string and also generates the results page
                  >> (preferably on the sarch page itself).
                  >> I am looking for a google like solution where the site homepage has one
                  >> text field, and users can search for all the fields of a database to give
                  >> results on the same page.
                  >
                  > then why not just use Google's search tool on the site?
                  >
                  >