How to count rows in a table ?

How to count rows in a table ? SELECT TABLE_NAME, TABLE_ROWS FROM `information_schema`.`tables` WHERE `table_schema` = ‘YOUR_DB_NAME’;


Essential PHP Interview Questions & Answer

1) Whats is CURL ? A command line tools for sending and getting files and response. 2) How to use CURL in PHP ? // Step 1 $cSession = curl_init(); // Step 2 curl_setopt($cSession,CURLOPT_URL,””); curl_setopt($cSession,CURLOPT_RETURNTRANSFER,true); curl_setopt($cSession,CURLOPT_HEADER, false); //Step 3 $result=curl_exec($cSession); //Step4 curl_close($cSession); //Step5 echo $result; 3) How to access authenticated WEBSITE Datas in CURL ? […]

How to create own sticker in WhatsApp

Ensure the WhatsApp version in WhatsApp. Sticker feature support only version. 2.18 or above. Open WhatsApp > Settings > Help > App Information. Check the version. Download FREE APPs to design own stickers. Popular FREE APP in Google Play Store to create sticker is Sticker Maker Download Sticker Maker for WhatsApp and Install It. Open […]

Sum of array values in Javascript

How to sum of array values in Javascript ? Sample :- array.reduce(function(a,b){return a + b;},0) Example :-  let invoiceAmount = [1000, 1500, 2000]; invoiceAmount.reduce(function(a,b){return a + b;},0); The above code return if the array is NULL and return the calculate value. Sum of array values in Javascript Packers and Movers in Dubai

MySQL Email column validation | MySQL Email Validation

MySQL Email Validation Simple code to remove duplicate email ids in MySQL and validation the email column also. Show only Valid Email records Example :- SELECT distinct email, email REGEXP ‘^[A-Za-z0-9._%\-+!#$&/=?^|~]+@[A-Za-z0-9.-]+[.][A-Za-z]+$’ AS valid_email FROM enquiry having valid_email > 0 Packers and Movers in Dubai

Generate CSV File in Javascript

How to Generate CSV File in Javascript //JSON DATAS var data = [ [‘Singaporean’, ‘Singapore’], [‘Indian’, ‘India’] ]; //CONVERT JSON Variant to TWO-DIMENSION Array var csvContent = ”; data.forEach(function(infoArray, index) { dataString = infoArray.join(‘;’); csvContent += index < data.length ? dataString + ‘\n’ : dataString; }); //Function to DOWNLOAD a file. var download = function(content, fileName, mimeType) { var a […]

How to enable less secure app access in Google.

Open Gmail Login with your account Copy and Paste the below URL Note : To enable less secure app access to be an high risk. Find Best Movers in Dubai

jQuery Cookies | jQuery Cookie Example

Jquery Cookies is lightweight plugin to read, write data in session. Plugin File  : To Set Cookie : $.cookie(‘the_cookie’, ‘the_value’); Read Cookie : $.cookie(‘the_cookie’); // => ‘the_value’ Delete Cookie : $.cookie(‘the_cookie’, null);

jQuery | JSON | Filter condition in jQuery

How to FILTER specific column values in JSON ? The below example filter the DATAs. Whatever the column productId = 4. The results return to the skuDatasContainer as JSON structure Example : var skuDatasContainer = jQuery.grep(       skuDatas,         function (item,index) {             return item.productId == […]

MySQL | Locate | Find text or word in MySQL

MySQL – Locate : Syntax :- SELECT LOCATE(‘<< Find STRING >>’,‘<< COLUMN or VALUE’); Result : Return the string position Example :- SELECT LOCATE(‘Singapore’,‘Malaysia, Singapore’);