Introduction to PHP & mySQL, Austin, TX

"...absolutely excellent."

"...a gifted trainer whose small class size and personal approach make the most of her students' time."

"I've never experienced such a perfect balance between focused, goal-driven instruction and instruction that addresses the particular needs, interests and questions of our group."

"Thanks again for an invaluable week. It's made a huge, huge difference in our ability to move forward with our current plans."

"[The instructor]displayed an incredible breadth of technical knowledge extending well outside Drupal to security, administration of various operating systems, and IT in general."




Introduction to PHP Print

In this 3-day PHP training course, students will learn to create database-driven websites using PHP and MySQL.

Course Goals:

  • Learn how PHP works
  • Learn the basic syntax of PHP
  • Learn to create dynamic interactive pages with PHP
  • Learn to manipulate files with PHP
  • Learn to work with arrays in PHP
  • Learn to validate forms with PHP
  • Learn to write functions in PHP
  • Learn to manipulate and manage database data with PHP
  • Learn to authenticate users with PHP
  • Learn to manage sessions with PHP
  • Learn to work with the PEAR:DB module
  • Learn advanced form validation with regular expressions
  • Learn to send email with PHP

Course Outline
  1. PHP Basics
    1. How PHP Works
    2. The php.ini File
    3. Basic PHP Syntax
      1. PHP Tags
      2. PHP Statements and Whitespace
      4. PHP Functions
      5. Hello World!
    4. Variables
      1. Variable Types
      2. Variable Names (Identifiers
      3. Type Strength
      4. Hello Variables!
      5. Variable Scope
      6. Superglobals
      7. Constants
      8. Variable-Testing and Manipulation Functions
    5. First PHP Script
    6. PHP Operators
    7. Creating Dynamic Pages
      1. Single Quotes vs. Double Quotes
      2. Passing Variables on the URL
    8. Passing Variables via the Query String
  2. Flow Control
    1. Conditional Processing
      1. If Conditions
    2. Working with Conditions
    3. Loops
      1. while
      2. do...while
      3. for
      4. break and continue
    4. Working with Loops
  3. Arrays
    1. Enumerated Arrays
      1. Initializing Arrays
      2. Appending to an Array
      3. Reading from Arrays
      4. Looping through Arrays
    2. Working with Enumerated Arrays
    3. Associative Arrays
      1. Initializing Associative Arrays
      2. Reading from Associative Arrays
      3. Looping through Associative Arrays
      4. Superglobal Arrays
    4. Working with Associative Arrays
    5. Two-dimensional Arrays
      1. Reading from Two-dimensional Arrays
      2. Looping through Two-dimensional Arrays
    6. Array Manipulation Functions
  4. PHP and HTML Forms
    1. HTML Forms
      1. How HTML Forms Work
      2. A Sample HTML Form
      3. Form Variables
    2. Processing Form Input
  5. String Manipulation
    1. Formatting Strings
      1. Concatenation
      2. String Manipulation Functions
      3. Examples of String Functions
    2. Working with String Manipulation Functions
    3. Magic Quotes
      1. magic_quotes_gpc
      2. magic_quotes_runtime
      3. Recommendation on Magic Quotes
  6. Reusing Code and Writing Functions
    1. Including Files
      1. require
      2. require_once
      3. auto_prepend_file and auto_append_file
    2. Adding a Header and Footer
    3. User Functions
      1. Defining and Calling Functions
      2. Default Values
      3. Variable Scope
      4. By Reference vs. By Value
    4. Form Processing
      1. Code Organization
    5. Form Validation and Presentation Functions
  7. Managing Data
    1. Querying a Database
      1. mysqli() Overview
      2. mysqli Methods and Properties
      3. Inserting and Updating Records
      4. mysqli Prepared Statements
    2. Inserting Records
  8. PEAR:DB
    1. Advantages and Disadvantages of PEAR DB
      1. Why use a database abstraction layer?
      2. When not to use a database abstraction layer?
    2. Using PEAR DB
    3. Creating a Customer Report
  9. Authentication with PHP and SQL
    1. A Database-less Login Form
    2. Authenticating Users
  10. Session Control and Cookies
  11. Sessions
  12. Configuring Sessions
  13. Session Functions
    1. Cookies
    2. Authentication with Session Control
  14. Sending Email with PHP
    1. mail()
      1. Shortcomings of mail()
    2. PHPMailer
    3. Sending a Password by Email
  15. File System Management
    1. Opening a File
      1. fopen()
    2. Reading from a File
      1. fgets()
    3. Writing to a File
      1. fwrite()
    4. Writing to a File
    5. File Locking
      1. flock()
    6. Uploading Files via an HTML Form
    7. Getting File Information
    8. More File Functions
    9. Directory Functions
      1. Getting a Directory Listing
    10. Creating a Resume Management Page

Introduction to PHP Training Courseware Prerequisites

Experience in the following areas would be beneficial.

  • Basic Programming



On the Web

Back-End Engineer - PHP, MySQL, Javascript - 8140 in ...

... Javascript We have an immediate contract opportunity with a large F500 client in the Austin, TX area. As a member ... knowledge in PHP ... experience in MySQL

Database Design Concepts - Introduction to MYSQL - MYSQL ...

Free MYSQL Tutorial On Database Design Concepts At PHP For ... References; Introduction to MYSQL ... a MYSQL database table might look …

New Member Introduction from Austin, TX

... New Member Introduction from Austin, TX Welcome to FP Geeks! Will you be coming to the Dallas show in September? Quick Navigation New Members Top.

PHP 5 Introduction - W3Schools Online Web Tutorials

... Open/Read PHP File Create/Write PHP File Upload PHP Cookies PHP Sessions PHP Error Handling PHP Exception PHP Filters MySQL Database ... PHP 5 Introduction ...

Introduction To Microbiology Austin Community

Austin, TX 78759. Ph: ...Department of ... Introduction to microbiology austin community documents. Documents about Introduction to microbiology austin …

PHP MySQL interactive website design

Introduction. The combination of PHP and MYSQL, ... To extend your knowledge of MySQL study the Docs and Tutorials at the official MySQL website.

Clent Crumley » Web Designer & PHP Web Developer from ...

Clent Crumley. design; ... More specifically, I design HTML5/CSS3 Websites, build PHP/MySQL Web Applications, ... I'm currently Freelancing in beautiful Austin, ...

MySQL Tutorial - Introduction - Tizag Tutorials

An introduction to using the MySQL database. This tutorial uses PHP to complete many basic MySQL tasks.

PHP/MySQL Tutorial - Part 3 - Free Webmaster Help ...

Introduction Over the past two ... This line tells PHP to connect to the MySQL database server at 'localhost' (localhost means the server that the site is running one.

Introduction to MySQL + PHP (9780975241486) - Books - The ...

Buy the book Introduction to MySQL + PHP (ISBN: 9780975241486) ... This book will catapult you straight into working with real PHP and MySQL code, ...

PHP/MySQL Tutorial - Part 1 - Free Webmaster Help ...

Introduction For many people, ... (SQL, Oracle etc.) but as this is a PHP/MySQL tutorial I will deal just now with the MySQL database ...

3. PHP & MySQL in Pashto - Introduction to PHP & PHP Mysql ...

23.02.2012 · This Videos Provides an Introduction to Server Side Scripting (PHP & its Syntax). You will also learn PHP & MySQL Connection Steps and performing insertion ...

PHP Web Developer - Symfony, JavaScript, MySQL, Streaming ...

PHP Web Developer - Symfony, JavaScript, MySQL, Streaming Media for rapidly growing web-based media product company in Austin, TX

Samir Patel's Resume - Full Stack LAMP Developer (Linux ...

Software Engineer in Austin, TX. ... Created a standards compliant PHP/MySQL application for on site customers at factory locations to procure items by adding them …

PHP - MySQL - Selecting multiple rows from DB - PHP Coding ...

PHP - MySQL - Selecting multiple rows from DB - posted in PHP Coding Help: Hello everyone,First of all, ... Location Austin, TX; Posted 23 November 2008 - 11:55 AM

Introduction to MySQL Joins | PHP Forums

Introduction to MySQL Joins. ... Use the following code snippet in your PHP test script to show the results without using phpmyadmin for your example queries:

PHP Developer - Austin, Texas | Innofoundry

PHP Developer - Austin, Texas. We are looking for a experienced PHP Developer to join our growing team in the Austin, TX office. ... * Standard SQL skills using MySQL

Are You My Mary Poppins Jobs in Austin, TX (Hiring ...

Austin, TX Are You My Mary Poppins jobs & employment: ... (NEW!) Java Software Engineer PHP, MySQL. The HT Group 5.0 | Austin, TX . Java Software Engineer ...

Introduction To PHP - A Complete PHP Tutorial for Absolute ...

25.01.2012 · This is an introduction to PHP. It is a part of a series of complete tutorials on learning PHP as an absolute beginner. ... Understanding PHP, MySQL, ...

Austin Web Design - Austin Web Development - Website ...

Austin Web design company Interaria is a PHP/MySQL driven Web development agency. At Austin Web design company Interaria our team codes efficiently in PHP/MySQL ...