Learning Dynamic Website Design - PHP MySQL and JavaScript
Udemy
Course Summary
Learn Dynamic Web Design with PHP / MySQL, AJAX, JavaScript and CSS. Course comes with Certificate of Completion.
-
+
Course 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
-
+
Course Syllabus
- Introduction
- Working Files - Download These First
- 0101 What is PHP
- What Is MySQL?
- Simple PHP Program
- The Example Web Site - King Real Estate
- How to obtain your Certificate of Completion for this Infinite Skills course.
- Interface
- Setting Up Your Computer For PHP And MySQL
- Installing WAMP For Windows
- Installing MAMP For Macintosh - Part 1
- Installing MAMP For Macintosh - Part 2
- Using A Hosting Service
- PHP Basics
- Using PHP Script Tags
- Displaying HTML To Your Browser Window
- HTML Forms
- Using The SELECT Tag
- Using The TEXTAREA Tag
- Using The RADIOBUTTON Tag
- Using The CHECKBOX Tag
- Assigning Values To Variables
- Appending Text
- Debugging Techniques - Part 1
- Assignment 1
- Assignment 1 - Solution
- PHP Programming Fundamentals
- String Delimiters
- Simple Math
- HTML Tables
- Using IF Statements
- The ELSE Clause
- Nested IFs
- Code Formatting Rules
- Comparison Operators
- Using AND
- Using OR
- Using NOT
- Field Validations
- Using DIVs
- Using DIVs And Forms
- Debugging Techniques - Part 2
- Assignment 2
- Assignment 2 - Solution
- Advanced PHP Constructs
- The FOR Loop
- The WHILE Loop
- Reading A File
- Writing To A File
- Displaying A Data From A File Into An HTML Table
- Debugging Techniques - Part 3
- Assignment 3
- Assignment 3 - Solution
- Functions, Arrays, And Strings
- Simple Function
- Functions That Receives Data
- Functions That Returns A Value
- Functions That Receives Data And Returns A Value
- Variable Scope
- Functions That Returns Multiple Values
- Using Include Files
- Array Basics
- Sorting Arrays
- Loading An Array From A File
- Loading An Array From A Directory
- Recursive Programming
- Finding Text
- Finding Text With Regular Expressions
- Finding Simple Patterns Using Regular Expressions
- Debugging Techniques - Part 4
- Assignment 4
- Assignment 4 - Solution
- Introduction To MySQL
- Introduction To SQL
- The Example Database
- Interactive MySQL
- Creating Tables
- Simple SELECT Statement
- Comparison Operators
- Logical Operators
- Selecting Nulls
- Sorting Results
- Aggregate Functions
- Pattern Matching
- Inserting Rows
- Updating Table Data
- Deleting Rows
- SQL Debugging Techniques - Part 5
- Assignment 5
- Assignment 5 - Solution
- PHP With MySQL
- 0801 Connecting To MySQL Within A PHP Program
- 0802 Pass Data To A Select
- 0803 Adding Rows To A Table
- 0804 Deleting Rows From A Table
- 0805 Updating Data In A Table
- 0806 Populating A Select-Option List
- 0807 Login Validation
- Relative Referencing
- Creating Tables With phpMyAdmin
- Inserting Data With phpMyAdmin
- 0811 Common Database Functions
- 0812 Debugging Techniques - Part 6
- Assignment 6
- Assignment 6 - Solution - Part 1
- Assignment 6 - Solution - Part 2
- PHP With Advanced MySQL
- Date Functions
- Using Indexes
- Grouping Data
- HAVING Clause
- Joining Tables - Part 1
- Joining Tables - Part 2
- Joining Tables - Part 3
- Subqueries - Part 1
- Subqueries - Part 2
- Assignment 7
- Assignment 7 - Solution
- PHP With CSS, JavaScript And Ajax
- Basic JavaScript Syntax
- Validating A Form Field With JavaScript
- Positioning A DIV With JavaScript
- 1004 Parsing Multiple Values With Java Script
- Using Simple AJAX
- Using Ajax To Update A Form In Place
- Using Ajax To Show SQL Results In Place
- Using Ajax To Update The Database
- Debugging Techniques - Part 8
- Assignment 8
- Assignment 8 - Solution - Part 1
- Assignment 8 - Solution - Part 2
- Assignment 8 - Solution - Part 3
- Conclusion
- Server-Side Solutions
- Security Considerations
- Sending Email With PHP (Simple Mail Program)
- Next Steps