Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
What You Will Learn
- How to build functional, full-featured websites that utilize MySQL, PHP and other current web development technologies.
- How to install, configure and modify functional PHP constructs and MySQL databases for the web.
- The basic principles and best practices of PHP and MySQL in a relevant, real world project.
Who Should Take This Course
- Individuals and small business owners interested in creating their own fully featured websites with total control over data management, functionality and visual appearance.
- Web developers and programmers looking to learn a new language and set of standards.
- Anyone who has used basic CMS or templates to create basic websites in the past but want much more control.
- Anyone who has tried to learn PHP or MySQL in the past but found it difficult due to a lack of practical examples.
What People Are Saying
"Have to say I was nervous at first, but the authors explanations were very well laid out and crystal clear. The site is coming together nicely."
"A PHP tutorial that is up to date with current standards...very easy to follow."
"I come from a design background but I wanted to beef up my knowledge of basic code. This was a nice and easy primer, thanks."
Not for you? No problem.
30 day money back guarantee
Learn on the go.
Desktop, iOS and Android
Certificate of completion
|Section 1: Introduction|
Working Files - Download These First
0101 What is PHPPreview
What Is MySQL?
Simple PHP Program
The Example Web Site - King Real Estate
|Instructions on how to obtain your Certificate of Completion for this Infinite Skills course. All Users of this course are eligible for a Certificate of Completion. Each certificate is issued with a unique number which allows verification that the user has undertaken the course listed. In order to o…|
|Section 2: Interface|
Setting Up Your Computer For PHP And MySQL
Installing WAMP For Windows
Installing MAMP For Macintosh - Part 1
Installing MAMP For Macintosh - Part 2
Using A Hosting Service
|Section 3: PHP Basics|
Using PHP Script Tags
Displaying HTML To Your Browser Window
Using The SELECT TagPreview
Using The TEXTAREA Tag
Using The RADIOBUTTON Tag
Using The CHECKBOX Tag
Assigning Values To Variables
Debugging Techniques - Part 1
Assignment 1 - Solution
|Section 4: PHP Programming Fundamentals|
Using IF Statements
The ELSE Clause
Code Formatting RulesPreview
Using DIVs And Forms
Debugging Techniques - Part 2
Assignment 2 - Solution
|Section 5: Advanced PHP Constructs|
The FOR Loop
The WHILE Loop
Reading A File
Writing To A File
Displaying A Data From A File Into An HTML TablePreview
Debugging Techniques - Part 3
Assignment 3 - Solution
|Section 6: Functions, Arrays, And Strings|
Functions That Receives DataPreview
Functions That Returns A Value
Functions That Receives Data And Returns A Value
Functions That Returns Multiple Values
Using Include Files
Loading An Array From A FilePreview
Loading An Array From A Directory
Finding Text With Regular Expressions
Finding Simple Patterns Using Regular Expressions
Debugging Techniques - Part 4
Assignment 4 - Solution
|Section 7: Introduction To MySQL|
Introduction To SQL
The Example Database
Simple SELECT Statement
Updating Table Data
SQL Debugging Techniques - Part 5
Assignment 5 - Solution
|Section 8: PHP With MySQL|
0801 Connecting To MySQL Within A PHP Program
0802 Pass Data To A Select
0803 Adding Rows To A Table
0804 Deleting Rows From A Table
0805 Updating Data In A Table
0806 Populating A Select-Option List
0807 Login Validation
Creating Tables With phpMyAdmin
Inserting Data With phpMyAdmin
0811 Common Database Functions
0812 Debugging Techniques - Part 6
Assignment 6 - Solution - Part 1
Assignment 6 - Solution - Part 2
|Section 9: PHP With Advanced MySQL|
Infinite Skills is a Canadian based company who offer a huge and ever growing range of high quality eLearning solutions that teach using studio quality narrated videos backed-up with practical hands-on examples and comprehensive working files. All courses are created by trained educators and experts in video based education.
The emphasis is on teaching real life skills that are essential for progressing in today's commercial environment.
Additionally, I am the author of three DVD/streaming video courses:
- PHP Object-Oriented Programming,
- Learning SQL For Oracle
I have a Master's degree in Education from the Universityof Phoenix (specializing in Adult Education and Online Training) and a BA in Mathematics from Illinois Institute of Technology.
Prior to becoming a full-time instructor, I have worked in Information Technology for over 24 years as an applications developer, systems analyst, and project leader.
Hours of video content