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