prepare("INSERT INTO clients (name, client_code) VALUES (:name, :client_code)");
$stmt->execute(['name' => $client_name, 'client_code' => $client_code]);
}
// Modifier un client
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['edit_client'])) {
$client_id = $_POST['client_id'];
$client_name = $_POST['client_name'];
$client_code = strtoupper($_POST['client_code']);
$stmt = $pdo->prepare("UPDATE clients SET name = :name, client_code = :client_code WHERE id = :id");
$stmt->execute(['name' => $client_name, 'client_code' => $client_code, 'id' => $client_id]);
}
// Supprimer un client
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['delete_client'])) {
$client_id = $_POST['client_id'];
$stmt = $pdo->prepare("DELETE FROM clients WHERE id = :id");
$stmt->execute(['id' => $client_id]);
}
// Récupérer tous les clients
$stmt = $pdo->query("SELECT * FROM clients");
$clients = $stmt->fetchAll();
?>
Manage Clients
Manage Clients
Add Client
Existing Clients
| ID |
Name |
Client Code |
Actions |
|
|
|
|
Retour à la page principale