diff -r aae5b0ecc47b -r a382de56a8e4 fhiiqm/raum_ins.php
--- a/fhiiqm/raum_ins.php Thu Jan 12 11:41:22 2012 +0100
+++ b/fhiiqm/raum_ins.php Mon Feb 06 13:44:00 2012 +0100
@@ -97,6 +97,7 @@
$raum['rbez'] = substr($raum['rbez'],0,50);
$raum['rnum'] = substr($raum['rnum'],0,10);
if ($raum['rtyp']== -1) $rtyp = "NULL"; else $rtyp = "'" . $raum['rtyp'] . "'";
+ if ($raum['reityp']== -1) $raum['reityp'] = null;
// Filename Vertrag
$raum['rfname'] = substr($raum['rfname'],0,50);
if (isset($raum['rflae']) && $raum['rflae']>"0")
@@ -124,11 +125,11 @@
if (is_object($stmt))
{
if ($raum['rtyp']== -1) $raum['rtyp']=null;
- $stmt -> prepare ("INSERT INTO Raum (raum_nr,raum_name,geb_ID,raumtyp_ID,raum_flaeche) VALUES (?,?,?,?,?)");
- $stmt -> bind_param('ssssd', $raum['rnum'], $raum['rbez'], $raum['geb'], $raum['rtyp'], $raum['rflae']);
+ $stmt -> prepare ("INSERT INTO Raum (raum_nr,raum_name,geb_ID,raumtyp_ID,reinigung_typ_ID,raum_flaeche) VALUES (?,?,?,?,?,?)");
+ $stmt -> bind_param('sssssd', $raum['rnum'], $raum['rbez'], $raum['geb'], $raum['rtyp'], $raum["reityp"], $raum['rflae']);
$result = $stmt -> execute();
}
- if ($dbc->error) echo "error: " . $dbc->error . "
\n";
+ if ($stmt->error) echo "error: " . $stmt->error . "
\n";
if ($result)
{ // INSERT o.k.
// raum_ID ermitteln