automatically send entire page in an email

[canajien]

How can I get a php page to automatically send all the contents in an
email when it is generated?

I managed to hack together a script that sends an email, but it will
only send the 1st record returned and I would like it to send all the
records that are on the page when it is loaded.

<?php
$con = mysql_connect("localhost","user","pass");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}

mysql_select_db("db", $con);

$sql = 'SELECT * FROM `table` WHERE status = "fail" AND `submitted` >
NOW() - INTERVAL 24 HOUR ';

$result=mysql_query($sql);

$i_mail = mysql_fetch_array($result);

$num = mysql_numrows($result);

$row = mysql_fetch_row($result);

if (!mysql_query($sql,$con))
{
die('Error: ' . mysql_error());
}

mysql_close($con)
?>

<?php
// displays records in browser
$i=0;
while ($i < $num) {

$visited=mysql_result($result,$i,"visited");
$submitted=mysql_result($result,$i,"submitted");

echo "<br><b>$visited</b$id<br>$submitted<hr>";

$i++;
}

?>

<?php
//sends the email automatically

//to and from addressess

$email = "em***@someurl.com";
$fromemail = "anotherem***@someurl.com";
// The subject

$subject = "warning";

// The message

$message = $i_mail['visited'].", ".$i_mail['submitted']."
http://someurl.com/display.php?id=".$i_mail['id']." \n";

mail($email, $subject, $message, "From: $fromemail");

echo "<p>The email has been sent.";

?>

[Gene Kelley]

Mc*******@gmail.com wrote:
<SNIP>

<?php
// displays records in browser
$i=0;
while ($i < $num) {

$visited=mysql_result($result,$i,"visited");
$submitted=mysql_result($result,$i,"submitted");

echo "<br><b>$visited</b$id<br>$submitted<hr>";

$i++;
}

?>

</SNIP>

>

Maybe part of the problem, maybe just a typo, but....

where are you initializing $id?
--
------------------------------------
Gene Kelley
Senior Open Source Software Engineer
Advanced Design Solutions Team
Network Solutions (MonsterCommerce)
Swansea, Illinois, USA

[canajien]

On Jun 9, 4:09 pm, Gene Kelley <[e-mail]:

[e-mail] wrote:

<SNIP>

<?php
// displays records in browser
$i=0;
while ($i < $num) {

$visited=mysql_result($result,$i,"visited");
$submitted=mysql_result($result,$i,"submitted");

echo "<br><b>$visited</b$id<br>$submitted<hr>";

$i++;
}

?>

</SNIP>

Maybe part of the problem, maybe just a typo, but....

where are you initializing $id?

--
------------------------------------
Gene Kelley
Senior Open Source Software Engineer
Advanced Design Solutions Team
Network Solutions (MonsterCommerce)
Swansea, Illinois, USA

that's just a typo, sorry

[canajien]

the code should read as follows (i forgot that i took $id out of it
when i was copying/pasting/etc...

<?php
$con = mysql_connect("localhost","user","pass");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}

mysql_select_db("db", $con);

$sql = 'SELECT * FROM `table` WHERE status = "fail" AND `submitted` >
NOW() - INTERVAL 24 HOUR ';

$result=mysql_query($sql);

$i_mail = mysql_fetch_array($result);

$num = mysql_numrows($result);

$row = mysql_fetch_row($result);

if (!mysql_query($sql,$con))
{
die('Error: ' . mysql_error());
}

mysql_close($con)
?>

<?php
// displays records in browser
$i=0;
while ($i < $num) {

$visited=mysql_result($result,$i,"visited");
$submitted=mysql_result($result,$i,"submitted");

echo "<br><b>$visited</b><br>$submitted<hr>";

$i++;

}

?>

<?php
//sends the email automatically

//to and from addressess

$email = "[e-mail]";
$fromemail = "[e-mail]";

// The subject

$subject = "warning";

// The message

$message = $i_mail['visited'].", ".$i_mail['submitted']."\n";

mail($email, $subject, $message, "From: $fromemail");

echo "<p>The email has been sent.";

?>

sorry about that

[Jerry Stuckle]

ca******@gmail.com wrote:

the code should read as follows (i forgot that i took $id out of it
when i was copying/pasting/etc...

<?php
$con = mysql_connect("localhost","user","pass");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}

mysql_select_db("db", $con);

$sql = 'SELECT * FROM `table` WHERE status = "fail" AND `submitted` >
NOW() - INTERVAL 24 HOUR ';

$result=mysql_query($sql);

$i_mail = mysql_fetch_array($result);

$num = mysql_numrows($result);

$row = mysql_fetch_row($result);

if (!mysql_query($sql,$con))
{
die('Error: ' . mysql_error());
}

mysql_close($con)
?>

<?php
// displays records in browser
$i=0;
while ($i < $num) {

$visited=mysql_result($result,$i,"visited");
$submitted=mysql_result($result,$i,"submitted");

echo "<br><b>$visited</b><br>$submitted<hr>";

$i++;

}

?>

<?php
//sends the email automatically

//to and from addressess

$email = "[e-mail]";
$fromemail = "[e-mail]";

// The subject

$subject = "warning";

// The message

$message = $i_mail['visited'].", ".$i_mail['submitted']."\n";

mail($email, $subject, $message, "From: $fromemail");

echo "<p>The email has been sent.";

?>

sorry about that

A couple of things.

First of all, don't use die() in a production system. It's good for
testing, but in a live system, put out an error message (NOT the results
from mysql_error()!) and bypass the rest of the script with an else {...
statement.

Using die() like you are displays some of the internals of your scripts
and can leave you open to hackers.

Also, you're calling mysql_query() twice. That just returns the same
result set a second time, creating unnecessary overhead.

Also, the mysql_fetch... calls only return one row at a time - not the
entire result set. So once you've gotten a good return value from your
SELECT statement, you need to loop to fetch all of the returned rows., i.e.

while ($i_mail = mysql_fetch_array($result)) {

Of course, each time you call mysql_fetch_array(), it will overlay the
previous data in $i_mail, so you either need to add the data to your
email now, or save it (i.e. in an array), i.e.

(initialize $message to '' before calling mysql_fetch_array!)

$message .= $i_mail['visited'].", ".$i_mail['submitted']."\n";

Hope this leads you to the correct solution.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================

[canajien]

THANKS!!!

thats a heck of a lot easier than what I was trying to do, and it
works

(I was trying to turn:

<?php
// displays records in browser
$i=0;
while ($i < $num) {

$visited=mysql_result($result,$i,"visited");
$submitted=mysql_result($result,$i,"submitted");

echo "<br><b>$visited</b><br>$submitted<hr>";

$i++;

}

?>

into a function and have $message=function

[Jerry Stuckle]

ca******@gmail.com wrote:

THANKS!!!

thats a heck of a lot easier than what I was trying to do, and it
works

(I was trying to turn:

<?php
// displays records in browser
$i=0;
while ($i < $num) {

$visited=mysql_result($result,$i,"visited");
$submitted=mysql_result($result,$i,"submitted");

echo "<br><b>$visited</b><br>$submitted<hr>";

$i++;

}

?>

into a function and have $message=function

Yep, we all go through doing things the hard way when we're learning.

Then we find the easy way.

Then we find the fastest way and create the most unmanageable mess
you've ever seen :-)

Glad to be of help.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================

[canajien]

On Jun 10, 2:18 pm, Jerry Stuckle <[e-mail]:

[e-mail] wrote:

THANKS!!!

thats a heck of a lot easier than what I was trying to do, and it
works

(I was trying to turn:

<?php
// displays records in browser
$i=0;
while ($i < $num) {

$visited=mysql_result($result,$i,"visited");
$submitted=mysql_result($result,$i,"submitted");

echo "<br><b>$visited</b><br>$submitted<hr>";

$i++;

}

?>

into a function and have $message=function

Yep, we all go through doing things the hard way when we're learning.

Then we find the easy way.

Then we find the fastest way and create the most unmanageable mess
you've ever seen :-)

Glad to be of help.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
[e-mail]
==================

:)