<?php
//INSERT
$tab_client = array('nom' => 'Rabourdin', 'prenom' => 'Baptiste');
$id_client = db_insert('clients', $tab_client, $debug);
echo 'Client inséré ' . $id_client;
//UPDATE
$tab_client = array('nom' => 'Rabourdin1', 'prenom' => 'Baptiste1');
$affected_rows = db_update('clients', $tab_client, array('id' => 1), $debug);
//DELETE
$affected_rows = db_delete('clients', array('nom' => 'Rabourdin'), $debug);
echo $affected_rows;
//SELECT
$clients = db_select('SELECT * FROM clients');
foreach ($clients as $client) {
echo '<div>' . $client['nom'] . ' ' . $client['prenom'] . ' ' . $client['id'] . '</div>';
}
//SHOW
db_show_on_table($clients);
</div>
</div>
<div class="row">
<div class="large-12 columns">
<div class="row">
<div class="large-8 columns">
<h1>Accueil</h1>
<p class="subheader">Valorisation de pneus et câbles électriques.</p>
<?php
$debug = true;
include 'inc/fonctions.php';
$clients = db_select('SELECT * FROM clients');
//SHOW
db_show_on_table($clients, array('id' => 'id', 'Nom' => 'nom', 'Prénom' => 'prenom'));
?>
</div>
<div class="large-4 columns">
<h2>Col Droite</h2>
</div>
</div>
</div>
</div>
<?php
include 'blocs/footer.php';
