Categories
Search
Syndication
Sponsors

Archive for the ‘Tutorials’ Category

MySQL video tutorials

Tuesday, January 27th, 2009

MySQL

Virtual Training Company’s MySQL tutorial is just what you need to begin designing and developing database management systems. Joshua Mostafa will help you go from a beginner’s understanding of databases and SQL to gaining mastery knowledge in only 8 hours of training. He starts the tutorial by covering the basics of databases and SQL. Once you are comfortable with the basics, move on to the more complex aspects of SQL, such as variables and security. You can start right away by simply clicking one of the movie topics below.

Getting Started

Welcome

What You Will Need

Database Basics

What Is A Database?

RDBMSs

Tables and Data Pt 1

Tables and Data Pt 2

SQL Basics

Finding Your Way About

Creating a Database

Creating a Table

Column Types-String Pt 1

Column Types-String Pt 2

Column Types-Numeric Pt 1

Column Types-Numeric Pt 2

Retrieving Data With Search Criteria

Changing Existing Data

Altering A Table

Keys And Indexes

Basics Syntax Recap

Operators in MySQL

Arithmetic Operators

Numeric Comparison Operators

String Comparison Operators

Logical Operators

Bitwise Operators

Regular Expressions 1

Regular Expressions 2 Pt 1

Regular Expressions 2 Pt 2

Operators Syntax Recap

Querying Your Data

Sorting Retrieved Data

Specifying Numbers of Results

Joining Tables Pt 1

Joining Tables Pt 2

More On Joining Tables

Data Aggregation

Queries Syntax Recap

More Complex SQL

Using Default Data

Date And Time 1 Pt 1

Date And Time 1 Pt 2

Date And Time 2

ENUM column type

SET column type Pt 1

SET column type Pt 2

Using Variables

Conditional: IF()

Complex Syntax Recap

Good Practices

Using SQL batch files Pt 1

Using SQL batch files Pt 2

Data Modeling Pt 1

Data Modeling Pt 2

Normalization Pt 1

Normalization Pt 2

Optimizations

Security

Users And Privileges

More About Users And Privileges

The mysql Database Pt 1

The mysql Database Pt 2

Encryption

Security Syntax Recap

Building A Database Application

Planning The Structure

Designing The Database Pt 1

Designing The Database Pt 2

Creating The Database Pt 1

Creating The Database Pt 2

Logging In And Out

Checking Videos In And Out Pt 1

Checking Videos In And Out Pt 2

Searching For A Video

Adding A New Title

Signing Up A New Customer

Hiring And Firing Employees Pt 1

Hiring And Firing Employees Pt 2

Listing Debtors

Credits

About the Author

Tags:
Posted in Tutorials | No Comments »

PHP Project Solutions

Tuesday, January 27th, 2009

PHP Project Solutions

This course will provide in-depth coverage of major PHP syntax, built-in functions of PHP, web application programming techniques and recommended coding solutions based on common PHP requirements. The user will also learn how to create a complete web application using HTML/XHTML/XML, Javascript, Postgres/SQL and then learn to troubleshoot by example. Examples and code for an online card game, shopping cart, email newsletter, content management system and online survey system, are included within the tutorial. To get started today, simply click one of the movie topics below.

PHP Projects Introduction

PHP Project Solutions Prerequisites

Course Introduction - Course Requirements

Short History of PHP/HTML/the Web

Creating a Web Application with PHP

PHP Data Processing in a Web Page

Web Interaction with PHP (Query Strings)

Web Interaction with PHP (HTML Forms)

PHP Sessions and Variables/Connections/SQL

Overview

Sessions and Variables pt. 1

Sessions and Variables pt. 2

Sessions and Variables pt. 3

Sessions and Variables pt. 4

Creating Postgres Database Tables

Include Files for Database Connections

Running SQL Queries pt. 1

Running SQL Queries pt. 2

The Admin Area and Login Function

Overview

Creating the Admin Table and Index File

Client-side Validation

Server-side Validation

Managing Admin Users pt. 1

Managing Admin Users pt. 2

Managing Registered Customers pt. 1

Managing Registered Customers pt. 2

Online Card Game

Overview

The Game Flow

Creating the Cards

Creating the Screens as Web Pages

Creating the Database Tables

Generating Random Numbers

Creating Card Image and Value Arrays

Dealing Cards - Storing Scores

Calculating Scores

Determining the Next Move

Playing the Game

Shopping Cart

Overview

Building Products and Orders Tables pt. 1

Building Products and Orders Tables pt. 2

Sessions and Arrays

Registration Screen

Displaying Products

Starting an Order

Editing and Order pt. 1

Editing and Order pt. 2

Checking Out and Sending Order

Confirmation Screen

The Cart in Action

Email Newsletter

Overview

Creating a Newsletter Table

Selecting Recipients

Composing Newsletters

Validating Email Addresses

Sending with PHP Mail Functions

The Newsletter System in Action

Content Management System

Overview

Storing Content in a Database

File System Functions

Working With File System Functions

Copying Template Files

Writing to Files

Displaying Files for Editing pt. 1

Displaying Files for Editing pt. 2

Uploading Files

Setting File Permissions

Creating Site Pages

Editing Site Page Content

Uploading Image Files

Online Survey System

Overview

Design Considerations

Tables for Polls/Questions/Answers

The Logic for Scoring Answers pt. 1

The Logic for Scoring Answers pt. 2

Creating a Poll and Questions

Displaying the Poll

Preventing Poll Misuse

Creating a Poll in Action

Viewing a Poll in Action

XML Files

Overview

What is XML?

Parsing XML

Displaying XML

Creating XML Files from Database Records

The Admin Interface Page

Editing the XML File

Using the XML Functions

Applications Map

Application and Admin Files and Folders

Credits

About this Author

Tags:
Posted in Tutorials | No Comments »

PHP Programming: The Basics

Tuesday, January 27th, 2009

PHP Programming: The Basics

In Real World PHP Programming: The Basics, VTC Author Mike Morton introduces PHP programming in a fashion that is immediately applicable to experienced programmers, and new programmers alike. This programming title does not focus on getting certified in PHP, but rather focuses on the application of PHP in everyday programming, including the proper terminology as well as learning PHP slang. Starting with the absolute basics of PHP types and statements, Mike progresses you through conditional and loops, MySQL, and into advanced topics such as functions and session management. With working examples, and application of what you are learning shown throughout, Mike makes learning PHP an easy and enjoyable endeavour. To begin learning today simply click on one of the links.

Introduction

What This Course Covers

What You Will Need

Resources - Using PHP.net Pt.1

Resources - Using PHP.net Pt.2

Other PHP Resources

Hosting Resources

Starting with PHP

What is PHP

PHP Programming Standards

Embedding PHP in HTML

Embedding HTML in PHP

The All Important Semi-colon

Your First PHP Script

Comments

Chapter 2 Challenge

PHP Basics

Variables

PHP Statements

Values and Value Types Part 1

Values and Value Types Part 2

Referencing Variables and Constants

Superglobals

Variable Variables

Basic Operators Part 1

Basic Operators Part 2

Advanced Operators

Chapter 3 Challenge

PHP Conditionals and Loops

The “IF” Statement

Extending “IF”

“SWITCH” Statements

The “WHILE” Structure

The “DO-WHILE” Structure

The “FOR” Loop

Chapter 4 Challenge

Applying What You Know

INCLUDE and REQUIRE

Setting up Your File Structure

Global Headers and Footers

A Functional Website Example Pt.1

A Functional Website Example Pt.2

A Functional Website Example Pt.3

A Functional Website Example Pt.4

A Functional Website Example Pt.5

A Functional Website Example - Addendum

PHP and functions

Why use functions

Variable Scope

Creating and using Functions

Functions with Parameters

Returning Values

Chapter 6 Challenge

PHP Arrays

What is an Array

Creating Arrays

Multidimensional Arrays

“FOREACH” looping - basic

“FOREACH” looping - advanced

Navigating Arrays

Manipulating Keys

Sorting Arrays

Serialization

Challenge

Starting with MYSQL

Getting Information: mysql.com

Other MYSQL Resources

What is a relational database?

Accessing MYSQL - the command line

MYSQL Basics

Configuring Users in MYSQL - Part 1

Configuring Users in MYSQL - Part 2

Creating Databases and Tables

MYSQL Data Types - Numeric Types

MYSQL Data Types - Date Types

MYSQL Data Types - String Types

EXAMPLE: Creating A Table Statement - Part 1

EXAMPLE: Creating A Table Statement - Part 2

Basic MYSQL commands - INSERT

Basic MYSQL commands - SELECT and UPDATE

Basic MYSQL commands - DELETE and DROP

Setting Up phpMyAdmin

Using phpMyAdmin

Using MYSQL with PHP

Connecting to MYSQL

Choosing a database

Querying a database

Retrieving results

Useful MySQL functions in PHP

PHP and Sessions

What is a session

set_cookie vs session_start

Session Tracking With Built in PHP Functions

Session Tracking With Databases Pt.1

Session Tracking With Databases Pt.2

Final Words

Where to go from here

Credits

About the Author

Tags: ,
Posted in Tutorials | No Comments »

PHP tutorials

Tuesday, January 27th, 2009

PHP

**NOTE** This tutorial explains an outdated version of PHP. If you have installed PHP recently it is highly likely the code shown here WILL NOT WORK in your scripts. We highly recommend viewing This PHP title instead
A PHP5 title is also currently in production. **NOTE**

PHP (Hypertext Preprocessor) is a tool that lets you create dynamic web pages. PHP-enabled web pages are treated just like regular HTML pages and you can create and edit them the same way you normally create regular HTML pages. Virtual Training Company’s tutorial is taught by Joshua Mostafa and shows you how to get the most out of using PHP. He begins with the basics and takes you smoothly through all you need to know to use PHP in creating an incredible web site. To start today, just click on one of the topics below.

Concepts

What is PHP?

Data Flow

What You’ll Need pt. 1

What You’ll Need pt. 2

Scripting vs. Viewing

Your First Script

Absolute Basics

Embedding PHP within HTML

Variables

Operators

More Complex Operators pt. 1

More complex Operators pt. 2

Making Choices

Introducing Conditionals: ‘If’ and Conditional Operators

Logical Operators

Using ‘Else’ and ‘Elseif’

Multiple Choices: ‘Switchcasebreak’

The Concise Conditional: ‘?’ :

Loops and Control Structures

Repetition: The ‘For’ Loop

‘While’ and ‘Do..While’ Loops

Get Me Out Of Here! ‘Break’ and ‘Exit’

Data

Introduction to Arrays

Referencing and Sorting Arrays

Associative Arrays pt. 1

Associative Arrays pt. 2

More About Arrays

Multidimensional Arrays

Joining Arrays and Splitting Strings

More String Manipulation

Replacing Text Within Strings

Introduction to Regular Expressions pt. 1

Introduction to Regular Expressions pt. 2

More About Regular Expressions pt. 1

More About Regular Expressions pt. 2

Replacing Text Using Regular Expressions

Querying A Database

Our Sample MySQL Database

Connecting to the Database

Retrieving Data

Interacting With The User

A Simple HTML Form

A Simple PHP Search Script. pt. 1

A Simple PHP Search Script. pt. 2

Validating User Input

A Search Feature With Dynamic Options pt. 1

A Search Feature With Dynamic Options pt. 2

An HTML Form For User Feedback

Adding The Feedback to the Database pt. 1

Adding The Feedback to the Database pt. 2

Validating an Email Address

Uploading a File pt. 1

Uploading a File pt. 2

Intermediate Coding Techniques

Reusing Code: Functions pt. 1

Reusing Code: Functions pt. 2

Variable Scope

Calling By Value or By Reference

Variable Numbers of Arguments

Calling Functions Through Variables

Recursive Functions

Date and Time

Using External Code Resources

Error Capture: The Graceful Death pt. 1

Error Capture: The Graceful Death pt. 2

Error Capture: Custom Error Handlers pt. 1

Error Capture: Custom Error Handlers pt. 2

Sessions and Users

A Simple Login System

Sessions

Cookies

Logging a User In pt. 1

Logging a User In pt. 2

Logging Out

Registering a User pt. 1

Registering a User pt. 2

Objects

Classes And Objects

Properties and Methods pt. 1

Properties and Methods pt. 2

Constructor Functions

Inheritance pt. 1

Inheritance pt. 2

Polymorphism

Aggregation pt.1

Aggregation pt. 2

Building a Data-Driven Website

The Project: A Discussion Forum

Common Elements pt. 1

Common Elements pt. 2

Adapting the Login Page pt. 1

Adapting the Login Page pt. 2

Adapting the Registration Page

View all Threads pt. 1

View all Threads pt. 2

Viewing a Thread pt. 1

Viewing a Thread pt. 2

Making or Editing A Post pt. 1

Making or Editing A Post pt. 2

Deleting a Post or Thread

Credits

About the Author

Tags:
Posted in Tutorials | No Comments »

Links
Translate
Tags