MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

Beginner PHP and MySQL Tutorial

Course Summary

Learn PHP and MySQL and start developing web apps like a pro! This course also comes with a Certificate of Completion.


  • +

    Course Syllabus

    • Intro to Beginners PHP
      • Working Files - Download These First
      • Intro - What This Course Covers
      • What We Need
      • How to obtain your Certificate of Completion for this Infinite Skills course.
    • Getting Started
      • Introducing XAMPP
      • Downloading XAMPP
      • XAMPP - Installing
      • XAMPP - Setting Up
      • Setting Up A PHP Editor - bluefish
      • Introduction To bluefish
      • The bluefish Interface
      • bluefish Summary
      • Downloading PHP Snippets
      • PHP Comments
      • Our First PHP Page
      • Using PHP Snippets
      • Intro To MySQL Databases
      • Into To phpMyAdmin
      • External Helpful Resources
      • Exercises
    • Our First Look At MySQL And PHP
      • Connecting To A MySQL Database - Part 1
      • Connecting To A MySQL Database - Part 2
      • Our First MySQL Query - Part 1
      • Our First MySQL Query - Part 2
      • Creating A MySQL Database
      • Create MySQL Tables - Part 1
      • Create MySQL Tables - Part 2
      • Database Structure
      • Inserting Data in MySQL
      • Updating MySQL Tables
      • Updating MySQL Tables Example
      • MySQL Delete Command
      • Intro To Variables And Operators
      • Arithmetic Operators
      • Assignment Operators
      • Comparison Operators
      • Introduction To Arrays
      • Numeric Arrays
      • Associative Arrays
      • Multi-Dimensional Arrays
      • Creating And Working With Arrays
      • Creating Arrays From A Text File
      • Lesson Review
    • Outputting And Processing Data
      • Hiding Sensitive Data
      • Including Sensitive Data
      • PHP Echo And Quotes - Part 1
      • PHP Echo And Quotes - Part 2
      • Formatting Using sprintf
      • Outputting Tabular Data
      • Outputting Data And Time
      • Introduction To Loops
      • do...while Loops
      • Repetition - for Loops
      • Repetition - foreach Loops
      • MySQL Select
      • Formatting Outputted MySQL Data
      • MySQL Joins - Overview
      • MySQL Joins
      • MySQL Where And Order By
    • Dealing With Variables
      • Intro To Sending Variables
      • Using Variables With GET
      • Using Variables With POST
      • Inserting Sent Data In A Database
      • Updating A Database With Sent Data - Part 1
      • Updating A Database With Sent Data - Part 2
      • Redirection In PHP
      • Creating A List - Example
      • Styling The List - Example
      • What We Have Learned
    • Inserting And Using Database Data
      • Using One Page To Process Forms - Part 1
      • Using One Page To Process Forms - Part 2
      • Multi Part Forms
      • Save And Return POST and GET
      • Save And Return INSERT
      • Save And Return UPDATE
      • Normalization
      • Simple Drop Downs
      • Complex Drop Downs
      • Revised Form - The Code
      • Revised Form - The Result
      • Lesson Review
    • MySQL Joins
      • MySQL Join Types - Examples
      • MySQL Join Diagrams
      • Creating Nested Lists
      • MySQL Nested Processing
      • Styling Our Lists
      • Intro To Functions
      • Included Files
    • PHP Errors And Security
      • Introduction To Security And Errors
      • Error Types - Databases
      • PHP Error Types
      • Custom Error Testing
      • Create A Login Page
      • Passwords For Login
      • Protecting Pages
      • Using Cookies - Theory
      • Using Cookies - Practice
      • Access Levels - Basic Restriction
      • Access Levels - Restrict Fields
      • Managing Users - Structure
      • Managing Users - Create New
      • Audit Trails - Access Function
      • Audit Trails - Logging Logins
      • Errors And Security - Review
    • Building A Template Page
      • PHP Templates
      • Building Our PHP Template CSS/HTML
      • Creating Template Menu
      • Create Template Login Script
      • Template Logout Script
      • CMS Switch Statement
      • Building Our CMS
      • Setting up our CMS Content
      • Complete CMS Module
      • Review And Exercise
    • PHP Functions
      • Function Structure
      • Built In Functions Maths And Strings
      • Built In Functions Date And Time
      • Custom Functions
      • Format With Functions
      • Email Address Checking
      • Database Functions
      • Array Functions - sort And unique
      • Array Functions - search, slice And merge
      • Server Variables
      • Browser Detection
    • Using External Files, And Images
      • Reading Text Files
      • Writing Text Files
      • Working With Image Files - exif
      • Creating Image Files With GD Library
      • Managing Images With GD Library
      • Resizing Images With PHP
      • Uploading Files - Overview
      • Uploading Files - In Action
      • Remote File Parsing
    • Email With PHP
      • Email With PHP And MySQL
      • Sendmail SMTP Server
      • Sendmail mail Function
      • PHP mail CC And BCC
      • HTML email Content
      • Email Out - Hiding SMTP Address
      • Email Out - Embedded Form
      • Logging Sent Email
    • Real Life PHP Introduction
      • Real Life Introduction
      • Building PHP Tools - Button Maker
      • Building PHP Tools - Embedded Tool
      • Managing Deletions - Suspension Fields
      • Managing Deletions - Suspend Record
      • Managing Deletions - Restore Records
      • OO Programming - A Caveat
      • OO Programming Model - DB Connection
      • OO Programming - DB Examples
      • CMS Open Source
      • CMS Joomla
      • CRM Download And Extract
      • CRM vTiger Install
      • CRM Modifying vTiger
    • About The Author
      • About The Author


Course Fee:
Free

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top