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

LEARNING PHP MySQL

Video Description

Learning PHP & MySQL

In this Beginners PHP / MySQL tutorial video by expert author Robert J. Tucker, you will learn the fundamentals of PHP and MySQL. Instead of your standard "this is a variable" type training however, Robert teaches you how to actually apply PHP and MySQL in real world scenarios. This PHP / MySQL Tutorial takes you through building a CRM (customer relationship management) application, and through this teaches you how to leverage the power of PHP and MySQL. You will learn about variables, standard PHP functions such as date/time, arithmetic and comparison functions, as well as advanced techniques such as sending emails and creating images using the GD libraries. You will also learn how to create databases and tables, and manage your data in MySQL. By the completion of this PHP training video, you will be fully capable of creating a CRM application, and have all the groundwork laid for creating your own fully featured PHP/MySQL websites and applications. This tutorial video comes complete with extensive work files, and a special website created just to support this training video.

Download the working files for this course at: http://www.infiniteskills.com/01748

Table of Contents

  1. Intro To Beginners PHP
    1. Intro - What This Course Covers 00:01:42
    2. What We Need 00:06:19
  2. Getting Started
    1. Introducing XAMPP 00:00:39
    2. Downloading XAMPP 00:00:59
    3. XAMPP - Installing 00:01:56
    4. XAMPP - Setting Up 00:02:20
    5. Setting Up A PHP Editor - bluefish 00:02:35
    6. Introduction To bluefish 00:02:49
    7. The bluefish Interface 00:03:13
    8. bluefish Summary 00:00:36
    9. Downloading PHP Snippets 00:02:32
    10. Using PHP Snippets 00:05:22
    11. PHP Comments 00:04:20
    12. Our First PHP Page 00:05:02
    13. Intro To MySQL Databases 00:03:15
    14. Into To phpMyAdmin 00:05:21
    15. External Helpful Resources 00:00:43
    16. Exercises 00:01:07
  3. Our First Look At MySQL And PHP
    1. Connecting To A MySQL Database - Part 1 00:06:00
    2. Connecting To A MySQL Database - Part 2 00:02:59
    3. Our First MySQL Query - Part 1 00:06:21
    4. Our First MySQL Query - Part 2 00:05:09
    5. Creating A MySQL Database 00:04:08
    6. Create MySQL Tables - Part 1 00:03:37
    7. Create MySQL Tables - Part 2 00:05:17
    8. Database Structure 00:05:41
    9. Inserting Data In MySQL 00:05:46
    10. Updating MySQL Tables 00:02:39
    11. Updating MySQL Tables - Example 00:03:05
    12. MySQL Delete Command 00:06:44
    13. Intro To Variables And Operators 00:04:05
    14. Arithmetic Operators 00:03:39
    15. Assignment Operators 00:05:24
    16. Comparison Operators 00:04:15
    17. Introduction To Arrays 00:03:18
    18. Numeric Arrays 00:02:25
    19. Associative Arrays 00:04:08
    20. Multi-Dimensional Arrays 00:06:29
    21. Creating And Working With Arrays 00:04:21
    22. Creating Arrays From A Text File 00:07:19
    23. Lesson Review 00:01:23
  4. Outputting And Processing Data
    1. Hiding Sensitive Data 00:01:58
    2. Including Sensitive Data 00:04:04
    3. PHP Echo And Quotes - Part 1 00:05:14
    4. PHP Echo And Quotes - Part 2 00:04:54
    5. Formatting Using sprintf 00:05:49
    6. Outputting Tabular Data 00:04:59
    7. Outputting Data And Time 00:05:32
    8. Introduction To Loops 00:02:22
    9. do...while Loops 00:01:52
    10. Repetition - for Loops 00:01:55
    11. Repetition - foreach Loops 00:04:07
    12. MySQL Select 00:04:31
    13. Formatting Outputted MySQL Data 00:02:04
    14. MySQL Joins - Overview 00:03:58
    15. MySQL Joins 00:03:32
    16. MySQL Where And Order By 00:06:56
  5. Dealing With Variables
    1. Intro To Sending Variables 00:01:48
    2. Using Variables With GET 00:07:57
    3. Using Variables With POST 00:03:27
    4. Inserting Sent Data In A Database 00:07:13
    5. Updating A Database With Sent Data - Part 1 00:03:15
    6. Updating A Database With Sent Data - Part 2 00:05:11
    7. Redirection In PHP 00:04:03
    8. Creating A List - Example 00:06:33
    9. Styling The List - Example 00:04:49
    10. What We Have learned 00:01:08
  6. Inserting And Using Database Data
    1. Using One Page To Process Forms - Part 1 00:02:07
    2. Using One Page To Process Forms - Part 2 00:04:08
    3. Multi Part Forms 00:03:59
    4. Save And Return POST and GET 00:02:59
    5. Save And Return INSERT 00:01:50
    6. Save And Return UPDATE 00:03:03
    7. Normalization 00:04:02
    8. Simple Drop Downs 00:04:19
    9. Complex Drop Downs 00:03:58
    10. Revised Form - The Code 00:04:55
    11. Revised Form - The Result 00:02:50
    12. Lesson Review 00:00:56
  7. MySQL Joins
    1. MySQL Join Types - Examples 00:05:57
    2. MySQL Join Diagrams 00:01:44
    3. Creating Nested Lists 00:04:35
    4. MySQL Nested Processing 00:03:33
    5. Styling Our Lists 00:05:12
    6. Intro To Functions 00:07:34
    7. Included Files 00:08:28
  8. PHP Errors And Security
    1. Introduction To Security And Errors 00:01:26
    2. Error Types - Databases 00:08:26
    3. PHP Error Types 00:06:41
    4. Custom Error Testing 00:03:27
    5. Create A Login Page 00:08:12
    6. Passwords For Login 00:03:02
    7. Protecting Pages 00:08:36
    8. Using Cookies - Theory 00:01:34
    9. Using Cookies - Practice 00:04:42
    10. Access Levels - Basic Restriction 00:05:30
    11. Access Levels - Restrict Fields 00:02:51
    12. Managing Users - Structure 00:03:41
    13. Managing Users - Create New 00:03:46
    14. Audit Trails - Access Function 00:04:23
    15. Audit Trails - Logging Logins 00:03:07
    16. Errors And Security - Review 00:01:08
  9. Building A Template Page
    1. PHP Templates 00:03:49
    2. Building Our PHP Template CSS/HTML 00:05:24
    3. Creating Template Menu 00:05:06
    4. Create Template Login Script 00:04:45
    5. Template Logout Script 00:04:29
    6. CMS Switch Statement 00:03:49
    7. Building Our CMS 00:04:29
    8. Setting up our CMS Content 00:06:08
    9. Complete CMS Module 00:02:17
    10. Review And Exercise 00:01:46
  10. PHP Functions
    1. Function Structure 00:06:41
    2. Built In Functions Maths And Strings 00:07:44
    3. Built In Functions Date And Time 00:04:06
    4. Custom Functions 00:04:09
    5. Format With Functions 00:03:18
    6. Email Address Checking 00:07:42
    7. Database Functions 00:04:34
    8. Array Functions - sort And unique 00:05:23
    9. Array Functions - search, slice And merge 00:07:09
    10. Server Variables 00:04:18
    11. Browser Detection 00:03:10
  11. Using External Files, And Images
    1. Reading Text Files 00:07:05
    2. Writing Text Files 00:04:05
    3. Working With Image Files - exif 00:04:54
    4. Creating Image Files With GD Library 00:04:32
    5. Managing Images With GD Library 00:05:34
    6. Resizing Images With PHP 00:02:50
    7. Uploading Files - Overview 00:03:16
    8. Uploading Files - In Action 00:06:29
    9. Remote File Parsing 00:05:27
  12. Email With PHP
    1. Email With PHP And MySQL 00:01:18
    2. Sendmail SMTP Server 00:02:21
    3. Sendmail mail Function 00:05:45
    4. PHP mail CC And BCC 00:03:49
    5. HTML email Content 00:06:45
    6. Email Out - Hiding SMTP Address 00:01:41
    7. Email Out - Embedded Form 00:06:48
    8. Logging Sent Email 00:06:03
  13. Real Life PHP Introduction
    1. Real Life Introduction 00:01:29
    2. Building PHP Tools - Button Maker 00:05:31
    3. Building PHP Tools - Embedded Tool 00:03:59
    4. Managing Deletions - Suspension Fields 00:03:29
    5. Managing Deletions - Suspend Record 00:05:28
    6. Managing Deletions - Restore Records 00:05:09
    7. OO Programming - A Caveat 00:02:07
    8. OO Programming Model - DB Connection 00:03:37
    9. OO Programming - DB Examples 00:06:06
    10. CMS Open Source 00:01:30
    11. CMS Joomla 00:04:56
    12. CRM Download And Extract 00:03:05
    13. CRM vTiger Install 00:03:39
    14. CRM Modifying vTiger 00:02:02
  14. About The Author
    1. About The Author 00:01:16