MySQL – Locate : Syntax :- SELECT LOCATE(‘<< Find STRING >>’,‘<< COLUMN or VALUE’); Result : Return the string position Example :- SELECT LOCATE(‘Singapore’,‘Malaysia, Singapore’);
Read MoreMySQL | Locate | Find text or word in MySQL
Month: September 2018
nginx | Page Redirect from OLD URL to NEW URL.
Redirect Page from OLD URL to NEW URL Nginx : Syntax : rewrite ^/<OLD LOCATION>$ <NEW LOCATION> permanent; Example : rewrite ^/oldlocation$ http://www.newdomain.com/newlocation permanent;
Read MorePHP | mail | Send email thru PHP mail function.
Send mail thru PHP Mail function Mail Function send an email from the direct PHP Script. Syntax : mail(to,subject,message,headers,parameters); Example : $to = “text1@gmail.com”; $subject = “HTML email”; $message = “<html><head><title>HTML email</title></head> <body> <p>This email contains HTML Tags!</p> <table> <tr><th>Firstname</th><th>Lastname</th></tr> <tr><td>John</td><td>Doe</td></tr> </table></body></html>”; $headers = “MIME-Version: 1.0” . “\r\n”; $headers .= “Content-type:text/html;charset=UTF-8” . “\r\n”; $headers .= ‘From: <text@gmail.com>’ . “\r\n”; mail($to,$subject,$message,$headers);
Read MoreMySQL | Find and Replace text in Column value
Find and Replace text in Column value The below example shows the find and replace text in column values in MySQL tables. Syntax : UPDATE `<Table Name>` SET `<Field Name>` = replace(fieldName, FIND_TEXT, REPLACE_TEXT) Example : UPDATE `Employee` SET `allImageURLsMobile` = replace(allImageURLsMobile, ‘/ids/’, ‘/ids/mobile/’)
Read MoreWordPress asking FTP Credentials to Install Plugins ?
Install WordPress PLUGIN without FTP Credentials in Dashboard ? Open WORDPRESS Folder EDIT wp-config.php Paste the below code snippet (define(‘FS_METHOD’, ‘direct’);) Save the FILE and refresh the dashboard.
Read MoreHow to add SSH key in Ubuntu ?
Add SSH Key in Server Open Terminal Command pbcopy < ~/.ssh/id_rsa.pub Open server terminal cd ~/.ssh pico authorized_keys paste the copied key.
Read MorePHP – PDF Generator
FPDF – PDF Generation FPDF is a PHP class which allows to generate PDF files with pure PHP, that is to say without using the PDFlib library. F from FPDF stands for Free: you may use it for any kind of usage and modify it to suit your needs. http://www.fpdf.org/ fPDF Tutorial – Sample Code :- require(‘fpdf/fpdf.php’); $pdf = new FPDF(); $pdf->AddPage(); $pdf->SetFont(‘Arial’,’B’,16); $pdf->Cell(40,10,’Hello World!’); $pdf->Output();
Read MoreCopy SSH key to Clipboard
How to Copy SSH Key to ClipBoard ? Mac Open Terminal Command pbcopy < ~/.ssh/id_rsa.pub
Read MoreHow to compress files and folders in Ubuntu ?
Compress Files and Folders in Ubuntu Zip File / Folder apt-get install zip zip -r <<FILENAME>>.zip <<FOLDERNAME>> Rar / Unrar To extract the contents of a .rar file, run this command unrar e file.rar Compress Files, Folders & Subfolders rar a -r <<FILENAME>> <<FOLDER NAME>> UnCompress Files, Folders & Subfolders unrar x <<FILENAME>>.rar <<FOLDER>>
Read MoreDefault nginx path in ubuntu ?
Nginx Path in Ubuntu /etc/nginx/nginx.conf Edit nginx.conf in Ubuntu pico /etc/nginx/nginx.conf cat /etc/nginx/nginx.conf vi /etc/nginx/nginx.conf Restart nginx Service service nginx restart
Read More