Beginner PHP and MySQL Tutorial

Beginner PHP and MySQL Tutorial, available at Free, has an average rating of 3.72, with 156 lectures, based on 10587 reviews, and has 337642 subscribers.

Free Enroll Now

You will learn about 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. This course is ideal for individuals who are Anyone who wants to build a website that goes beyond the requirements of basic HTML and CSS. or Anyone who wants to learn how to build an app that can handle data and interface with end users at the same time. or Anyone who wants to learn how MySQL can function as a database solution. or Anyone who wants to learn basic programming and development skills without days of digging through technical books. It is particularly useful for Anyone who wants to build a website that goes beyond the requirements of basic HTML and CSS. or Anyone who wants to learn how to build an app that can handle data and interface with end users at the same time. or Anyone who wants to learn how MySQL can function as a database solution. or Anyone who wants to learn basic programming and development skills without days of digging through technical books.

Enroll now: Beginner PHP and MySQL Tutorial

Summary

Title: Beginner PHP and MySQL Tutorial

Price: Free

Average Rating: 3.72

Number of Lectures: 156

Number of Published Lectures: 156

Number of Curriculum Items: 156

Number of Published Curriculum Objects: 156

Original Price: Free

Quality Status: approved

Status: Live

What You Will 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.

Who Should Attend

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.

Target Audiences

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.

PHP and MySQL are incredibly powerful open source technologies that allow people to create functional websites and apps that go way beyond basic HTML. While it can seem intimidating to someone with no background in coding, working with PHP is much easier than many realize. With the right guidance and a desire to learn, most people can learn how to put together a functional web app in a few days! 

This PHP / MySQL Tutorial Video Course is narrated by Robert Tucker, a long-time trainer, lecturer and consultant who specializes in helping people learn how to use technology to solve real world problems. In this high-impact course, Robert walks users through the creation of a functional PHP / MySQL interface from beginning to end, explaining where needed the important technical points without relying on excessive jargon. This is not an overview of complex theory, but a hands-on primer that will allow even beginners to create usable solutions quickly! 

Robert shows you how to make the most from these free technologies used by everyone from small startups to the biggest technology companies in the world. 

Learn PHP and MySQL and start developing web apps like a pro! Learn PHP and MySQL and start developing web apps like a pro!

Course Curriculum

Chapter 1: Intro to Beginners PHP

Lecture 1: Working Files – Download These First

Lecture 2: Intro – What This Course Covers

Lecture 3: What We Need

Chapter 2: Getting Started

Lecture 1: Introducing XAMPP

Lecture 2: Downloading XAMPP

Lecture 3: XAMPP – Installing

Lecture 4: XAMPP – Setting Up

Lecture 5: Setting Up A PHP Editor – bluefish

Lecture 6: Introduction To bluefish

Lecture 7: The bluefish Interface

Lecture 8: bluefish Summary

Lecture 9: Downloading PHP Snippets

Lecture 10: PHP Comments

Lecture 11: Our First PHP Page

Lecture 12: Using PHP Snippets

Lecture 13: Intro To MySQL Databases

Lecture 14: Into To phpMyAdmin

Lecture 15: External Helpful Resources

Lecture 16: Exercises

Chapter 3: Our First Look At MySQL And PHP

Lecture 1: Connecting To A MySQL Database – Part 1

Lecture 2: Connecting To A MySQL Database – Part 2

Lecture 3: Our First MySQL Query – Part 1

Lecture 4: Our First MySQL Query – Part 2

Lecture 5: Creating A MySQL Database

Lecture 6: Create MySQL Tables – Part 1

Lecture 7: Create MySQL Tables – Part 2

Lecture 8: Database Structure

Lecture 9: Inserting Data in MySQL

Lecture 10: Updating MySQL Tables

Lecture 11: Updating MySQL Tables Example

Lecture 12: MySQL Delete Command

Lecture 13: Intro To Variables And Operators

Lecture 14: Arithmetic Operators

Lecture 15: Assignment Operators

Lecture 16: Comparison Operators

Lecture 17: Introduction To Arrays

Lecture 18: Numeric Arrays

Lecture 19: Associative Arrays

Lecture 20: Multi-Dimensional Arrays

Lecture 21: Creating And Working With Arrays

Lecture 22: Creating Arrays From A Text File

Lecture 23: Lesson Review

Chapter 4: Outputting And Processing Data

Lecture 1: Hiding Sensitive Data

Lecture 2: Including Sensitive Data

Lecture 3: PHP Echo And Quotes – Part 1

Lecture 4: PHP Echo And Quotes – Part 2

Lecture 5: Formatting Using sprintf

Lecture 6: Outputting Tabular Data

Lecture 7: Outputting Data And Time

Lecture 8: Introduction To Loops

Lecture 9: dowhile Loops

Lecture 10: Repetition – for Loops

Lecture 11: Repetition – foreach Loops

Lecture 12: MySQL Select

Lecture 13: Formatting Outputted MySQL Data

Lecture 14: MySQL Joins – Overview

Lecture 15: MySQL Joins

Lecture 16: MySQL Where And Order By

Chapter 5: Dealing With Variables

Lecture 1: Intro To Sending Variables

Lecture 2: Using Variables With GET

Lecture 3: Using Variables With POST

Lecture 4: Inserting Sent Data In A Database

Lecture 5: Updating A Database With Sent Data – Part 1

Lecture 6: Updating A Database With Sent Data – Part 2

Lecture 7: Redirection In PHP

Lecture 8: Creating A List – Example

Lecture 9: Styling The List – Example

Lecture 10: What We Have Learned

Chapter 6: Inserting And Using Database Data

Lecture 1: Using One Page To Process Forms – Part 1

Lecture 2: Using One Page To Process Forms – Part 2

Lecture 3: Multi Part Forms

Lecture 4: Save And Return POST and GET

Lecture 5: Save And Return INSERT

Lecture 6: Save And Return UPDATE

Lecture 7: Normalization

Lecture 8: Simple Drop Downs

Lecture 9: Complex Drop Downs

Lecture 10: Revised Form – The Code

Lecture 11: Revised Form – The Result

Lecture 12: Lesson Review

Chapter 7: MySQL Joins

Lecture 1: MySQL Join Types – Examples

Lecture 2: MySQL Join Diagrams

Lecture 3: Creating Nested Lists

Lecture 4: MySQL Nested Processing

Lecture 5: Styling Our Lists

Lecture 6: Intro To Functions

Lecture 7: Included Files

Chapter 8: PHP Errors And Security

Lecture 1: Introduction To Security And Errors

Lecture 2: Error Types – Databases

Lecture 3: PHP Error Types

Lecture 4: Custom Error Testing

Lecture 5: Create A Login Page

Instructors

Infinite Skills
High Quality Training

Rating Distribution

1 stars: 405 votes

2 stars: 434 votes

3 stars: 1680 votes

4 stars: 3437 votes

5 stars: 4631 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!