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 MoreDay: September 26, 2018
MySQL | 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 More