PHP has been a popular server-side web technology for almost two decades—longer than any other commonly used programming language for building database-driven websites. Although PHP can be used with any of the popular databases (e.g., SQL Server, Oracle, PostgreSQL), it is most commonly paired with MySQL. The MySQL training portion of the course covers the MySQL-PHP connection. Learning to use PHP and MySQL together positions you well for jobs maintaining the millions upon millions of websites built on these technologies. You will also be able to build websites from scratch, though you will need to know other technologies, such as HTML and CSS.
Instructor(s):Self-Study
Requirements:
Hardware Requirements:
- This course can be taken on either a PC or Mac. Chromebooks are not compatible.
Software Requirements:
- PC: Windows 8 or later.
- Mac: macOS 12 or later.
- Browser: The latest version of Google Chrome or Mozilla Firefox is preferred. Microsoft Edge and Safari are also compatible.
- Adobe Acrobat Reader
- Software must be installed and fully operational before the course begins. Setup instructions can be found here.
Other:
- Email capabilities and access to a personal email account.
Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online.
Hide Syllabus
Lesson 1
- Working with Databases
- Objects
- Attributes / Properties
- Behaviors / Methods
- Classes vs. Objects
- Connecting to a Database with PDO
- Introducing the Poetree Database
- phpMyAdmin
- Querying Records with PHP
- Queries Returning Multiple Rows
- Adding Pagination
- Sorting
- Anticipating Foul Play
- Filtering
- Exception Handling
- Uncaught Exceptions
- Throwing Your Own Exceptions
- Catching Exceptions
- Exceptions
- Division Form
- PDOExceptions
- Logging Errors
- The dbConnect() Function
- When Queries Fail to Execute
- Preparing for the Catching Errors Exercise
- Catching Errors in the PHP Poetry Website
- Sending Email with PHP
- mail()
- Setting Up PHPMailer
- Mail Server
- Including a Mail Configuration File
- Sending Email with PHPMailer
- PHPMailer Methods and Properties
- Creating a Contact Form
- Authentication with PHP and SQL
- The Registration Process
- Passwords and Pass Phrases
- Registration with Tokens
- Creating a Registration Form
- Sessions
- Cookies
- Logging In and Out
- $_REQUEST Variables
- Resetting the Pass Phrase Introduction
- LAB: Inserting, Updating, and Deleting Poems
- Submitting a New Poem
- Showing All User's Poems in on the Poems Page
- Editing an Existing Poem
- Deleting a Poem
Hide Syllabus
Login/Create account
checkout
view cart (
0
)
