Month: November 2018


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 […]