prepare("INSERT INTO testimonials (customer_name, content, rating, event_type, sort_order, status) VALUES (?,?,?,?,?,?)");
$stmt->bind_param("ssisii", $name, $content, $rating, $event_type, $sort, $status);
} else {
$id = intval($_POST['id']);
$stmt = $conn->prepare("UPDATE testimonials SET customer_name=?, content=?, rating=?, event_type=?, sort_order=?, status=? WHERE id=?");
$stmt->bind_param("ssisiii", $name, $content, $rating, $event_type, $sort, $status, $id);
}
$stmt->execute(); $msg = 'Saved!
';
} elseif ($action == 'delete') {
$conn->query("DELETE FROM testimonials WHERE id=" . intval($_POST['id']));
$msg = 'Deleted!
';
}
}
$testimonials = getTestimonials();
?>
Testimonials
| ID | Name | Rating | Event Type | Status | Action |
|---|
| |
|
| Active':'Hidden' ?> |
|