Wer kann mir helfen?
Irgendwas muss mit " und ' falsch sein aber ich weis nicht was ich bei meiner db-abfrage ändern muss!
Fehlermeldung:
Parse error: parse error, unexpected T_CONSTANT_ENCAPSED_STRING in C:\php5xampp-dev\htdocs\leisys\infile.php on line 46
<?
class odbc
{
var $connid;
var $erg;
//This is the Constructor for Class ODBC
function odbc()
{
$U = "root";
$DB = "leisys";
$P = "pw";
$Srv = "localhost";
$DSN = "Driver=MySQL;Server=$Srv;Database=$DB";
if(!$this->connid = odbc_connect ("$DSN","$U","$P",SQL_CUR_USE_ODBC))
{
echo odbc_errormsg();
}
else
{
echo "ODBC Ok";
return $this->connid;
}
}
//With this Function you can create SQL_Queries
function f_sql($sql)
{
if (!$this->erg = odbc_exec($this->connid, $sql))
{
echo "Fehler beim Senden der Abfrage...";
}
return $this->erg;
}
}//End of Class ODBC
$db = new odbc();
$db->f_sql(" LOAD DATA INFILE 'C:\\WINNT\\TEMP\\test.csv'
INTO TABLE `before_extracting` FIELDS TERMINATED BY ';'
ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\r\n'
");
?>