My organization is a print graphic designer and have just started dabbling into web site design. I have successfully taught myself basic html not to mention designing the program. These are two sites i have done to date www. parplussupplies. com plus my personal internet site www. oliverdesigns. com just to offer an idea from the level I am at at the tables.
We’ve a personal project that i am working on and need quite a few advice/help. This site require a search function where visitors can search a database and then narrow down their particular search from YOU to 4 parameters. Example: search by way of state or alphabetical get or size, or two or three variable etc, and so forth.
Is this doable by way of novice and if you have can anyone provide me a basic outline of the way this works concerning how and where must put the records and possible a connection to a code that will access this records. I did a pinch of research on mysql plus php but still hasnt grasp the idea fully yet.
Sorry guys my site is certainly www. olivergraphicdesigns. com
To write a reliable search function you’re looking for a fairly outstanding grounding in PHP. Can’t you make use of google site search Or pay someone with the understand how to drum something up in your case
It is going to be a search through my specifically compiled list and specifics, not a basic search. So google woulgnt be suitable.
On earth do you or anyone give me a thought of what similar to this would expense me for another person to drum ” up ” – thanks
Setting up a search function isn’t all that tricky.
// SQL decide on data from stand.
// PHP trap through data.
If you ever gave me your tables and columns Possible write you a simple search script.
The situation arises on various levels.
1) Validation – May be the user input correct What goes on if it is incorrect Could be the user input malicious
2) Multiple Searches – If your person wants to bring down a site by doing many queries one of the most effective way to accomplish it is by simply searching different terms repeatedly.
If you ever site will often be small something home made, assuming it provides validation, will become OK. If you are making something bigger then you really need to bring in an expert.
When you’ve got a template I see no reasons why you cannot outsource this on the fareast for $100, it’s possible less. A westerner could possibly charge a tad bit more.
Database
LABEL LOCATION BEACH BILLIARDS DESCRIPTION
lodge 1 south yes no Excelent bch view….
lodge 2 north zero yes All inclusice…….
lodge 3 central yes yes Hiden diamond……..
listing of about 1000 hotel in a very small island
some sort of visitor would seek out using about FIVE check or listing box to limit their search
or just use one to secure a broader result.
eg: COAST: north COLLECTION: (Y) BEACH ( ) OTHER ( ) ETC ( )
Then they would get a listing of hotel on the NORTH coast along with POOL
I would be prepared to pay but now I am looking to get the site to be effective up to the basic point myself and bring in another person to bring it approximately a real road ready standard for instance security, SEO and so forth. However if this ladies to be additional work expected give me a price
sorry about the table… let find again
HOTELNAME – LOCATION – BEACH – POOL – DESCRIPTION
lodge 1 ———–south ——-yes ——no —- Excelent bch view….
lodge 2 ———–north ——–no —–yes —-All inclusice…….
lodge 3 ———-central ——-yes —–yes —-Hiden diamond……..
lodge 4
lodge 5
ok the following is an example http: //www. villasinjamaica. com/
Hello patto, you’re in close proximity to us (Transio) — we’re in Downtown Miami. In answer to your original question – it is a good project that you can learn, if that’s exactly what you’re looking related to it. If you happen to be looking tos sour a biz, you ought to look at it from the management perspective and also have a professional devleoper exercise.
Thanks for the advice Steve. I do include high expectation due to this site but for now I can keep it on the personal level seeing that I cannot afford to engage a professional. And I also need to use it as an opportunity to learn and develop myself at the same time.
Ok, well then, a proper design can be several tables:
MAKE TABLE location ( id INT NOT NULL AUTO_INCREMENT MAJOR KEY, name VARCHAR(255) NOT REALLY NULL ) TYPE-InnoDB; STICK IN INTO location (id, name) BELIEFS (1, 'North'); STICK IN INTO location (id, name) BELIEFS (2, 'South'); STICK IN INTO location (id, name) BELIEFS (3, 'Jamaica'); MAKE TABLE amentiy ( id INT NOT NULL AUTO_INCREMENT MAJOR KEY, name VARCHAR(255) NOT REALLY NULL ) TYPE-InnoDB; STICK IN INTO amenity (id, name) BELIEFS (1, 'Pool'); STICK IN INTO amenity (id, name) BELIEFS (2, 'Spa'); MAKE TABLE hotel ( id INT NOT NULL AUTO_INCREMENT MAJOR KEY, location_id INT NOT REALLY NULL REFERENCES location(id), label VARCHAR(255) NOT NULL, explanation TEXT NULL ) TYPE-InnoDB; STICK IN INTO hotel (id, location_id, label, description) VALUES (1, 1, 'Hotel 1', 'This is usually a beautiful hotel. '); MAKE TABLE hotel_amenity ( hotel_id INT NOT REALLY NULL REFERENCES hotel(id), amenity_id INT NOT REALLY NULL REFERENCES amenity(id), MOST IMPORTANT KEY (hotel_id, amenity_id) ) TYPE-InnoDB; STICK IN INTO hotel_amenity (hotel_id, amenity_id) BELIEFS (1, 1); STICK IN INTO hotel_amenity (hotel_id, amenity_id) BELIEFS (1, 2);
Your search it is fair to join the tables to search for the appropriate matches.