Courses by Category
Click on a category below to see a listing of courses.

This course is available for customized on-site delivery for groups of 3 or more students.
Contact us today at 877-258-8987 for more information or a quote.

Scroll down the page for a list of upcoming course dates in our public calendar.

Introduction to PHP with MySQL/PostgreSQL/Oracle/DB2 (5 days)


Our Learning PHP course is the course developers need to learn how to leverage the PHP language and the MySQL database to generate web applications. This course covers the fundamentals of PHP programming, and also covers some advanced features of the language, such as Object Oriented database access, XML, and sending text and HTML email messages.

This course teaches students a database engine independent method of accessing databases (using PHP Data Objects (PDO) ). This allows students to develop PHP applications that are portable across database engines, using a single, abstracted interface.

Introduction to PHP with MySQL/PostgreSQL/Oracle/DB2 Course Calendar (5 days)

Call for upcoming dates or on-site delivery.

1 Includes airfare from anywhere in the continental United States and some parts of Canada as well as accommodation and shuttle services.
spacer
2 Include course and course materials only.
spacer
3 Requires a broadband internet connection and microphone. Note that Virtual LIVE courses are led by an instructor, and as such start and end in local time (based on the course location), this my differ from your time zone.
spacer
For government and education pricing, please contact us.

Recommended Pre-requisites

Some understanding of programming concepts, HTML, and experience working with a DBMS is recommended prior to attending this course.

Course Outline/Agenda

  • Introduction to PHP
    • PHP's role in the WWW
  • Language fundamentals
    • PHP Basics
    • PHP Data types
    • Storing & retrieving information in variables
    • Basic operations with variables
    • Variable rules
  • Decision making in PHP
    • Comparison operators
    • The if construct
    • The while construct
    • The for construct
  • Arrays and PHP
    • Working with arrays
    • Sorting arrays
    • Other array related functions
    • Multi-dimensional arrays
  • Re-using PHP code
    • Functions
      • Declaring functions
      • Passing data by reference
    • Including code in scripts
    • Variable scope in PHP
  • PHP and the WWW server
    • Working with web forms
    • PHP POST & GET form elements
    • Embedding forms with PHP code
    • Validating form data
    • Preventing spoofed submissions
    • Guidelines for secure PHP
    • Understanding magic quotes
    • Setting default values in forms
    • Processing uploaded files
    • Retrieving & Sorting uploaded files
  • Working with databases and ADODB
    • A brief history of databases
    • Relational database concepts
    • Database tables
  • Using the CREATE TABLE statement
  • SQL Data types
    • Integer data types
    • Floating point data types
    • Character data types
    • Other SQL data types
  • SQL column modifiers
  • Understanding SERIAL and AUTO_INCREMENT column options
  • Table & database naming syntax
  • Manipulating data in SQL
    • The SELECT statement
      • Overall SELECT syntax
      • Selecting values to display
      • Restricting selections using the WHERE clause
      • Using ORDER BY to sort query results
      • Using LIMIT to limit result sets
    • The INSERT statement
    • The UPDATE Statement
    • The DELETE and TRUNCATE TABLE statements
  • Leveraging existing code using PEAR & PECL
  • Accessing databases using PHP
    • Downloading & Installing ADODB
    • Creating a Data Source Name (DSN)
    • Setting connection options & connecting to the database
    • Executing SQL statements
    • Executing prepared statements
    • Multiple statement execution
    • Retrieving information about queries (metadata)
    • Transactions and queries
    • Retrieving data from a database
    • Single-step queries
  • Managing web sessions
    • Using PHP session handling
    • PHP cookie handling
  • Handling date & time in PHP
    • Diplaying dates & times
    • Parsing a date or time
    • Generating relative times
  • Working with files in PHP
    • Reading & writing files with PHP
    • File permissions
    • Handling errors
  • Working with XML data in PHP
    • Understanding XML
    • RSS Feeds
  • Sending email using PHP
    • PHP Email settings
    • Sending text messages using PHP
    • Sending HTML formatted email messages using PHP
  • Debugging PHP Code
    • PHP Error handling
    • PHP debugging tools
    • Suppressing errors

Class Size

This class is limited to a maximum of 12 students.

On-Site Delivery

This course is available for on-site delivery for groups of 3 or more students.

OTG offers discounted training for on-site courses of more than 3 students - call us at 877-258-8987 (or submit the form on the upper right side of this page) for more information.

Course Details

Upon completion of this course, students will be able to:

  • Develop PHP scripts that perform decision making and looping tasks
  • Develop PHP scripts that integrate with a WWW server, and do the following:
    • Handle the processing of GET and POST forms
    • Securely produce output that prevents Cross-Site Scripting (CSS) attacks.
    • Securely process input from users, to prevent Shell Injection attacks
    • Set and retrieve cookies stored on the client web browser
    • Securely store and retrieve session information, without placing the information on the client browser (so it cannot be tampered with, and is not visible to the client)
    • Dynamically generate web pages as well as pre-populate web forms.
    • Create secure web pages that require authentication and are user specific
    • Create shopping cart type applications, which store user session information
  • Understand how to interact with a database
    • Understand basic database concepts
    • Design a database schema to store data
    • Create and execute queries to store and retrieve data from a databases
    • Integrate with back-end databases, using a databases-independent method
  • Communicate with a database using PHP
    • Integrate with a database server (such as MySQL, PostgreSQL, Oracle, DB2, Informix, MS SQL Server, etc.) to store and retrieve data
    • Interface with DB2 on the IBM iSeries (i5/OS) platform
    • Convert user submitted information to "database safe" information, to prevent SQL Injection attacks
    • Perform single-step operations to store and retrieve information from a database
  • Work with XML data
    • Create RSS aggregators
    • Generate dynamic RSS feeds
    • Retrieve and parse XML data using PHP
  • Send email using PHP
    • Send HTML Formatted email messages
    • Send text email messages

Instructional Materials
The following materials are used to deliver this course:
  • OTG Course Guide
  • Learning PHP 5 (O'Reilly & Associates)
Adobe PDF Logo View course guide table of contents
Requires Adobe Acrobat Reader

Enroll in this course

Activestate Logo

PostgreSQL Admin Training Logo

View upcoming course calendar

info@otg-nc.com
877-258-8987