MySQL

OBJECTIVES

At the end of this course, the participant will have understood and be able to use the main instructions of PHP language.  They will be able to create and manipulate data (interaction), create a simple form and integrate Flash elements using Action Script.


CLIENTELE

Web programmers, Web specialists and Webmasters

PREREQUISITES

Knowledge of HTML and a programming language.  Some basic knowledge of SQL is an asset.

DURATION

2 days (15 hours)

 

COURSE SYLLABUS

Presentation and installation of EasyPHP

 

Inserting a PHP Script in an HTML page

 

Variables, constants and data types

 

Operators, conditional expressions, loops and functions

 

Reading input from the user

 

Useful functions for Web development

 

Indexed and associative arrays

  • Sorting functions

 

Strings and regular expressions

 

Date and time functions

 

Sending e-mail with PHP

 

Managing a MySQL database using phpMyAdmin

 

Using a MySQL database

  • Connecting and disconnecting
  • SQL queries
  • Fetching results
  • Handling errors
TOP