Learn how to build dynamic, data-driven webpages using PHP with MySQL.

Strengthen your PHP and MySQL skills by building a robust content management system with secure user authentication.

Learn how to access and manipulate databases using the object-oriented PHP extensions PDO and MySQLi.

Learn to make your job easier and your code more accurate by choosing from a selection of general-purpose and PHP-specific code editors and IDEs.

Optimize your URLs for search engines and site visitors. Learn how to use the Apache mod_rewrite module to create clean URLs for PHP sites.

Hackers target PHP web applications more often than other sites because most PHP code is written by developers with little security experience. Protecting web applications from these attacks has become an essential skill for all PHP developers. PHP: Creating Secure Websites shows you how to meet the most important security challenges when developing websites with PHP. Instructor Kevin Skoglund covers the techniques and PHP code needed to develop sites that are more secure, and to avoid common mistakes. Learn how to configure PHP properly and filter input and escape output. Then check out step-by-step defenses against the most common forms of attack, including cross-site scripting and SQL injection.

Write better PHP code by following these popular (and time-tested) design patterns.

Learn how to use PHP to programmatically send email, including HTML email and personalized bulk email, with Swift Mailer, the free PHP library.

Learn how to export data from a database with PHP in a variety of formats, including: rich text, CSV, Excel, Word, OpenOffice spreadsheets and documents, and even XML.

Learn how to store persistent PHP session data in a SQL server and create an auto-login system that recognizes returning users.

Learn how to use object-oriented programming principles in PHP.

Learn how to efficiently interact with databases using object-oriented PHP code.

Learn how to speed up your PHP applications. Explore a variety of tools and techniques for developing high-performing PHP software.

Learn how to batch process images with the PHP GD functions. Watermark photos and generate different sizes ready for use in responsive web design.

Develop better software with fewer bugs with test-driven development and PHPUnit. Learn how to write unit tests in PHP using this popular tool and methodology.

Learn how to write tests for legacy PHP code bases. Discover why legacy code can be tough to test, how to determine what to test, and how to plan and build testing scenarios.

Do you need to know how to apply best practices for user authentication in PHP? This course walks you through a series of best practices that you can apply to your own PHP projects to avoid costly security pitfalls. Instructor Kevin Skoglund gives you an overview of user authentication in PHP, then dives into how you can implement it. He steps through creating the database table, adding new users, logging users in and out, and controlling access to pages and functions. Kevin shows you how to work with strong passwords, prevent weak ones, and reset forgotten ones. He shows you how to secure user authentication by preventing insecure direct object references (IDOR), using HTTPS, protecting access tokens, and keeping track of logins. Kevin concludes with a challenge/solution set exploring how to write PHP code that expires a user login after a set amount of time has passed.

Learn how to play piano at your own pace. Former Curtis Institute professor and acclaimed accompanist Hugh Sung presents online piano lessons for beginners.

Learn how to play piano while you practice classics from the catalogs of great composers such as Strauss, Beethoven, and Chopin.

Learn how to play piano and sight-read sheet music while you master classics from great composers such as Bach, Satie, and Chopin.