PHP & MySQL - Learn The Easy Way. Master PHP & MySQL Quickly

Learn To Build Robust PHP / MySQL Web Applications, Taught By Leading Zend Certified PHP Trainer. Learn To Code PHP Fast
  • Lectures 144
  • Video 16 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 15 hour PHP & MySQL Training Course Taught By A Zend Certified PHP Trainer, This PHP with MySQL Essential Training Teaches You All You Need To Know.

In this PHP / MySQL training title from InfiniteSkills, you will learn PHP and MySQL and its fundamentals. These two platforms have been virtually inseparable for many years, and major groundbreaking websites such as WordPress, Wikipedia, and Facebook use PHP and MySQL technologies.

This PHP with MySQL Essential Training is designed for the beginner; no previous programming or database experience is required. Your training begins with the absolute basics, covering topics such as creating variables, working with data types and outputting them to a web page. You will learn how to work with arrays, how to use loops and control structures such as for each, while and if. You will learn about functions and creating classes for object-oriented programming. You will master interacting with MySQL and using SQL functions to store and retrieve data. Doug also provides in-depth lessons on how PHP and MySQL can be used to send email, work with date and time functions, use cookies and sessions, building web forms, and much more.

Throughout this PHP with MySQL Essential Training course you will complete labs that re-enforce the concepts you have learnt. Once you have completed this video tutorial you will be well versed in the fundamentals of creating web applications using PHP and MySQL. Working files are included, allowing you to follow along with the author throughout the lessons.

</p>

What are the requirements?

  • The Desire To Create Cool Web Applications In PHP And MySQL

What am I going to get from this course?

  • Over 144 lectures and 15.5 hours of content!
  • How to download and install PHP and MySQL tools and frameworks onto a server and home machine.
  • How to configure relevant setting to match the needs of your project.
  • How to work between a user interface and a database back-end that stores critical information.
  • How to plan and apply PHP and MySQL to specific examples and finally your own real world projects.

What is the target audience?

  • Anyone who wants to build a website that goes beyond the requirements of basic HTML and CSS.
  • Anyone who wants to learn how to build an app that can handle data and interface with end users at the same time.
  • Anyone who wants to learn how MySQL can function as a database solution.
  • Anyone who wants to learn basic programming and development skills without days of digging through technical books.

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: Getting Started
PHP Working Files - Download These First
Text
How to Obtain Certification for this Course
Text
0101 What The Course Covers
11:22
0102 Course Setup Using XAMPP
07:00
0103 Installing XAMPP On Windows
06:50
0104 Installing MAMP On The Mac
05:05
0105 Installing XAMPP On Linux
04:52
0106 Configuring PHP And MySQL
11:59
0107 Configuring Apache
09:34
0108 Using Editors And IDEs
06:58
0109 Saving Your Code
02:37
0110 Searching PHP And MySQL Documentation
07:55
0111 Getting Help And Verifying XAMPP Status
07:05
0112 Setup And Finding Course Files:
05:11
0113 Lab: Building A New Website
03:55
0114 Solution: Building A New Website
03:32
Section 2: Understanding The Basics
0201 Creating Variables In PHP
05:32
0202 Assigning Different Data Types
09:20
0203 Performing Arithmetic Operations
05:43
0204 Adding Comments To The Code
02:30
0205 Assigning Constant Values In PHP
04:09
0206 Using The printf Command To Format A String
04:26
0207 Understanding The substr Command
04:41
0208 Working With Strings
08:11
0209 Debugging An Application
07:39
0210 Lab: Mixing HTML And PHP
03:04
0211 Solution: Mixing HTML And PHP
04:43
Section 3: Working With Arrays
0301 Working With Numeric Keys
03:24
0302 Working With Associative Arrays
02:01
0303 Assigning Values To Arrays
05:13
0304 Creating A Multidimensional Array
05:31
0305 Searching Arrays
05:08
0306 Sorting Arrays
07:32
0307 Removing Values From Arrays
04:21
0308 Measuring Array Differences
03:27
0309 Merging Arrays
01:27
0310 Lab: Using An Array To Generate A Drop Down Menu
02:09
0311 Solution: Using An Array To Generate A Drop Down Menu
04:19
Section 4: Creating Control Structures: Looping And Branching
0401 Comparing Values
05:21
0402 Using if, else, And elseif
07:12
0403 Using switch
03:16
0404 Setting Up A for Loop
04:34
0405 Configuring while And do while Loops
05:34
0406 Using A foreach Loop
05:58
0407 Branching With continue, break, And goto
05:19
0408 Lab: Using Loops To Display Rows Of Data On A Web Page
02:16
0409 Solution: Using Loops To Display Rows Of Data On A Web Page
03:23
Section 5: Managing The Code: Functions
0501 Using Built-In Functions
05:36
0502 Creating Your Own Functions
06:29
0503 Returning Values
03:53
0504 Defining Mandatory And Optional Parameters
04:11
0505 Using Parameters By Reference
05:32
0506 Handling A Variable Number Of Parameters
04:11
0507 Understanding Global Variables In PHP
06:40
0508 Lab: Creating A Function Which Paginates Rows Of Data
02:51
0509 Solution: Creating A Function Which Paginates Rows Of Data
08:33
Section 6: Managing The Code: Object-Oriented Programming
0601 Defining Classes
09:45
0602 Adding Properties
04:56
0603 Creating Methods
07:54
0604 Determining The Visibility Level
07:58
0605 Building Classes By Inheritance
05:14
0606 Handling Exceptions
07:18
0607 Introducing The MVC (Model-View-Controller) Design Pattern
05:27
0608 Lab: Building An MVC Website Using OOP
01:54
0609 Solution: Building An MVC Website Using OOP
03:08
Section 7: Managing The Code: External Libraries
0701 Loading Code With include
02:47
0702 Loading Code With require
04:34
0703 Loading Code Once Only
04:05
0704 PHP Extensions And PECL
06:16
0705 PHP Libraries And PEAR
04:31
0706 Lab: Downloading An External Library
02:19
0707 Solution: Downloading An External Library
03:36
Section 8: Managing Files
0801 Using The f* Family
07:16
0802 Using The *file* Family
05:09
0803 Understanding Streams
07:21
0804 Updating The Error_Log
05:41
0805 Parsing Directory Structures
04:15
0806 Lab: Reading A CSV File
03:30
0807 Solution: Reading A CSV File
08:37
Section 9: Managing A MySQL Database
0901 Understanding RDBMS Terminology
05:52
0902 Command Line Access
04:24
0903 Using phpMyAdmin
09:56
0904 Configuration
12:16
0905 Creating A Database
08:47
0906 Managing Tables - Part 1
07:57
0907 Managing Tables - Part 2
07:08
0908 Understanding Indexes And Relationships
06:48
0909 Establishing Relationships And Constraints
09:34
0910 Lab: Defining Tables And Relationships For A Website
04:32
0911 Solution: Defining Tables And Relationships For A Website
08:47
Section 10: Understanding Structured Query Language (SQL)
1001 Retrieving Data Using SELECT
10:46
1002 Adding Data Using INSERT
08:42
1003 Editing Data Using UPDATE
07:57
1004 Removing Data Using DELETE
05:30
1005 Performing Advanced Queries Using JOIN
11:51
1006 Lab: Creating Select, Insert, Update, And Delete SQL Statements
02:24
1007 Solution: Creating Select, Insert, Update, And Delete SQL Statements
10:41
Section 11: Using PHP To Interact With A MySQL Database
1101 Understanding The Different MySQL Database Extensions
10:38
1102 Reading Data From A Table
09:57
1103 Writing Data To A Table
11:32

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.

Join the biggest student community

6,400,000

Hours of video content

29,000,000

Course Enrollments

7,900,000

Students

Reviews

Average Rating
4.3
Details
  1. 5 Stars
    18
  2. 4 Stars
    6
  3. 3 Stars
    2
  4. 2 Stars
    1
  5. 1 Stars
    2
    • Yaswanth Reedy Kalathuru

    The one major problem with this course is instructor using older version of internet explorer and old version computer so this will display that the tutorial is done way back. Please do the tuotorial again with new versions so that people will easily understand. Other than that tutorial is fantastic!!!!!!!!!!!!!

    • Daniele Brunengo

    Good course, no support

    The course is very good, but nobody answers the students' questions anymore, that's why I rated it one star short of 5.

    • Dan Goldfeder

    Great course for beginners BUT! ...

    I took 1 star because some videos needs to be updated as some files too. Or at least before the student buy the course Udemy or the teacher must warn that the course has more than 3 years and needs and update. The second star I took is because the teacher no longer answer questions so you have to do a research sometimes to make changes on the code for the correct functioning. And the third star I took away is for the cost, it is to expensive for an outdated course and no help at all.

    • Gary Williams

    Very Helpful

    This is one of the better and more helpful and thorough PHP/MySQL courses I have taken. It covers more advanced topics such as OOP, MVC, error exceptions and logging, file manipulation and CSV data storage, PDO data access, regular expressions, email attachments, headers and output buffering, and form sanitation and validation. By the end of the course, a nearly complete website is built consisting of a catalog of items and a shopping cart.

    • Osvaldo Dias dos Santos

    Educational course

    Well taught, nice pace, good lesson sequence, lots of hands-on exercises carefully explained.

Show more reviews
Ready to start learning?
Preview this course