Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

Overview

In this PHP - MYSQL training course you will learn how to leverage PHP and MySQL for your website development to create dynamic, interactive websites. This training is designed for the savvy developer, you should have some experience with programming languages, and familiarity with PHP and MySQL, as well as HTML. Author Steve Perry starts with some basics on PHP, and integrating it into a website form. The tutorial continues on with some PHP programming fundamentals, covering the most often used functions - IF, ELSE, AND, OR, NOT, and others. You then cover looping, arrays and functions. As you continue on in this video training course, you cover the basics of MySQL - adding, deleting and updating data to tables. You will then combine PHP and MySQL together for managing your data. You finish off with some CSS, JavaScript and Ajax integration to bring it all together to make your site interactive. Throughout this video tutorial, you will complete assignments that will help you apply everything you are learning along the way. By the end of this video course, you will have a solid understanding of how to apply PHP and MySQL together to create a dynamic website. Extensive working files are provided to allow you to follow along and create a project with the author in this Dynamic Web Design Course with PHP and MySQL.

Subscriber Reviews

Average Rating: 4.428571428571429 out of 5 rating Based on 7 Ratings

No Subscribers have provided a review for this video.

Table of Contents

Chapter/Selection

Time

01. Introduction

What Is PHP?

Preview

00:04:33

What Is MySQL?

Preview

00:02:39

Simple PHP Program

Preview

00:06:27

The Example Web Site - King Real Estate

Preview

00:03:54

02. Interface

Setting Up Your Computer For PHP And MySQL

Preview

00:04:01

Installing WAMP For Windows

Preview

00:07:03

Installing MAMP For Macintosh - Part 1

Preview

00:03:57

Installing MAMP For Macintosh - Part 2

Preview

00:02:28

Using A Hosting Service

Preview

00:06:38

03. PHP Basics

Using PHP Script Tags

Play Video

00:04:00

Displaying HTML To Your Browser Window

Preview

00:07:47

HTML Forms

Preview

00:10:13

Using The SELECT Tag

Play Video

00:06:19

Using The TEXTAREA Tag

Preview

00:06:46

Using The RADIOBUTTON Tag

Preview

00:04:08

Using The CHECKBOX Tag

Preview

00:05:35

Assigning Values To Variables

Preview

00:04:49

Appending Text

Preview

00:04:12

Debugging Techniques - Part 1

Preview

00:07:21

Assignment 1

Preview

00:04:12

Assignment 1 - Solution

Preview

00:05:48

04. PHP Programming Fundamentals

String Delimiters

Preview

00:07:47

Simple Math

Preview

00:05:29

HTML Tables

Play Video

00:07:53

Using IF Statements

Preview

00:04:15

The ELSE Clause

Preview

00:04:44

Nested IFs

Preview

00:05:40

Code Formatting Rules

Play Video

00:05:24

Comparison Operators

Preview

00:08:17

Using AND

Preview

00:04:38

Using OR

Preview

00:04:26

Using NOT

Preview

00:05:39

Field Validations

Preview

00:06:52

Using DIVs

Preview

00:08:31

Using DIVs And Forms

Preview

00:03:17

Debugging Techniques - Part 2

Preview

00:10:00

Assignment 2

Preview

00:04:39

Assignment 2 - Solution

Preview

00:10:16

05. Advanced PHP Constructs

The for Loop

Preview

00:07:34

The while Loop

Preview

00:09:01

Reading A File

Preview

00:08:29

Writing To A File

Preview

00:07:44

Displaying A Data From A File Into An HTML Table

Play Video

00:12:55

Debugging Techniques - Part 3

Preview

00:07:58

Assignment 3

Preview

00:05:33

Assignment 3 - Solution

Preview

00:08:56

06. Functions, Arrays, And Strings

Simple Function

Preview

00:02:37

Functions That Receives Data

Preview

00:03:30

Functions That Returns A Value

Preview

00:02:28

Functions That Receives Data And Returns A Value

Play Video

00:06:20

Variable Scope

Preview

00:07:19

Functions That Returns Multiple Values

Preview

00:06:49

Using Include Files

Preview

00:04:16

Array Basics

Preview

00:07:52

Sorting Arrays

Preview

00:06:14

Loading An Array From A File

Play Video

00:02:09

Loading An Array From A Directory

Preview

00:06:18

Recursive Programming

Preview

00:08:57

Finding Text

Preview

00:06:47

Finding Text With Regular Expressions

Preview

00:05:11

Finding Simple Patterns Using Regular Expressions

Preview

00:07:59

Debugging Techniques - Part 4

Preview

00:08:03

Assignment 4

Preview

00:05:40

Assignment 4 - Solution

Preview

00:09:18

07. Introduction To MySQL

Introduction To SQL

Preview

00:09:46

The Example Database

Preview

00:06:50

Interactive MySQL

Preview

00:07:20

Creating Tables

Preview

00:08:19

Simple SELECT Statement

Preview

00:05:38

Comparison Operators

Play Video

00:05:40

Logical Operators

Preview

00:05:56

Selecting Nulls

Preview

00:02:05

Sorting Results

Preview

00:05:46

Aggregate Functions

Preview

00:06:37

Pattern Matching

Preview

00:05:14

Inserting Rows

Preview

00:04:05

Updating Table Data

Preview

00:05:14

Deleting Rows

Preview

00:01:56

SQL Debugging Techniques - Part 5

Preview

00:05:38

Assignment 5

Preview

00:02:53

Assignment 5 - Solution

Preview

00:03:19

08. PHP With MySQL

Connecting To MySQL Within A PHP Program

Preview

00:09:51

Pass Data To A Select

Play Video

00:04:48

Adding Rows To A Table

Preview

00:09:06

Deleting Rows From A Table

Preview

00:05:11

Updating Data In A Table

Preview

00:08:51

Populating A Select-Option List

Preview

00:03:31

Login Validation

Preview

00:06:36

Relative Referencing

Preview

00:04:38

Creating Tables With phpMyAdmin

Preview

00:07:07

Inserting Data With phpMyAdmin

Preview

00:07:46

Common Database Functions

Preview

00:07:15

Debugging Techniques - Part 6

Preview

00:05:12

Assignment 6

Preview

00:03:42

Assignment 6 - Solution - Part 1

Preview

00:06:33

Assignment 6 - Solution - Part 2

Preview

00:07:48

09. PHP With Advanced MySQL

Date Functions

Preview

00:04:24

Using Indexes

Play Video

00:06:58

Grouping Data

Preview

00:06:59

Having Clause

Preview

00:04:45

Joining Tables - Part 1

Preview

00:06:45

Joining Tables - Part 2

Preview

00:07:27

Joining Tables - Part 3

Preview

00:04:05

Subqueries - Part 1

Play Video

00:08:15

Subqueries - Part 2

Preview

00:05:24

Assignment 7

Preview

00:02:07

Assignment 7 - Solution

Preview

00:04:15

10. PHP With CSS, JavaScript And Ajax

Basic JavaScript Syntax

Preview

00:09:43

Validating A Form Field With JavaScript

Preview

00:08:12

Positioning A DIV With JavaScript

Preview

00:07:49

Parsing Multiple Values JavaScript With PHP

Preview

00:05:35

Using Simple Ajax

Preview

00:09:14

Using Ajax To Update A Form In Place

Preview

00:04:57

Using Ajax To Show SQL Results In Place

Preview

00:06:44

Using Ajax To Update The Database

Preview

00:05:31

Debugging Techniques - Part 8

Preview

00:09:31

Assignment 8

Preview

00:05:18

Assignment 8 - Solution - Part 1

Preview

00:07:40

Assignment 8 - Solution - Part 2

Preview

00:07:16

Assignment 8 - Solution - Part 3

Preview

00:05:44

11. Conclusion

Server-Side Solutions

Preview

00:04:29

Security Considerations

Preview

00:03:26

Sending Email With PHP (Simple Mail Program)

Preview

00:05:44

Next Steps

Preview

00:05:30

About The Author

Preview

00:02:30

Extras

The publisher has provided additional content related to this title.


Description
Content

These files have been provided by the publisher.

  • Working_Files.zip