How to count rows in a table ? SELECT TABLE_NAME, TABLE_ROWS FROM `information_schema`.`tables` WHERE `table_schema` = ‘YOUR_DB_NAME’;
Read MoreHow to count rows in a table ?
Month: November 2018
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 ? // http header: “Authorization: Basic “. base64_encode(“username:password”); // Set the below option for CURL curl_setopt($ch, CURLOPT_USERPWD, ‘username:password’); 4) What is Buffer ? Store all output results into a buffer for improving network performance. Access the…
Read MoreHow 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 Sticker Maker. Create New Group. Select the image from your mobile phone. But WhatsApp most preferred images are PNG with Transparent. Open the Group and Choose the tray icon image from your image gallery. Tray…
Read MoreSum 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
Read MoreMySQL 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
Read MoreGenerate 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 = document.createElement(‘a’); mimeType = mimeType || ‘application/octet-stream’; if (navigator.msSaveBlob) { // IE10 navigator.msSaveBlob(new Blob([content], { type: mimeType }), fileName); } else if (URL && ‘download’ in a) { //html5 A[download] a.href = URL.createObjectURL(new Blob([content], {…
Read More