File size: 3.47Kb
<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">Contact 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 contact_us";
$result = mysqli_query($conn, $sql);
if (!$result) {
die("Error executing the query: " . mysqli_error($conn));
}
while ($row = mysqli_fetch_assoc($result)) {
echo "<div class='row'>";
echo "<div class='col-md-6'>";
echo "<label class='form-label'>Content:</label>";
echo "<textarea class='form-control about-us-textarea' rows='5'>" . $row['content'] . "</textarea>";
echo "</div>";// col-md-6 end
echo "<div class='col-md-6'>";
echo '<label class="form-label">Hubspot Script:<span class="text-danger fs-11"><a target="_blank" href="https://www.hubspot.com/">(Create Account)</a></span></label>';
echo "<textarea class='form-control' rows='5'>" . $row['text'] . "</textarea>";
echo "</div>";// col-md-6 end
echo "<div class='col-md-12'>";
// Add an edit button to toggle the edit mode
echo "<button type='button' class='btn btn-primary edit-content-btn1 mt-3' data-toggle='modal' data-target='#editContactUsModal' data-id='" . $row['id'] . "'>Edit</button>";
echo "</div>";// col-md-12 end
echo "</div>";// row end
}
mysqli_close($conn);
?>
</div>
</div>
</div>
<!-- Edit About Us Modal -->
<div class="modal fade" id="editContactUsModal" tabindex="-1" aria-labelledby="editContactUsModalLabel" aria-hidden="true">
<div class="modal-dialog modal-lg">
<div class="modal-content">
<div class="modal-header">
<h5 class="modal-title" id="editContactUsModalLabel">Edit Contact Us Content</h5>
<button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
</div>
<div class="modal-body">
<form id="editContactUsForm">
<div class="mb-3">
<label for="contactUsContent" class="form-label">Content</label>
<textarea class="form-control" id="contactUsContent" name="contactUsContent" rows="5"></textarea>
</div>
<div class="mb-3">
<label for="contactUsScript" class="form-label">Hubpsot Script</label>
<textarea class="form-control" id="contactUsScript" name="contactUsScript" rows="5"></textarea>
</div>
<input type="hidden" id="contactUsId" name="contactUsId">
</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="saveContactUsChanges">Save changes</button>
</div>
</div>
</div>
</div>