Monday, 26 August 2013

Set recycle option in your admin panel.

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