Build interactive, data-driven websites with the potent combination of open source technologies and web standards, even if you have only basic HTML knowledge. With the latest edition of this popular hands-on guide, you’ll tackle dynamic web programming using the most recent versions of today’s core technologies: PHP, MySQL, JavaScript, CSS, HTML5, jQuery, Node.js, and the powerful React library. Web designers will learn how to use these technologies together while picking up valuable web programming practices along the way, including how to optimize websites for mobile devices. 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 queries Explore MySQL from database structure to complex queries Use the MySQL PDO extension, PHP’s improved MySQL interface Use the MySQL PDO extension, PHP’s improved MySQL interface Create dynamic PHP web pages that tailor themselves to the user Create dynamic PHP web pages that tailor themselves to the user Manage cookies and sessions and maintain a high level of security Manage cookies and sessions and maintain a high level of security Use Ajax calls for background browser-server communication Use Ajax calls for background browser-server communication Style your web pages by acquiring CSS skills Style your web pages by acquiring CSS skills Reformat your websites into mobile web apps Reformat your websites into mobile web apps Learn to use enhanced CSS features, such as CSS Grid and Flexbox Learn to use enhanced CSS features, such as CSS Grid and Flexbox