About this Course

Learn how to create Dynamic, Online Applications - like Shopping Carts, Customer Databases, Online Stores, Accounting Systems, Membership Systems, all using PHP programming language, and the MySQL Relational Database.

Course Objectives

You Will Learn How To:

• Install, Setup and Create a database using MySQL
  
• Insert, Update, Delete Records in MySQL database tables
  

• Write Queries against the MySQL database & Retrieve data using specific criteria
  
• Write effective, efficient PHP scripts
  

• Embed PHP scripts in HTML pages to create dynamic Web pages
  
• Manipulate data from Web page forms
  

• Track users as they navigate your site with cookies and other PHP features
  
• Structure PHP code using user-defined functions and external libraries
  

• Develop database-enabled Web applications using MySQL ( You can also get an Introduction to MySQL database, and Oracle Database SQL Expertise in a separate training class too)
  

Course Outline

In this course, you develop PHP scripts to perform a variety of tasks, culminating in the development of a full database-driven Web application.

Exercises include:

• Creating A MySQL Database, Creating Tables, Fields, and Inserting Records in the MySQL Database tables
  
• Selecting Data from the MySQL database using various filtering criteria techniques.
  
• Sort, Format and Convert MySQL data using specific MySQL Functions and features.
  
• Generating Web pages dynamically using PHP
  
• Retrieving and manipulating form data
  
• Personalizing Web site content using cookies
  
• Tracking user navigation on your Web site
  
• Integrating database content to generate dynamic Web pages
  
• Building modular scripts to enable code reusability
  

1. Introduction to PHP
   
2. PHP language building blocks
   
3. Writing PHP scripts
4. Writing Web Pages with PHP
5. Interacting with the server
6. Manipulating user input
7. Applying Advanced Scripting Techniques
8. Exploiting the built-in functionality of PHP
9. Structuring PHP code
10. Building Complete Web Applications Managing errors
11. Handling problematic situations
    
12. Establishing database connectivity
    

Course Benefits

PHP is a scripting language used to create dynamic, complex and robust Web pages. It can seamlessly integrate with a wide range of database servers, including Oracle, MySQL and Microsoft SQL Server.

In this Introductory course on PHP programming, you gain a solid foundation for incorporating PHP techniques in your online, web based applications, and learn how to interface it with the MySQL database.

Extensive hands-on exercises provide you with the skills to produce dynamic Web pages, retrieve and manipulate data, track user navigation, and integrate database content.

Practical, Hands-On Exercises & Techniques to Gain a Solid Understanding of:

• Creating a User Login & Authentication System
  
• Sending Form Data to the MySQL Database
  
• Using Sessions & Cookies in PHP pages
  
• Insert, Update, Delete, Select and Display data from MySQL Database into the Web
  
• Search the Database and Display only Matching Results using PHP
  
• Use Pagination to Control Results Per Page
  
• Advanced Features & Structured Code Writing Tips
  

Target Audience

Those creating dynamic, database-driven Web sites. Basic experience with HTML is assumed. Prior Programming or PHP experience is helpful but not required.

Certification:

Certificate of attendance would be given to all participants who attend the complete training.

Materials:

Notes in folders will be provided.

Class Size: 

8-12 participants

Course Duration: 

3 Full Days - on PHP & MySQL

Rate this course:

Log in to submit

Comments