"; try { //open the database $db = new PDO('sqlite:trafficnews.sqlite'); //$db->exec("CREATE TABLE trafficnews (Id INTEGER PRIMARY KEY, wo TEXT, von TEXT, nach TEXT, vonsub TEXT, nachsub TEXT, info TEXT, aktuell BOOLEAN, time INTEGER)"); $db->exec("INSERT INTO trafficnews (wo, von, nach, vonsub, nachsub, info, aktuell, time) VALUES ('".$wo."', '".$von."', '".$nach."', '".$vonsub."', '".$nachsub."', '".$info."', '".$aktuell."', ".$time.");"); //$db->exec('DELETE FROM trafficnews WHERE Id=1'); // close the database connection $db = NULL; }//try end catch(PDOException $e) { print 'Exception : '.$e->getMessage(); } echo "thank you"; } ?>