your shopping cartyour account

Free eNewsletter   |   Testimonials   |   News Releases   |   Press   |   FAQ  
Home > Products > Essential PHP, Web, and MySQL (Volume 3)
forward to a friend
 
  news and press
Our Product Catalog
   
Essential PHP, Web, and MySQL (Volume 3) Product Image Essential PHP, Web, and MySQL (Volume 3)
18+ hours of Instruction on PHP Web Scripting with Dreamweaver CS3.
3 Bonus Sections on SQL, phpMyAdmin and more!


This disc contains: 148 Movies, 18 Video Hours, and over 3.2 Gigabytes!
Learn how to program PHP with Dreamweaver CS3!! This is the best training on the market for effectively learning how to create dynamic PHP web sites with MySQL. Learn from a professional programmer and web guru. This title is jam packed with over 18 hours of video training. You will effectively learn how to work with databases outside of the PHP language and by directly working with the best functionality in PHP. You will get a firm foundation in creating, manipulating, and displaying SQL databases using multiple examples. You get a firm foundation in database concepts and the essential parts of the SQL language. You will get many, many professional tips and tricks along the way. No title on the market has as many examples and exercises as this title. You owe it to yourself to learn the essential techniques used by the best and most successful web professionals and sites.

Current Price: $99.95 USD
Buy Now: Windows and Mac Compatible DVD-ROM  add product to cart    DVD-ROM logo
System Requirements:
DVD-ROM drive required; Mac OS X or Windows (2000, XP, Vista); 1024 video display resolution or greater; 512 MB Memory or more recommended.


Click on the available links or format logos below to view
the Flash Video, Windows Media, or QuickTime format.


Sample Videos The videos presented here are of a lower audio and video quality. Our discs are created at the highest quality! Videos  are compressed here for ease of viewing.
 
07-10 Table Joins (Relationships),P1

07-10 Table Joins (Relationships),P1
View the Flash Video
flash video 16:10 (16.5 MB)

07-11 Table Joins (Relationships),P2

07-11 Table Joins (Relationships),P2
View the Flash Video
flash video 15:30 (20.0 MB)

11-01 Paging Records in HTML, P1

11-01 Paging Records in HTML, P1
View the Flash Video
flash video 17:50 (13.5 MB)


Sample Videos There are 148 fantastic videos to choose from!
 The DVD-ROM is packed with 3.2 Gigabytes!

01 Setting Up PHP
01-01 quick install on windows
01-02 web server conflicts on windows, p1
01-03 web server conflicts on windows, p2
01-04 web server conflicts on windows, p3
01-05 wamp server on windows in depth, p1
01-06 wamp server on windows in depth, p2
01-07 wamp server on windows in depth, p3
01-08 downloading apache, php, mysql (mac osx)
01-09 install apache, php (mac osx)
01-10 install mysql (mac osx)
01-11 install mamp server, p1 (mac osx)
01-12 install mamp server, p2 (mac osx)

02 Getting Started and Review
02-01 Basic PHP
02-02 Data Types
02-03 Strings
02-04 Numbers
02-05 Integers
02-06 Arrays
02-07 Loops
02-08 If and Else
02-09 Functions and Includes
02-10 Objects

03 Web Pages and PHP
03-01 HTTP, HTML and State
03-02 PHP and Dynamic Pages
03-03 Super Global Arrays
03-04 Browser Redirects
03-05 Browser Caching
03-06 Server-Side Vs. Client-Side
03-07 PHP and Javascript
03-08 Regular Expressions

04 Web Forms
04-01 Get Parameters
04-02 REQUEST global
04-03 Post Parameters
04-04 Simple Forms, P1
04-05 Simple Forms, P2
04-06 A Contact Us Form
04-07 Validating Form Fields, P1
04-08 Validating Form Fields, P2
04-09 Preventing Multi-Submissions
04-10 Magic Quotes
04-11 Required Fields
04-12 Auto-Fill Fields
04-13 Checkboxes and PHP
04-14 Dynamic Selection Lists
04-15 Using Hidden Fields
04-16 A Complete Form Example

05 Sessions and Cookies
05-01 Introducing Sessions
05-02 Sessions with Logins, P1
05-03 Sessions with Logins, P2
05-04 Sessions and Session Variables
05-05 Setting Sessions, P1
05-06 Setting Sessions, P2
05-07 session_register
05-08 Destroying Sessions
05-09 Setting Cookies
05-10 Deleting Cookies
05-11 Multi-Value Cookies
05-12 Deleting Cookie Arrays
05-13 Unsetting Cookies
05-14 Exploding Cookies

06 MySQL Basics
06-01 MySQL Overview
06-02 The SQL Language
06-03 Databases, Tables, Queries
06-04 Creating Databases
06-05 Tables, Keys, and Indexes
06-06 Table Relationships
06-07 Column Data Types
06-08 Users and Data Security
06-09 Database Design
06-10 Database GUI Tools
06-11 About the SQL Sections

07 Manipulating MySQL Data
07-01 Insert, Select, Update, Delete
07-02 Insert Statements
07-03 Select Statements
07-04 Where Clauses
07-05 Distinct - Unique Rows
07-06 Distinct Example
07-07 Null Values
07-08 Update Statements
07-10 Table Joins (Relationships),P1
07-11 Table Joins (Relationships),P2
07-12 Sorting Results
07-13 Limiting Rows
07-14 Built-in Functions
08 phpMyAdmin Essentials
08-01 About phpMyAdmin
08-02 Install and Configure, P1
08-03 Install and Configure, P2
08-04 Install and Configure, P3
08-05 Creating Databases
08-06 Creating Tables
08-07 Inserting Values
08-08 Default Column Values
08-09 Executing SQL
08-10 Updating Data Rows
08-11 Deleting Rows
08-12 Modifying Table Columns
08-13 Sorting Rows

09 PHP and Databases, P1
09-01 Types of Databases
09-02 Overview of the Examples
09-03 Connecting to Servers
09-04 MySQL Connection Scripts
09-05 Other Database Connections
09-06 Basic Select Statements, P1
09-07 Basic Select Statements, P2
09-08 Basic Select Statements, P3
09-09 Fetch Rows with List
09-10 Fetch Associative Arrays
09-11 Fetch Indexed Arrays
09-12 Fetch Objects
09-13 Basic Inserts, P1
09-14 Basic Inserts, P2
09-15 Insertion IDs
09-16 Basic Delete Statements

10 PHP and Databases, P2
10-01 mysqli Functions
10-02 More mysqli
10-03 Other Delete Statements
10-04 More Prepared Statements
10-05 Performance Issues
10-06 Persistent Connections
10-07 mySQL Errors

11 PHP and Databases, P3
11-01 Paging Records in HTML, P1
11-02 Paging Records in HTML, P2
11-03 Paging Records in HTML, P3
11-04 Setting up Pagination, P1
11-05 Setting up Pagination, P2
11-06 Prevent SQL Injection
11-07 Some mysql Functions
11-08 PDO Connections, P1
11-09 PDO Connections, P2
11-10 PDO Connections, P3
11-11 SQLite
11-12 PostgreSQL

12 Data-Driven Web Sites
12-01 Creating a Blog
12-02 Creating Topics, P1
12-03 Creating Topics, P2
12-04 Creating Article Page
12-05 Create the Post Page, P1
12-06 Create the Post Page, P2

13 Working with Email
13-01 Sending Email, P1
13-02 Sending Email, P2
13-03 phpmailer
13-04 PEAR mail
13-05 Mail Headers, P1
13-06 Mail Headers, P2
13-07 Internet Mail Protocols
13-08 SMTP authentication

14 Conclusion
14-01 Wrapping Things Up
14-02 What is Next









 



Quixel Video, inVision Tek, Advanced Learning Potential, and Video Book are trademarks of inVision Tek OHG.

Quixel Video is owned and operated by inVision Tek OHG. Copyright © 2000-2010. All rights reserved. Quixel Video and the Quixel Video logo are trademarks and service marks of inVision Tek OHG. All other company, product and service names are trademarks and service marks of their respective owners.

inVision Tek OHG Logo