Introduction to PHP and MySQL – 2 Day

Request info

PHP & My SQL Training

Introduction

  • Installing PHP & MySQL

  • Introducing PHP & MySQL

  • Installing Your Own Web Server

  • Your First PHP Script

MySQL Databases

  • Your First Database

  • An Introduction to Databases

  • Using phpMyAdmin to Execute SQL

  • SQL Basics

PHP Fundamentals Part 1

  • Introducing PHP

  • PHP Variables, Operators, and Comments

  • PHP Arrays

  • Passing Variables in Links

  • Passing Variables in Forms

PHP Fundamentals Part 2

  • PHP Conditional Statements

  • PHP Loops

  • PHP Functions

  • PHP Templates

  • Controllers and Templates

Displaying MySQL Content

  • Connecting to MySQL with PHP

  • Sending SQL Queries with PHP

  • Handling SELECT Result Sets

Modifying Database Content with PHP

  • Inserting Data into the Database

  • Deleting Data from the Database

  • Updating Data in the Database

Extended Database Design: Multi-table Queries

  • SELECT with Multiple Tables

  • Simple Relationships

  • Many-to-Many Relationships

Structured PHP Programming

  • Including HTML Content and PHP Code

  • Types of Includes

  • Custom Functions

  • Variable Scope and Global Access

Feeding Web Pages With AJAX

  • Creating the Client Side User Interface

  • Passing Data to Server Side PHP Using jQuery

  • Passing AJAX Data to Client Using PHP

Course Duration: 2 Days

Cost: £595 + VAT

 

PHP and MySQL Training Inverness, Aberdeen, Glasgow, Edinburgh, Dunfermline and other sites throughout the UK including onsite closed company courses are available.

SELECT wp_posts.*, wp_p2p.* FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) INNER JOIN wp_p2p WHERE 1=1 AND wp_posts.post_type = 'schedule' AND (wp_posts.post_status = 'publish') AND ( ( wp_postmeta.meta_key = 'start_date' AND CAST(wp_postmeta.meta_value AS DATE) >= '2017-11-21' ) ) AND (wp_p2p.p2p_type = 'schedule_to_courses' AND wp_posts.ID = wp_p2p.p2p_from AND wp_p2p.p2p_to IN (SELECT wp_posts.ID FROM wp_posts WHERE 1=1 AND wp_posts.ID IN (7020) AND wp_posts.post_type = 'courses' AND (wp_posts.post_status = 'publish') ORDER BY wp_posts.post_date DESC )) GROUP BY wp_posts.ID ORDER BY CAST(wp_postmeta.meta_value AS DATE) ASC