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

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

Mark Lassoff , Founder, LearnToProgram, Inc.

LearnToProgram is a leading publisher of web, mobile and game development courses that are used by individuals and companies world-wide. Based outside of Hartford, Connecticut, the LearnToProgram team is dedicated to teaching more people to program than any other company on the face of the Earth. Our authors are among the most experienced in the field-- and they have one important thing in common: LearnToProgram authors consider themselves teachers first and technical experts second. The primary skill of LearnToProgram author is communication-- and you will always find our courses easy to understand and successfully complete.

About Mark-- The Guy Behind LearnToProgram

Mark Lassoff's parents frequently claim that he was born to be a programmer. In the mid-eighties, when the neighborhood kids were outside playing kickball and throwing snowballs, Mark was hard at work on his Commodore 64 writing games in the BASIC programming language. Computers and programming continued to be a strong interest in college where Mark majored in Communications and Computer Science. After completing his college career, Mark worked in the software and web development departments at several large corporations.

In 2001, on a whim, while his contemporaries were conquering the dot com world, Mark accepted a position training programmers in a technical training center in Austin, Texas. It was there that Mark fell in love with teaching programming, which has been his passion ever since. Today Mark is a top technical trainer, traveling the country providing training for software and web developers. Mark's training clients include the Department of Defense, Lockheed Martin, Discover Card Services, and Kaiser Permanente. He has consulted for companies such as Dell, Target, Lockheed Martin, and government agencies including the US House of Representatives.

He lives near Hartford, Connecticut where he is in the process of redecorating his condominium.

Reviews

Average Rating
4.5
Details
  1. 5 Stars
    8
  2. 4 Stars
    3
  3. 3 Stars
    2
  4. 2 Stars
    0
  5. 1 Stars
    0
    • 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.

    • Juan Berlanga

    Awesome!

    I am taking a course in the University on PHP and haven't learned much. Out of desperation I bought this course. I have learned more in one week with this course than half a semester at the University. I love it!

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