PHP Tutorial: PHP/MySQL for Beginners

Learn PHP online with MySQL and Start Developing Web Apps like a Pro!
  • Lectures 47
  • Video 6 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

So you're getting comfortable with HTML, CSS and Javascript? You're up for the next challenge? The PHP programming language coupled with the mySQL database is the final step toward making a complete application. Many commercial e-commerce sites, membership sites and even online communities use PHP. Once you learn PHP online you can use this free technology to build just about any type of web presence you can imagine.

If you're a mobile developer, you need to learn PHP and MySQL too. Most mobile devices consume web-based services. There is no easier way to create web services designed to be consumed by mobile devices than PHP-- guaranteed!

In this PHP and MySQL training course you'll join master trainer Mark Lassoff as you learn all of the major concepts that beginner PHP developers need to master. You'll be able to code along with Mark as he demonstrates everything from simple PHP commands to more advanced database applications. Each lesson features a companion lab exercise, which will help you retain, reinforce and remember each concept in the course.

So are you ready to learn PHP online?

</p>

What am I going to get from this course?

  • Over 47 lectures and 5.5 hours of content!
  • By the end of the course you will be able to understand how PHP works.
  • By the end of the course you will be able to implement PHP on a website.
  • By the end of the course you will be able to use advanced database operations with PHP and MySQL

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

01:49

Please watch this first.

Section 1: Your First PHP Scripts
06:36

In this video Mark shows you how to get the tools you will need to complete this course.

05:20

In this video Mark demonstrates how to open the files you will be working with through your server.

09:15

In this video Mark shows you how to write a few simple scripts in PHP.

07:31

In this video Mark demonstates different ways to output text in PHP.

1 page
Complete these lab exercises after watching the Chapter 1 video lectures.
Section 2: Variables
09:38

In this video Mark shows you how to declare variables in PHP.

09:39

In this lecture Mark shows you how to perform operations using PHP. 

1 page
Complete these lab exercises after watching the Chapter 2 video lectures.
Section 3: Arrays
08:11

In this video Mark shows you a few different ways to declare simple arrays.

05:32

In this lecture Mark demonstrates how to declare associative arrays.

06:06

In this video Mark shows you how to declare another type of array in PHP.

12:08

In this video Mark shows you how to use super global arrays to pass information from one page to another.

2 pages
Complete these lab exercises after watching the Chapter 3 video lectures.
Section 4: Conditionals
13:29

In this video Mark goes over how to set up simple conditional statements in PHP.

08:59

In this video Mark goes over how to use more complex conditional statements with the if and elseif commands.

07:30

In this video Mark goes over the Switch, Case and Break commands and discusses its uses.

05:29

In this video Mark demonstrates another alternative to If statements called the ternary operator.

1 page
Complete these lab exercises after watching the Chapter 4 video lectures.
Section 5: Loops
10:15

In this lecture Mark discusses While loops and Do While loops in PHP.

05:27

In this video Mark shows you how to use For Loops in PHP.

08:05

In this video Mark shows you another kind of loop called the Foreach Loop.

2 pages
Complete these lab exercises after watching the Chapter 5 video lectures.
Section 6: Custom PHP Functions
05:35

In this video Mark demonstrates the include command in PHP.

06:18

In this lecture Mark shows you how to create a simple funtion and call it in PHP.

07:09

In this lecture Mark demonstrates how to create functions that take arguments.

09:14

In this video Mark shows you how to write a function that returns a value.

1 page
Complete these lab exercises after watching the Chapter 6 video lectures.
Section 7: Server File I/O
09:02

In this lecture Mark teaches you how to write and save a file to your server using PHP.

09:22

In this video Mark shows you how to read a file that is saved on your server and output it.

05:24

In this video Mark teaches you how to append text to a document on the serve and he also shows you how to delete a file on the server.

06:45

In this video Mark shows you how to read and output data from a CSV file on your server.

1 page
Complete these lab exercises after watching the Chapter 7 video lectures.
Section 8: Sending Email with PHP
03:28

In this video Mark shows you how to send mail using PHP.

05:08

In this video Mark shows you how to send an HTML Email using PHP.

Section 9: Working with the mySQL Database
10:26

In this video Mark shows you how to set up the mySQL database.

20:13

In this section Mark shows you how to get queries from you database and shows you how to format them into a table.

17:38

In this lecture Mark shows you how to set up a form to store new information into your database.

34:22

In this video Mark shows you how to update and delete records on your database by creating php processing pages.

06:11

In this video lecture Mark will show you how to excute a more complex query and obtain data from more then one table via an informal join.

1 page
Complete these lab exercises after watching the Chapter 9 video lectures.
Section 10: Useful PHP Classes and Objects
08:27

In this video lecture Mark will show you how to use the Date() features within PHP to access and manipulate date and time information.

09:23

In this video lecture Mark discusses some of the ways you can manipulate strings with PHP.

08:03

In this video lecture you'll learn how to use sessions to maintain state in your PHP application.

06:53

In this video lecture Mark reviews Cookies, which allow you to save state in your PHP applications.

1 page
Complete these lab exercises after watching the Chapter 10 video lectures.
Section 11: Solutions
13.89 KB

These are sample solutions for the labs throughout the course. These are here for you to look at if you are stuck. Remember, they are just samples, your solutions may not look like these and they can still work.

Instructor Biography

LearnToProgram, Inc. , Learn Web, Mobile and Game Development

LearnToProgram Media is a leading publisher of web, mobile, and game development courses that are used by over 500,000 people in 65 countries. LearnToProgram's valuable network of technical resources includes content on YouTube, iTunes, and Roku, as well as books, free tutorials, and online courses.

With a mission of “teaching the world to code" LearnToProgram instructors are teachers first and technical experts second. Their primary skill is relating complex technical information to nontechnical people learning web, mobile and game development. The entirely online, self-paced sales model allows students to learn at their own pace.

With over 40 courses on the market, LearnToProgram offers students flexible programs in web development, mobile application development and game development. Currently the company's most popular online courses include Become a Certified Web Developer and 10 Apps in 10 Weeks.

The company is based outside of Hartford, Connecticut.

Join the biggest student community

7,700,000

Hours of video content

28,000,000

Course Enrollments

7,500,000

Students

Reviews

Average Rating
4.5
Details
  1. 5 Stars
    10
  2. 4 Stars
    4
  3. 3 Stars
    2
  4. 2 Stars
    0
  5. 1 Stars
    0
    • David Corso

    Great, simple walkthrough of PHP

    I've attempted to dig into PHP on Codecademy, but had a hard time staying with it. This course does a great job of keeping you coding.

    • Jeremy Lewis

    Some good info, but course is not supported by teacher

    Unfortunately, if you have a question about anything in the course do not expect to get it answered. It seems this course is all but abandoned by the instructor. Code or PHP beginners (the demographic that this course is marketed to) have a lot of questions. In this course there are several questions that are unanswered from over a year ago and some that the students have tried to help others with by using Google. It is rare to find any question answered by the instructor. As such, take this course with an "as-is" mentality and use it not as your primary means of understanding PHP, but rather as a supplemental tool to a more supported course on PHP.

    • Craig LaBarge

    Good Introduction

    I needed a good, general introduction to PHP and this course fit the fill nicely. Mark has a great, informal way of presenting the information, which I like. I like being able to "look over his shoulder" as he writes the code during the lessons and the labs give you a chance to practice what you've learned. Highly recommended!

    • Christopher Angus

    The only PHP & MySQL course you'll need

    This is the perfect beginners course, if you you want to learn PHP and MySQL with no experience. It's covers all the essentials from setting up your environment and teaching you about variables, right through to working with SQL databases. By the end of this course, you'll know enough so you're proficient in PHP and could even do some basic paid client work. Sincerely recommended.

    • Alex Reynolds

    Another Great course by Mark

    I did Mark's Javascript course before I did php because I heard you need to learn the languages in that order. Knowing all the front end languages really helped me get the most out of this course. Mark does a great job of ordering the material in such a way that by the time you get complex it all makes sense. Amazing course. It has helped me feel confident about php and SQL coding. I would love it if he offered intermediate or advanced PHP and javascript courses. Or maybe even basic Jquery library coding. Totally worth the money.

Show more reviews
Ready to start learning?
Preview this course