O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Dynamic Web Design with PHP and MySQL

Video Description

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.

Table of Contents

  1. Introduction
    1. What Is PHP? 00:04:34
    2. What Is MySQL? 00:02:39
    3. Simple PHP Program 00:06:27
    4. The Example Web Site - King Real Estate 00:03:55
  2. Interface
    1. Setting Up Your Computer For PHP And MySQL 00:04:02
    2. Installing WAMP For Windows 00:07:03
    3. Installing MAMP For Macintosh - Part 1 00:03:58
    4. Installing MAMP For Macintosh - Part 2 00:02:28
    5. Using A Hosting Service 00:06:38
  3. PHP Basics
    1. Using PHP Script Tags 00:04:01
    2. Displaying HTML To Your Browser Window 00:07:48
    3. HTML Forms 00:10:13
    4. Using The SELECT Tag 00:06:20
    5. Using The TEXTAREA Tag 00:06:47
    6. Using The RADIOBUTTON Tag 00:04:09
    7. Using The CHECKBOX Tag 00:05:36
    8. Assigning Values To Variables 00:04:49
    9. Appending Text 00:04:12
    10. Debugging Techniques - Part 1 00:07:21
    11. Assignment 1 00:04:12
    12. Assignment 1 - Solution 00:05:49
  4. PHP Programming Fundamentals
    1. String Delimiters 00:07:47
    2. Simple Math 00:05:30
    3. HTML Tables 00:07:53
    4. Using IF Statements 00:04:16
    5. The ELSE Clause 00:04:44
    6. Nested IFs 00:05:41
    7. Code Formatting Rules 00:05:25
    8. Comparison Operators - Chapter 4 00:08:18
    9. Using AND 00:04:38
    10. Using OR 00:04:27
    11. Using NOT 00:05:39
    12. Field Validations 00:06:52
    13. Using DIVs 00:08:31
    14. Using DIVs And Forms 00:03:17
    15. Debugging Techniques - Part 2 00:10:00
    16. Assignment 2 00:04:39
    17. Assignment 2 - Solution 00:10:16
  5. Advanced PHP Constructs
    1. The for Loop 00:07:35
    2. The while Loop 00:09:02
    3. Reading A File 00:08:29
    4. Writing To A File 00:07:44
    5. Displaying A Data From A File Into An HTML Table 00:12:55
    6. Debugging Techniques - Part 3 00:07:58
    7. Assignment 3 00:05:34
    8. Assignment 3 - Solution 00:08:56
  6. Functions, Arrays, And Strings
    1. Simple Function 00:02:38
    2. Functions That Receives Data 00:03:30
    3. Functions That Returns A Value 00:02:28
    4. Functions That Receives Data And Returns A Value 00:06:20
    5. Variable Scope 00:07:19
    6. Functions That Returns Multiple Values 00:06:50
    7. Using Include Files 00:04:16
    8. Array Basics 00:07:52
    9. Sorting Arrays 00:06:14
    10. Loading An Array From A File 00:02:10
    11. Loading An Array From A Directory 00:06:19
    12. Recursive Programming 00:08:57
    13. Finding Text 00:06:48
    14. Finding Text With Regular Expressions 00:05:11
    15. Finding Simple Patterns Using Regular Expressions 00:07:59
    16. Debugging Techniques - Part 4 00:08:04
    17. Assignment 4 00:05:40
    18. Assignment 4 - Solution 00:09:18
  7. Introduction To MySQL
    1. Introduction To SQL 00:09:46
    2. The Example Database 00:06:50
    3. Interactive MySQL 00:07:20
    4. Creating Tables 00:08:19
    5. Simple SELECT Statement 00:05:39
    6. Comparison Operators - Chapter 7 00:05:41
    7. Logical Operators 00:05:56
    8. Selecting Nulls 00:02:05
    9. Sorting Results 00:05:46
    10. Aggregate Functions 00:06:38
    11. Pattern Matching 00:05:14
    12. Inserting Rows 00:04:05
    13. Updating Table Data 00:05:14
    14. Deleting Rows 00:01:56
    15. SQL Debugging Techniques - Part 5 00:05:38
    16. Assignment 5 00:02:54
    17. Assignment 5 - Solution 00:03:20
  8. PHP With MySQL
    1. Connecting To MySQL Within A PHP Program 00:09:52
    2. Pass Data To A Select 00:04:49
    3. Adding Rows To A Table 00:09:06
    4. Deleting Rows From A Table 00:05:11
    5. Updating Data In A Table 00:08:51
    6. Populating A Select-Option List 00:03:32
    7. Login Validation 00:06:37
    8. Relative Referencing 00:04:39
    9. Creating Tables With phpMyAdmin 00:07:07
    10. Inserting Data With phpMyAdmin 00:07:47
    11. Common Database Functions 00:07:16
    12. Debugging Techniques - Part 6 00:05:13
    13. Assignment 6 00:03:43
    14. Assignment 6 - Solution - Part 1 00:06:33
    15. Assignment 6 - Solution - Part 2 00:07:49
  9. PHP With Advanced MySQL
    1. Date Functions 00:04:24
    2. Using Indexes 00:06:58
    3. Grouping Data 00:06:59
    4. Having Clause 00:04:46
    5. Joining Tables - Part 1 00:06:46
    6. Joining Tables - Part 2 00:07:28
    7. Joining Tables - Part 3 00:04:05
    8. Subqueries - Part 1 00:08:16
    9. Subqueries - Part 2 00:05:24
    10. Assignment 7 00:02:07
    11. Assignment 7 - Solution 00:04:16
  10. PHP With CSS, JavaScript And Ajax
    1. Basic JavaScript Syntax 00:09:44
    2. Validating A Form Field With JavaScript 00:08:13
    3. Positioning A DIV With JavaScript 00:07:49
    4. Parsing Multiple Values JavaScript With PHP 00:05:36
    5. Using Simple Ajax 00:09:14
    6. Using Ajax To Update A Form In Place 00:04:58
    7. Using Ajax To Show SQL Results In Place 00:06:45
    8. Using Ajax To Update The Database 00:05:32
    9. Debugging Techniques - Part 8 00:09:32
    10. Assignment 8 00:05:18
    11. Assignment 8 - Solution - Part 1 00:07:41
    12. Assignment 8 - Solution - Part 2 00:07:16
    13. Assignment 8 - Solution - Part 3 00:05:44
  11. Conclusion
    1. Server-Side Solutions 00:04:30
    2. Security Considerations 00:03:27
    3. Sending Email With PHP (Simple Mail Program) 00:05:44
    4. Next Steps 00:05:31
    5. About The Author 00:02:31