Learning Dynamic Website Design - Php Mysql And Javascript

Learn Dynamic Web Design with PHP / MySQL, AJAX, JavaScript and CSS. Course comes with Certificate of Completion.

What you'll learn
Requirements
Description
A Verifiable Certificate of Completion is presented to all students who undertake this course. This Dynamic Web Design with PHP and MySQL training course will give you a working understanding of these important technologies and show you how to use them to create your own impressive websites. When used in combination, there simply isn't a better way to construct sites that involve complexity, large volumes of data, and the flexibility to make adjustments and changes over time. This course goes step by step through the basics of each technology, and then gradually shows you how to build the necessary components and underlying framework of your site. It goes through installation of PHP and MySQL technologies on your local machine as well as hosted servers, explains basic tags, commands and constructs, and helps you build and work within a solid back-end database. One you have the basics of PHP and MySQL covered, you'll also learn how to use CSS, JavaScript and AJAX to create the visual style and added functionality your pages deserve.   What You Will Learn - How to build functional, full-featured websites that utilize MySQL, PHP and other current web development technologies. - How to install, configure and modify functional PHP constructs and MySQL databases for the web. - How to pair a secure PHP / MySQL backend of a website with a compelling visual interface made with CSS, AJAX, and JavaScript code. - The basic principles and best practices of PHP and MySQL in a relevant, real world project.   Who Should Take This Course - Individuals and small business owners interested in creating their own fully featured websites with total control over data management, functionality and visual appearance. - Web developers and programmers looking to learn a new language and set of standards. - Anyone who has used basic CMS or templates to create basic websites in the past but want much more control. - Anyone who has tried to learn PHP or MySQL in the past but found it difficult due to a lack of practical examples.   What People Are Saying "Have to say I was nervous at first, but the authors explanations were very well laid out and crystal clear. The site is coming together nicely." -Ben Jeffries "A PHP tutorial that is up to date with current standards…very easy to follow." -Breck Defontes "I come from a design background but I wanted to beef up my knowledge of basic code. This was a nice and easy primer, thanks." -Angela Redberg

Overview

Section 1: Introduction

Lecture 1 Working Files - Download These First

Lecture 2 0101 What is PHP

Lecture 3 What Is MySQL?

Lecture 4 Simple PHP Program

Lecture 5 The Example Web Site - King Real Estate

Section 2: Interface

Lecture 6 Setting Up Your Computer For PHP And MySQL

Lecture 7 Installing WAMP For Windows

Lecture 8 Installing MAMP For Macintosh - Part 1

Lecture 9 Installing MAMP For Macintosh - Part 2

Lecture 10 Using A Hosting Service

Section 3: PHP Basics

Lecture 11 Using PHP Script Tags

Lecture 12 Displaying HTML To Your Browser Window

Lecture 13 HTML Forms

Lecture 14 Using The SELECT Tag

Lecture 15 Using The TEXTAREA Tag

Lecture 16 Using The RADIOBUTTON Tag

Lecture 17 Using The CHECKBOX Tag

Lecture 18 Assigning Values To Variables

Lecture 19 Appending Text

Lecture 20 Debugging Techniques - Part 1

Lecture 21 Assignment 1

Lecture 22 Assignment 1 - Solution

Section 4: PHP Programming Fundamentals

Lecture 23 String Delimiters

Lecture 24 Simple Math

Lecture 25 HTML Tables

Lecture 26 Using IF Statements

Lecture 27 The ELSE Clause

Lecture 28 Nested IFs

Lecture 29 Code Formatting Rules

Lecture 30 Comparison Operators

Lecture 31 Using AND

Lecture 32 Using OR

Lecture 33 Using NOT

Lecture 34 Field Validations

Lecture 35 Using DIVs

Lecture 36 Using DIVs And Forms

Lecture 37 Debugging Techniques - Part 2

Lecture 38 Assignment 2

Lecture 39 Assignment 2 - Solution

Section 5: Advanced PHP Constructs

Lecture 40 The FOR Loop

Lecture 41 The WHILE Loop

Lecture 42 Reading A File

Lecture 43 Writing To A File

Lecture 44 Displaying A Data From A File Into An HTML Table

Lecture 45 Debugging Techniques - Part 3

Lecture 46 Assignment 3

Lecture 47 Assignment 3 - Solution

Section 6: Functions, Arrays, And Strings

Lecture 48 Simple Function

Lecture 49 Functions That Receives Data

Lecture 50 Functions That Returns A Value

Lecture 51 Functions That Receives Data And Returns A Value

Lecture 52 Variable Scope

Lecture 53 Functions That Returns Multiple Values

Lecture 54 Using Include Files

Lecture 55 Array Basics

Lecture 56 Sorting Arrays

Lecture 57 Loading An Array From A File

Lecture 58 Loading An Array From A Directory

Lecture 59 Recursive Programming

Lecture 60 Finding Text

Lecture 61 Finding Text With Regular Expressions

Lecture 62 Finding Simple Patterns Using Regular Expressions

Lecture 63 Debugging Techniques - Part 4

Lecture 64 Assignment 4

Lecture 65 Assignment 4 - Solution

Section 7: Introduction To MySQL

Lecture 66 Introduction To SQL

Lecture 67 The Example Database

Lecture 68 Interactive MySQL

Lecture 69 Creating Tables

Lecture 70 Simple SELECT Statement

Lecture 71 Comparison Operators

Lecture 72 Logical Operators

Lecture 73 Selecting Nulls

Lecture 74 Sorting Results

Lecture 75 Aggregate Functions

Lecture 76 Pattern Matching

Lecture 77 Inserting Rows

Lecture 78 Updating Table Data

Lecture 79 Deleting Rows

Lecture 80 SQL Debugging Techniques - Part 5

Lecture 81 Assignment 5

Lecture 82 Assignment 5 - Solution

Section 8: PHP With MySQL

Lecture 83 0801 Connecting To MySQL Within A PHP Program

Lecture 84 0802 Pass Data To A Select

Lecture 85 0803 Adding Rows To A Table

Lecture 86 0804 Deleting Rows From A Table

Lecture 87 0805 Updating Data In A Table

Lecture 88 0806 Populating A Select-Option List

Lecture 89 0807 Login Validation

Lecture 90 Relative Referencing

Lecture 91 Creating Tables With phpMyAdmin

Lecture 92 Inserting Data With phpMyAdmin

Lecture 93 0811 Common Database Functions

Lecture 94 0812 Debugging Techniques - Part 6

Lecture 95 Assignment 6

Lecture 96 Assignment 6 - Solution - Part 1

Lecture 97 Assignment 6 - Solution - Part 2

Section 9: PHP With Advanced MySQL

Lecture 98 Date Functions

Lecture 99 Using Indexes

Lecture 100 Grouping Data

Lecture 101 HAVING Clause

Lecture 102 Joining Tables - Part 1

Lecture 103 Joining Tables - Part 2

Lecture 104 Joining Tables - Part 3

Lecture 105 Subqueries - Part 1

Lecture 106 Subqueries - Part 2

Lecture 107 Assignment 7

Lecture 108 Assignment 7 - Solution

Section 10: PHP With CSS, JavaScript And Ajax

Lecture 109 Basic JavaScript Syntax

Lecture 110 Validating A Form Field With JavaScript

Lecture 111 Positioning A DIV With JavaScript

Lecture 112 1004 Parsing Multiple Values With Java Script

Lecture 113 Using Simple AJAX

Lecture 114 Using Ajax To Update A Form In Place

Lecture 115 Using Ajax To Show SQL Results In Place

Lecture 116 Using Ajax To Update The Database

Lecture 117 Debugging Techniques - Part 8

Lecture 118 Assignment 8

Lecture 119 Assignment 8 - Solution - Part 1

Lecture 120 Assignment 8 - Solution - Part 2

Lecture 121 Assignment 8 - Solution - Part 3

Section 11: Conclusion

Lecture 122 Server-Side Solutions

Lecture 123 Security Considerations

Lecture 124 Sending Email With PHP (Simple Mail Program)

Lecture 125 Next Steps