Learning PHP, MYSQL & JavaScript: With jQuery, CSS & HTML5

Build interactive, data-driven websites with the potent combination of open source technologies and web standards, even if you have only basic HTML knowledge. In this update to this popular hands-on guide, you&;ll tackle dynamic web programming with the latest versions of today&;s core technologies: PHP, MySQL, JavaScript, CSS, HTML5, and key jQuery libraries.Web designers will learn how to use these technologies together and pick up valuable web programming practices along the way&;including how to optimize websites for mobile devices. At the end of the book, you&;ll put everything together to build a fully functional social networking site suitable for both desktop and mobile browsers.Explore MySQL, from database structure to complex queriesUse the MySQLi extension, PHP&;s improved MySQL interfaceCreate dynamic PHP web pages that tailor themselves to the userManage cookies and sessions and maintain a high level of securityEnhance the JavaScript language with jQuery and jQuery mobile librariesUse Ajax calls for background browser-server communicationStyle your web pages by acquiring CSS2 and CSS3 skillsImplement HTML5 features, including geolocation, audio, video, and the canvas elementReformat your websites into mobile web apps