PHP and MySQL

Class Resources

Recaps of each class session can be found here.

For those class members who have been working through the web development certificate classes, a completed solution for the ToDo application can be downloaded here, or you can browse the source code on GitHub. This application brings together JavaScript, jQuery, AJAX, PHP, and MySQL into a single project.

All sample prompts can be downloaded here or browsed on GitHub. The solutions to the prompts are found in the book and available from the author’s web site.

Online Resources

Stack Overflow is a Q&A site with thousands of software development questions and answers covering C#, .NET, and many other technologies.

W3schools provides PHP and SQL references and tutorials. The PHP web site also provides a simple PHP tutorial.

Tools

PhpStorm is an integrated PHP development environment. It allows you to code, test, and deploy a PHP-based web site.

phpDesigner is another integrated development environment for building PHP web sites.

Development Servers

XAMPP is a completely free, easy to install Apache distribution containing MySQL, PHP, and Perl. There are versions for Windows, Linux, and Mac OS.

WampServer is a Windows-only alternative to XAMPP.

MAMP is another development server option for Windows and Mac OS.

Class Slides

Chapter 1 – Introduction to PHP – Comments, variables, strings, numbers, constants
Chapter 2 – Programming with PHP – Forms, conditionals, operators, form data validation, arrays, loops
Chapter 3 – Creating Dynamic Web Sites – Including files, sticky forms, functions
Chapter 4 – Introduction to MySQL – Database elements, column types and properties
Chapter 5 – Introduction to SQL – Create databases and tables, insert, select, sorting, updating, deleting, functions
Chapter 6 – Database Design – Normalization, indexes, table types, languages, time zones, foreign keys
Chapter 7 – Advanced SQL and MySQL – Joins, grouping, FULLTEXT search, optimizations, transactions, encryption

Leave a Reply

Your email address will not be published. Required fields are marked *