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,”http://www.yahoo.com/search?q=curl”); 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 […]