Learning PHP, MySQL & JavaScript: With jQuery, CSS & HTML5 (Learning Php, Mysql, Javascript, Css & Html5)

Learning PHP, MySQL & JavaScript: With jQuery, CSS & HTML5 (Learning Php, Mysql, Javascript, Css & Html5)
By Robin Nixon

List Price: $49.99
Price: $30.59 Details

Availability: Usually ships in 24 hours
Ships from and sold by Amazon.com

75 new or used available from $15.75

Average customer review:
(78 customer reviews)

Product Description

The fully revised, updated and extended 4th edition of the hugely popular web development book - includes CSS, HTML5, jQuery and the mysqli extension.

Build interactive, data-driven websites with the potent combination of open-source technologies and web standards, even if you only have basic HTML knowledge. With this popular hands-on guide, you'll tackle dynamic web programming with the help of today's core technologies: PHP, MySQL, JavaScript, jQuery, CSS, and HTML5.
Explore each technology separately, learn how to use them together, and pick up valuable web programming practices along the way. At the end of the book, you'll put everything together to build a fully functional social networking site, using XAMPP or any development stack of your choice.
  • Learn PHP in-depth, along with the basics of object-oriented programming
  • Explore MySQL, from database structure to complex queries
  • Use the mysqli Extension, PHP's improved MySQL interface
  • Create dynamic PHP web pages that tailor themselves to the user
  • Manage cookies and sessions, and maintain a high level of security
  • Master the JavaScript language--and enhance it with jQuery
  • Use Ajax calls for background browser/server communication
  • Acquire CSS2 & CSS3 skills for professionally styling your web pages
  • Implement all the new HTML5 features, including geolocation, audio, video, and the canvas

Product Details

  • Amazon Sales Rank: #11564 in Books
  • Brand: O Reilly Media
  • Published on: 2014-12-14
  • Original language: English
  • Number of items: 1
  • Dimensions: 9.17" h x 1.61" w x 7.01" l, 2.85 pounds
  • Binding: Paperback
  • 812 pages


  • O Reilly Media

Editorial Reviews

Amazon reviews from the 3rd edition

  • "The web programming equivalent of a well-stocked toolbox... it packs a lot of utility into a compact space"
  • "I literally devoured it over the course of the rest of the day"
  • "The book is very clearly written and easy to understand. I would definitely recommend it for beginners"
  • "A must have book for those who begin sailing in the Web development waters"
  • "A very in-depth introduction for webmasters"
  • "It has everything I needed to get up to speed very quickly"
  • "The book did a great job of filling the holes in my knowledge"

  • "Launched My Career This book taught me everything I needed to know to land a decent job as a PHP developer - best thirty dollar investment of my life" - Amazon reviewer

From the Author
In the first edition of this book I took you from first steps, without assuming any prior knowledge other than basic HTML (and maybe some CSS), through the use of PHP, MySQL and JavaScript, and along the way pointed out the shortcuts and pitfalls I have discovered, to give you the head start I didn't have. Thankfully the book was extremely well received, and various editions have remained at the top of the web development book charts for over five years. In fact there have been three full editions and some edition updates, as I ensure the book is kept fully up-to-date, and add information on the latest and most current web development technologies.

In the previous two editions I added coverage of CSS, and then HTML5, and now this fourth edition comes with a comprehensive jQuery primer, so you can take your JavaScript programming to the next level. I have also removed all coverage of the outdated mysql extension, and replaced it with the newer and more efficient mysqli. I also updated all the errata and added many reader suggestions. But with so many technologies now in the book, I decided not to keep adding to its title. Instead I've reverted to the original title of Learning PHP, MySQL & JavaScript, and the extra technologies are now mentioned in the subtitle:With jQuery, CSS & HTML5.

So I hope you'll find the book even more of a one-stop resource than ever, and that you also find it easy to read and understand (and enjoyable too). And, as always, I welcome any comments or questions you may have via the book's website at lpmj.net, and always do my best to provide assistance if you need it.

From the Back Cover
"This is a great beginner's book that introduces several crucial web developer languages. It's a quick-paced, easy-to-read, information-packed book that will soon have you creating dynamically driven web sites, including a basic social networking site." - Albert Wiersch, developer of CSE HTML Validator

Customer Reviews

Most helpful customer reviews

48 of 50 people found the following review helpful.
4Great Book, but PHP/MYSQL is now outdated. Best to look elsewhere.
By zak frisch
I updated my review from 5 stars to 4.

The author, it seems, has avoided changing the code within the examples offered. Though I'm sure this book was pretty close to spot on when it came out, over the duration of the last year and a half, there are differences that haven't been addressed and therefore I would wholly suggest passing on this book to a more updated learning experience.

Don't get me wrong, it's a great book. JavaScript, JQuery, CSS, and HTML5 are quite excellent and still worth the read if that's what you're looking for. However, MySQL and PHP have changed DRASTICALLY and if you learn from this book only you will need to supplement all of the knowledge gained and it will probably only lead to confusion.

A few examples:

*Salt and Hash: This book dedicates time to salting and hashing using ripemd. Most recently salting and hashing has been automated by the overlords of PHP into a singular function: password_hash(STRING, PRESET_ALGORITHM). There are currently, as far as I know, only two different algorithms to choose from: PASSWORD_BCRYPT or PASSWORD_DEFAULT. This was done because salting and hashing were produced incorrectly on so many sites that PHP's caretakers decided that it would be in everyone's best interest to simplify the process. Keep in mind that the password_hash function will automagically salt the hash so there is no step to do so. To verify the password from hash you would use the password_verify(STRING, HASHED_STRING) and it will return a Boolean.

*Sanitiation of User Input: Though important to realize when you're putting user input directly into the page, this book has an absolutely tremendous amount of pages dedicated to sanitizing strings. Honestly it's a large chunk of the PHP sections/code. The problem with the methods the author has prescribed is that they are outdated. Only briefly there is part of a chapter where he touches on prepared statements, which has become the correct way to instantiate MySQL queries. We do not need to sanitize our injected strings when using prepared statements. Why? Because prepared statements literally setup the query and prepare it for specific input. The bind_param() method of the mysqli prepare object makes certain that the input will only be interpreted as it's intended and a string will never be interpreted as a command.

63 of 69 people found the following review helpful.
3Lot of good information, but no organization or useful examples
By Kiefer Slaton
After a couple years of coding HTML, CSS, and Javascript/Jquery, I decided to dive into PHP/MySQL to start building some backend chops. To be fair, I'm comparing this book to Learning Web Design by Jennifer Robbins and Javascript/JQuery: The Missing Manual by David Sawyer McFarland, which I consulted to learn all my front-end knowledge and which have to be two of the most straightforward, well-organized, example-driven books I've ever read. Sadly, Nixon's book didn't have the same great qualities. There's no doubt this guy knows PHP backward and forward. The trouble is that he doesn't really seem to know how to convey that knowledge to a beginner. His writing doesn't seem to have much organization to it- there's a lot of "Hey, PHP can do this, oh and while I'm at it, it can also do this. And by the way, it can also do this, but I'm only showing it to you because you really don't want to do it this way." He also, in my opinion, takes for granted that you already understand how internet databases work, which in my case was a poor assumption. My biggest complaint is the lack of PRACTICAL examples. For every concept he describes, he provides a small, isolated example, but they often don't make sense because you don't understand WHY or in what context he's trying to perform the action he's performing. I'm the kind of guy that really needs to see the bigger picture in order to learn what each detail is contributing to it. And those bigger picture examples just weren't there for me.

All in all, I think the author really knows what he's talking about and probably provides a lot of good information, but as a complete beginner to PHP and back-end programming, I couldn't get any utility out of it. The writing was just too disorganized. This review does not apply to the Javascript section of the book, as I already know how to code JS and didn't read that.

2 of 2 people found the following review helpful.
2Outdated and some examples don't work
By Josina Miles
I'm glad I only rented this book. Since I made the investment, I will see it through to the end, but it's painful to read. The language is simple to follow, but it's like being taken site seeing. There is no destination, only a tour and brief explanation of the object. I don't know where, why or how I ended up at a certain location and why it's important for me to learn this particular lesson at this point. Since I don't have any idea of where I'm going or how it ties into anything else, I learn it, then I lose it. Therefore, I will need to revisit the path again to figure out what I may have missed or misunderstood. Some of the examples are not formatted properly, so if you don't have a even a basic knowledge of the PHP or other programming languages to begin with, you won't know it's an example you should try on your own. Which leads me to to my next point...I never know when I should try an example or it is just a snippet of a bigger explanation. It's not entirely a waste of time, but I will need to get through it as quickly as possible so that I can move on to 'real world' projects.

See all 78 customer reviews...

Connect with defaultLogic
What We've Done
Led Digital Marketing Efforts of Top 500 e-Retailers.
Worked with Top Brands at Leading Agencies.
Successfully Managed Over $50 million in Digital Ad Spend.
Developed Strategies and Processes that Enabled Brands to Grow During an Economic Downturn.
Taught Advanced Internet Marketing Strategies at the graduate level.

Manage research, learning and skills at defaultLogic. Create an account using LinkedIn or facebook to manage and organize your IT knowledge. defaultLogic works like a shopping cart for information -- helping you to save, discuss and share.

  Contact Us