Learning Dynamic Website Design - PHP MySQL and JavaScript

Learn Dynamic Web Design with PHP / MySQL, AJAX, JavaScript and CSS. Course comes with Certificate of Completion.
  • Lectures 126
  • Video 13 Hours
  • Skill level all level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

Course Description

A Verifiable Certificate of Completion is presented to all students who undertake this course.

This Dynamic Web Design with PHP and MySQL training course will give you a working understanding of these important technologies and show you how to use them to create your own impressive websites. When used in combination, there simply isn't a better way to construct sites that involve complexity, large volumes of data, and the flexibility to make adjustments and changes over time. This course goes step by step through the basics of each technology, and then gradually shows you how to build the necessary components and underlying framework of your site. It goes through installation of PHP and MySQL technologies on your local machine as well as hosted servers, explains basic tags, commands and constructs, and helps you build and work within a solid back-end database. One you have the basics of PHP and MySQL covered, you'll also learn how to use CSS, JavaScript and AJAX to create the visual style and added functionality your pages deserve.

 

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.

- How to pair a secure PHP / MySQL backend of a website with a compelling visual interface made with CSS, AJAX, and JavaScript code.

- 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."

-Ben Jeffries


"A PHP tutorial that is up to date with current standards...very easy to follow."

-Breck Defontes


"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."

-Angela Redberg

What am I going to get from this course?

  • Over 126 lectures and 12.5 hours of content!

What you get with this course?

Not for you? No problem.
30 day money back guarantee

Forever yours.
Lifetime access

Learn on the go.
Desktop, iOS and Android

Get rewarded.
Certificate of completion

Curriculum

Section 1: Introduction
Working Files - Download These First
Text
0101 What is PHP
Preview
04:33
What Is MySQL?
02:39
Simple PHP Program
06:27
The Example Web Site - King Real Estate
03:54
Text
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
04:01
Installing WAMP For Windows
07:03
Installing MAMP For Macintosh - Part 1
03:57
Installing MAMP For Macintosh - Part 2
02:28
Using A Hosting Service
06:38
Section 3: PHP Basics
Using PHP Script Tags
04:01
Displaying HTML To Your Browser Window
07:47
HTML Forms
10:13
Using The SELECT Tag
Preview
06:19
Using The TEXTAREA Tag
06:47
Using The RADIOBUTTON Tag
04:09
Using The CHECKBOX Tag
05:36
Assigning Values To Variables
04:49
Appending Text
04:12
Debugging Techniques - Part 1
07:21
Assignment 1
04:12
Assignment 1 - Solution
05:49
Section 4: PHP Programming Fundamentals
String Delimiters
07:47
Simple Math
05:29
HTML Tables
Preview
07:53
Using IF Statements
04:15
The ELSE Clause
04:44
Nested IFs
05:40
Code Formatting Rules
Preview
05:24
Comparison Operators
08:18
Using AND
04:38
Using OR
04:26
Using NOT
05:39
Field Validations
06:52
Using DIVs
08:31
Using DIVs And Forms
03:17
Debugging Techniques - Part 2
10:00
Assignment 2
04:39
Assignment 2 - Solution
10:16
Section 5: Advanced PHP Constructs
The FOR Loop
07:35
The WHILE Loop
09:02
Reading A File
08:29
Writing To A File
07:44
Displaying A Data From A File Into An HTML Table
Preview
12:55
Debugging Techniques - Part 3
07:58
Assignment 3
05:33
Assignment 3 - Solution
08:56
Section 6: Functions, Arrays, And Strings
Simple Function
02:38
Functions That Receives Data
Preview
03:30
Functions That Returns A Value
02:28
Functions That Receives Data And Returns A Value
06:20
Variable Scope
07:19
Functions That Returns Multiple Values
06:49
Using Include Files
04:16
Array Basics
07:52
Sorting Arrays
06:14
Loading An Array From A File
Preview
02:10
Loading An Array From A Directory
06:19
Recursive Programming
08:57
Finding Text
06:47
Finding Text With Regular Expressions
05:11
Finding Simple Patterns Using Regular Expressions
07:59
Debugging Techniques - Part 4
08:03
Assignment 4
05:40
Assignment 4 - Solution
09:18
Section 7: Introduction To MySQL
Introduction To SQL
09:46
The Example Database
06:50
Interactive MySQL
07:20
Creating Tables
08:19
Simple SELECT Statement
05:38
Comparison Operators
Preview
05:40
Logical Operators
05:56
Selecting Nulls
02:05
Sorting Results
05:46
Aggregate Functions
06:37
Pattern Matching
05:14
Inserting Rows
04:05
Updating Table Data
02:43
Deleting Rows
01:56
SQL Debugging Techniques - Part 5
05:38
Assignment 5
02:54
Assignment 5 - Solution
03:19
Section 8: PHP With MySQL
0801 Connecting To MySQL Within A PHP Program
08:29
0802 Pass Data To A Select
03:26
0803 Adding Rows To A Table
06:43
0804 Deleting Rows From A Table
03:55
0805 Updating Data In A Table
04:27
0806 Populating A Select-Option List
03:09
0807 Login Validation
04:00
Relative Referencing
04:38
Creating Tables With phpMyAdmin
07:07
Inserting Data With phpMyAdmin
07:46
0811 Common Database Functions
06:38
0812 Debugging Techniques - Part 6
07:24
Assignment 6
03:42
Assignment 6 - Solution - Part 1
06:33
Assignment 6 - Solution - Part 2
07:48
Section 9: PHP With Advanced MySQL
Date Functions
04:24
Using Indexes
06:58

Instructor Biography

Infinite Skills , High Quality Training

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.

Instructor Biography

Steve Perry , Computer Software Instructor

My name is Steve Perry and I have been teaching college classes since 1995. I have taught classes in Java, PHP, AJAX, Perl, SQL, MySQL, HTML, CSS, JavaScript/jQuery, Oracle, Database Design and Management, PowerBuilder, and Computer Science.

Additionally, I am the author of three DVD/streaming video courses:

- Dynamic Web Design using PHP, MySQL, and JavaScript

- 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.

Join the biggest student community

7,000,000

Hours of video content

26,000,000

Course Enrollments

7,100,000

Students

Reviews

Average Rating
4.5
Details
  1. 5 Stars
    32
  2. 4 Stars
    8
  3. 3 Stars
    2
  4. 2 Stars
    1
  5. 1 Stars
    2
    • Christopher Wulle

    Wonderful Intro Into PHP and MySQL

    This course should be viewed a couple of time to truly understand the concepts shown. However the course will guide you from "newb to ready to dig in." I like the pace and explanation of topics in this course. Awesome job all around.

    • Sugananth Thinagaran

    Looks promising

    Excited !!! Looking forward to crack this course soon

    • Ercan Beşli

    Instructor says he does not have to answer all the questions.

    • Pablo Gómez

    Great !

    With this course I learned php in 2 weeks!! Really you learn the needed syntax to develop any app in php and mysql.

    • Saeed Abu Roken

    very good course

    it gave me all information to build dynamic web i only view the lessons and try to answer the examination and the course meet expectations at all

Show more reviews
Ready to start learning?
Preview this course