Course Date Duration
PHP and MySQL (Beginner – Intermediate) Kindly contact us for more information 3 days

PHP and MySQL (Beginner – Intermediate)

OVERVIEW

This class introduces the participants to develop dynamic, secure, commercial Web sites to reflect the rapidly changing landscape of MySQL and PHP. This will broaden the scope to integrate and implement these technologies by following real-world examples and working sample projects, and also covers related technologies needed to build a dynamic web site.

PHP and MySQL (Beginner – Intermediate)

Installation

  • Windows Installation
  • All-in-one Installation
  • Installing Individual Packages
  • Editing PHP Scripts - Free IDE
  • Introducing PHP

  • Syntax and Statements
  • Variables, Operators, and Comments
  • Arrays
  • User Interaction and Forms
  • Control Structures
  • Use PHP Templates
  • PHP functions

  • Defining a & Calling a Basic Function
  • Call-by-value & Call-by-reference
  • Mathematical Functions
  • String ,Date, and Time Functions
  • Anonymous Functions
  • Introducing MySQL

  • Structured Query Language
  • Creating a Database
  • Creating a Table
  • Inserting/ Viewing/ Modifying/ Deleting Data into a Table
  • Functions for Use with GROUP BY Clauses
  • Publishing MySQL Data on the Web with PHP

  • Connecting to MySQL with PHP
  • Sending SQL Queries with PHP
  • Handling SELECT Result Sets
  • Inserting / Deleting Data into the Database
  • Relational Database Design

  • SELECT with Multiple Tables
  • Simple Relationships
  • Many-to-Many Relationships
  • One for Many, and Many for One
  • Advanced SQL Queries

  • Sorting SELECT Query Results
  • LOCKING TABLES
  • Column and Table Name Aliases
  • GROUPING & LIMITING SELECT Results
  • LEFT JOINs
  • Structured PHP Programming

  • Including HTML Content
  • Including PHP Code
  • Shared Include Files
  • Advance Custom Functions and Function Libraries
  • Variable Scope and Global Access
  • Cookies, Sessions, and Access Control

  • How Sessions Work in PHP
  • Session Code & Functions
  • Configuration Issues
  • How Cookies Work in PHP
  • Sending HTTP Headers
  • Binary Data

  • Handling File Uploads
  • Recording Uploaded Files in the Database
  • Storing Files
  • MySQL Packet Size
  • PHP Script Timeout
  • Contact Us for More Information

    Interested with the training course? Need more information? Contact Us.

    Contact Us