<form action="index.php" method="post">
<input type="submit" name="allclients" value="All clients">
<input type="submit" name="allwaiters" value="All waiters">
<input type="submit" name="alldiscounts" value="All discounts">
<input type="submit" name="alldishes" value="All dishes">
<input type="submit" name="allorders" value="All orders">
<input type="submit" name="allbills" value="All bills">
<hr>
Use other queries:
<input type="submit" name="innerJoin" value="INNER JOIN">
<input type="submit" name="leftJoin" value="LEFT JOIN">
<hr>
</form>
<?php
if (isset($_POST['allclients'])) {
$client = new View\Clients();
$client->allClients();
?>
<form action="ChangeClient.php" method="post">
<fieldset>
<legend>Update:</legend>
id <input type="number" name="upd_id_clients">
name <input type="text" name="upd_name_clients">
id_discount <input type="number" name="upd_id_discount">
<input type="submit" name="update_clients" value="UPDATE">
</fieldset>
<fieldset>
<legend>Delete a client by id</legend>
id <input type="number" name="id_del_clients">
<input type="submit" name="delete_clients" value="DELETE">
</fieldset>
/**
* Created by PhpStorm.
* User: kate
* Date: 02.11.15
* Time: 12:52
*/
require_once '../vendor/autoload.php';
use Layer\Connector;
if (isset($_POST['update_clients'])) {
$id = $_POST['upd_id_clients'];
$name = $_POST['upd_name_clients'];
$id_discount = $_POST['upd_id_discount'];
$client = new View\Clients();
$client->updateClient($id, $name, $id_discount);
}
if (isset($_POST['delete_clients'])) {
$id = $_POST['id_del_clients'];
$client = new View\Clients();
$client->deleteClient($id);
}
if (isset($_POST['insert_clients'])) {
$id = $_POST['ins_id_clients'];
$name = $_POST['ins_name_clients'];
$id_discount = $_POST['ins_id_discount'];
$client = new View\Clients();
$client->insertClient($id, $name, $id_discount);
}
?>
<a href="index.php" style="color: #dd4444">Preview</a>
