Duration: 5 Days

Essentially three courses in one: provides thorough introductions to the PHP language and the MySQL database, and shows how these two technologies can be effectively integrated to build powerful websites. When it comes to creating dynamic, database-driven Web sites, MySQL and PHP provide a winning open source combination. With this course, and there’s no limit to the powerful, interactive Web sites that developers can create.

In this 5 days training will basically covers step-by-step instructions, complete scripts, and tips to guide trainee. Not only this training includes the discussions on the scripting language (PHP) and then the database program (MySQL), it also goes on to cover security, sessions and cookies, and using additional Web tools, with several sections devoted to creating sample applications. This training is indispensable for intermediate- to advanced level Web designers who want to replace their static sites with something dynamic.

Basic programming language
Lesson 1: Introduction to PHP

  • Basic Syntax
  • Sending Data to the Web Browser
  • Understanding PHP, HTML, and White Space
  • Writing Comments
  • What Are Variables?
  • Introducing Strings
  • Concatenating Strings
  • Introducing Numbers
  • Introducing Constants
  • Single vs. Double Quotation Marks

Lesson 2: Programming with PHP

  • Creating in HTML Form
  • Handling an HTML Form
  • Conditionals and Operators
  • Validating Form Data
  • Introducing Arrays
  • For and While Loops

Lesson 3: Creating Dynamic Web Sites

  • Including Multiple Files
  • Handling HTML Forms, Revisited
  • Making Sticky Forms
  • Creating and Calling Your Own Functions

Lesson 4: Introducing to MySQL

  • Naming Database Elements
  • Choosing Your Column Types
  • Choosing Other Column Properties
  • Accessing MySQL

Lesson 5: Introduction to SQL

  • Creating Databases and Tables
  • Inserting Records
  • Selecting Data
  • Using Conditionals
  • Using LIKE and NOT LIKE
  • Sorting Query Results
  • Updating Data
  • Deleting Data
  • Using Functions

Lesson 6: Advanced SQL and MYSQL

  • Database Design
  • Performing Joins
  • Grouping Selected Results
  • Creating Indexes
  • Using Different Table Types
  • Performing FULLTEXT Searches
  • Performing Transactions

Lesson 7: Error Handling and Debugging

  • Error Types and Basic Debugging
  • Displaying PHP Errors
  • Adjusting Error Reporting in PHP
  • Creating Custom Error Handlers
  • PHP Debugging Techniques
  • SQL and MySQL Debugging Techniques

Lesson 8: Using PHP with MYSQL

  • Modifying the Template
  • Connecting to MySQL
  • Executing Simple Queries
  • Retrieving Query Results
  • Ensuring Secure SQL
  • Counting Returned Records
  • Updating Records with PHP

Lesson 9: Common Programming Techniques

  • Sending Values to a Script
  • Using Hidden Form Inputs
  • Editing Existing Records
  • Paginating Query Results
  • Making Sortable Displays

Lesson 10: Web Application Development

  • Sending Email
  • Date and Time Functions
  • Handling File Uploads
  • PHP and JavaScript
  • Understanding HTTP Headers

Lesson 11: Cookies and Sessions

  • Making a Login Page
  • Defining the Login Functions
  • Using Cookies
  • Using Sessions
  • Improving Session Security

Lesson 12: Security Methods

  • Preventing Spam
  • Validating Data by Type
  • Preventing XSS Attacks
  • Preventing SQL Injection Attacks
  • Database Encryption

Lesson 13: Perl-compatible Regular Expressions

  • Creating a Test Script
  • Defining Simple Patterns
  • Using Quantifiers
  • Using Character Classes
  • Finding All Matches
  • Using Modifiers
  • Matching and Replacing Patterns

Lesson 14: Making Universal Sites

  • Character Sets and Encoding
  • Creating Multilingual Web Pages
  • Unicode in PHP
  • Collation in PHP
  • Transliteration in PHP
  • Languages and MySQL
  • Time Zones and MySQL
  • Working with Locales

Register Now

Drop us your entry if you are interested to join this course.