Introduction to PHP and MySQL
Introduction to PHP and MySQL
Learn how to create an interactive website, allowing visitors to post and retrieve information provided by you or your site’s visitors. In this online course, you’ll see how to create dynamic web pages using the PHP programming language and the MySQL database server.
During the course, you’ll walk through the development of a complete content management system web application. You’ll receive clear, step-by-step, instructions demonstrating how to create a complete website capable of dynamically displaying data from a MySQL database.
You’ll discover how you can allow your site’s visitors to add new information to an online database, search through posted data, and create meaningful printed reports. By the end of this course, you’ll have plenty of useful code templates that will help you create your very own dynamic, web-based, content management system.
Syllabus
- Lesson 1 – What Is PHP?
- Lesson 2 – Basic PHP Programming
- Lesson 3 – More PHP Programming Features
- Lesson 4 – Creating a MySQL Database
- Lesson 5 – Creating a Dynamic Home Page
- Lesson 6 – Displaying Database Content Dynamically
- Lesson 7 – Allowing Visitors to Enter Data
- Lesson 8 – Implementing a Simple Search Engine
- Lesson 9 – Producing Attractive Printer-Friendly Pages
- Lesson 10 – Controlling User Access
- Lesson 11 – Backing up and Restoring MySQL Data Files
- Lesson 12 – Implementing Pagination
Requirements:
Hardware Requirements:
- This course can be taken on either a PC or Mac.
- Mac users will not be able to use the WAMP5 software, and must provide their own PHP and MySQL development environment.
Software Requirements:
- PC: Windows 8 or later.
- Mac: macOS 10.6 or later.
- Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge and Safari are also compatible.
- During the first lesson in the course, you will be walked through the process of installing WAMP5 software, which provides a full PHP and MySQL development environment. You can download WAMP5 for free here.
- Adobe Acrobat Reader.
- Software must be installed and fully operational before the course begins.
Other:
Email capabilities and access to a personal email account.
Prerequisites:
There are no prerequisites to take this course. Prior HTML coding experience is helpful, but not required.
Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online.
<ul><li>6 Weeks Access</li>
<li>Course Code: iph</li>
<li>Start Dates* Jan 12 | Feb 09 | Mar 16 | Apr 13</li>
<li>$187.00 USD</li></ul><br><br>
<p><strong>Self-Paced</strong></p><br>
<ul><li>3 Months Access</li>
<li>Course Code: T9603</li>
<li>No Instructor, Start Anytime</li>
<li>$187.00 USD</li></ul>
Richard Blum has been an IT industry professional for over 20 years, working mainly as a network and systems administrator. During this time, he has worked with Microsoft, Novell, Unix, and Linux servers, and has created websites using a variety of different programming languages. Blum is the author of several programming and systems administration books, including Professional Assembly Language, C# Network Programming, PostgreSQL 8 for Windows, Sendmail for Linux, Postfix, and Network Performance Open Source Toolkit.
Be the first to add a review.
Related Courses
