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.

    LEARNING PHP MySQL

    Subscriber Reviews • Browse Similar Topics

    Overview

    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.

    Subscriber Reviews

    Average Rating: 4.5 out of 5 rating Based on 14 Ratings

    "I like it so far." - by pdl2020 on 29-JAN-2012
    Reviewer Rating: 1 star rating2 star rating3 star rating4 star rating5 star rating
    I am very new to php and mySQL. I just started viewing this video. So far I like Mr Tuckers class. His instructions are very easy to follow.

    As recommended I downloaded Bluefish for php eiditor

    Please Note: Mr Tucker user XAMP, but I could not find XAMP for Windows 7 64 bit. So I downloaded WAMP.



    Report as Inappropriate

    Table of Contents

    Chapter/Selection

    Time

    Intro To Beginners PHP

    Intro - What This Course Covers

    Play Video

    00:01:42

    What We Need

    Play Video

    00:06:19

    Getting Started

    Introducing XAMPP

    Play Video

    00:00:39

    Downloading XAMPP

    Play Video

    00:00:59

    XAMPP - Installing

    Play Video

    00:01:55

    XAMPP - Setting Up

    Play Video

    00:02:19

    Setting Up A PHP Editor - bluefish

    Play Video

    00:02:34

    Introduction To bluefish

    Play Video

    00:02:49

    The bluefish Interface

    Play Video

    00:03:13

    bluefish Summary

    Play Video

    00:00:36

    Downloading PHP Snippets

    Play Video

    00:02:31

    Using PHP Snippets

    Play Video

    00:05:22

    PHP Comments

    Play Video

    00:04:19

    Our First PHP Page

    Play Video

    00:05:01

    Intro To MySQL Databases

    Play Video

    00:03:14

    Into To phpMyAdmin

    Play Video

    00:05:20

    External Helpful Resources

    Play Video

    00:00:42

    Exercises

    Play Video

    00:01:07

    Our First Look At MySQL And PHP

    Connecting To A MySQL Database - Part 1

    Play Video

    00:06:00

    Connecting To A MySQL Database - Part 2

    Play Video

    00:02:59

    Our First MySQL Query - Part 1

    Play Video

    00:06:21

    Our First MySQL Query - Part 2

    Play Video

    00:05:09

    Creating A MySQL Database

    Play Video

    00:04:08

    Create MySQL Tables - Part 1

    Play Video

    00:03:37

    Create MySQL Tables - Part 2

    Play Video

    00:05:16

    Database Structure

    Play Video

    00:05:40

    Inserting Data In MySQL

    Play Video

    00:05:46

    Updating MySQL Tables

    Play Video

    00:02:39

    Updating MySQL Tables - Example

    Play Video

    00:03:04

    MySQL Delete Command

    Play Video

    00:06:44

    Intro To Variables And Operators

    Play Video

    00:04:04

    Arithmetic Operators

    Play Video

    00:03:38

    Assignment Operators

    Play Video

    00:05:24

    Comparison Operators

    Play Video

    00:04:14

    Introduction To Arrays

    Play Video

    00:03:18

    Numeric Arrays

    Play Video

    00:02:24

    Associative Arrays

    Play Video

    00:04:08

    Multi-Dimensional Arrays

    Play Video

    00:06:29

    Creating And Working With Arrays

    Play Video

    00:04:20

    Creating Arrays From A Text File

    Play Video

    00:07:18

    Lesson Review

    Play Video

    00:01:22

    Outputting And Processing Data

    Hiding Sensitive Data

    Preview

    00:01:57

    Including Sensitive Data

    Preview

    00:04:04

    PHP Echo And Quotes - Part 1

    Preview

    00:05:13

    PHP Echo And Quotes - Part 2

    Preview

    00:04:53

    Formatting Using sprintf

    Preview

    00:05:49

    Outputting Tabular Data

    Preview

    00:04:58

    Outputting Data And Time

    Preview

    00:05:31

    Introduction To Loops

    Preview

    00:02:21

    do...while Loops

    Preview

    00:01:51

    Repetition - for Loops

    Preview

    00:01:55

    Repetition - foreach Loops

    Preview

    00:04:07

    MySQL Select

    Preview

    00:04:31

    Formatting Outputted MySQL Data

    Preview

    00:02:03

    MySQL Joins - Overview

    Preview

    00:03:58

    MySQL Joins

    Preview

    00:03:31

    MySQL Where And Order By

    Preview

    00:06:55

    Dealing With Variables

    Intro To Sending Variables

    Preview

    00:01:47

    Using Variables With GET

    Preview

    00:07:57

    Using Variables With POST

    Preview

    00:03:27

    Inserting Sent Data In A Database

    Preview

    00:07:13

    Updating A Database With Sent Data - Part 1

    Preview

    00:03:14

    Updating A Database With Sent Data - Part 2

    Preview

    00:05:11

    Redirection In PHP

    Preview

    00:04:02

    Creating A List - Example

    Preview

    00:06:32

    Styling The List - Example

    Preview

    00:04:48

    What We Have learned

    Preview

    00:01:08

    Inserting And Using Database Data

    Using One Page To Process Forms - Part 1

    Preview

    00:02:07

    Using One Page To Process Forms - Part 2

    Preview

    00:04:08

    Multi Part Forms

    Preview

    00:03:58

    Save And Return POST and GET

    Preview

    00:02:58

    Save And Return INSERT

    Preview

    00:01:50

    Save And Return UPDATE

    Preview

    00:03:02

    Normalization

    Preview

    00:04:01

    Simple Drop Downs

    Preview

    00:04:19

    Complex Drop Downs

    Preview

    00:03:58

    Revised Form - The Code

    Preview

    00:04:54

    Revised Form - The Result

    Preview

    00:02:50

    Lesson Review

    Preview

    00:00:55

    MySQL Joins

    MySQL Join Types - Examples

    Preview

    00:05:57

    MySQL Join Diagrams

    Preview

    00:01:44

    Creating Nested Lists

    Preview

    00:04:34

    MySQL Nested Processing

    Preview

    00:03:32

    Styling Our Lists

    Preview

    00:05:11

    Intro To Functions

    Preview

    00:07:34

    Included Files

    Preview

    00:08:28

    PHP Errors And Security

    Introduction To Security And Errors

    Preview

    00:01:25

    Error Types - Databases

    Preview

    00:08:25

    PHP Error Types

    Preview

    00:06:41

    Custom Error Testing

    Preview

    00:03:26

    Create A Login Page

    Preview

    00:08:12

    Passwords For Login

    Preview

    00:03:02

    Protecting Pages

    Preview

    00:08:35

    Using Cookies - Theory

    Preview

    00:01:33

    Using Cookies - Practice

    Preview

    00:04:42

    Access Levels - Basic Restriction

    Preview

    00:05:30

    Access Levels - Restrict Fields

    Preview

    00:02:51

    Managing Users - Structure

    Preview

    00:03:41

    Managing Users - Create New

    Preview

    00:03:46

    Audit Trails - Access Function

    Preview

    00:04:22

    Audit Trails - Logging Logins

    Preview

    00:03:07

    Errors And Security - Review

    Preview

    00:01:08

    Building A Template Page

    PHP Templates

    Preview

    00:03:49

    Building Our PHP Template CSS/HTML

    Preview

    00:05:23

    Creating Template Menu

    Preview

    00:05:05

    Create Template Login Script

    Preview

    00:04:45

    Template Logout Script

    Preview

    00:04:28

    CMS Switch Statement

    Preview

    00:03:49

    Building Our CMS

    Preview

    00:04:29

    Setting up our CMS Content

    Preview

    00:06:07

    Complete CMS Module

    Preview

    00:02:16

    Review And Exercise

    Preview

    00:01:45

    PHP Functions

    Function Structure

    Preview

    00:06:40

    Built In Functions Maths And Strings

    Preview

    00:07:43

    Built In Functions Date And Time

    Preview

    00:04:05

    Custom Functions

    Preview

    00:04:08

    Format With Functions

    Preview

    00:03:18

    Email Address Checking

    Preview

    00:07:41

    Database Functions

    Preview

    00:04:34

    Array Functions - sort And unique

    Preview

    00:05:22

    Array Functions - search, slice And merge

    Preview

    00:07:09

    Server Variables

    Preview

    00:04:17

    Browser Detection

    Preview

    00:03:09

    Using External Files, And Images

    Reading Text Files

    Preview

    00:07:04

    Writing Text Files

    Preview

    00:04:05

    Working With Image Files - exif

    Preview

    00:04:53

    Creating Image Files With GD Library

    Preview

    00:04:31

    Managing Images With GD Library

    Preview

    00:05:33

    Resizing Images With PHP

    Preview

    00:02:50

    Uploading Files - Overview

    Preview

    00:03:15

    Uploading Files - In Action

    Preview

    00:06:29

    Remote File Parsing

    Preview

    00:05:27

    Email With PHP

    Email With PHP And MySQL

    Preview

    00:01:17

    Sendmail SMTP Server

    Preview

    00:02:21

    Sendmail mail Function

    Preview

    00:05:45

    PHP mail CC And BCC

    Preview

    00:03:48

    HTML email Content

    Preview

    00:06:45

    Email Out - Hiding SMTP Address

    Preview

    00:01:41

    Email Out - Embedded Form

    Preview

    00:06:48

    Logging Sent Email

    Preview

    00:06:02

    Real Life PHP Introduction

    Real Life Introduction

    Preview

    00:01:29

    Building PHP Tools - Button Maker

    Preview

    00:05:30

    Building PHP Tools - Embedded Tool

    Preview

    00:03:59

    Managing Deletions - Suspension Fields

    Preview

    00:03:29

    Managing Deletions - Suspend Record

    Preview

    00:05:28

    Managing Deletions - Restore Records

    Preview

    00:05:08

    OO Programming - A Caveat

    Preview

    00:02:06

    OO Programming Model - DB Connection

    Preview

    00:03:37

    OO Programming - DB Examples

    Preview

    00:06:05

    CMS Open Source

    Preview

    00:01:29

    CMS Joomla

    Preview

    00:04:56

    CRM Download And Extract

    Preview

    00:03:05

    CRM vTiger Install

    Preview

    00:03:39

    CRM Modifying vTiger

    Preview

    00:02:01

    About The Author

    About The Author

    Preview

    00:01:15

    Extras

    The publisher has provided additional content related to this title.


    Description
    Content

    These files have been provided by the publisher.

    • Working_Files.zip