Click this widget to change the font size.
Click this widget to change contrast.

Home Page 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | Links | Search | Bio |

Guide to PHP and MySQL (Buffalo State University Version)


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" (CDA216) for the Department of Computational and Data-Enabled Science and Engineering at the University at Buffalo and "Programming for the Web Environment II" (CIS475) at Buffalo State University 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 bscacad3 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 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: Creating a Custom 404/500 Error Page

Show DivChapter 18: Useful Links & Resources

Let's Get Started Exercises

Help contribute to my OER Resources. Donate with PayPal button via my PayPal account.
Creative Commons License This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License. Copyright © 2016-2024 Jim Gerland