sophie17117

Sending php/html document as an email using php mail() function

sophie17117 replied to sophie17117's topic in PHP Coding Help

Daft question now--- So if i replace all of my echo statements with $email_body .= 'whaterver' then include $email_body in my email sending bit, this should work??? even for tables? ???

Sending php/html document as an email using php mail() function

sophie17117 replied to sophie17117's topic in PHP Coding Help

Still not so sure what i'm doing!!! ???

Sending php/html document as an email using php mail() function

sophie17117 replied to sophie17117's topic in PHP Coding Help

Thanks

Sending php/html document as an email using php mail() function

sophie17117 posted a topic in PHP Coding Help

Okay so heres the dillio deal- I need to send the following code in an email...but its a mix of php and html, and it retrieves various values from a database before sending...oh and i wouldnt mind the sending of the mail to be done on a button click!...anyways i have messed and messed but i aint too sure whether it can be done! Can someone please tell me the code and where i need to place it within my code? :queasy: i'll post it all for whoever wants to take a look! Thank you in advance Ps...I know my code is off the wall, i'm like this when i java program too!! <html> <link rel='stylesheet' type='text/css' href='style.css'> <TITLE>Network Operation Centre Morning Bulletin- Preview Bulletin</TITLE> <img align="left" align="top" src="TMDicon.JPG" alt="Icon" width="189" height="39"> <H2>Trader Media Digital Network Operation Centre Morning Bulletin</H2> <body> <?php $connect= mysql_connect('localhost','sophie-j','sophie'); if (!$connect) { echo("ERROR: Not connecting" . mysql_error() . "\n"); } mysql_select_db('sophie'); ?> <?php $day = date('l, '); $dtoday = date('Y-m-d'); $time = date('H:i:sa'); $timez = date('O T'); print "Date: $day $dtoday Time: $time. Time zone: $timez"; ?> <h2>Trader Media Digital - Service Issues:</h2> <big> Current Service Issues: </big> Incidents: The following services are unavailable or otherwise affected, as of 10:00 this morning: <?php $result = mysql_query("SELECT * FROM bulletin_data WHERE `RepDate` = '$dtoday'"); echo "<table border='1' cellspacing='0' cellpadding='0'> <tr> <th>Country</th> <th>Service</th> <th>Status Description</th> <th>RefNo</th> </tr>"; while($row = mysql_fetch_array($result)) { echo "<tr>"; echo "<td>" . $row['Country'] . "</td>"; echo "<td>" . $row['Service'] . "</td>"; echo "<td>" . $row['StatusDesc'] . "</td>"; echo "<td>" . $row['RefNo'] . "</td>"; echo "</tr>"; } echo "</table>"; echo "</table>"; echo ""; echo "<big>Historic service issues:</big>"; echo "Listed below are significant incidents encountered in the last 24 hrs that have been resolved: "; $results = mysql_query("SELECT * FROM bulletin_data WHERE `RepDate` = '$dtoday'"); echo "<table border='1' cellspacing='0' cellpadding='0'> <tr> <th>Country</th> <th>Service</th> <th>Summary</th> <th>Impact</th> <th>Time Period</th> <th>PastRefNo</th> </tr>"; while($row = mysql_fetch_array($results)) { echo "<tr>"; echo "<td>" . $row['PastCountry'] . "</td>"; echo "<td>" . $row['PastService'] . "</td>"; echo "<td>" . $row['IssueSummary'] . "</td>"; echo "<td>" . $row['IssueImpact'] . "</td>"; echo "<td>" . $row['TimePeriod'] . "</td>"; echo "<td>" . $row['PastRefNo'] . "</td>"; echo "</tr>"; } echo "</table>"; echo " "; echo "<h2>Trader Media Digital - NOC News:</h2>"; echo "<big>Deployments and Maintenance News for Today:</big> "; echo " Service Affecting Deployments and Maintenance"; $todayd = date('Y-m-d'); $resul = mysql_query("SELECT * FROM `bulletin_data` WHERE `RepDate` = '$todayd' AND `ServiceAffect` !=('NULL')"); echo "<table border='0'>"; while($row = mysql_fetch_array($resul)) { echo "<tr>"; echo "<td>". $row['ServiceAffect']."</td>"; echo "</tr>"; } echo "</table>"; echo " Non-Service Affecting Deployments and Maintenance"; $todaydy = date('Y-m-d'); $res = mysql_query("SELECT * FROM bulletin_data WHERE `RepDate` = '$todaydy' AND `NonServiceAffect` !=('NULL')"); echo "<table border='0'>"; while($row = mysql_fetch_array($res)) { echo "<tr>"; echo "<td>". $row['NonServiceAffect']."</td>"; echo "</tr>"; } echo "</table>"; echo " <big>Deployments and Maintenance News for Tomorrow:</big> "; echo " Service Affecting Deployments and Maintenance"; $dytoday = date('Y-m-d'); $reslt = mysql_query("SELECT * FROM bulletin_data WHERE `RepDate` = '$dytoday' AND `ServAffectTomrw` !=('NULL')"); echo "<table border='0'>"; while($row = mysql_fetch_array($reslt)) { echo "<tr>"; echo "<td>". $row['ServAffectTomrw']."</td>"; echo "</tr>"; } echo "</table>"; echo " Non-Service Affecting Deployments and Maintenance"; $todayday = date('Y-m-d'); $resu = mysql_query("SELECT * FROM bulletin_data WHERE `RepDate` = '$todayday' AND `NonServAffectTomrw` !=('NULL')"); echo "<table border='0'>"; while($row = mysql_fetch_array($resu)) { echo "<tr>"; echo "<td>". $row['NonServAffectTomrw']."</td>"; echo "</tr>"; } echo "</table>"; echo "Click 'Return' to go back and enter more data or click 'Send' to send the NOC Bulletin via e-mail."; echo "<input type='button' value='Return' onClick=\"window.location='http://nlwapp103/nocapps/sophie/'\">"; echo "<input type='button' value='Send' onClick='\"window.location='http://nlwapp103/nocapps/sophie/'\">"; msql_close($connection); ?> </body>[color=black][/color] </html>

[SOLVED] Simple array help needed urgently

sophie17117 replied to sophie17117's topic in PHP Coding Help

ive had insider help!!! i'm inserting all of my array data into separate tables into my database linking them using join now. I dare say i'll hit another problem soon thanks

[SOLVED] Simple array help needed urgently

sophie17117 replied to sophie17117's topic in PHP Coding Help

I have got it to print all the values to screen its just inserting them into my database. This is the code section in the index- <tr><td><select multiple align= "left" name="country[]" size="2"> <option>IE</option> <option>NL</option> <option>UK</option> <option>ZA</option> </select></td> then i have a page called issue, which just prints out the users selection to the screen and then inserts it into the database- $countries[]=<?php foreach($country as $value)echo "$value."; ?> insert bit- <?php $connect= mysql_connect('localhost','',''); if (!$connect) { echo("ERROR: Not connecting" . mysql_error() . "\n"); } mysql_select_db('sophie'); ?> <?php $insert = "INSERT INTO bulletin_data (RepDate, RepTime, Country, Service, StatusDesc, RefNo) VALUES ('$today','$time','$countries', '$services', '$status', '$refno')"; MYSQL_QUERY($insert) or die(mysql_error()); msql_close($connection); ?> when i call my insert statement i call $countries should i be using $country?

[SOLVED] Simple array help needed urgently

sophie17117 posted a topic in PHP Coding Help

I'm trying to loop through values and insert them into $countries so that i can put $countries into a database field. :-\ at the moment i have a preview page that, once in my index page i have selected multiple options in a menu, the user submitts and the preview page prints the multiple selections using <?php foreach($country as $value)echo "$value."; ?> i now need to put all those $values into one $countries array by looping through, but...i'm being blonde and really cant do it even though i no its simple!!! Students eigh!

Sign In

Posts

Joined

Last visited

Profile Information

sophie17117's Achievements

Newbie (1/5)

Reputation

Sending php/html document as an email using php mail() function

Sending php/html document as an email using php mail() function

Sending php/html document as an email using php mail() function

Sending php/html document as an email using php mail() function

[SOLVED] Simple array help needed urgently

[SOLVED] Simple array help needed urgently

[SOLVED] Simple array help needed urgently

Browse

Activity

Important Information