Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-611.16.1.el9_7.x86_64

PHP Version:

8.2.30

User:

u226437350

Directory:

/home/u226437350/domains/extrapower.in/public_html/emp

Free Space:

8.51 TB

🔧 Quick Actions

✏️ Editing: adminct.php

<?php

require 'authentication.php'; // admin authentication check

// auth check
$user_id = $_SESSION['admin_id'];
$user_name = $_SESSION['name'];
$security_key = $_SESSION['security_key'];
if ($user_id == NULL || $security_key == NULL) {
    header('Location: index.php');
}

// check admin
$user_role = $_SESSION['user_role'];

if(isset($_GET['delete_lead'])){
  $action_id = $_GET['lead_id'];
  
  $sql = "DELETE FROM lead WHERE lead_id = :id";
  $sent_po = "lead-info.php";
  $obj_admin->delete_data_by_this_method($sql,$action_id,$sent_po);
}

if(isset($_POST['add_task_post'])){
    $obj_admin->add_new_clead($_POST);
}

$page_name="Task_Info";
include("include/sidebar.php");
// include('ems_header.php');

<?php
$servername = "localhost";
$username = "u226437350_emp";
$password = "Subham@2009";
$dbname = "u226437350_emp";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

$sql = "SELECT user_id, fullname FROM tbl_admin WHERE user_role = 2";
$result = $conn->query($sql);

?>
<form action="adminct.php" method="get">
<select class="form-control rounded-0" name="user_id" id="user_id" required>
    <option value="">Select Employee...</option>

<?php while($row = $result->fetch_assoc()) { ?>
        <option value="<?php echo $row['user_id']; ?>"><?php echo $row['fullname']; ?></option>
    <?php } ?>

</select>

<input type="submit" value="Submit">
</form>
<?php
// Close the database connection
$conn->close();
?>
          
          <?php
$servername = "localhost";
$username = "u226437350_emp";
$password = "Subham@2009";
$dbname = "u226437350_emp";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

// Assuming user_id and date are obtained from a form or URL parameter
$user_id = $lead_user_id = isset($_GET['user_id']) ? $_GET['user_id'] : null;
$date = isset($_GET['date']) ? $_GET['date'] : null;

// You may need to sanitize and validate these inputs

$sql = "SELECT a.user_id, c.location, c.travelmode, c.tcost, c.breakfast, c.image
        FROM tbl_admin a
        JOIN clead c ON a.user_id = c.lead_user_id
        WHERE c.lead_user_id = '$lead_user_id' AND DATE(c.date) = '$date'";
$result = $conn->query($sql);

// Check if there are rows in the result
if ($result->num_rows > 0) {
    // Output data in a table
    echo "<table class='table table-codensed table-custom'>
         <tr>
             <th>Customer Name</th>
             <th>Customer Address</th>
             <th>Mobile No.</th>
             <th>Remark</th>
             <th>Image</th>
         </tr>";

// Fetch data and output each row
    while ($row = $result->fetch_assoc()) {
        echo "<tr>
                 <td>{$row['location']}</td>
                 <td>{$row['travelmode']}</td>
                 <td>{$row['tcost']}</td>
                 <td>{$row['breakfast']}</td>
                 <td><img src='img/{$row['image']}' alt='Image'></td>
             </tr>";
    }

echo "</table>";
} else {
    echo "No results found.";
    // Output SQL error for debugging
    echo "Error: " . $sql . "<br>" . $conn->error;
}

// Close the database connection
$conn->close();
?>

<?php

include("include/footer.php");

flatpickr('#t_end_time', {
    enableTime: true
  });

</script>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: adminct.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation