Php And Mysql Beginner To Developer - 2 Projects Included

To the point PHP & MySQL course for beginners and people wanting to learn how to create dynamic web apps with php/mysql.

What you'll learn
Learn PHP
Learn SQL
Learn MySQL
Learn how to use PHP with MySQL
Learn how to create custom php & mysql web apps
Learn how to upload your php/mysql website online so that everyone can access it
Requirements
Basic html and css knowledge is assumed
A text editor or an IDE that supports PHP
Windows OS is assumed (PHP installation is done and shown on Windows only, you can of course use a Mac but you will need to install PHP yourself, suggestions for that are given)
Description
The only course you need to learn how to use PHP and MySQL. Absolutely no PHP/MySQL knowledge is either assumed or required.Go from a complete beginner to PHP/MySQL developer! This course takes you from complete beginning (installing php) to creating 2 projects and showing you how to get your php/mysql website online!Great for both beginner programmers and PHP enthusiasts.Every single thing is done from scratch and on video!This is a no-nonsense and to the point course designed to teach beginner programmers and others who want to learn php and mysql and how php and mysql work in practice.Covers PHP versions 5.6 and 7.Learn PHP,SQL,MySQL, how to use PHP with MySQL and then use that knowledge to create 2 projects, all in one course!Learn and understand how PHP and MySQL work in practice.
Learn from complete beginning up to getting your dynamic website online!NOTE: If the current asking price is too much for you feel free to message me for a discount!

Overview

Section 1: Course Introductio

Lecture 1 Course overview

Section 2: PHP

Lecture 2 setting up php on windows

Lecture 3 the root folder www

Lecture 4 setting up the project root

Lecture 5 bare basics

Lecture 6 variables

Lecture 7 superglobals and constants

Lecture 8 numbers 1

Lecture 9 numbers 2

Lecture 10 strings 1

Lecture 11 strings 2

Lecture 12 logical and comparison operators

Lecture 13 conditionals

Lecture 14 loops

Lecture 15 arrays 1

Lecture 16 arrays 2

Lecture 17 functions 1

Lecture 18 functions 2

Lecture 19 post 1

Lecture 20 post 2

Lecture 21 sticky form

Lecture 22 get

Lecture 23 error reporting

Lecture 24 external files

Lecture 25 date and time

Lecture 26 http headers

Lecture 27 ob

Lecture 28 cookies

Lecture 29 sessions

Lecture 30 files and dirs

Lecture 31 uploading 1

Lecture 32 uploading 2

Lecture 33 uploading 3

Lecture 34 type casting

Lecture 35 php 7 - new features

Section 3: SQL & MySQL

Lecture 36 mysql intro

Lecture 37 creating dbs and tables with sql

Lecture 38 creating dbs and tables with phpmyadmin gui

Lecture 39 insert with sql and gui

Lecture 40 selecting

Lecture 41 update delete rows and copy and empty tables

Lecture 42 table relationships

Lecture 43 foreign keys

Lecture 44 inner joins and aliases

Lecture 45 left, right and full joins

Lecture 46 indexes

Lecture 47 sql dumps

Lecture 48 fulltext searches

Lecture 49 transactions

Section 4: PHP & MyQSL

Lecture 50 connect to db with php

Lecture 51 create

Lecture 52 read

Lecture 53 update and delete

Lecture 54 transactions with php and mysql

Lecture 55 pagination 1

Lecture 56 pagination 2

Lecture 57 pagination 3

Lecture 58 pagination 4

Section 5: Project 1: CMS

Lecture 59 db and db conn

Lecture 60 templates

Lecture 61 db conn and home page

Lecture 62 admin 1

Lecture 63 admin 2

Lecture 64 admin 3

Lecture 65 admin 4

Lecture 66 admin 5

Lecture 67 admin 6

Lecture 68 front

Lecture 69 admin login

Lecture 70 final touches

Section 6: Project 2: Shopping Cart

Lecture 71 shopping cart 1

Lecture 72 shopping cart 2

Lecture 73 shopping cart 3

Lecture 74 shopping cart 4

Section 7: Bonus Videos

Lecture 75 Get your website online

Lecture 76 Bonus Material

Beginner programmers wanting to learn PHP and MySQL to develop dynamic websites,Non programmers wanting to learn PHP as their first language