Hi all, dont have time to scour the site as i'm currently in work, and maybe someone has the answer to hand?
I've done some php coding before, and studied a couple of books on the rudiments of php, including following the coding tutes, such as buiilding admin pages for log in/out etc. but i want to go further now.
can anyone recommend a decent book or quality tutorial which will teach me how to put together the php/database side fo a website with good search parameters - think an estate agents with the various drop downs to narrow a search such as area, price range, property type, number or bedrooms etc. it doesnt have to be specific, but just that type of tutorial.
thanks
good book/tutorial
Moderator: General Moderators
- Jonah Bron
- DevNet Master
- Posts: 2764
- Joined: Thu Mar 15, 2007 6:28 pm
- Location: Redding, California
Re: good book/tutorial
Sounds like you just want a generic tutorial on forms and databases.
http://w3schools.com/php/php_forms.asp
http://w3schools.com/php/php_mysql_intro.asp
http://w3schools.com/php/php_forms.asp
http://w3schools.com/php/php_mysql_intro.asp
-
ineedcheese
- Forum Newbie
- Posts: 3
- Joined: Tue Sep 14, 2010 9:36 am
Re: good book/tutorial
hmm, thanks but need something a bit more non-generic. i've been through these before, but i'm just not getting my head around the use of differing tables 'pooled' as it were, to product a set of narrowed down results.
cheers anyway
cheers anyway
- Jonah Bron
- DevNet Master
- Posts: 2764
- Joined: Thu Mar 15, 2007 6:28 pm
- Location: Redding, California
Re: good book/tutorial
You have a table for all products, and columns for each attribute. To narrow down a search, just use the WHERE SQL clause. You can combine requirements like this:
Code: Select all
WHERE size = 'big' AND price < 345.23 AND [etc.]-
ineedcheese
- Forum Newbie
- Posts: 3
- Joined: Tue Sep 14, 2010 9:36 am
Re: good book/tutorial
hmmm,ok, if no-one has anything along the lines of a tute, thanks jonah. still would prefer something infront of me to learn it.