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

5,893 students enrolled

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

5,893 students enrolled

Created by Infinite Skills

Last updated 1/2017

English

English [Auto-generated]

Preview this course

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

$34.99 $49.99 30% off

5 hours left at this price!

30-Day Money-Back Guarantee

15.5 hours on-demand video
1 article
1 downloadable resource
Full lifetime access
Access on mobile and TV

Certificate of Completion

Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business

What you'll learn

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.

+ – Getting Started

15 lectures 01:33:56

PHP Working Files - Download These First

Preview 00:01

0101 What The Course Covers

Preview 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

+ – Understanding The Basics

11 lectures 59:58

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

+ – Working With Arrays

11 lectures 44:32

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

+ – Creating Control Structures: Looping And Branching

9 lectures 42:53

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

+ – Managing The Code: Functions

9 lectures 47:56

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

+ – Managing The Code: Object-Oriented Programming

9 lectures 53:34

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

+ – Managing The Code: External Libraries

7 lectures 28:08

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

+ – Managing Files

7 lectures 41:49

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

+ – Managing A MySQL Database

11 lectures 01:26:01

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

+ – Understanding Structured Query Language (SQL)

7 lectures 57:51

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

6 more sections

Requirements

The Desire To Create Cool Web Applications In PHP And MySQL

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>

Who this course is for:

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.