GSAtrain

​

PHP Overview, Installation and Configuration

• Intro to PHP: Client-server model; Implementation
• Learn how a web server handles PHO scripts with embedded HTML
• Practical methods of PHP Installation on Windows: Configuring PHP using php.ini; Getting installation information using the phpinfo() function

PHP Programming Basics

• Introduction to the various parts of PHP programming language syntax and how it can dynamically generate HTML web pages
• Variables: What are they? What types exist? How are they used?

Program Control Flow

• Conditionals
• Loops
• Construct pitfalls

Form Data Capture and Email Disbursement

• Capture form data on the server
• Email form data or store it in a database

Associative Arrays

• Examine Each Variation
• Numerically indexed
• Associative Arrays

Database Recordsets

• MySQL (an open source relational database)
• MS Access

Database Queries with DBI and DBD

• DBI - "Database Independent"
• DBD - "Database Dependent"
• How to connect to several databases using "Structured Query Language" (SQL)
• • Any ODBC - compliant database on Windows (including MS Access)
  • A MySQL database server
  • A tab-delimited flat file (text)

Updating and Inserting Table Rows

• Change content of a table
• Update existing rows
• Insert new rows

Outputting a Recordset as XML

• Learn to use the DBIx::XML_RBD module: Turn a simple database into a real database server that can be queried from across the web with the help of a web server and some Perl scripts