Page 1 of 1

good book/tutorial

Posted: Tue Sep 14, 2010 9:47 am
by ineedcheese
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

Re: good book/tutorial

Posted: Tue Sep 14, 2010 1:08 pm
by Jonah Bron
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

Re: good book/tutorial

Posted: Wed Sep 15, 2010 5:30 am
by ineedcheese
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

Re: good book/tutorial

Posted: Wed Sep 15, 2010 12:11 pm
by Jonah Bron
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.]

Re: good book/tutorial

Posted: Fri Sep 17, 2010 8:46 am
by ineedcheese
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.