From the course: Practice It: PHP with MySQL
Unlock the full course today
Join today to access over 24,900 courses taught by industry experts.
Continue your practice using PHP with SQL databases
From the course: Practice It: PHP with MySQL
Continue your practice using PHP with SQL databases
- [Kevin] Thank you for practicing your PHP and SQL skills with me. We covered all of the most common database interactions, creating records, reading records, updating records, and deleting records. I hope this opportunity to practice was useful, whether you're just starting out or getting a refresher. If you want to continue your practice, there are a few improvements you can make to the exercise files. Here are a few that I see. The exercises duplicated a lot of code that could be moved into reusable functions. The code could be better organized to move those functions into a private area, and then include those files in the public pages when they're needed. The data being output to HTML could be escaped to prevent HTML injection attacks. And if you're really ambitious, you could try adding additional database tables to the code space, and then build new pages to manage them. For example, you might add a users…