MySQL/PHP queries

[j05hr]

Does anyone know of any books that would explain how to do a query search from something like an estate agent? (I think in America you call it Real Estate though)

 

As in search for a property for example between £300,000 - £500,000 only detached houses with more than 5 bedrooms.

 

I don't want any open source CMS's as it's something I want to learn rather than just implement.

 

The problem is, I'm not sure what the term is of what I'm trying to do so can't search for it. It doesn't have to just be books any online examples would be really helpful too.

 

Here is an example of a site I've built with what I'm talking about.

 

http://www.sampleestateagent.com/buying.php

 

I did get a coder to write a page that will do it but now I want to learn how it's done

 

Thanks for any help.

 

Josh

[sunfighter]

Josh,

Why pay for something that's free? Many, many sites on the internet explaining what is needed. You first need to know what database your using. Lets say its MySQL. http://www.w3schools.com/sql/default.asp will give you a good start on learning. Another is http://www.tizag.com/ and lets not forget this site for answers.

 

I don't know where your site is but check and see if it has cPanel and/or phpMyAdmin available. Easy way to work with a DB without learning a programming language. It is also possible to install a DB on your personal computer and work with it there. Check out http://www.wampserver.com/en/

[j05hr]

Josh,

Why pay for something that's free? Many, many sites on the internet explaining what is needed. You first need to know what database your using. Lets say its MySQL. http://www.w3schools.com/sql/default.asp will give you a good start on learning. Another is http://www.tizag.com/ and lets not forget this site for answers.

 

I don't know where your site is but check and see if it has cPanel and/or phpMyAdmin available. Easy way to work with a DB without learning a programming language. It is also possible to install a DB on your personal computer and work with it there. Check out http://www.wampserver.com/en/

 

Hey thanks for the reply, I know basic PHP and MySQL and I had just built my own CMS for this and was really excited with it that I just wanted to get it up and running. 

 

Now comes the time where I want to learn how to do the queries but the problem  is that I'm not sure of the term used for what I'm after or a book with a long section that explains in detail would be handy too.

[j05hr]

Hopeful bump for a few more replies

[Muddy_Funster]

Bumping is against the rules....  What are you looking to learn? PHP or SQL?  Books are a good resource (even if you do have to spend all of about £30 for a good one) but often, if you have the time and determination you will be able to colate information from the inter net that you can then print off and create your own refference volume.

[j05hr]

Sorry about the bump I didn't know that as it had been a few days and didn't get a reply.  I am looking to learn how to make a search function with drops downs for arguments sake.  If a property is between $200,000 - $300,000 with only 4 bedrooms coming up as the result.

 

So like this http://www.sampleestateagent.com/buying.php

 

I would like a book however I'm not sure what book covers this.  Is there a term for what I'm trying to do?

[Muddy_Funster]

Well the drop down and the page layout is done with HTML and CSS.

The actual querie is done through PHP and SQL.

 

So you're looking fore a little of everything.  I can't recomend any books for the PHP / SQL as I have used online manuals for both for years now.  I will look out what books I have on CSS and HTML and let you know what they are, they are pretty good - just can't remember what they are called  :-\

 

I'll get back to you.

[j05hr]

Ahh no, I'm ok with HTML and CSS, that is my site that I built as a project to learn PHP. I built a custom built CMS for the site as a learning project.  I was really excited with it when it was all done that  I paid a developer to build the search part of it as it was a little too advanced for me and now I want to learn how it's done.

 

Is there a name for what I'm trying to do so I can search for it on Google?

 

Thanks for your help so far.

[ccmcs]

The best way to do it in all honesty is use the scripting that you paid for, have a look through it and see if you can follow each bit, I've hardly done any PHP but managed to get a working login system etc uploaded from bits off the internet and then reading the php manual on-line that describes each function/command/variable etc... Load it up you must have all the scripts and sections if you are hosting the site?

[Muddy_Funster]

OK, well all I can suggest for books on PHP/MySQL is "PHP and MySQL For Dummies 2nd EDT"  (although I would guess it's on the 4th or 5th EDT by now) It walks you through the basics of setting up php and mysql functionality.  I would only use it as a starting point though, it is just the basics.  Further than that, have a look at some of the guides here at phpFreaks, there are is a lot of good content published by a lot of very skilled people.  and the php online manual(as has been suggested already) is the best reference you'll come across, although confusing as hell if you don't know what your looking for and have no experience with the language.