College of Information and Communication Technologies

College of ICT

University of Dar Es Salaam

Short courses

PHP & MySQL Programming

  • Date: - -
  • Venue: Gold Crest Hotel, Mwanza
  • Cost: TZS 1,200,000
  • Contact: 0715677873 | oscar.mashauri@udsm.ac.tz
  • Register

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

Introduction

  • PHP and MySQL Overview
  • What is a Web Server

Setup Dev Server

  • Installing Web server (WAMP, 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

Object Oriented Programming

  • 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 Arrays
  • Associative Arrays
  • Multidimensional Arrays
  • Array Functions

MySQL Database

  • 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.

Log in