File size: 2.5Kb
<div class="col-md-6">
<div class="card border-0 mt-4 p-0 shadow mb-4">
<div class="card-header bg-white border-bottom py-3 border-top-left-right">
<h6 class="m-0 fw-bold">About Us</h6>
</div>
<div class="card-body">
<!-- PHP code to fetch and display data -->
<?php
require_once('config/core.php');
$conn = mysqli_connect(DB_HOST, DB_USER, DB_PASS, DB_NAME);
$sql = "SELECT * FROM about_us";
$result = mysqli_query($conn, $sql);
if (!$result) {
die("Error executing the query: " . mysqli_error($conn));
}
while ($row = mysqli_fetch_assoc($result)) {
echo "<label class='form-label'>Content:</label>";
echo "<textarea class='form-control about-us-textarea' rows='5'>" . $row['content'] . "</textarea>";
// Add an edit button to toggle the edit mode
echo "<button type='button' class='btn btn-primary edit-content-btn mt-3' data-toggle='modal' data-target='#editAboutUsModal' data-id='" . $row['id'] . "'>Edit</button>";
}
mysqli_close($conn);
?>
</div>
</div>
</div>
<!-- Edit About Us Modal -->
<div class="modal fade" id="editAboutUsModal" tabindex="-1" aria-labelledby="editAboutUsModalLabel" aria-hidden="true">
<div class="modal-dialog modal-lg">
<div class="modal-content">
<div class="modal-header">
<h5 class="modal-title" id="editAboutUsModalLabel">Edit About Us Content</h5>
<button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
</div>
<div class="modal-body">
<form id="editAboutUsForm">
<div class="mb-3">
<label for="aboutUsContent" class="form-label">Content</label>
<textarea class="form-control" id="aboutUsContent" name="aboutUsContent" rows="5"></textarea>
</div>
<input type="hidden" id="aboutUsId" name="aboutUsId">
</form>
</div>
<div class="modal-footer">
<button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Close</button>
<button type="button" class="btn btn-primary" id="saveAboutUsChanges">Save changes</button>
</div>
</div>
</div>
</div>