//connect to ag database
$db_name = "ag_db";
$table_name = "events";
$connection = @mysql_connect('localhost','ag','ag123') or die(mysql_error());
$db = @mysql_select_db($db_name, $connection) or die(mysql_error());
//page numbering stuff
/* check for page offset */
if(!isset($_GET["offset"])) {
$offset = 0;
} else {
$offset = intval($_GET["offset"]);
}
if(!isset($_GET["page"])) {
$page = 1;
} else {
$page = intval($_GET["page"]);
}
//end page stuff
$sql = "SELECT id, event_title, DATE_FORMAT(start_date, '%m/%d/%Y') as start_date, DATE_FORMAT(end_date, '%m/%d/%Y') as end_date, start_time, end_time, venue, location, scheduler, description, contact_person, contact_email, participants, event_image, event_image_title, event_image_credits, o_participants FROM $table_name ORDER BY DATE_FORMAT(start_date, '%Y/%m/%d') DESC LIMIT $offset,10";
$result = @mysql_query($sql,$connection) or die(mysql_error());
//ag more pages
$num_rows = mysql_num_rows($result);
$sql_pages = "SELECT id FROM events";
$result_pages = mysql_db_query("ag_db",$sql_pages) or die(mysql_error());
$total = mysql_num_rows($result_pages);
$num_pages = $total / 10;
$num_pages = ceil($num_pages);
$current_page = $page;
if($page != $num_pages) {
$start = $offset+1;
$end = $offset+10;
$view_block = "$start-$end of $total";
} else {
$start = $offset+1;
$view_block = "$start-$total of $total";
}
$i = 2;
$offset_num = 0;
if($num_pages > 1) {
if($page >= 2) {
$page_prev = $page-1;
$offset_prev = $offset-10;
$prevlink = "
";
} else {
$prevlink = "";
}
if(($num_pages > 1) && ($page != $num_pages)) {
$page_next = $page+1;
$offset_next = $offset+10;
$nextlink = "
";
} else {
$nextlink = "";
}
$pages_block = "1 ";
while ($i <= $num_pages) {
$offset = $offset_num+=10;
$pagenum = $i++;
if($page == $pagenum) {
$pages_block .= " $pagenum ";
} else {
$pages_block .= " $pagenum ";
}
}
$more_pages = "$prevlink $pages_block $nextlink";
} else {
$more_pages = "viewing all events";
}
// end more pages
if ($participants) {
$participants = implode("|",$participants);
}
while ($row = mysql_fetch_array($result)) {
$id = $row['id'];
$event_title = stripslashes($row['event_title']);
$start_date = $row['start_date'];
$end_date = $row['end_date'];
$start_time = $row['start_time'];
$end_time = $row['end_time'];
$venue = stripslashes($row['venue']);
$location = stripslashes($row['location']);
$scheduler = stripslashes($row['scheduler']);
$description = stripslashes($row['description']);
$contact_person = $row['contact_person'];
$contact_email = $row['contact_email'];
$participants = $row['participants'];
$event_image = stripslashes($row['event_image']);
$event_image_title = stripslashes($row['event_image_title']);
$event_images_credits = stripslashes($row['event_images_credits']);
$o_participants = stripslashes($row['o_participants']);
//evl
$db_on = mysql_connect('localhost','webuser','www123');
if ($participants != "") {
$evlppl_list = explode("|",$participants);
$total_evlppl = count($evlppl_list);
$where_evlppl = "WHERE";
for($i=0;$i<$total_evlppl;$i++) {
$where_evlppl .= " indi =\"$evlppl_list[$i]\" OR";
}
$where_evlppl = substr($where_evlppl,0,-3);
$evlppl_sql = "SELECT fname, lname FROM directory $where_evlppl ORDER BY lname";
$evlppl_list_new = "";
$evlppl_res = mysql_db_query("evl",$evlppl_sql) or die(mysql_error());
while($evlppl_row = mysql_fetch_array($evlppl_res)) {
$evlppl_lname = $evlppl_row["lname"];
$evlppl_fname = $evlppl_row["fname"];
$evlppl_list_new .= "$evlppl_fname $evlppl_lname, ";
}
$evlppl_list_new = substr($evlppl_list_new,0,-2);
}
if ($o_participants != "" && $participants != "") {
$evlppl_list_now = $evlppl_list_new .= ", $o_participants";
} else if ($participants == "") {
$evlppl_list_now = $o_participants;
} else {
$evlppl_list_now = $evlppl_list_new;
}
if ($evlppl_list_now) {
$evlppl_list_now = "
participants: $evlppl_list_now";
}
if ($start_time && $end_time) {
$times = "$start_time - $end_time";
} else {
$times = "$start_time";
}
$db_off = mysql_close();
if($event_image != ""){
$display_block .= "
";
//begin other display block
}else{
$display_block .= "
";
}
}
?>
Access Grid @ the electronic visualization laboratory
echo "$display_block"; ?>