Download Safari Books Online apps: Apple iOS | Android

Entire Site

Safari Books Online

    Free Trial

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

    Dynamic Web Design with PHP and MySQL

    Subscriber Reviews • Browse Similar Topics

    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