Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 4.18.0-553.54.1.lve.el8.x86_64

PHP Version:

7.3.33

User:

u435171512

Directory:

/home/u435171512/domains/novanexus.in/public_html/test/admin

Free Space:

4.11 TB

🔧 Quick Actions

✏️ Editing: manage-testimonials.php

<?php 
session_start();
include('includes/config.php');
error_reporting(0);

// Handle new testimonial submission (POST request)
if ($_SERVER["REQUEST_METHOD"] == "POST") {
    // Sanitize and capture form data
    $name = mysqli_real_escape_string($con, $_POST['name']);
    $email = mysqli_real_escape_string($con, $_POST['email']);
    $phone_number = mysqli_real_escape_string($con, $_POST['phone_number']);
    $comments = mysqli_real_escape_string($con, $_POST['comments']);
    $rating = isset($_POST['rating']) ? $_POST['rating'] : 0; // Default rating if not set
    
    // Ensure rating is between 0 and 5
    if ($rating < 0 || $rating > 5) {
        $rating = 0; // Default to 0 if rating is out of range
    }

// Insert data into the database with active_status set to 0 (disabled) by default
    $query = "INSERT INTO testimonials (name, email, phone_number, comments, rating, active_status, delete_status, added_date) 
              VALUES ('$name', '$email', '$phone_number', '$comments', '$rating', 0, 0, NOW())";

if (mysqli_query($con, $query)) {
        $_SESSION['msg'] = "Your review has been submitted successfully.";
        header('Location: testimonials.php');
        exit;
    } else {
        $_SESSION['error'] = "There was an error submitting your review. Please try again.";
        header('Location: testimonials.php');
        exit;
    }
}

// Check if user is logged in
if(strlen($_SESSION['login'])==0) { 
    header('location:index.php');
    exit;
} else {
    // Soft delete testimonial (update delete_status)
    if ($_GET['action'] == 'del') {
        $testimonial_id = intval($_GET['cid']);
        $query = mysqli_query($con, "UPDATE testimonials SET delete_status=1 WHERE testimonial_id='$testimonial_id'") or die(mysqli_error($con));
        if ($query) {
            $_SESSION['msg'] = "Testimonial successfully deleted.";
        } else {
            $_SESSION['error'] = "Something went wrong. Please try again.";
        }
        header('Location: manage-testimonials.php');
        exit;
    }

// Update testimonial status (active/inactive)
    else if ($_GET['action'] == 'status') {
        $testimonial_id = intval($_GET['tid']);
        $val = intval($_GET['val']);
        $new_status = ($val == 1) ? 0 : 1;  // Toggle between 1 and 0 (active/inactive)
        $query = mysqli_query($con, "UPDATE testimonials SET active_status='$new_status' WHERE testimonial_id='$testimonial_id'") or die(mysqli_error($con));
        if ($query) {
            $_SESSION['msg'] = "Testimonial status successfully updated.";
        } else {
            $_SESSION['error'] = "Something went wrong. Please try again.";
        }
        header('Location: manage-testimonials.php');
        exit;
    }

// Edit testimonial details (update fields)
    else if ($_GET['action'] == 'edit') {
        $testimonial_id = intval($_GET['id']);
        if ($_SERVER['REQUEST_METHOD'] == 'POST') {
            // Sanitize and capture updated form data
            $name = mysqli_real_escape_string($con, $_POST['name']);
            $email = mysqli_real_escape_string($con, $_POST['email']);
            $phone_number = mysqli_real_escape_string($con, $_POST['phone_number']);
            $comments = mysqli_real_escape_string($con, $_POST['comments']);
            $rating = isset($_POST['rating']) ? $_POST['rating'] : 0;

// Ensure rating is between 0 and 5
            if ($rating < 0 || $rating > 5) {
                $rating = 0;
            }

// Update testimonial in the database
            $query = "UPDATE testimonials SET name='$name', email='$email', phone_number='$phone_number', comments='$comments', rating='$rating' 
                      WHERE testimonial_id='$testimonial_id'";
            if (mysqli_query($con, $query)) {
                $_SESSION['msg'] = "Testimonial updated successfully.";
                header('Location: manage-testimonials.php');
                exit;
            } else {
                $_SESSION['error'] = "Error updating testimonial. Please try again.";
                header('Location: edit-testimonials.php?id='.$testimonial_id);
                exit;
            }
        }

// Fetch testimonial data to pre-fill the form
        $query = "SELECT * FROM testimonials WHERE testimonial_id='$testimonial_id'";
        $result = mysqli_query($con, $query);
        $testimonial = mysqli_fetch_array($result);
    }
?>

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Manage Testimonials</title>
    <?php include('includes/headerfiles.php'); ?>
</head>
<body class="fixed-left">
    <div id="wrapper">
        <?php include('includes/topheader.php');?>
        <?php include('includes/leftsidebar.php');?>
        
        <div class="content-page">
            <div class="content">
                <div class="container">
                    
                    <div class="row">
                        <div class="col-sm-6">
                            <?php if($_SESSION['msg']) { ?>
                                <div class="alert alert-success" role="alert">
                                    <strong>Well done!</strong> <?php echo $_SESSION['msg']; ?>
                                </div>
                                <?php unset($_SESSION['msg']); ?>
                            <?php } ?>

<?php if($_SESSION['error']) { ?>
                                <div class="alert alert-danger" role="alert">
                                    <strong>Oh snap!</strong> <?php echo $_SESSION['error']; ?>
                                </div>
                                <?php unset($_SESSION['error']); ?>
                            <?php } ?>
                        </div>
                    </div>

<div class="row">
                        <div class="col-sm-12">
                            <div class="card-box">
                                <div class="table-responsive">
                                    <table class="table table-colored table-centered table-inverse m-0">
                                        <thead>
                                            <tr>
                                                <th>S.No</th>
                                                <th>Name</th>
                                                <th>Job_role</th>
                                                <th>company_name </th>
                                                <th>Comments</th>
                                                <th>Status</th>
                                                <th>Action</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <?php
                                                $limit = isset($_GET['limit']) ? $_GET['limit'] : 10;
                                                $page = isset($_GET['page']) ? $_GET['page'] : 1;
                                                $start = ($page - 1) * $limit;
                                                  
                                                $query1 = "SELECT * FROM testimonials WHERE delete_status=0";
                                                $query1 .= " ORDER BY added_date DESC LIMIT $start, $limit";

$result = mysqli_query($con, $query1);
                                                $sql1 = mysqli_query($con, "SELECT * FROM testimonials WHERE delete_status=0");
                                                $total_rows = mysqli_num_rows($sql1);
                                                $total_pages = ceil($total_rows / $limit);
                                                  
                                                $i = $start;
                                                while ($row = mysqli_fetch_array($result)) {
                                                    $i++;
                                            ?>
                                            <tr>
                                                <td><b><?php echo $i; ?></b></td>
                                                <td><?php echo $row['name']; ?></td>
                                                <td><?php echo $row['Job_role']; ?></td>
                                                <td><?php echo $row['company_name']; ?></td>
                                                <td width="300"><?php echo $row['comments']; ?></td>
                                                <td width="90" align="center">
                                                <a href="manage-testimonials.php?tid=<?php echo htmlentities($row['testimonial_id']);?>&&action=status&&val=<?php echo $row['active_status']; ?>" onclick="return confirm('Do you want to update status ?')" class="btn <?php echo ($row['active_status'] == 1) ? 'btn-success' : 'btn-danger'; ?>"><?php echo ($row['active_status'] == 1) ? 'Enable' : 'Disable'; ?></a></td>
                                                <td width="120" align="center">
                                                    <a href="edit-testimonials.php?id=<?php echo htmlentities($row['testimonial_id']);?>" class="btn btn-warning"><i class="fa fa-pencil" style="color: #000;"></i></a> 
                                                    &nbsp;
                                                    <a class="btn btn-danger" href="manage-testimonials.php?cid=<?php echo htmlentities($row['testimonial_id']);?>&action=del" onclick="return confirm('Do you want to delete?')"><i class="fa fa-trash-o" style="color: #fff"></i></a> 
                                                </td>
                                            </tr>
                                            <?php } ?>
                                        </tbody>
                                    </table>
                                </div>
                            </div>
                        </div>
                    </div>

<div aria-label="Page navigation">
                            <ul class="pagination" id="page">
                                <li class="page-item">
                                    <?php 
                                        if($page > 1)
                                        { 
                                            $prev_page = $page - 1;
                                    ?>
                                        <a class="page-link" href="manage-testimonials.php?page=<?php echo $prev_page ?>&search=<?php echo $search; ?>" aria-label="Previous">
                                        <span aria-hidden="true">&laquo;</span>
                                        <span class="sr-only">Previous</span>
                                        </a>
                                    <?php
                                        }
                                    ?>
                                </li>
                                <?php
                                    if($page == 1)
                                    {
                                        $c = 2;
                                    }
                                    else
                                    {
                                        $c = 1;
                                    }
                                    for($i = max(1, $page - 1); $i <= min($page + $c, $total_pages); $i++)
                                    {
                                        if($i == $page)
                                        {
                                            echo "<li class='page-item active'><a class='page-link' href='manage-testimonials.php?page=$i&search_by=$search_By&search=$search'>$i</a></li>";
                                        }
                                        else
                                        {
                                            echo "<li class='page-item'><a class='page-link' href='manage-testimonials.php?page=$i&search_by=$search_By&search=$search'>$i</a></li>";
                                        }
                                    }

if ($page < $total_pages) 
                                    {
                                        $next_page = $page + 1;
                                ?>
                                <li class="page-item">
                                    <a class="page-link" href="manage-testimonials.php?page=<?php echo $next_page; ?>&search=<?php echo $search; ?>" aria-label="Next">
                                    <span aria-hidden="true">&raquo;</span>
                                    <span class="sr-only">Next</span>
                                    </a>
                                </li>
                            <?php } ?>
                        </ul>
                    </div>

</div> 
            </div>

</div>

</div> 
</body>
</html>

<?php include('footer.php'); } ?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: manage-testimonials.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation