Forum d'entraide PHPFrance

pdo_sqlite
PDO Driver for SQLite 3.x enabled
PECL Module version 1.0.1 $Id: pdo_sqlite.c,v 1.10.2.6.2.2 2007/03/23 14:30:00 wez Exp $
SQLite Library 3.3.17undefined

Echec de la connexion :could not find driver
Fatal error: Call to a member function query() on a non-object in D:\www\azuracd.fr\htdocs\class\MyPDO.class on line 32

try{
		$this->oDbConnection=new PDO('sqlite2:./Db/MyDb.sql');
	}catch (Exception $e){
					echo 'Echec de la connexion :'.$e->getMessage();
					
				}

Notice: Use of undefined constant F1_AMIANTE_TTC - assumed 'F1_AMIANTE_TTC' in D:\www\azuracd.fr\htdocs\inc\ContenuPageSansFormulaire.inc on line 35

Notice: Use of undefined constant F1_CARREZ_TTC - assumed 'F1_CARREZ_TTC' in D:\www\azuracd.fr\htdocs\inc\ContenuPageSansFormulaire.inc on line 35

Notice: Use of undefined constant F1_DPE_TTC - assumed 'F1_DPE_TTC' in D:\www\azuracd.fr\htdocs\inc\ContenuPageSansFormulaire.inc on line 35

Notice: Use of undefined constant F1_GAZ_TTC - assumed 'F1_GAZ_TTC' in D:\www\azuracd.fr\htdocs\inc\ContenuPageSansFormulaire.inc on line 35

Notice: Use of undefined constant F1_PLOMB_TTC - assumed 'F1_PLOMB_TTC' in D:\www\azuracd.fr\htdocs\inc\ContenuPageSansFormulaire.inc on line 35

Notice: Use of undefined constant F1_NSH_TTC - assumed 'F1_NSH_TTC' in D:\www\azuracd.fr\htdocs\inc\ContenuPageSansFormulaire.inc on line 35

Notice: Use of undefined constant F1_TERMITE_TTC - assumed 'F1_TERMITE_TTC' in D:\www\azuracd.fr\htdocs\inc\ContenuPageSansFormulaire.inc on line 35

Notice: Use of undefined constant F1_AMIANTE_TTC - assumed 'F1_AMIANTE_TTC' in D:\www\azuracd.fr\htdocs\inc\ContenuPageSansFormulaire.inc on line 37

public function ShowTableUnderSelectBox($NomChamp,$Table,$NameOfSelect,$CssOfSelect,$NameOfOption1){
	global$fTextShowTable;
	$fTextShowTable='<select name="'.$NameOfSelect.'" id="'.$NameOfSelect.'"    class="'.$CssOfSelect.'"><option>'.$NameOfOption1.'</option>';
	$oPDOStatement=$this->oDbConnection->query("SELECT $NomChamp FROM $Table");
	if($oPDOStatement!==FALSE){
		while($aRow=$oPDOStatement->fetch()){
			$fTextShowTable.='<option>'.$aRow[$NomChamp].'</option>';
		}
	}
	$fTextShowTable.='</select>';
	$oPDOStatement=NULL;
	return $fTextShowTable;
}

public function Definition($sTable,$sNomDuDefineTtc){
	$oPDOStatement=$this->oDbConnection->query("SELECT PrixTtc from $sTable WHERE idPiece='1' ");
	if($oPDOStatement!==FALSE){
		while($aRow=$oPDOStatement->fetch()){
			define($sNomDuDefineTtc,$aRow['PrixTtc']);
		}
	}
	$oPDOStatement=NULL;
	return TRUE;
}

Notice: Constant F1_ERNT_TTC already defined in D:\www\azuracd.fr\htdocs\class\MyPDO.class on line 35

try{
			$oPDOStatement=$this->oAccesBase->prepare("INSERT INTO ".NOM_TABLE_CLIENT." (TypeDemande,DesignationClient,MailClient,TelClient) VALUES (?,?,?,?)");
			$oPDOStatement->bindValue(1,TYPE_DEMANDE_DEVIS);
			$oPDOStatement->bindValue(2,$this->sClient);
			$oPDOStatement->bindValue(3,$this->sAdresseMailClient);
			$oPDOStatement->bindValue(4,$this->iTelClient);
			$oPDOStatement->execute();
			$this->oAccesBase=NULL;
		}
		catch (PDOException $e){
			echo 'erreur'.$e->getMessage();
			include(PIED_DE_PAGE);
		}

try{
			$oConnection=new PDO("sqlite2:".MY_DATA_BASE);
		   	$oPDOStatement=$oConnection->prepare("INSERT INTO ".NOM_TABLE_CLIENT." (TypeDemande,DesignationClient,MailClient,TelClient) VALUES (?,?,?,?)");
			if ($oPDOStatement === FALSE ){
				throw new Exception ('la preparation de la requete n\'a pas marché');
			}else
			{
				$oPDOStatement->bindValue(1,TYPE_DEMANDE_CONTACT);
				$oPDOStatement->bindValue(2,$aData['Nom-Prenom']);
				$oPDOStatement->bindValue(3,$aData['Email']);
				$oPDOStatement->bindValue(4,$aData['Telephone']);
				
				if ($oPDOStatement->execute()===FALSE ){
					throw new Exception('l\'exectution de la requete preparé ne s\'est pas fait correcxtement');
				}else{
					$oConnection=NULL;
				}
			}
		}
		catch (PDOException $e){
			echo 'erreur'.$e->getMessage();
		}