File: /home/panama/public_html_old/managesite/event_listing.php
<?php
include("../include/config.php");
include("../include/opner_admin.php");
if(strlen(trim($_POST["btnadd"])) > 0)
{
header("location: event_andnew.php");
}
$remove = ((empty($_GET['remove']))?0:$_GET['remove']);
//remove testimonial
if($remove > 0)
{
$queryi="SELECT * FROM event_photos WHERE event_id =".$remove;
$resulti=@mysql_query($queryi);
while($row = mysql_fetch_assoc($resulti))
{
if($row['path']<>'')
{
$path="../uploaded_images/".$row['path'];
@unlink($path);
}
}
$db_del = new database();
$db_del->where("eid=".$remove);
$db_del->delete("events");
$db_del->where("event_id=".$remove);
$db_del->delete("event_photos");
}
$tbl_name = "events";
$targetpage = $_SERVER['PHP_SELF'];
$limit = RECORDS_PER_PAGE;
if(strlen(trim($_GET['page'])) > 0)
{ $page = $functions->anti_injection($_GET['page']); }
if($page)
$start = ($page - 1) * $limit; //first item to display on this page
else
$start = 0;
?>
<html>
<head>
<title><?=SITE_ADMIN_TITLE?></title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<meta name="description" content="<?=META_DESCRIPTION?>" />
<meta name="keywords" content="<?=META_KEYWORD?>" />
<link href="css.css" rel="stylesheet" type="text/css" />
<script src="js/MyFunctions.js"></script>
</head>
<body>
<table width="100%" border="0" cellspacing="0" cellpadding="0" >
<tr>
<td width="100%" colspan="2"><? include("header.php")?></td>
</tr>
<tr>
<td align="right" valign="top" width="100%">
<form name="frmabout" action="<?=$_SERVER['PHP_SELF'];?>" method="post">
<table width="100%" border="0" cellspacing="0" cellpadding="0" class="inertable">
<tr>
<td colspan="2" class="inertr" style="padding-left:7px" align="left"><img src="images/bullet_new.png" align="absmiddle" /> Event List </td>
</tr>
<tr>
<td colspan="2" align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="left" valign="top">
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr><td colspan="2"> </td></tr>
<tr>
<td align="center" class="error" width="80%"><?=$_SESSION['msg'];?></td>
<td align="right" style="padding-right:10px">
<input type="submit" name="btnadd" value="Add New" class="btn"/>
</td>
</tr>
<tr align="right" valign="top">
<td height="30" colspan="2" style="padding-right:10px"><? $functions->Paging($tbl_name,$targetpage,$limit,$page)?></td>
</tr>
<tr>
<td align="center" valign="top" colspan="6">
<table width="98%" border="0" cellpadding="3" cellspacing="1" bgcolor="#CCCCCC" class="text">
<tr class="list-mainHeading">
<td width="6%" height="25" align="center" valign="middle"> Id.</td>
<td width="23%" align="left" style="padding-left:10px" valign="middle"> Event Title</td>
<td width="27%" align="left" style="padding-left:10px" valign="middle"> Venue</td>
<td width="13%" align="left" style="padding-left:10px" valign="middle">Date / Time</td>
<td width="7%" align="center" valign="middle">Edit</td>
<td width="7%" align="center" valign="middle">Delete</td>
</tr>
<?php
$counter=1;
$db_list = new database();
$db_list->where("1 order by eid desc LIMIT $start, $limit");
$db_list->selectstmt("events");
//echo date("F d Y","31 Jan 2010");
if($db_list->row_count > 0)
{
for($i=0;$i < $db_list->row_count;$i++)
{
$db_list->moveto($i);
$eventtype = $db_list->f_eventtype;
$dd = explode(" ",$db_list->f_datetime);
$date = explode("-",$dd['0']);
//echo $eventdate = $date[1]."/".$date[0]."/".$date[2];
if($db_list->f_datetime<>"0000-00-00") {
list($m,$d,$y) = split("-",$db_list->f_datetime);
$dt = date("F j, Y",mktime(0,0,0,$m,$d,$y));
}
//echo $db_list->f_datetime."--";
//echo date("F d Y",$eventdate);
?>
<tr onMouseOver="changeColor(this.id)" id="<?=$counter;?>" onMouseOut="defualtColor(this.id)" class="trDefualtBackgroundColor" bgcolor="#F4FFE4">
<td align="center" valign="middle"><?=$counter + $start;?></td>
<td align="left" valign="middle" style="padding-left:10px"> <?=$db_list->f_title;?></td>
<td align="left" valign="middle" style="padding-left:10px"> <?=$db_list->f_venue;?></td>
<td align="left" valign="middle" style="padding-left:10px"><?=$dt;?></td>
<td align="center" valign="middle">
<a href="event_edit.php?edit=<?=base64_encode($db_list->f_eid);?>">
<img src="images/icon-edit.gif" alt="Edit" title="Edit" width="16" height="16" border="0" /></a> |
<a href="event_edit_photo.php?event_id=<?=base64_encode($db_list->f_eid);?>">
<img src="images/glass.png" alt="Edit Photos" title="Edit Photos" width="16" height="16" border="0" /></a>
</td>
<td align="center" valign="middle">
<a href="event_listing.php?remove=<?=$db_list->f_eid;?>" onClick="javascript: return delete_yesno('<?=$db_list->f_title;?>');"><img src="images/padlock-closed.gif" alt="Delete" title="Delete" width="16" height="16" border="0" /></a></td>
</tr>
<? $counter++;
}
}
else
{?>
<tr height="25px;">
<td colspan="6" align="center" valign="middle"><span class="error">
<?=$err_msg1;?>There is no record in your database</span></td>
</tr>
<? }
?>
</table>
</td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
<tr>
<td height="26" colspan="2" align="left" > </td>
</tr>
</table>
</form>
</td>
</tr>
<tr><td height="50"></td></tr>
</table>
<? unset($_SESSION['msg']);?>
</body>
</html>