PHP and MySQL Full Course

#education #edutainment #programming #freelancing #beyourownboss

00:00:00 - Intro
00:03:55 - XAMPP Install
00:09:37 - My first PHP Code
00:16:47 - Escaping Characters
00:20:00 - Error Reporting
00:24:33 - Comments
00:31:19 - Variables
00:35:51 - Strings
00:39:08 - Numbers
00:44:39 - Constants
00:48:15 - Arrays
00:55:06 - Associative Arrays
00:58:09 - Access Array with Foreach
01:02:58 - Multidimensional Arrays
01:08:53 - Operators
01:11:02 - If Else
01:20:56 - Else If
01:23:59 - For Loop
01:28:29 - While Loop
01:31:55 - Switch
01:39:07 - Creating a Form
01:52:04 - Post, Get, Request
02:06:03 - Handling a Form
02:16:31 - Include and Require
02:24:34 - Creating a Dynamic Website
02:42:14 - Storing Sections in Variables
02:51:24 - Functions
02:59:09 - Variable Scope
03:02:21 - MySQL Intro
03:06:39 - Creating a Database
03:19:08 - Database Form
03:24:55 - Database Connection
03:34:11 - Minimal Form Validation
03:52:47 - Inserting Values Into a Database
04:06:53 - Output Records from a Database
04:17:37 - Output Records by Specific Order
04:31:29 - Login Script
04:51:42 - Security Functions
04:55:09 - Update Records from a Database
05:29:16 - Delete Records from a Database
05:46:29 - Passing Values Through URL
06:14:30 - Delete User from Database
06:30:15 - Edit User Passing Values Through Url
06:44:18 - Reorganizing the Code
06:59:12 - Pagination

Hey everyone! Yes, I know that this is a music channel, but I had the rare opportunity to purchase my programming mentor’s business. In 2014, I began to learn how to code for the purposes of making a game but ultimately decided to not follow through on selling those games. I originally learned how to program from my mentor, who was a web developer that happened to be an Udemy instructor at the time. My mentor hired me, after I messaged him on LinkedIn, for a few jobs and I’d like to think we’ve had a positive relationship ever since. I have long since become my own web dev and tech enthusiast, and while I no longer seek answers from him I hold him in a high regard.

A few weeks before the release of these programming and freelancing videos, my mentor contacted me to see if I wanted to purchase his business. He hired myself and others to make these videos, so I take pride in being able to take advantage of this opportunity, gladly deciding to pick up that edutainment mantle even if it would be for a short bit (as I do not plan to add to this collection). I intend on making all of the courses that were created available on YouTube, that way people can have yet another source to learn how to program and run their business for free.

Did it cost me a lot of money and legal conferences for a few weeks? Yeah, but I honestly think it’s worth it to not only help my mentor out but to make educational material free. So, while I know this is a music channel, this is also where I'm going to put the courses that I got from my mentor :)

For 5GB worth of Web Dev Care Kit, check out https://sinithwar.gumroad.com/l/vrxjsb . It's $2 because it's over 250MB, but there's a ton of stuff in there.

If you’d like to support me, please check out my music.
https://open.spotify.com/artist/0OCiIlqMBsOWR6cjhDI2dY?si=pP8H7YCZSce_MGumBKVhmA
or
https://sinithwar.bandcamp.com/

Disclaimer: This course was not made by me and was inherited. I do not agree to any claims or promises in the video. This video is purely here to provide a free learning resources.