File: /home/panama/public_html_old/managesite/services_list.php
<?php
include("../include/config.php");
include("../include/opner_admin.php");
if(strlen(trim($_POST["btnaddauser"])) > 0)
{
header("location: services_addnew.php");
exit();
}
$remove = ((empty($_GET['remove']))?0:$_GET['remove']);
//remove testimonial
if($remove > 0)
{
$queryi="SELECT * FROM embassy_services WHERE sid =".$remove;
$resulti=@mysql_query($queryi);
if(@mysql_result($resulti, 0, "simg")<>'d_photo.jpg')
{
$path="../newsimg/".@mysql_result($resulti, 0, "simg");
@unlink($path);
}
$db_del = new database();
$db_del->where("sid=".$remove);
$db_del->delete("embassy_services");
}
$searchText="1";
$tbl_name = "embassy_services";
$targetpage = $_SERVER['PHP_SELF'];
$limit = MY_PAGES;
//$limit = 1;
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 onLoad="javascript:showhide('admin');">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="100%"><? include("header.php")?></td>
</tr>
<tr>
<td align="right" valign="top" width="100%">
<form id="form1" name="form1" method="post">
<table width="100%" border="0" cellspacing="0" cellpadding="0" class="inertable">
<tr>
<td class="inertr" style="padding-left:7px" colspan="2"><img src="images/bullet_new.png" align="absmiddle" /> Manage News </td>
</tr>
<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="btnaddauser" value="Add News" class="btn"/>
</td>
</tr>
<tr>
<td height="5px;" colspan="2"></td>
</tr>
<tr>
<td colspan="2" align="center">
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr align="right" valign="top">
<td height="30"><? $functions->Paging($tbl_name,$targetpage,$limit,$page)?></td>
</tr>
<tr>
<td align="center" valign="top">
<table width="99%" border="0" cellpadding="3" cellspacing="1" bgcolor="#CCCCCC" class="text">
<tr class="list-mainHeading">
<td width="8%" height="25" align="center" valign="middle"> <strong>Sr No.</strong></td>
<td width="32%" align="left" valign="top" class="tdpadding"><span style="padding-left:10px;">Title</span></td>
<!-- <td width="20%" align="center" valign="top" style="padding-left:10px;">Image</td>-->
<td width="26%" align="left" valign="top" style="padding-left:10px;">Date</td>
<td width="7%" align="center" valign="middle">Edit</td>
<td width="7%" align="center" valign="middle">Delete</td>
</tr>
<?
$counter=1;
$db_list = new database();
$db_list->where($searchText." and 1 order by sid desc LIMIT $start, $limit");
$db_list->selectstmt("embassy_services");
if($db_list->row_count > 0)
{
for($i=0;$i < $db_list->row_count;$i++)
{
$db_list->moveto($i);
$simg=""; $dt="";
if($db_list->f_simg<>"" ) $simg = $db_list->f_simg;
if($db_list->f_dat<>"0000-00-00") {
list($y,$m,$d) = split("-",$db_list->f_dat);
$dt = date("F j, Y",mktime(0,0,0,$m,$d,$y));
}
?>
<tr onMouseOver="changeColor(this.id)" id="<?=$counter;?>" onMouseOut="defualtColor(this.id)" class="trDefualtBackgroundColor" bgcolor="#252525">
<td align="center" valign="middle" bgcolor="" class="menu-inner2"><?=$counter;?></td>
<td align="left" valign="middle" bgcolor="" class="tdpadding"><span class="menu-inner2" style="padding-left:10px;">
<?=$db_list->f_title;?>
</span></td>
<!--<td align="center" valign="middle" class="menu-inner2" style="padding-left:10px;">
<? //if($simg<>"") { ?>
<img src="../display_image.php?path=newsimg/<?php //echo $simg;?>&width=91&height=68&watermark=-1" border="0" style="padding-bottom:5px; padding-top:5px;">
<? //} ?>
</td>-->
<td align="left" valign="middle" bgcolor="" class="tdpadding"><?=$dt;?></td>
<td align="center" valign="middle" class="menu-inner2">
<a href="services_edit.php?edit=<?=base64_encode($db_list->f_sid);?>"><img src="images/icon-edit.gif" alt="Edit" title="Edit" width="16" height="16" border="0" /></a> </td>
<td align="center" valign="middle" bgcolor="" class="menu-inner2">
<a href="services_list.php?remove=<?=$db_list->f_sid;?>" 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 bgcolor="#252525">
<td colspan="5" align="center" valign="middle" bgcolor="#FFFFFF">
<span class="error"><?=$err_msg1;?>There is no record in your database</span> </td>
</tr>
<? }
?>
</table>
</td>
</tr>
<tr><td> </td></tr>
</table>
</td>
</tr>
</table>
</form>
</td>
</tr>
</table>
<? unset($_SESSION['msg']);?>
</body>
</html>