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.53 TB

🔧 Quick Actions

✏️ Editing: daily-client-report.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');
?>
<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/flatpickr/dist/flatpickr.min.css">

<?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);

?>
 <div class="row">
      <div class="col-md-12">
        <div class="well well-custom rounded-0">
          <div class="gap"></div>
          <div class="row">
            <div class="col-md-4">
<form action="daily-client-report.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>
    </div>

<div class="col-md-4">
                  <button class="btn btn-primary btn-sm btn-menu" type="submit" id="filter"><i class="glyphicon glyphicon-filter"></i> Filter</button>
                  <button class="btn btn-success btn-sm btn-menu" type="button" id="print"><i class="glyphicon glyphicon-print"></i> Print</button>
            </div>

</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 "
    <div class='table-responsive' id='printout'>
    <table class='table table-codensed table-custom'>
    <thead>
         <tr>
             <th>Customer Name</th>
             <th>Customer Address</th>
             <th>Mobile No.</th>
             <th>Remark</th>
             <th>Image</th>
         </tr>
         </thead>";

// Fetch data and output each row
    while ($row = $result->fetch_assoc()) {
        echo " <tbody>
        <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 "</tbody>
</table>
</div>
</div>
</div>
</div>";
} else {
    echo "No results found.";
    // Output SQL error for debugging
    }
// 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: daily-client-report.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation