This is a script that I've been working on to get the upcoming events within 7 days etc. from a mysql database. This is built into php fusion so many functions are used from that to reduce the work on my part. Something goes wrong at dbarray however and it only grabs one row from the db when there are more events that are under 7 days away. Where am I going wrong? (Everything works besides the actual array part.)
require_once "maincore.php";
$CurTimeStamp = time();
$CurDateName = date("l");
echo $CurDateName;
$Email = "";
define('DB_EVENTS',
DB_PREFIX.'aw_ec_events');
/*-------------------------------------------------------+
| Upcoming Events Search - Sunday
+--------------------------------------------------------*/
if ($CurDateName=="Sunday") {
$Day7 = "600937";
$CurDate7 = date("Y-m-d",$CurTimeStamp + $Day7);
$CurDate = date("Y-m-d",$CurTimeStamp);
echo $CurDate7;
echo "Sunday";
$result = dbquery("SELECT * FROM ".DB_EVENTS." WHERE ev_start BETWEEN '$CurDate' AND '$CurDate7' ");
if (dbrows($result)) {
echo dbrows($result);
$data = dbarray($result);
var_dump($data);
$Email = "1";
echo "Email";
/*-------------------------------------------------------+
| Creation of Email Message - Sunday
+--------------------------------------------------------*/
$subject = "Upcoming Events This Week";
foreach ($data as $row) {
$eventinfo = "<ul>";
$eventinfo .= "<li><a href='http://--.com/infusions/aw_ecal_panel/view_event.php?id=".$row['event_id']."'/> ".$row['ev_title']." </a>";
$eventinfo .= " on ".$row['ev_start']." from ".$row['ev_start_time']." ".$row['ev_start_ampm']." </li>";
$eventinfo .= "</ul>";
$message = "<html><table><tr><td><img src='http://--.com/images/calendar.png' /></td><td><h1 style='font-size:125%'>$subject</h1></td></tr>";
$message .= "<tr><td colspan='2'><hr>The following events are taking place this week: <br /><br />$eventinfo</td></tr><tr><td colspan='2'>";
$message .= "<a href='http://--.com/news.php'><img src='http://--.com/images/logo.png' /></a></td></tr></table></html>";
}
}
}
if ($Email=="1") {
echo "Sent";
require_once INCLUDES."sendmail_include.php";
$result = dbquery("SELECT 'user_email' FROM ".DB_USERS." ");
$email = dbarray($result);
$toname = "--";
$toemail = "--";
$fromemail ="admin@--.com";
$fromname = "--";
sendemail($toname, $toemail, $fromname, $fromemail, $subject, $message);
}
Here are the functions used as defined by PHP-Fusion:
function dbquery($query) {
$result = @mysql_query($query);
if (!$result) {
echo mysql_error();
return false;
} else {
return $result;
}
}
function dbrows($query) {
$result = @mysql_num_rows($query);
return $result;
}
function dbarray($query) {
$result = @mysql_fetch_assoc($query);
if (!$result) {
echo mysql_error();
return false;
} else {
return $result;
}
}
Something goes wrong at dbarray however, even though it should be pulling up multiple events but it just pulls up the closest one to the current date. And then here is the email I get from it:
The following events are taking place this week:
