homepage Welcome to WebmasterWorld Guest from 54.242.241.20
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Pubcon Platinum Sponsor 2014
Home / Forums Index / Code, Content, and Presentation / PHP Server Side Scripting
Forum Library, Charter, Moderators: coopster & jatar k

PHP Server Side Scripting Forum

    
Search Boxes using MYSQL Database
Helllppppp
url PinPointthings

5+ Year Member



 
Msg#: 4000569 posted 7:58 pm on Oct 3, 2009 (gmt 0)

I have no idea about Mysql and trying to learn is confusing as hell.
I have an affiliate website which I wish to add 2 search boxes that look into a mysql database and display the results in a different page.

Please can some one guide me step by step to create the search boxes which will be Keyword and Location and to pull the info from my database.

Basically Search for a keyword in a database and also in a specific location and display in a new page within my site

 

jd01

WebmasterWorld Senior Member 5+ Year Member



 
Msg#: 4000569 posted 3:18 am on Oct 4, 2009 (gmt 0)

Hi url PinPointthings,

Welcome to WebmasterWorld!

This is probably not the answer you are looking for, especially in response to your first post, but:

Actually, that's a complicated little project you're asking someone to handle for you and the truth is (form my perspective anyway), unless one of us had all the pertinent information right in front of us, the answer is actually, no...

I actually cannot do what you are asking, because I have no idea how your data is structured, how it should be returned, what information needs to be returned as a result for each search, what fields you might need in the database, how the information is stored currently to tell you how to get it into the database, how future information will be entered into the database, and the list of things I don't know to even make it possible to give you an answer just keep going.

I think the best advice I can give you is:
1.) Find a tutorial and work through it.
2.) Hire someone to do it for you.

If budget is the biggest concern #1 is probably the best option, because once you understand the project, can write some of the project and know how to communicate what people here need to know, we can probably help you work through the places where you get stuck.

If it's going to be a 'site attraction' and speed, efficiency and usefulness are the biggest concerns, it's probably best to hire a professional. My first search engine took me a month to write and get to where I was happy with the efficiency and speed of it. When I say a month I mean a full time job of learning, testing, re-testing, restructuring, expanding my knowledge, testing, more testing, and I had a great deal of frustration along the way to accompany my headaches...

Something you might look for is a tutorial for an AJAX based search, rather than MySql, depending on how much information you need to search. I know I found one when I first started using AJAX that uses an XML file rather than a database and creates a drop down menu of links as the person types... It's absolutely cool if you don't have too much information you need to search, but again we're back to specifics I just plain don't have and everything you are asking for and about is 'application specific' to your needs, wants, goals and website.

Sorry I can't be of much more help... If you decide to write it yourself and have something to show us we can work with, I'm fairly sure one of us will give you a hand working through it, but the short version is most of us (AFAIK) post here to educate rather than work for, and for us to really be able to do that you have to have a working knowledge of what you're doing.

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / PHP Server Side Scripting
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved