(PDO) database entries are not possible, even without errorfeedback!

[Tamer Higazi <tameritoke2@xxxxxxxx>]

Hi!
I am trying to insert with PDO-Sqlite rows through a form. I can do
whatever I want, I don't find the sollution where I made the error.
Perhaps somebody of you could help me?!

However, the database is created with sqlite, and the entries should be
done with PDO_SQLITE. However, no entries are done anyways and I am one
step going nuts, specially because I don't receive no warning or
errormessage on the screen.

For any help, I would thank you very much.

Tamer


Code:

<?php
require_once('HTML/Form.php');
require_once('I18N/UnicodeString.php');
require_once('HTML/Table.php');

class Formular
{
	private $ServerVar = array("Auswahl","Betreff","Eingabe");

	
	function __construct()
	{
		
		$this->ServerVar["Auswahl"] = $_GET['Auswahl'];
		$this->ServerVar["Betreff"] = $_GET['Feld'];
		$this->ServerVar["Eingabe"] = $_GET['Eingabe'];
		$this->MeinFormular();
		
		
		//$this->sqdb();
		if(($this->ServerVar["Betreff"] === null) or
($this->ServerVar["Eingabe"] === null))
		{
			$this->MeineDB();
			$this->TextFeld();
		}
		elseif (($this->ServerVar["Betreff"] === "") or
($this->ServerVar["Eingabe"] === ""))
		{
			$this->MeineDB();
			$this->TextFeld();
		}
		
		else
		{
			$Auswahl = $this->ServerVar["Auswahl"];
			$Betreff = $this->ServerVar["Betreff"];
			$Eingabe = $this->ServerVar["Eingabe"];
			$this->MeineDB2($Auswahl,$Betreff,$Eingabe);
			$this->TextFeld();
		}
		
		
		
	}

	
	private function MeineDB()
	{
		
		try
		{
			$dbh = new
PDO('sqlite2:/home/tamer/public_html/citybaker/WebContent/mysqlitedb');
			$sql = 'select * from Daten';
			
			foreach ($dbh->query($sql) as $row)
			{
				//print_r($row);
			}
			$this->ServerVar = $row;
			$dbh = null;
			
			
		}
		
	
		catch (PDOException $e)
		{
			die("Can't connect!");
		}
			
			
	}
	
	private function MeineDB2($selection,$subj,$input)
	{
		switch ($selection)
		{
			
		case 0:
			$selection = 'Deutsch';
		break;
		
		case 1:
			$selection = 'Englisch';
			break;
		case 2:
			$selection = "Arabisch";
			break;
	}
	
		$DBWerte = 'insert into Daten
values('.'"'.$selection.'","'.$subj.',"'.$input.')';
		//print($DBWerte);
		try
		{			
			$dbh = new
PDO('sqlite2:/home/tamer/public_html/citybaker/WebContent/mysqlitedb');
			//$dbh->beginTransaction();
			$dbh->exec($DBWerte);
			//$dbh->commit();
			$dbh = null;
			$this->ServerVar = $row;
			
		}
		
	
		catch (PDOException $e)
		{
			
			//$dbh->rollBack();
			echo "Failed: ".$e->getMessage();
		}
		
	}
	
	private function MeinFormular()
	{
		$Sprachen = array('deutsch','englisch','arabisch');
		$Formular = new
HTML_Form("Formular.php",'get','Meinformular','',"text/plain","accept-charset=utf-8");
		$Formular->addSelect("Auswahl","Auswahl",$Sprachen);
		$Formular->addText("Feld","Betreff",null,50,50);
		$Formular->addTextarea("Eingabe","Eingabefeld",null,50,10,10);
		$Formular->addSubmit('submit','absenden!');
		$Formular->display();
	}
	
	private function TextFeld()
	{
		$TabelleAttribute = array("border"=>"1");
		$Tabelle = new HTML_Table($TabelleAttribute,0,false);
		$Tabelle->addCol($this->MeinArrayText);
		print($Tabelle->toHtml());
	}
	
	private function sqdb()
	{
		if ($db = sqlite_open('mysqlitedb', 0666, $sqliteerror))
		{
			sqlite_query($db, 'CREATE TABLE Daten (sprache varchar(100),betreff
varchar(100),feld varchar(1000))');
			//sqlite_query($db, "INSERT INTO foo VALUES ('fnord')");
			//$result = sqlite_query($db, 'select bar from foo');
			//var_dump(sqlite_fetch_array($result));
		} else {
			die($sqliteerror);
		}
	}
}


?>

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php