152 */ |
152 */ |
153 $stmt = $dbc -> stmtinit(); |
153 $stmt = $dbc -> stmtinit(); |
154 if (is_object($stmt)) |
154 if (is_object($stmt)) |
155 { |
155 { |
156 $stmt -> prepare("INSERT INTO Vertrag (contract_name, contract_l,vtyp_ID,contract_begin, contract_end, contract_autoend, |
156 $stmt -> prepare("INSERT INTO Vertrag (contract_name, contract_l,vtyp_ID,contract_begin, contract_end, contract_autoend, |
157 contract_mon_notice, contract_file, bemerkung) |
157 contract_mon_notice, bemerkung) |
158 VALUES(?,?,?,?,?,?,?,?,?)"); |
158 VALUES(?,?,?,?,?,?,?,?)"); |
159 $stmt -> bind_param('ssissiiss',$vtr["cname"],$vtr["clong"],$vtr['vtyp'],$vbegin,$vend,$vtr['cautoend'],$vtr['cnot'],$cfile,$vtr['cbem']); |
159 $stmt -> bind_param('ssissiis',$vtr["cname"],$vtr["clong"],$vtr['vtyp'],$vbegin,$vend,$vtr['cautoend'],$vtr['cnot'],$vtr['cbem']); |
160 $result = $stmt -> execute(); |
160 $result = $stmt -> execute(); |
161 } |
161 } |
162 if ($stmt->error) echo "INSERT Vertrag, error: " . $stmt->errno . " - ". $stmt->error . "<br><br>\n"; |
162 if ($stmt->error) echo "INSERT Vertrag, error: " . $stmt->errno . " - ". $stmt->error . "<br><br>\n"; |
163 if ($result) |
163 if ($result) |
164 { // INSERT o.k. |
164 { // INSERT o.k. |