Welcome to TalkGraphics.com
Results 1 to 7 of 7
  1. #1
    Join Date
    Aug 2009
    Location
    Orlando, Florida
    Posts
    64

    Default Embedded database search form

    Could you recommend a simple software or service which can be used to create a web-based database with a search form? The code would be embedded into a placeholder.

    Example: A Chamber of Commerce website needs a search form to find businesses by name or category.

    I am able to create mySQL databases, but writing raw PHP code for search forms is out of my reach. I'm trying to find the Xara vs. Dreamweaver equivalent solution for databases.

    Thank you for your advice...

    PS: I know this is not directly related to XWD, but just like widgets, it would be a great addition to our tool box.

  2. #2
    Join Date
    Sep 2000
    Location
    London, UK
    Posts
    1,436

    Default Re: Embedded database search form

    Hi

    Have a go with php/mysql! There is plenty of stuff on the net. As long as the businesses are only in one category, you have two tables - business and category, with the key to category (let's say 'categoryid') in the business table.

    You then need a form, where a dropdown is populated from the Category table. The form then passes the data from the name field and the dropdown to a second php script which returns a list to the search results page.

    Each php script using a database has to:
    - connect to the database - giving a username and password
    - create a query like "SELECT * FROM tblbusiness WHERE tblbusiness.categoryid = (the value from the search)"
    - run the query to create the recordset
    - a DO...WHILE loop which runs through the recordset and displays the data in a table or list, or populating the dropdown in the search form

    You will need logic in the searchresults script to look at the incoming field data to see if you have either/or/and so you search only for those requests.

    BTW you will also need admin pages to add, edit and delete the categories and the businesses.

    I tend to use a mix of Dreamweaver, text editor and query tool like FlySpeed) to do this, but only cos DW does a lot of donkeywork - it is not essential. I am not aware of any tools which make this stuff really easy, for less than the cost of Dreamweaver. Alpha Five looks clever but you need the server product which I think only runs on Windows - not Linux/Apache/MySQL/PHP, and together they cost a heap.

    Good luck.
    Simon
    ------------------------------
    www.tlaconsultancy.co.uk
    www.bricksandbrass.co.uk

  3. #3
    Join Date
    Dec 2004
    Location
    Boston, UK
    Posts
    204

    Default Re: Embedded database search form

    Try: http://www.appgini.com It's awesome!
    "Second class fairway is better than first class rough!"

  4. #4
    Join Date
    Jul 2005
    Location
    Ocala, FL, USA
    Posts
    387

    Default Re: Embedded database search form

    Thanks for the link Woody.
    That app looks like a time saver! Might have to give it a try.
    -Samantha
    "Try to live your life so that you wouldn't be afraid to sell the family parrot to the town gossip." Will Rogers (1879 - 1935)

  5. #5
    Join Date
    Aug 2009
    Location
    Orlando, Florida
    Posts
    64

    Default Re: Embedded database search form

    Greetings!

    I found a "free" database service which seems to do the trick. Everything is done online and it can be embedded on a placeholder.

    http://www.infodome.com/

    Here is their demo code for public view:

    <object id="MDBEmbeddedForm" name="MDBEmbeddedForm" data="https://secure.infodome.com/app/MDBEmbeddedForm.swf"align="middle" width="100%" height="100%" type="application/x-shockwave-flash"><param value="https://secure.infodome.com/app/MDBEmbeddedForm.swf" name="movie"/><param value="high" name="quality"/><param value="#869ca7" name="bgcolor"/><param value="guid=da935983ab1b30a5c06a070f78e36c46&tbar= 1&isIE=false" name="flashvars"/><param value="sameDomain" name="allowScriptAccess"/><param value="false" name="SeamlessTabbing"/><param value="transparent" name="wmode"/></object>

  6. #6
    Join Date
    Apr 2005
    Location
    Regional Victoria (Australia)
    Posts
    109

    Default Re: Embedded database search form

    [QUOTE=maxtrac;368692]Could you recommend a simple software or service which can be used to create a web-based database with a search form? The code would be embedded into a placeholder.

    You can also try http://www.codecanyon.net/category/p...e-abstractions
    Last edited by Teedee; 11 July 2010 at 07:18 AM. Reason: missed part of URL

  7. #7

    Default Re: Embedded database search form

    Depending on your needs, you might take a look at this: http://caspio.com

 

 

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •