Description

Type

Course

Methodology

Online

PHP & MySQL for Web Development Course OverviewThe PHP & MySQL for Web Development course is designed to give delegates the knowledge to develop/maintain HTML/PHP code that utilises the MySQL Database system.Who will the Course Benefit?UNIX and Windows Users, Web Developers and Programmers wishing to create web based systems utilising PHP and MySQL. Learning Objectives Course ObjectivesOn completion of the PHP & MySQL for Web Development course the delegate will have a good practical knowledge of how to write successful HTML/PHP code utilising a MySQL database.Skills GainedThe delegate will learn to:Install and Test MySQLBasic SQL SyntaxConnect to a MySQL Database with Error CheckingUse PHP to Interact with a MySQL DatabaseUtilise PHP with the HTML EnvironmentWork with Email and CookiesConsider Security Implications when using PHP and MySQL

About this course

Requirements

Pre-Requisite CoursesPHP Programming

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

All
Students
Centre

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

Web Development
Web
Database training
SQL
Database
Email
MySQL
PHP
HTML

Course programme

PHP & MySQL for Web Development Training CourseCourse Contents - DAY 1Course Introduction

Administration and Course Materials
Course Structure and Agenda
Delegate and Trainer Introductions

Session 1: MySQL

Installing MySQL
Testing MySQL

Session 2: BASIC SQL STATEMENTS

Creating Databases and Tables
Inserting Data into Tables
Viewing Tables
UPDATE
Drop

Session 3: CONNECTING TO MySQL

mysql_connect
mysql_error
mysql_select_db
Die

Session 4: USING PHP TO PERFORM DATABASE FUNCTIONS

Inserting Data into a Database
Creating Queries
Executing Queries
Processing the Returned Query Data
Updating the Database

PHP & MySQL for Web Development Training CourseCourse Contents - DAY 2Session 5: GENERATING HTML USING PHP

PHP Inside HTML
HTML Form with Embedded PHP
Multiple HTML Pages/Forms with PHP

Session 6: EMAIL AND COOKIES USING PHP

Generating Email using PHP
Generating Cookies using PHP
Using Cookies

Session 7: PHP AND DATABASE SECURITY

Designing Databases
Connecting to Database
Encrypted Storage Model
SQL Injection
Security Techniques
Error Reporting
User Submitted Data

See related categories

Contact us

PHP & MySQL for Web Development

Questions & Answers

Reviews

Subjects

Course programme

Add similar courses
and compare them to help you choose.

PHP & MySQL for Web Development

Questions & Answers

Reviews

Subjects

Course programme

Add similar coursesand compare them to help you choose.

Add similar courses
and compare them to help you choose.