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.

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

O'Reilly Media , High Quality Training

O'Reilly spreads the knowledge of innovators through its technology books, online services, magazines, research, and tech conferences. Since 1978, O'Reilly has been a chronicler and catalyst of leading-edge development, homing in on the technology trends that really matter and galvanizing their adoption by amplifying "faint signals" from the alpha geeks who are creating the future. An active participant in the technology community, O'Reilly has a long history of advocacy, meme-making, and evangelism.

Reviews

Average Rating
4.4
Details
  1. 5 Stars
    15
  2. 4 Stars
    3
  3. 3 Stars
    1
  4. 2 Stars
    0
  5. 1 Stars
    2
    • Muz

    Learn the boring way

    The good part was that the course got straight to the point. The bad part was that it was no better than a book. In fact, it was worse. It's like an audiobook for code. It took a lot of active effort to focus with the really slow pace, and by then you're too bored to remember what you've learned previously. I don't recommend this course, especially with the high price. I've done about 30% of the course and am bailing out because it's a waste of time.

    • Raghav Gupta

    Waste Of Money!

    Sharing the Working Files and simply showing the simulation/results in the lecture videos isn't what we define development as!Waste of time and Money!

    • Jordan Max

    Very explanatory and really good website to work off of

    I am very happy to have done this course I feel like I can fully understand how backend database programming of a website works. Anyone who is interested in this should take this course you will see why after you complete it.

    • Grant Hynd

    Comprehensive and Well Structured Course

    Everything is explain in great detail from the basics to the more advanced parts of the course. I think transforming a standard html website to a dynamic php website driven by a database is a great way to show students how php/mysql works together. Yes, the tutor for the course does have quite a monotone voice, which makes some section quite hard to pay attention too. However, i do think the well structured material and interactive project makes up for that.

    • Jon Buckner

    Good, informative but...

    Hi folks, There are a lot of lessons here, and I am sure that they help out a lot. Certainly seem to be very comprehensive. A lot of files to work with but... a) the lessons start and you have to search around (all be it, not for very long) to find the file associated with the lesson, would have been better if the files were labelled 'lesson1', 'lesson2', or if more than one per lesson 'lesson2_1' etc.. b) The tutor is the worlds best cure for insomnia, sorry to be harsh, but it's true. It is really difficult to listen and be attentive against the monotone voice. I'm sure he is a nice guy and means well, but it just drains me... c) I had trouble accessing files through browser, I had to copy and relabel the files, might have been a problem my end, will never know as had no response... d) the vidoe is quite blurred but that might be a Udemy thing, it means you can listen fine, but when watching the screen it is like you have had half a bottle of whiskey. Apart form all that, you can probably learn a lot of what you need from this course

Show more reviews

What you get with this course

30 day money back guarantee

Lifetime access

Available on desktop, iOS and Android

Certificate of completion

Join the biggest student community

5,400,000

Hours of video content

21,000,000

Course enrollment

6,300,000

Students

Ready to start learning?
Preview this course