PHP and MySQL: Web Development

PHP and MySQL: Web Development

A session with Practical PHP can help you decipher string and date and time Functions. It also allows you to manipulate files, call on system calls and modify MySQL Objects and PHP Data. Moreover, you can change database objects from PHP, update and delete data and perform a subquery. You can also validate and handle errors as well as study security in a separate session on cookies, and HTP authentication session. Your wait for learning PHP and MySQL and web development are therefore over. Course Contents (8 sessions of 3hrs each)
Day 1 Form (text field, password field, textarea, radio buttons, checkbox, file, select menu, buttons) Day 2 Dynamic Content and the Web
· PHP and MySQL's in Web Development
· Components of a PHP Application
· Integrating Many Sources of Information
· Requesting Data from a Web Page PHP and Dynamic HTML pages
· PHP and HTML Text
· Coding Building Blocks
Day 3 PHP Decision Making
· Expressions
· Operator Concepts
· Conditionals
· Looping
Functions
· Calling Functions
· Defining Functions
· Object-Oriented Programming

Day 4 Arrays
· Array Fundamentals
Database Basics
· Database Design
· Structured Query Language
Using MySQL
· Advanced SQL
Day 5 PHP to Talk to MySQL for Shopping Cart Design
· Shopping Cart Design Process
· Querying the Database with PHP Functions
· Database SQL language
· Select statement,
· update statement,
· create statement
· delete statement
· drop statement
· overview of database planning and design
Working with Forms
· Building a Form
· Templates
Day 6 Practical PHP
· String Functions
· Date and Time Functions
· File Manipulation
· Calling System Calls
Modifying MySQL Objects and PHP Data
· Changing Database Objects from PHP
· Manipulating Table Data
· Displaying Results with Embedded Links
· Presenting a Form to Add and Process in One File
· Updating Data
· Deleting Data
· Performing a Subquery
Day 7 Cookies, Sessions, and Access Control
· Cookies
· PHP and HTTP Authentication
· Sessions
· Using Auth_HTTP to Authenticate
Security
· Session Security
Day 8 Validation and Error Handling
· Validating User Input with JavaScript
· Pattern Matching
· Redisplaying a Form After PHP Validation Fails
Create Functional Shopping Cart
· Create PHP Product Page
· Product Update Page
· Search Page
· Shopping Basket
· Customer Page
· Check out page
Project work
· Professional Shopping Cart
After Course Free Lab Access