uCertify

Developing Websites using PHP/ MYSQL

(MDC-COP2842.AB1)
Lessons
Lab
TestPrep
AI Tutor (Add-on)
Instructor-Led (Add-on)
Get A Free Trial

Skills You’ll Get

Get the support you need. Enroll in our Instructor-Led Course.

Download Course Outline

1

What Is Web Publishing?

  • Thinking Like a Web Publisher
  • Web Browsers
  • Web Servers
  • Uniform Resource Locators
  • Defining Web Publishing Broadly
  • Summary
  • Workshop
  • Additional Exercises
2

Getting Your Tools in Order

  • Anatomy of a Website
  • Setting Up Your Computer for Web Publishing
  • Using the Google Chrome Developer Tools
  • What Do You Want to Do on the Web?
  • Wireframing Your Website
  • Web Hosting
  • Summary
  • Workshop
  • Additional Exercises
3

Introducing HTML and CSS

  • What HTML Is (And What It Isn't)
  • What HTML Files Look Like
  • HTML Attributes
  • Using the style Attribute
  • A Short History of HTML Standards
  • The Current and Evolving Standard: HTML5
  • Summary
  • Workshop
  • Additional Exercises
4

Learning the Basics of HTML

  • Structuring Your HTML
  • The Title
  • Headings
  • Paragraphs
  • Comments
  • Summary
  • Workshop
  • Additional Exercises
5

Organizing Information with Lists

  • Lists: An Overview
  • Numbered Lists
  • Unordered Lists
  • Definition Lists
  • Nesting Lists
  • Other Uses for Lists
  • Summary
  • Workshop
  • Additional Exercises
6

Working with Links

  • Creating Links
  • Linking Local Pages Using Relative and Absolute Pathnames
  • Links to Other Documents on the Web
  • Linking to Specific Places Within Documents
  • Anatomy of a URL
  • Kinds of URLs
  • Summary
  • Workshop
  • Additional Exercises
7

Formatting Text with HTML and CSS

  • Character-Level Elements
  • Character Formatting Using CSS
  • Preformatted Text
  • Horizontal Rules (or Thematic Breaks)
  • Line Break
  • Addresses
  • Quotations
  • Special Characters
  • Fonts and Font Sizes
  • Summary
  • Workshop
  • Additional Exercises
8

Using CSS to Style a Site

  • Including Style Sheets in a Page
  • Selectors
  • Units of Measure
  • Editing Styles with Developer Tools
  • Using Color
  • Links
  • The Box Model
  • More Selectors
  • The <body> Tag
  • Summary
  • Workshop
  • Additional Exercises
9

Structuring a Page with HTML5

  • A Short History of HTML Page Layout
  • Laying Out a Page in HTML5
  • HTML5 Structural Tags
  • The Page Outline
  • Using HTML5 Structural Elements
  • Summary
  • Workshop
  • Additional Exercises
10

Installing Apache, PHP, and MySQL

  • Installing Apache, PHP, and MySQL Under UNIX
  • Installing Apache, PHP, and MySQL for Windows and Mac OS X Using All-in-One Installation Packages
  • Installing PEAR
  • Installing PHP with Other Web Servers
11

PHP Crash Course

  • Before You Begin: Accessing PHP
  • Creating a Sample Application: Bob's Auto Parts
  • Embedding PHP in HTML
  • Adding Dynamic Content
  • Accessing Form Variables
  • Understanding Identifiers
  • Examining Variable Types
  • Declaring and Using Constants
  • Understanding Variable Scope
  • Using Operators
  • Working Out the Form Totals
  • Understanding Precedence and Associativity
  • Using Variable Handling Functions
  • Making Decisions with Conditionals
  • Repeating Actions Through Iteration
  • Breaking Out of a Control Structure or Script
  • Employing Alternative Control Structure Syntax
  • Using declare
  • Next
  • Programming Exercises
12

Reusing Code and Writing Functions

  • The Advantages of Reusing Code
  • Using require() and include()
  • Using Functions in PHP
  • Defining Your Own Functions
  • Examining Basic Function Structure
  • Using Parameters
  • Understanding Scope
  • Passing by Reference Versus Passing by Value
  • Using the return Keyword
  • Implementing Recursion
  • Further Reading
  • Next
  • Programming Exercises
13

String Manipulation and Regular Expressions

  • Creating a Sample Application: Smart Form Mail
  • Formatting Strings
  • Joining and Splitting Strings with String Functions
  • Comparing Strings
  • Matching and Replacing Substrings with String Functions
  • Introducing Regular Expressions
  • Finding Substrings with Regular Expressions
  • Replacing Substrings with Regular Expressions
  • Splitting Strings with Regular Expressions
  • Further Reading
  • Next
  • Programming Exercises
14

Using Arrays

  • What Is an Array?
  • Numerically Indexed Arrays
  • Arrays with Different Indices
  • Array Operators
  • Multidimensional Arrays
  • Sorting Arrays
  • Sorting Multidimensional Arrays
  • Reordering Arrays
  • Loading Arrays from Files
  • Performing Other Array Manipulations
  • Further Reading
  • Next
  • Programming Exercises
15

Storing and Retrieving Data

  • Saving Data for Later
  • Storing and Retrieving Bob's Orders
  • Processing Files
  • Opening a File
  • Writing to a File
  • Closing a File
  • Reading from a File
  • Using Other File Functions
  • Locking Files
  • A Better Way: Databases
  • Further Reading
  • Next
  • Programming Exercises
16

Designing Your Web Database

  • Relational Database Concepts
  • Designing Your Web Database
  • Web Database Architecture
  • Further Reading
  • Next
17

Creating Your Web Database

  • Using the MySQL Monitor
  • Logging In to MySQL
  • Creating Databases and Users
  • Setting Up Users and Privileges
  • Introducing MySQL's Privilege System
  • Setting Up a User for the Web
  • Using the Right Database
  • Creating Database Tables
  • Understanding MySQL Identifiers
  • Choosing Column Data Types
  • Further Reading
  • Next
  • Programming Exercises
18

Working with Your MySQL Database

  • What Is SQL?
  • Inserting Data into the Database
  • Retrieving Data from the Database
  • Updating Records in the Database
  • Altering Tables After Creation
  • Deleting Records from the Database
  • Dropping Tables
  • Dropping a Whole Database
  • Further Reading
  • Next
  • Programming Exercises
19

Accessing Your MySQL Database from the Web with PHP

  • How Web Database Architectures Work
  • Querying a Database from the Web
  • Putting New Information in the Database
  • Using Other PHP-Database Interfaces
  • Further Reading
  • Next
  • Programming Exercises
20

Building a Secure Web Application

  • Strategies for Dealing with Security
  • Securing Your Code
  • Securing Your Web Server and PHP
  • Database Server Security
  • Protecting the Network
  • Computer and Operating System Security
  • Disaster Planning
  • Next
  • Programming Exercises
21

How to Publish Your Site

  • What Does a Web Server Do?
  • How to Find Web Hosting
  • Organizing Your HTML Files for Publishing
  • Publishing Your Files
  • Troubleshooting
  • Promoting Your Web Pages
  • Finding Out Who's Viewing Your Web Pages
  • Summary
  • Workshop
  • Additional Exercises

1

Introducing HTML and CSS

  • Creating a Basic HTML Page
2

Learning the Basics of HTML

  • Using Paragraphs and Headings in HTML
3

Organizing Information with Lists

  • Organizing Content in HTML
4

Working with Links

  • Creating Hyperlinks
5

Formatting Text with HTML and CSS

  • Formatting Text in HTML
6

Using CSS to Style a Site

  • Creating the External Style Sheet
  • Using CSS IDs
  • Implementing a Class
  • Creating an Internal Style Sheet
  • Implementing Inline Styles
  • Using Positioned Floats
  • Using Overflow Properties
7

Structuring a Page with HTML5

  • Using the Header and Footer Tags
  • Using the Nav Tag
  • Using the Article Tag
  • Using the Section Tag
  • Using the Aside and Hr Tags
8

PHP Crash Course

  • Creating a Form
  • Declaring Constants
  • Using Arithmetic Operators
  • Concatenating Strings
  • Using the Ternary Operator
  • Using the Type Operator
  • Creating an Output Form
  • Using the if Statement
  • Using the if-else Statement
  • Using the switch Statement
  • Using the while Loop
  • Using the for Loop
  • Using the foreach Loop
  • Using the do-while Loop
9

Reusing Code and Writing Functions

  • Reusing the Code
  • Creating a Function
  • Using the Pass by Reference
  • Reversing a String Using Recursion and Iteration
10

String Manipulation and Regular Expressions

  • Creating a Dynamic Form
  • Splitting Strings with Regular Expressions
11

Using Arrays

  • Creating an Array
  • Inserting and Retrieving Values from an Array Using the foreach Loop
  • Creating a Multi-dimensional Array
  • Sorting an Array
  • Generating a Random Value
  • Loading Arrays from a File
12

Storing and Retrieving Data

  • Opening and Reading a File
13

Creating Your Web Database

  • Creating a Table
14

Working with Your MySQL Database

  • Inserting Values into a Table
  • Retrieving All the Attribute Values Using an Asterisk
  • Retrieving the Data from Multiple Tables
  • Retrieving the Data in Sorted Order
  • Using Aggregate Functions
  • Using the GROUP BY and HAVING Clauses
  • Retrieving the Limited Number of Rows from the Table
  • Using the NOT IN Operator
  • Updating a Table
  • Modifying a Table Definition
  • Dropping a Table

Any questions?
Check out the FAQs

Still have unanswered questions and need to get in touch?

Contact Us Now

Related Courses

All Courses
We use cookies for improving site experience and analytics. Learn More