Set recycle bin in your admin panel
php script for recycle option:<?php
session_start();
$connect = mysql_connect("servername","username","password");
mysql_select("databasename");
$value=$_GET['value'];
if($value=="restore")
{
$id=$_GET['id'];
if($id!="")
{
$uid=$_SESSION['uid'];
mysql_query("UPDATE portfolio SET Is_Deleted=0,Is_Active=1,Modified_By='$uid',Modified_Date=now() WHERE P_Id='$id';");
//mysql_query("DELETE FROM loginmaster WHERE Login_Id='$id';");
$msg="Blog Restored Successfully..!!";
}
}
if($value=="delete")
{
$id=$_GET['id'];
if($id!="")
{
mysql_query("DELETE FROM portfolio WHERE P_Id='$id';");
$msg="Package Permanantly Deleted..!!";
}
}
$select=mysql_query("SELECT * FROM portfolio WHERE Is_Deleted=1 ORDER BY P_Id desc;") or die(mysql_error());
$count=mysql_num_rows($select);
if($count==0)
$msg1="No Data Found";
$srno=0;
?>
this script for in your table:
<?php
while($row=mysql_fetch_assoc($select))
{
$id= $row['P_Id'];
$P_Name= $row['P_Name'];
$Photo= $row['Photo'];
$Website= $row['Website'];
$srno=$srno+1;
?>
<tr>
<td align='center'><?php echo "$srno"; ?></td>
<td align='center'><?php echo "$P_Name"; ?></td>
<td align='center'><?php
if($Photo=="")
{ echo "Empty";}
else
echo "<a href='Uploaded/$Photo' target='_blank'>Download</a>";
?>
</td>
<td align='center'><?php echo "$Website"; ?></td>
<td align='center'><?php echo "<a href='ViewPo.php?value=View&id=$id'><img src='../Images/View.png' alt='View' title='View Record'></a>"; ?></td>
<td align='center'><?php echo "<a href='RecyclePo.php?value=restore&id=$id'><img src='../Images/Restore.png' title='Restore Record' width='32px' height='32px'></a>"; ?></td>
<td align='center' class="tdforfees1"><?php echo "<a href='RecyclePo.php?value=delete&id=$id' onclick='return confirmdelete();'><img src='../Images/Delete.png' title='Delete Record'></a>"; }?>
script for delete button:
<script type="text/javascript">
function confirmdelete()
{
var Click=confirm("Are You Sure To Permenent Delete?");
if(Click==true)
return true;
else
return false;
}
</script>
No comments:
Post a Comment