Centre for Virtual Learning

The College of Information and Communication Technologies

Univeristy of Dar es Salaam

PHP & MySQL Course

 This PHP and MySQL course will provide you with the skills and knowledge beyond basics necessary to build powerful database-driven websites using PHP programming advanced tips and techniques.

 

This PHP and MySQL course is practical oriented which includes demonstrations and hands-on exercises.You’ll able to establish database connection and perfom useful SQL command like fetch, insert, update, delete, and search records. You’ll get familiarize with phpMyAdmin on how to create databases and tables, as well as data types and indexes. You'll know how to work with forms, validate and sanitize form input for security, understand how sessions and cookies works.

 

Course Outline

Introducing Database Driven Website

  • PHP and MySQL Overview
  • What is a Web Server

Setting Up a Development Server

  • Installing Web server (WAMP, MAMP, or LAMP)
  • Testing the Installation
  • Configuring PHP
  • Configuring MySQL

PHP: Understanding The Basics

  • Basic Syntax
  • Data Types

Expressions and Loops in PHP

  • Expressions
  • Operators
  • Conditionals
  • Looping

Working With PHP Functions

  • Defining a Function
  • Function Arguments
  • Return a Value
  • Return an Array
  • Scope and Global Variables

Introduction to PHP OOP

  • Why Object Oriented
  • What is Class, Object ?
  • Define a Class
  • Declaring Class Properties
  • Create and Accessing Objects
  • Constructors
  • Static Properties And Methods
  • Accessing Classes without Instantiation
  • Inheritance And Interfaces

Working with PHP Arrays

  • Indexed Arrarys
  • Associative Arrays
  • Multidimentional Arrays
  • Array Functions

Introduction to MySQL

  • What is MySQL?
  • Basic SQL Commands
  • Creating A Database
  • Indexes
  • MySQL Functions
  • Establishing Relationships And Constraints
  • Normalization
  • Transanctions
  • Backing Up and Restoring
  • PhpMyAdmin Overview

Build Database Driven Web Site Project

  • Make Database Connection
  • Accessing Database Tables using PHP Data Object (PDO)
  • Working with Forms
  • Forms Validation
  • Regular Expressions
  • Uploading Form Data Securely with PHP
  • Using MVC architecture
  • User Authentication, Sessions and Cookies

Style Web Project with CSS and JavaScript

  • Introduction to BootStrap CSS
  • Styling Body and Header
  • Working with List Styles
  • Working with Table Styles
  • Style Forms
  • Using Javascript Components

MySQL Backup and Restore

  • Introduction
  • Backup With mysqldump
  • Restore database

Finalize Project

  • Remote Access
  • Using FTP to Upload the Project

Who Should Attend This Course?

  • Anyone who wants to learn PHP programming and develop a dynamic website easily.
  • Anyone who wants to build a powerful dynamic database-driven website.
  • Anyone who wants to convert a static website to dynamic one.
  • Anyone who wants use the MVC pattern to organize code.

How to make Payment

The fees Paid by cash should be deposited to NBC Bank, Account Name: Centre for Virtual Learning, Account Number: 040103002088 and by Cheque should be made payable to the Director, Centre for Virtual Learning (CVL), University of Dar es Salaam. Come with deposit(s) slip.

Mon 02 Apr 2018 - Fri 06 Apr 2018
16:00 PM. - 18:30 PM.
Kijitonyama Campus
0754677873
TZS 350,000

Office Contact

Centre for Virtual Learning
University of Dar es Salaam
P.O. Box 33335
Kijitonyama Campus

Phone: (+255)-22-2700766
Fax: (+255)-22-2700766
Email: cvl@udsm.ac.tz