MYSQL - CROSS JOIN Query
MySQL CROSS JOIN is used to combine all possibilities of the two or more tables and returns the result that contains every row from all contributing t...
MYSQL - RIGHT JOIN Query
RIGHT JOIN Query in mysql is used to join multiple tables which return all the records from the second (right side) table even no matching records fou...
MYSQL - LEFT JOIN Query
LEFT JOIN Query in mysql is used to join multiple tables which return all the records from the first (left-side) table even no matching records ...
MYSQL - INNER JOIN Query
INNER JOIN keyword is used to join two tables and selects records that have matching values in both tables. MYSQL Syntax : SELECT field_name1, ...
MYSQL - SELECT Query
MYSQL SELECT Query is used to fetch existing records from database. You can fetch one or more data from table. If You specify star (*) in plac...
MYSQL - DELETE Query
MYSQL DELETE Query is used to delete existing records in a table. You can delete one or more field altogether. You can use any condition using...
MYSQL - UPDATE Query
MYSQL UPDATE Query is used to update existing records in a table. You can modify one or more field altogether. You can use any condition using...
MySQL - insert into
MySQL - insert into statement is used to insert new records in a table. Insert query doesn't have WHERE clause. MYSQL Syntax : INSERT INTO ...
MySQL - Create Table
The CREATE TABLE statement is used to create a new table in MYSQL database. MYSQL Syntax : CREATE TABLE table_name ( column1 ...
MySQL - Create Database
You have the root user access to create database in mysql. The CREATE DATABASE statement is used to create a new MYSQL database. You can create new...
MySQL - Connection
You can establish the MySQL database server connection using the mysql command at the command prompt or using php mysql function. MYSQL Command ...
MySQLi - PHP Syntax
MySQL can be used with PHP programming languages. PHP provides verious function to call mysql database query. We can develop good web applicatio...
MySQL - Introduction
What is MYSQL Database? MySQL is a freely available open source Relational Database Management System (RDBMS) that uses Structured Query Language (...
PHP oops - Magic Method
What is Magic Method in php? Magic methods are special methods that are used to perform certain tasks in PHP. Magic methods are started with double...
PHP oops - Method Overloading
What is Overloading in PHP? If method have same name and different quantities and types of parameters, then it is called as Method Overloading in m...
PHP OOPs - The final Keyword
The final Keyword is used for below purposes. The final keyword can be used to prevent class inheritance. Final class can not be inherited by an...
PHP OOPs - Method Overriding
What is Method Overriding in php? If both parent and child classes have same function name with number of arguments, then it is called Method Overr...
PHP OOPs - Inheritance
What is Inheritance in php? When the child class can inherit all the public and protected properties and methods from the parent class, it is calle...
PHP OOPs - Interfaces vs. Abstract Classes
What is difference between Abstract class and Interfaces in php? Difference between Abstract class and Interfaces. Abstract class ...
PHP OOPs - Interfaces
What is an interface in php? An interface contains All abstract methods by default. An interface doesn't have any common methods. Methods of in...
PHP oops - Abstract class
What is an abstract class in PHP? An abstract class is a class that contains at least one abstract method. An abstract method is a method that is d...
PHP oops - $this Keyword
$this keyword is used to access current properties and methods in a class. $this is used to point the current object of class in php. We can also u...
PHP oops - Destructor
What is PHP oops - Destructor? A destructor is called when the object is destructed or release any object from its memory. A destructor is used ...
PHP oops - Constructor
What is PHP oops - Constructor? A constructor is a method defined inside a class which is called automatically when object is created. A constru...
PHP oops - Access Modifiers
What is Access Modifiers in php oops? PHP access modifiers are used to provide access rights for PHP classes and their members that are the functio...