How to import large Dump mysql database file for mysql?
How to import large database file for mysql? Big Dump MYSQL file using php....
How to integrate simple PHP CAPTCHA script?
How to integrate simple PHP CAPTCHA script?Many times public form will spam data. We can prevent spamming data using PHP CAPTCHA script....
MYSQL GROUP BY Clause
The GROUP BY statement is often used with aggregate functions like COUNT, MAX, MIN, SUM, AVG to group the result-set by one or more columns. The MYSQL GROUP BY Clause is used to collect data from multiple records and group the result by one or more column. It is generally used in a SELECT statement....
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 tables. The CROSS JOIN clause returns the Cartesian product of rows from the joined tables. The CROSS JOIN is also known as CARTESIAN JOIN, which provides the Cartesian product of all associated tables. if each table has n and m rows respectively, the result set will have n x m rows....
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 found from the first (left-side) table. If it will not find any matches record from the left side first table, then returns null....
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 found from the second (right side) table. If it will not find any matches record from the right side table, then returns null....
MYSQL - INNER JOIN Query
INNER JOIN keyword is used to join two tables and selects records that have matching values in both tables....
MYSQL - SELECT Query
MYSQL SELECT Query is used to fetch existing records from database....
MYSQL - DELETE Query
MYSQL DELETE Query is used to delete existing records in a table....
MYSQL - UPDATE Query
MYSQL UPDATE Query is used to update existing records in a table....
MySQL - insert into
MySQL - insert into statement is used to insert new records in a table. Insert query doesn't have WHERE clause....
MySQL - Create Table
The CREATE TABLE statement is used to create a new table in MYSQL database....
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....
MySQL - Connection
You can establish the MySQL database server connection using the mysql command at the command prompt or using php mysql function....
MySQLi - PHP Syntax
PHP - MySQLi Functions - MySQL can be used with PHP programming languages. PHP provides verious function to call mysql database query....
MySQL - Introduction
What is MYSQL Database? MySQL is a freely available open source Relational Database Management System (RDBMS) that uses Structured Query Language (SQL). Mysql database is used to store data....
PHP oops - Magic Method
Magic methods are special methods that are used to perform certain tasks in PHP. Magic methods are started with double underscore (__) as prefix. The function __construct(), __destruct(), __call(), __callStatic(), __get(), __set(), __isset(), __unset(), __sleep(), __wakeup(), __serialize(), __unserialize(), __toString(), __invoke(), __set_state(), __clone() and __debugInfo() are called as Magic Methods in php...
PHP oops - Method Overloading
If method have same name and different quantities and types of parameters, then it is called as Method Overloading in most object oriented languages. But in php, magic methods are used to achieve method overloading....
PHP OOPs - The final Keyword
The final keyword can be used to prevent class inheritance. The final keyword can be used to prevent method overriding....
PHP OOPs - Method Overriding
If both parent and child classes have same function name with number of arguments, then it is called Method Overriding in php object oriented programming....