PHP & MySQL

PHP (Basic To Advance)

Course Details

  • →   Introduction
  • →   Data Types
  • →   Operators
  • →   Variables, Constants & Super Global Variables
  • →   If and Else & Switch Conditions
  • →   For, While & Foreach Loops
  • →   Functions & Arrays, Date & Time
  • →   Forms Handling & Sending Email
  • →   Session and Cookies
  • →   File handling
  • →   Include and Require Files
  • →   URL Rewriting
  • →   Captcha
 

MySQLi

  • →   Introduction
  • →   Database, Table & Columns structure
  • →   Database Connection
  • →   Primary (Auto Increment) & Foreign Key Concepts
  • →   INSERT, SELECT, UPDATE & DELETE Query
  • →   WHERE Clause, ORDER BY, LIMIT
  • →   JOINS, COUNT, IN, GROUP, HAVING, WILD CARD, MIN-MAX, AVG, SUM, BETWEEN etc.
 

COMBINE PHP & MySQLi

  • →   Login & Logout Page using SESSION
  • →   Fetch and Iterate data from Database
  • →   Search Page
  • →   CRUD Operation
  • →   Pagination
  • →   Image upload & Update
  • →   CSV File Generate and Upload
  • →   Multi-level category handle
  • →   WYSIWYG (CKEditor) Text area Implement
  • →   Dynamic lightbox image gallery
  • →   SQL Injection & Password encryption
  • →   Different types of form data insert in database and many more…
 

WHAT NEXT

  • →   Create database online and add user to this database
  • →   Upload project from local to online server
  • →   Error handling
  • →   Cron Job