Guide to PHP and MySQL (Buffalo State College Version)


Introduction

I developed this guide as a way to present the PHP language and MySQL database to an advanced web design course. While teaching "Web Programming II" (MFC211) for Millard Fillmore College at the University at Buffalo and "Programming for the Web Environment II" (CIS475) at Buffalo State College for many semesters I have researched and used quite a few different PHP/MySQL textbooks. Most of these textbooks covered the PHP/MySQL topics well enough but they tended to be written with a general audience in mind. I needed to supplement these textbooks with numerous lecture notes specific to the BSC web server environment. Throughout this guide I will use the bscacad3 web server in the examples. You will need to contact your web server support for specific setting for your web server hosting provider.

These courses have knowledge of HTML, CSS, and JavaScript as pre-requisites. In reality, about 25% of my students each semester were at the beginning level and the rest were at a more advanced level already.

This guide is intended for you to learn the PHP language and MySQL syntax.

Visit the Let's Get Started! page.

You may also want to visit my Guide to HTML, CSS, and JavaScript, Guide to Object Oriented Programming with Java, and Guide to Oracle Database SQL sites.

Show DivChapter 1: Introduction to PHP

Show DivChapter 2: Setting Up Your Web Server

Show DivChapter 3: PHP Variables and Arrays

Show DivChapter 4: Using Conditionals

Show DivChapter 5: Using Loops

Show DivChapter 6: Working With Functions

Show DivChapter 7: Working With Files

Show DivChapter 8: Working With the MySQL Database

Show DivChapter 9: Working With PHP and a MySQL Database

Show DivChapter 10: Using PHP and MySQL With HTML Forms

Show DivChapter 11: Sending Email with PHP

Show DivChapter 12: Error Handling

Show DivChapter 13: Cookies and Sessions

Show DivChapter 14: Object-Oriented PHP

Show DivChapter 15: PHP, JavaScript & AJAX

Show DivChapter 16: Putting It All Together

Show DivChapter 17: Useful Links & Resources

Let's Get Started Exercises

Creative Commons License This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License. Copyright © 2016-2018 Jim Gerland