J223: MySQL and PHP Programming: Complete Solution - 5 days

Who Should Attend:

Web designers and programmers, software engineers, systems analysts, applications programmers, computer science students, and anyone who is interested in finding a complete solution to Intranet/Internet based computing as well as Database management and OS management using scripting languages.

Prerequisites:

Knowledge on web and browsers as well as basic programming experience with scripting languages like Perl is recommended.

Objectives:

MySQL and PHP programming enables an individual to set up an e-commerce platform for commercial purposes. These software packages are popular freeware, which are easily available to small-and medium size enterprises. The actual platform can be hosted either on Windows or on Linux operating systems for added flexibility and economy to the company.

Contents:

Introduction to E-Commerce.

PHP Introduction: Storing and Retrieving Data; Using Arrays; String Manipulation and Regular Expressions; Reusing Code and Writing Functions; Object-Oriented PHP.

Using MySQL and Basics of MySQL Administration: Designing Your Web Database; Creating Your Web Database; Working with Your MySQL Database; Accessing Your MySQL Database from the Web with PHP; Advanced MySQL.

Security Issues: E-commerce Security Issues; Implementing Authentication with PHP and MySQL; Implementing Secure Transactions with PHP and MySQL.

Advanced PHP Techniques: Interacting with the File System and the Server; Using Network and Protocol Functions; Managing the Date and Time; Generating Images; Using Session Control in PHP.

Combining PHP and MySQL: Building a Shopping Cart, Content Management System, Web-Based Email Service, Mailing List Manager and Web Forums.

Installing PHP 4 and MySQL.