PHP and MySQL Series
Create dynamic, interactive web pages that allow users to post and retrieve information using the PHP programming language and MySQL database server. After learning the basics, you discover how to create an interactive online store with a catalog, shopping cart, and order completion capabilities. You will even gain useful code templates to help you create your own web-based content management system and online store as you complete your coursework!
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 six-week 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.
Intermediate PHP and MySQL
Learn how to create an interactive online store complete with an online catalog of products, allowing customers to browse the catalog to select items, place them in a shopping cart, and complete an order. In this six-week online course, you'll see how to create a commercial online store using the PHP programming language and the MySQL database server.
We'll walk through the steps for developing a complete online store web application. During the course, you'll see step-by-step how to create all of the software and database objects used in the application. The application consists of two parts, an administrative web application allowing a store manager to post new products, alter product information, and process customer orders, and a customer web application allowing customers to browse the catalog of products, select products for purchase, and check out using a shopping cart. At the end of the course, you'll be able to use these code templates to create your own online store application.
Series bundles are not eligible for partial drops or refunds. Transfers to other open sessions of the same course are available. Please refer to your school for additional details regarding drops, transfers, and refunds on Series bundles.
How the course is taught
- Instructor-led online course
- 48 course hours
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.
There are no prerequisites to take this course. Prior HTML coding experience is helpful, but not required.
- 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.
- 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.
- Adobe Acrobat Reader.
- Software must be installed and fully operational before the course begins.
- 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.
- 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.