Printable View
I really want to learn MySQL but I don't know anything about it. I need to know what is the best book for learning to use MySQL with PHP.
The MySQL query language (I think that's what it's called) is very confusing and since I have not references at all, it's a bit difficult for me to work with.
I'm aware of two:
http://www.amazon.com/exec/obidos/tg...=UTF8&v=glance
http://www.amazon.com/exec/obidos/tg...17743?v=glance
It comes easy to you once you start on it. It's almost like working in ASP.
www.php.net and www.mysql.com will be two online references that you will be referencing all the time, so you can look up whatever you need for MySQL there. Althought, as far as I know, MySQL is similar to the basic SQL we learned when we were crawling around in diapers last week.
You know C++ don't you? Well PHP is very similar in syntax and very easy to learn.
SQL (Structured Query Language) is the application level protocol used to manage information stored in database. The idea behind SQL is to allow for a uniform application interface to any relation database management system regardless of the underlaying filesystem, storage methods and vendor. SQL is defined as both an ISO and ANSI standard, so in theory an SQL statment written to the SQL92 standard can be used in any database supporting that language. If you are used to the likes of Access its time ot forget what you know, SQL is very easy to learn and you'll pick it up easily as you start to develop web applications in PHP.
I would recommend buying a book on PHP which will have extensive coverage of SQL and also give you an introduction to the language, go for PHP 5 becuase this is going to superceed PHP 4. It may also be a good idea to buy a MySql reference guide, especially if you don't get on too well with the online manuals (which incidently is excelent).
Here are a few books you may want to take a look at:
http://www.amazon.co.uk/exec/obidos/...845093-7572419
http://www.amazon.co.uk/exec/obidos/...845093-7572419
http://www.amazon.co.uk/exec/obidos/...845093-7572419
It is also worth downloading Apache, PHP and MySql installing them on your local PC as a test envrionment. All are stable on both Windows and UNIX platforms.
Beaten to it by the ugly frog. How is it you read my mind?Quote:
Originally Posted by mendhak
Because I'm your parent object. :afrog:
OK, add a note here:
You can also run PHP on IIS, which is very convenient, because then you can have HTML, PHP, ASP and ASP.NET pages all in one without having to maintain two webservers.
I mainly use tutorials on the internet when I want't to learn something.
This is where I learned the basics of PHP and mySQL: www.phpfreaks.com Some of their tutorials are a bit dated and don't use $_GET[], $_POST[] and the like, but they are still good.
For basic SQL stuff I usually go here: http://www.w3schools.com/sql/
And as ppl before me have said, the online PHP manual is exelent! It's pretty much the only reference you need. They also have a good "Get started" tutorial.
I personally perfer using the .CHM files you can download from php.net ;)
As for MySQL you can download files from their site as well :yes:
But then you miss out on all the good comments! That's where you'll find the really powerful functions! (PHP that is)