[bacc182]

Das ist mein php code

PHP-Code:

$insert = 'INSERT INTO T_LEIMBUCH (A_ID, A_LOGOTYPE, A_DATE, A_NOTE, A_ORDERNR, A_PRESSNO, A_BEAMNO, A_LAMELLANO, A_GLUEAMOUNTPRESENT, A_RATIOH1PRESENT,
        A_RATIOH2PRESENT, A_TEMPERATUREPRESENT,    A_LAMELLATEMPERATUREMIN, A_LAMELLATEMPERATUREMAX, A_LAMPTEMPUSEDCALCGAM, A_RATIOSET_MAX, A_RATIOSET_MIN, 
        A_FLGLUEAMOFFSET, A_GLUEAMOUNTSETVALUE, A_LINESPEED, AGLUEAMOUNTSETMAXPERBATCH,    AGLUEAMOUNTSETMINPERBATCH, A_REMCATWHENLASTCAT, A_INPARAMETERPLANNEDCAT, 
        A_INPARESTCATLASTLAM, A_PRESSINGTIME_MINUTES, A_GLUEAMOUNTPREDICTEDSTART, A_GLUEAMOUNTPREDICTEDEND,    A_PARAMETERBITS) VALUES '; 
                
        $arr_values_count = count($arr_values);
        for($a = 0; $a < $arr_values_count; $a++) {
        
        $values = '('.
        "$arr_values[$a]['id']".', '.
        "'$arr_values[$a]['LogoType']'".', '.
        "to_timestamp('$arr_values[$a]['Date']', 'YYYY.MM.DD HH24-Mi-SS.ff3')".', '.
        "'$arr_values[$a]['Note']'".', '.
        "$arr_values[$a]['OrderNr']".', '.
        "$arr_values[$a]['PressNo']".', '.
        "$arr_values[$a]['BeamNo']".', '.
        "$arr_values[$a]['LamellaNo']".', '.
        "$arr_values[$a]['GlueAmountpresent']".', '.
        "$arr_values[$a]['RatioH1present']".', '.
        "$arr_values[$a]['RatioH2present']".', '.
        "$arr_values[$a]['Temperaturepresent']".', '.
        "$arr_values[$a]['Lamellatemperaturemin']".', '.
        "$arr_values[$a]['Lamellatemperaturemax']".', '.
        "$arr_values[$a]['LamptempusedcalcGam']".', '.
        "$arr_values[$a]['Ratioset_max']".', '.
        "$arr_values[$a]['Ratioset_min']".', '.
        "$arr_values[$a]['Flglueamoffset']".', '.
        "$arr_values[$a]['Glueamountsetvalue']".', '.
        "$arr_values[$a]['Linespeed']".', '.
        "$arr_values[$a]['Glueamountset_maxperBatch']".', '.
        "$arr_values[$a]['Glueamountset_minperBatch']".', '.
        "$arr_values[$a]['RemCATwhenlastcat']".', '.
        "$arr_values[$a]['Inparameterplannedcat']".', '.
        "$arr_values[$a]['InparEstCatlastlam']".', '.
        "$arr_values[$a]['Pressingtime-minutes']".', '.
        "$arr_values[$a]['Glueamountpredictedstartvalue']".', '.
        "$arr_values[$a]['Glueamountpredictedendvalue']".', '.
        "$arr_values[$a]['Parameterbits']".');';
        
        $query_insert = $insert.$values;
        $stid = oci_parse($connect, $query_insert);
        if ($stid == false) echo "Query-Error <BR>";
        $error = oci_execute($stid);
            if (!$error) {
                $fehler = oci_error($stid);
                echo "Oracle Fehler: ".htmlentities($fehler['message']);
                die();
        }
        oci_execute($stid); 


Ich bekomme in der letzten Zeile (oci_execute) diesen Fehler: Warning: oci_execute() function.oci-execute ORA-00917 missing comma in s*****.php on line 130 (letzte Zeile). Ich habe schon stundenlang gegoogelt habe nichts gefunden.
Danke im voraus

[kkhamburg]

Spontan würde ich sagen das die Bedingungsabfrage nicht geschlossen ist.

Da fehlt eine geschweifte Klammer

[bacc182]

lösung:

$insert = "INSERT INTO T_LEIMBUCH (A_ID, A_LOGOTYPE, A_DATE, A_NOTE, A_ORDERNR, A_PRESSNO, A_BEAMNO, A_LAMELLANO, A_GLUEAMOUNTPRESENT, A_RATIOH1PRESENT,
A_RATIOH2PRESENT, A_TEMPERATUREPRESENT, A_LAMELLATEMPERATUREMIN, A_LAMELLATEMPERATUREMAX, A_LAMPTEMPUSEDCALCGAM, A_RATIOSET_MAX, A_RATIOSET_MIN,
A_FLGLUEAMOFFSET, A_GLUEAMOUNTSETVALUE, A_LINESPEED, AGLUEAMOUNTSETMAXPERBATCH, AGLUEAMOUNTSETMINPERBATCH, A_REMCATWHENLASTCAT, A_INPARAMETERPLANNEDCAT,
A_INPARESTCATLASTLAM, A_PRESSINGTIME_MINUTES, A_GLUEAMOUNTPREDICTEDSTART, A_GLUEAMOUNTPREDICTEDEND, A_PARAMETERBITS) VALUES (
:idleimbuch, :logotype, to_timestamp(:dateleimbuch, 'YYYY.MM.DD HH24-Mi-SS.ff3'), :noteleimbuch, rdernr, ressno, :beamno, :lamellano, :glueamountpresent,
:ratioh1present, :ratioh2present, :temperaturepresent, :lamellatemperaturmin, :lamellatemperaturmax, :lamptempusedcalcgam, :ratioset_max, :ratioset_min,
:flglueamoffset, :glueamountsetvalue, :linespeed, :glueamountset_maxperbatch, :glueamountset_minperbatch, :remcatwhenlastcat, :inparameterplannedcat,
:inparestcatlastlam, ressingtimeminutes, :glueamountpredictedstartvalue, :glueamountpredictedendvalue, arameterbits)";

$stmt1 = oci_parse($connect,$insert);
$arr_values_count = count($arr_values);

for($a = 0; $a < $arr_values_count; $a++) {
oci_bind_by_name($stmt1, ":idleimbuch", $arr_values[$a]['id']);
oci_bind_by_name($stmt1, ":logotype", $arr_values[$a]['LogoType']);
oci_bind_by_name($stmt1, ":dateleimbuch", $arr_values[$a]['Date']);
oci_bind_by_name($stmt1, ":noteleimbuch", $arr_values[$a]['Note']);
oci_bind_by_name($stmt1, "rdernr", $arr_values[$a]['OrderNr']);
oci_bind_by_name($stmt1, "ressno", $arr_values[$a]['PressNo']);
oci_bind_by_name($stmt1, ":beamno", $arr_values[$a]['BeamNo']);
oci_bind_by_name($stmt1, ":lamellano", $arr_values[$a]['LamellaNo']);
oci_bind_by_name($stmt1, ":glueamountpresent", $arr_values[$a]['GlueAmountpresent']);
oci_bind_by_name($stmt1, ":ratioh1present", $arr_values[$a]['RatioH1present']);
oci_bind_by_name($stmt1, ":ratioh2present", $arr_values[$a]['RatioH2present']);
oci_bind_by_name($stmt1, ":temperaturepresent", $arr_values[$a]['Temperaturepresent']);
oci_bind_by_name($stmt1, ":lamellatemperaturmin", $arr_values[$a]['Lamellatemperaturemin']);
oci_bind_by_name($stmt1, ":lamellatemperaturmax", $arr_values[$a]['Lamellatemperaturemax']);
oci_bind_by_name($stmt1, ":lamptempusedcalcgam", $arr_values[$a]['LamptempusedcalcGam']);
oci_bind_by_name($stmt1, ":ratioset_max", $arr_values[$a]['Ratioset_max']);
oci_bind_by_name($stmt1, ":ratioset_min", $arr_values[$a]['Ratioset_min']);
oci_bind_by_name($stmt1, ":flglueamoffset", $arr_values[$a]['Flglueamoffset']);
oci_bind_by_name($stmt1, ":glueamountsetvalue", $arr_values[$a]['Glueamountsetvalue']);
oci_bind_by_name($stmt1, ":linespeed", $arr_values[$a]['Linespeed']);
oci_bind_by_name($stmt1, ":glueamountset_maxperbatch", $arr_values[$a]['Glueamountset_maxperBatch']);
oci_bind_by_name($stmt1, ":glueamountset_minperbatch", $arr_values[$a]['Glueamountset_minperBatch']);
oci_bind_by_name($stmt1, ":remcatwhenlastcat", $arr_values[$a]['RemCATwhenlastcat']);
oci_bind_by_name($stmt1, ":inparameterplannedcat", $arr_values[$a]['Inparameterplannedcat']);
oci_bind_by_name($stmt1, ":inparestcatlastlam", $arr_values[$a]['InparEstCatlastlam']);
oci_bind_by_name($stmt1, "ressingtimeminutes", $arr_values[$a]['Pressingtime-minutes']);
oci_bind_by_name($stmt1, ":glueamountpredictedstartvalue", $arr_values[$a]['Glueamountpredictedstartvalue']);
oci_bind_by_name($stmt1, ":glueamountpredictedendvalue", $arr_values[$a]['Glueamountpredictedendvalue']);
oci_bind_by_name($stmt1, "arameterbits", $arr_values[$a]['Parameterbits']);

$stid = oci_parse($connect, $insert);
if ($stid == false) echo "Query-Error <BR>";
$error = oci_execute($stid);
if (!$error) {
$fehler = oci_error($stid);
echo "Oracle Fehler: ".htmlentities($fehler['message']);
die();
}
$result = oci_execute($stid); // don't autocommit!
if (!$result) break;
}
oci_free_statement($stid);
oci_close($connect);
oci_commit($connect);
fclose($datei);
unlink($_FILES['fileupload']['tmp_name']);