PHP Mysql Tutorial for Beginners to Masters

PHP Mysql Tutorial for Beginners to Masters

By Deependra Singh Baghel

200

PHP MYSQL Tutorial for Beginners to Masters


This tutorial made for Beginner to Masters level students.in this tutorial we will cover all basic and advanced topics in php

PHP Tutorial Topic  

  • Introducation of PHP
  • History of PHP
  • PHP Environment Setup 
  • First Program Of PHP (Hello World)
  • PHP Syntex 
  • PHP Comment
  • PHP Variable
  • PHP Data Type
  • PHP print Operation
  • PHP Array Operation
  • PHP String Operation
  • PHP Number Operation
  • PHP Math Operation
  • Constants in PHP 
  • PHP Operators
  • PHP Conditional Statements
  • Switch Statement 
  • Loops in PHP 
  • Function in php 
  • Variable Scope in php 
  • Superglobal Variable in php 
  • isset and empty function in php 
  • form hendling in php 
  • form validation in php 
  • PHP Date Time Operation 
  • include and require in php 
  • File Handling in php 
  • File Upload in PHP 
  • PHP Filter 
  • json_encode and decode function in php 
  • impload and expload function in php 
  • E-Mail Sending 


PHP MYSQL

  • What is OOP
  • What is class/object
  • Constructor
  • Destructor
  • Access Modifiers in php
  • Inheritance
  • Constants
  • Abstract Classes
  • Static Methods
  • Static Properties
  • php Namespaces


PHP MYSQL

  • What is PHP MYSQL
  • What is phpmyadmin 
  • how to connect php to mysql(mysqli function in php)
  • Create db using php
  • Create table using php
  • Insert data in php
  • Get last insert id in php
  • Insert multipal data in mysql
  • Select Data Usingh PHP
  • PHP Where
  • Oreder By 
  • Group By
  • SUM ANd COUNT in PHP
  • PHP JOIN
  • delete data using php 
  • Update data using php 
  • Limit in mysql 


PDO MYSQL

  • What is PDO
  • insert Data using pdo 
  • select data using pdo
  • where using pdo
  • delete data using pdo
  • update data using pdo


PDO MYSQL

  • What is Jquery
  • What is AJAX 
  • Save Data Usign AJAX
  • GET Data Using AJAX 
  • Delete Data Using AJAX
  • Update Data Using AJAX
  • Live Search in PHP