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(); }