<?php
ob_start(); // Start output buffering
// Enable error reporting for debugging
error_reporting(E_ALL);
ini_set('display_errors', 1);
// Database connection
$conn = new mysqli("server329", "leadltht_prazey1982", "prazey1982123456", "leadltht_fastlinkinternet");
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
// Define base URL
$base_url = 'https://fastlinkinternet.com/administrator/data-provider/';
// JavaScript Redirect Function
function js_redirect($url) {
echo "<script type='text/javascript'>window.location.href='{$url}';</script>";
exit();
}
// Handle Add Internet Plan
if (isset($_POST['add'])) {
$name_plan = $_POST['name_plan'];
$name_plan_price = $_POST['name_plan_price'];
$sql = "INSERT INTO internet_name_plan (name_plan, name_plan_price) VALUES ('$name_plan', '$name_plan_price')";
if ($conn->query($sql) === TRUE) {
js_redirect("{$base_url}admin/?page=internet_name_plan&success=add");
} else {
echo "Error: " . $sql . "<br>" . $conn->error;
}
}
// Handle Edit Internet Plan
if (isset($_POST['edit'])) {
$id = $_POST['id'];
$name_plan = $_POST['name_plan'];
$name_plan_price = $_POST['name_plan_price'];
$sql = "UPDATE internet_name_plan SET name_plan='$name_plan', name_plan_price='$name_plan_price' WHERE id=$id";
if ($conn->query($sql) === TRUE) {
js_redirect("{$base_url}admin/?page=internet_name_plan&success=edit");
} else {
echo "Error updating plan: " . $conn->error;
}
}
// Handle Delete Internet Plan
if (isset($_POST['delete'])) {
$id = $_POST['id'];
$sql = "DELETE FROM internet_name_plan WHERE id=$id";
if ($conn->query($sql) === TRUE) {
js_redirect("{$base_url}admin/?page=internet_name_plan&success=delete");
} else {
echo "Error deleting plan: " . $conn->error;
}
}
ob_end_flush(); // Flush the output buffer and turn off output buffering
?>
<!DOCTYPE html>
<html>
<head>
<title>Internet Name Plan Management</title>
<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css">
</head>
<body>
<div class="container mt-5">
<h2 class="mb-4">Manage Internet Plans</h2>
<?php
if (isset($_GET['success'])) {
if ($_GET['success'] == 'add') {
echo '<div class="alert alert-success">New plan added successfully.</div>';
} elseif ($_GET['success'] == 'edit') {
echo '<div class="alert alert-success">Plan updated successfully.</div>';
} elseif ($_GET['success'] == 'delete') {
echo '<div class="alert alert-success">Plan deleted successfully.</div>';
}
}
?>
<div class="card mb-4">
<div class="card-header">Add Internet Plan</div>
<div class="card-body">
<form method="post" action="">
<div class="form-group">
<label for="name_plan">Plan Name:</label>
<input type="text" class="form-control" name="name_plan" required>
</div>
<div class="form-group">
<label for="name_plan_price">Plan Price:</label>
<input type="text" class="form-control" name="name_plan_price" required>
</div>
<input type="submit" name="add" class="btn btn-primary" value="Add Plan">
</form>
</div>
</div>
<h2 class="mb-4">Internet Plans</h2>
<?php
$sql = "SELECT * FROM internet_name_plan";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
echo '<table class="table table-bordered">';
echo '<thead><tr><th>#</th><th>Plan Name</th><th>Plan Price</th><th>Action</th></tr></thead>';
echo '<tbody>';
$counter = 1;
while ($row = $result->fetch_assoc()) {
echo '<tr>';
echo '<td>' . $counter . '</td>';
echo '<td>' . $row["name_plan"] . '</td>';
echo '<td>' . $row["name_plan_price"] . '</td>';
echo '<td>
<a href="javascript:void(0);" class="btn btn-sm btn-warning edit-btn" data-id="' . $row["id"] . '" data-name="' . $row["name_plan"] . '" data-price="' . $row["name_plan_price"] . '">Edit</a>
<form method="post" action="" style="display:inline-block;">
<input type="hidden" name="id" value="' . $row["id"] . '">
<input type="submit" name="delete" class="btn btn-sm btn-danger" value="Delete" onclick="return confirm(\'Are you sure you want to delete this plan?\');">
</form>
</td>';
echo '</tr>';
$counter++;
}
echo '</tbody>';
echo '</table>';
} else {
echo '<p>No internet plans found.</p>';
}
$conn->close();
?>
<!-- Edit Plan Modal -->
<div class="modal fade" id="editPlanModal" tabindex="-1" role="dialog" aria-labelledby="editPlanModalLabel" aria-hidden="true">
<div class="modal-dialog" role="document">
<div class="modal-content">
<div class="modal-header">
<h5 class="modal-title" id="editPlanModalLabel">Edit Internet Plan</h5>
<button type="button" class="close" data-dismiss="modal" aria-label="Close">
<span aria-hidden="true">×</span>
</button>
</div>
<form method="post" action="">
<div class="modal-body">
<input type="hidden" name="id" id="editPlanId">
<div class="form-group">
<label for="editPlanName">Plan Name:</label>
<input type="text" class="form-control" name="name_plan" id="editPlanName" required>
</div>
<div class="form-group">
<label for="editPlanPrice">Plan Price:</label>
<input type="text" class="form-control" name="name_plan_price" id="editPlanPrice" required>
</div>
</div>
<div class="modal-footer">
<button type="button" class="btn btn-secondary" data-dismiss="modal">Close</button>
<input type="submit" name="edit" class="btn btn-primary" value="Save Changes">
</div>
</form>
</div>
</div>
</div>
</div>
<script src="https://code.jquery.com/jquery-3.3.1.slim.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.14.7/umd/popper.min.js"></script>
<script src="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/js/bootstrap.min.js"></script>
<script>
$(document).ready(function() {
$('.edit-btn').on('click', function() {
var id = $(this).data('id');
var name = $(this).data('name');
var price = $(this).data('price');
$('#editPlanId').val(id);
$('#editPlanName').val(name);
$('#editPlanPrice').val(price);
$('#editPlanModal').modal('show');
});
});
</script>
</body>
</html>