public function add(Client $client)
{
$query = $this->_db->prepare('INSERT INTO t_client (nom, adresse, telephone1, telephone2, cin, email, created, code)
VALUES (:nom, :adresse, :telephone1, :telephone2, :cin, :email, :created, :code)') or die(print_r($this->_db->errorInfo()));
$query->bindValue(':nom', $client->nom());
$query->bindValue(':adresse', $client->adresse());
$query->bindValue(':telephone1', $client->telephone1());
$query->bindValue(':telephone2', $client->telephone2());
$query->bindValue(':cin', $client->cin());
$query->bindValue(':email', $client->email());
$query->bindValue(':created', $client->created());
$query->bindValue(':code', $client->code());
$query->execute();
$query->closeCursor();
}
