MySQL CASE In WHERE CLAUSE: Conditional conditions
Before proceeding to know how to use MySQL CASE in where clause, be sure to be aware of what a MySQ...
Programming
Learn to program for the web. Learn PHP, HTML, jQuery, Codeigniter, MySQL Database, and much more.
Fetch different columns conditionally using MySQL CASE
Before using MySQL CASE to fetch different columns based on condition, i.e. using where clause to s...
Read Files and Directories in a Folder with PHP Glob
To read all the files in a particular directory using PHP, we can use the glob() function. Moreover...
How to dynamically call methods in PHP
A simple definition for methods is: Methods are functions encapsulated within a class. Now lets exp...
How to check undefined variable in JavaScript/jQuery
To check an undefined variable in JavaScript or jQuery, we can use one of these two methods. Com...
MySQL CONCAT() AND CONCAT_WS() functions
MySQL CONCAT() functionMySQL CONCAT_WS() function MySQL CONCAT() function MySQL CONCAT() func...
How to check variable types in PHP
To check variable types in PHP, we have many variable handling functions available. Below is the li...
How to export MySQL database using Command Prompt or batch file
To export MySQL database from command Line a set of commands need to be executed. Follow the steps ...
MySQL CHAR and VARCHAR Types
The CHAR and VARCHAR types are String Types in MySQL as they store string (or say text type) data. ...
PHP gettype() Function: Check data type by PHP get type
The PHP gettype() function is a PHP function that is used to check the type of variables. This PHP ...