On going through training course of PHP along with MYSQL, you can learn database management system for creating dynamic data-driven applications and websites. You will gain command over database setup, forms creation, site security advanced training, E-commerce systems, and content management.
PHP is the open source scripting language that suits web development and able to embed into HTML. The most significant and strongest features of PHP are its ability to support various wide range databases like MYSQL.
Setting Development Environment Of PHP
PHP, MYSQL, Apache introduction
Development releases vs production / stable
Working of PHP
Client side vs server side scripting
MYSQL, PHP, and Apache installing
Basics Of PHP
PHP scripts embedding
Delimiters alternative, variables, & datatypes
Sorting values in variable
Understanding, strings, integers, point numbers floating, Boolean values, and arrays
Print(), echo(), printf(), sprint() statement
Understanding arithmetic operators, arithmetic assignment operators, comparison operators, error control operators, increment / decrement operators, logical & string operators.
Control structure & returning values from functions
Information Passing With PHP
Superglobal arrays and variable scope
URL variables accessing, & session_destro() usage
Databases Working
MYSQL storage data basics
MYSQL tables manipulating data
Delete and create databases
Create table statement
MYSQL data types & indexes
Understand auto_increment and primary key
Select, insert, update, join, delete statement
Opening connection, MYSQLi extension, prepared statements usage, and MYSQLi usage
PDO (PHP Data Objects), database table planning, and shortcut selector.
Entry Manager Building
Database table entry, input form entry creating, input form script process creation, initial verification, database connection, update.inc.php database connection, database entry planning scripts.
Unique ID retrieve & display entry to user, logic in programming separation, saved entries output map to functions
Write database functions, business function, presentation code.
Multiple pages Support
Add page column to entries table
Modify functions for accepting page parameters
Accept page formation in URL
Use page formation for entries filtering
Page associations saving on modifying admin.php
Friendly URLs creation using .htaccess, create friendly URLs automatically
Add menu and create various view styles for pages
Delete & Update Entries
Create & display administrative links, pass URL value to admin.php using .htaccess, modify original admin rule.
Update entries in database, entry deletion handling, handle submitted confirmation form.
Upload Images
Add file to admin form, access upload file, write image handling class, save image, modify update.inc.php for saving images.
Use try & catch using exceptions, determine file extension, store & retrieve images from database, resize images
Syndicate Blog
Create RSS feed
Describe feed, create feed items, publish feed, add feed to blog
Add Comment System To Blog
Create comment table in database
Comment class building, comment entry form building, sorting new comments in database, retrieve comments for the given entry, display comments, and deleting comments