PHP & MYSQL FOR WEB DEVELOPMENT (INTERMEDIATE)

Category:
Open Source – PHP Programming

Synopsis:
PHP is a widely-used, general-purpose scripting language that was originally designed for web development, to produce dynamic web pages. It can be embedded into HTML and generally runs on a web server, which needs to be configured to process PHP code and create web page content from it. It can be deployed on most web servers and on almost every operating system and platform free of charge. PHP is installed on over 20 million websites and 1 million web servers.

Note: PHP is free software released under the PHP License. PHP License is the software license under which the PHP programming language is released. The PHP License is a GPL incompatible free software license according to the Free Software Foundation and the Open Source Initiative due to restrictions on the usage of the term PHP. For more information about PHP licensing, please visit http://www.php.net/license/

Objective:
This course designed to enable web developers and others with limited programming experience to build dynamic database driven e-commerce web sites using the PHP programming language. Since PHP is such a rich and task-specific language, the course covers the most important range of functions in depth, and equips delegates to understand the remaining less essential aspects. Extensive hands-on exercises provide you with the skills to produce dynamic Web pages, retrieve and manipulate data, track user navigation, and integrate database content

Prerequisites:
No prerequisite is required but experience in the following areas would be beneficial:

• HTML
• CSS
• Basic Programming

Duration:
4 Full Days

Content:

Day 1
EasyPHP & IDE (Integrated Development Environment)

Basic Programming Fundamentals
• Data Type
• Variable
• Constant
• Operator
• Condition
• Array
• Loop
• Form
• Function

Day 2
Introduction to MySQL
• Folders and path

MySQL shell
• Connection
• Database creation
• Table creation
• Insert
• Update
• Delete
• Limit
• Search

Using PHPMyAdmin

Linking PHP and MySQL

Project Development (with guidance)
• Web development methodology
• List
• Add
• Edit
• Delete
• Search

Day 3
PHP setting
• $_SERVER
• error_reporting

File Manipulation
• Read
• Write
• Append

Session and Cookies
• What is session
• What is cookies
• Creating login script
• Encryption using MD5

Day 4
Date Manipulation
• List of date manipulation function
• Insert date from PHP to MySQL
• Retrieve date from MySQL to PHP

File Upload
• $_FILES
• Form enctype

Project Administration
• Backup
• Security


Who Should Attend:
Web developers, designers and system administrators who need to create and maintain dynamic, database-driven Web sites. This course comes with some hands-on on project development with guidance.