php - dynamic table in email -


i have been trying last few hours create dynamic table within email.. , have been unsuccuessful have tried create tables in , out of body varible , echo within have had no success have placed code bellow.. anyhelp great thanks.. im trying create table mysql data within , send clients.. thats run down of have been attemoting complete

$link = mysql_connect('localhost', 'root', '');     mysql_select_db('netbookdb');     $sql="select * rep_log s_date = '2012-05-31'";     $result=mysql_query($sql, $link);   $date=date('dmy'); require("../phpmailer/class.phpmailer.php"); $mail = new phpmailer();$mail = new phpmailer(); $mail->issmtp();    // set mailer use smtp $mail->host = "smtp";    // specify main , backup server  $mail->from = "support@.vic.edu.au";     $mail->fromname = "ict devices";    $mail->addaddress("email@h.vic.edu.au", "matthew");   $mail->subject = "damage log report";  $mail->ishtml(true); $var='xlsx'; $date=date('dmy.');  $mail->body = " while($rows=mysql_fetch_array($result)){         $cases=$rows['cases'];         $hg=$rows['hg'];         $surname=$rows['surname'];         $firstname=$rows['firstname'];         $claim=$rows['claim'];         $damage=$rows['damage'];         $cost=$rows['cost'];      }"; $mail->altbody="please use html compaible email veiwer";    if(!$mail->send()) {    echo "error sending: " . $mail->errorinfo;; } else {    echo "letter sent"; }

i used peace of code created script create dynamic table , echo out body of email basic table improvements can made 

$link = mysql_connect('localhost', 'root', '');     mysql_select_db('your dataabse name');     $sql="select * rep_log claim='insurance' , s_date = '2012-05-31'";     $result=mysql_query($sql, $link);  $table= "<table width='100%' border='3' cellspacing='0' cellpadding='0'>"; $table .="<th>cases</th>"; $table .="<th>hg</th>"; $table .="<th>surname</th>"; $table .="<th>fristname</th>"; $table .="<th>claim</th>"; $table .="<th>damage</th>"; $table .="<th>cost</th>";      while($rows=mysql_fetch_array($result)){         $cases=$rows['cases'];         $hg=$rows['hg'];         $surname=$rows['surname'];         $firstname=$rows['firstname'];         $claim=$rows['claim'];         $damage=$rows['damage'];         $cost=$rows['cost'];     $table .="<tr>";     $table .="<td>$cases</td>";     $table .="<td>$hg</td>";     $table .="<td>$surname</td>";     $table .="<td>$firstname</td>";     $table .="<td>$claim</td>";     $table .="<td>$damage</td>";     $table .="<td>$cost</td>";     $table .="</tr>";       } $table .="</table>";  $date=date('dmy'); require("../phpmailer/class.phpmailer.php"); $mail = new phpmailer();$mail = new phpmailer(); $mail->issmtp();    // set mailer use smtp $mail->host = "smtp";    // specify main , backup server  $mail->from = "support@ac.vic.edu.au";     $mail->fromname = "ict devices";    $mail->addaddress("gs@hum.vic.edu.au", "matthew");   $mail->subject = "damage log report";  $mail->ishtml(true); $var='xlsx'; $date=date('dmy.');  $mail->body = "$table;"; $mail->altbody="please use html compaible email veiwer";    if(!$mail->send()) {    echo "error sending: " . $mail->errorinfo;; } else {    echo "letter sent"; }

Comments

Post a Comment

Popular posts from this blog

java - Play! framework 2.0: How to display multiple image? -

i need display gallery of photos. here template: @(photos: list[photo]) @title = { <bold>gallery</bold> } @main(title,"photo"){ <ul class="thumbnails"> @for(photo <- photos) { <li class="span3"> <a href="#" class="thumbnail"> <img src="@photo.path" alt=""> </a> </li> } </ul> } and here controller method: public static result getphotos() { return ok(views.html.photo.gallery.render(photo.get())); } and here photo bean : @entity public class photo extends model { @id public long id; @required public string label; public string path; public photo(string path, string label) { this.path = path; this.label = label; } private static finder<long, photo> find = new finder<long, photo>( long.class, photo.class); public static list<phot...
Read more

gmail - Is there any documentation for read-only access to the Google Contacts API? -

i want read-only access user's google contacts. there stackoverflow member wanted this, , received following answer : yes, there is, use https://www.googleapis.com/auth/contacts.readonly scope , "view contacts". this exchange reference read-only access google contacts can find using google. simply using access token obtained attempt read usual google contacts api (i.e. https://www.google.com/m8/feeds ) fails insufficient permissions. similarly, using google contacts api on new target fails 404 errors (for example https://www.googleapis.com/auth/contacts.readonly/default/full ). is there documentation anywhere on how use api, or permissible way access google contacts api full read-write access?
Read more

php - Controller/JToolBar not working in Joomla 2.5 -

relevant code: jtoolbarhelper::custom('savecategories', 'save', '', 'save', false, false); ... <input type="hidden" name="controller" value="easyblogcontroller"> according can dig docs , own previous questions, should call savecategories() function in easyblogcontroller . i've tried setting value easyblog , easyblog.php (file name) current easyblogcontroller (class name). clicking on save button refreshes page. not redirect, echo or var_dump test code put in savecategories() function. var_dump ing jrequest::getvar('controller') , 'task' return correct values. creating controller object , using $controller->execute('task'); works. the values going depend on location of controller trying call, , have couple options here. typically there controller in base folder of component (likely components/com_easyblog) in file called controller.php , class name inside ...
Read more