58 lines
1.5 KiB
PHP
58 lines
1.5 KiB
PHP
<?php
|
|
include "db.php";
|
|
|
|
$id=$_GET['id'];
|
|
|
|
$record=mysqli_fetch_assoc(mysqli_query($conn,"SELECT * FROM records WHERE id=$id"));
|
|
|
|
$fields=mysqli_query($conn,"SELECT * FROM additional_fields WHERE record_id=$id");
|
|
?>
|
|
|
|
<div class="modal-header">
|
|
<h5 class="modal-title">Edit Record</h5>
|
|
<button type="button" class="btn-close" data-bs-dismiss="modal"></button>
|
|
</div>
|
|
|
|
<div class="modal-body">
|
|
|
|
<input type="hidden" id="edit_id" value="<?= $record['id'] ?>">
|
|
|
|
<label>Name</label>
|
|
<input type="text" id="edit_name" class="form-control mb-2" value="<?= $record['name'] ?>">
|
|
|
|
<label>Email</label>
|
|
<input type="text" id="edit_email" class="form-control mb-2" value="<?= $record['email'] ?>">
|
|
|
|
<label>Phone</label>
|
|
<input type="text" id="edit_phone" class="form-control mb-2" value="<?= $record['phone'] ?>">
|
|
|
|
<label>Category</label>
|
|
<input type="text" id="edit_category" class="form-control mb-2" value="<?= $record['category'] ?>">
|
|
|
|
<label>Description</label>
|
|
<textarea id="edit_description" class="form-control mb-3"><?= $record['description'] ?></textarea>
|
|
|
|
<hr>
|
|
<h6>Additional Fields</h6>
|
|
|
|
<div id="editFieldContainer">
|
|
|
|
<?php while($f=mysqli_fetch_assoc($fields)){ ?>
|
|
|
|
<div class="input-group mb-2 fieldRow">
|
|
<input type="text" class="form-control edit_field" value="<?= $f['field_value'] ?>">
|
|
<button class="btn btn-danger removeField">X</button>
|
|
</div>
|
|
|
|
<?php } ?>
|
|
|
|
</div>
|
|
|
|
<button class="btn btn-sm btn-outline-dark" id="addField">+ Add Field</button>
|
|
|
|
</div>
|
|
|
|
<div class="modal-footer">
|
|
<button class="btn btn-success" id="updateRecord">Update</button>
|
|
</div>
|