1#@!#!123s

��JFIF�� 1#@!#!123s
: / home4 / mcspunei / MCS_Backup / shubha27Aug / admin /
Filename : gothram.php
back
<?php 
include "includes/header.php";
include "includes/pagination.php";
$rowsPerPage = '20';
$u_id = isset($_REQUEST['u_id']) ? addslashes($_REQUEST['u_id']) : '';


if(isset($_REQUEST['del_id']))
{
$idd = addslashes($_REQUEST['del_id']);
				
$db->insertrec("DELETE FROM gothra WHERE gid='$idd'");
?>	
<script>

window.location="gothram.php?succ";

</script>			
			
<?php 					
}
if(isset($_REQUEST['active']))
{
$bid = addslashes($_REQUEST['active']);
$db->insertrec("update gothra set g_status='0' where gid='$bid'");

?>	
<script>

window.location="gothram.php?suca";

</script>			
			
<?php 		
}

if(isset($_REQUEST['inactive']))
{
$bid = addslashes($_REQUEST['inactive']);
$db->insertrec("update gothra set g_status='1' where gid='$bid'");

?>	
<script>

window.location="gothram.php?sucd";

</script>			
			
<?php 		
}

?>

	<header id="header">
		<hgroup>
			<h1 class="site_title"><a href="dashboard.php">Website Admin</a></h1>
			<h2 class="section_title">dashboard</h2><div class="btn_view_site"><a href="<?php echo $site_com; ?>" target="_blank">View Site</a></div>
		</hgroup>
	</header> <!-- end of header bar -->
	
	<section id="secondary_bar">
		<div class="user">
			<p>Admin<!-- (<a href="#">3 Messages</a>)--></p>
			<!-- <a class="logout_user" href="#" title="Logout">Logout</a> -->
		</div>
		<div class="breadcrumbs_container">
			<article class="breadcrumbs"><a href="dashboard.php">Website Admin</a> <div class="breadcrumb_divider"></div> <a class="current">Gothram Management</a></article>
		</div>
	</section><!-- end of secondary bar -->
	
	<?php include "includes/left_menu.php"; ?>
	
	<section id="main" class="column">
	<?php if(isset($_REQUEST['suc'])) { ?>
		<h4 class="alert_success">Updated Successfully</h4>
		<?php } ?>
		
		<?php if(isset($_REQUEST['suca'])) { ?>
		<h4 class="alert_success">Activated this Record Successfully</h4>
		<?php } ?>
		<?php if(isset($_REQUEST['sus'])) { ?>
		<h4 class="alert_success">Added Successfully</h4>
		<?php } ?>
		
		<?php if(isset($_REQUEST['succ'])) { ?>
		<h4 class="alert_success">Deleted Successfully</h4>
		<?php } ?>
		<?php if(isset($_REQUEST['sucd'])) { ?>
		<h4 class="alert_success">Deactivate this Record Successfully</h4>
		<?php } ?>
		
		
		<article class="module width_3_quarter">
		<header><h3 class="tabs_involved">Gothram Management</h3>
		<ul class="tabs">
   			<a href="gothram_add.php">Add New</a>
    		<!--<li><a href="#tab2">Comments</a></li>-->
		</ul>
		</header>

		<div class="tab_container">
			<div id="tab1" class="tab_content">
			<table width="700" cellspacing="0" class="tablesorter"> 
			<thead> 
				<tr> 
   					<th width="50">S.No</th> 
    				<th width="150"><span class="tabs_involved">Gothram</span> Field List</th> 
				
					<th width="100">Status</th> 
				</tr> 
			</thead> 
			<tbody> 
			
			<?php $sql="select * from gothra  order by gid desc";
			
			$strget="";

$result=$db->get_all_assoc(getPagingQuery1($sql, $rowsPerPage,$strget));
$pagingLink = getPagingLink1($sql, $rowsPerPage,$strget,$db); 


 if(isset($_REQUEST['page']))
					{
						$i=(($_REQUEST['page'] -1) *20 )+1;
					}
					else
					{
						
						$i=1;
					}	
$count =$db->numrows($sql);
if($count>0)
{
			
			  foreach($result as $sel_gothra)
			  {
			  ?>
				<tr> 
   					<td>&nbsp; <?php echo $i; ?></td> 
    				<td nowrap="nowrap"><?php echo $sel_gothra['gothra_name']; ?></td> 
				
    				<td nowrap="nowrap">
					<?php if($sel_gothra['g_status']==0) {?>
					<a href="gothram.php?inactive=<? echo $sel_gothra['gid']; ?>" title="click to deactivate"><img src="images/act.png" /></a>
					<?php } ?>
					
					<?php if($sel_gothra['g_status']==1) { ?>
					<a href="gothram.php?active=<? echo $sel_gothra['gid']; ?>" title="click to activate" ><img src="images/inact.png" /></a>
					<?php }?>
									
					<a href="gothram_edit.php?edit_id=<? echo $sel_gothra['gid']; ?>"><input type="image" src="images/icn_edit.png" title="Edit"></a>
					
					<a href="gothram.php?del_id=<? echo $sel_gothra['gid']; ?>"><input type="image" src="images/icn_trash.png" title="Trash"></a></td> 
				</tr> 
				
				<?php $i++; } } 
				else { 
				?> 
				<tr> 
   					<td colspan="8" align="center">No records found....</td> 
    				
				</tr> 
				
				<?php } ?>
				<tr align="right"> 
   					
					<td colspan="8" align="right" style="text-align:center; width:300px;"><div style="text-align:right; width:300px;"><?php echo  $pagingLink;?></div></td> 
    				
				</tr>   
			</tbody> 
			</table>
			</div><!-- end of #tab1 -->
			
		
			
		</div><!-- end of .tab_container -->
		
		</article><!-- end of content manager article -->
		
	
		
		<div class="clear"></div>
		
		
		
		
		
		<div class="spacer"></div>
	</section>


</body>

</html>