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, bemerkung) |
157 contract_mon_notice, bemerkung,email_send) |
158 VALUES(?,?,?,?,?,?,?,?)"); |
158 VALUES(?,?,?,?,?,?,?,?,?)"); |
159 $stmt -> bind_param('ssissiis',$vtr["cname"],$vtr["clong"],$vtr['vtyp'],$vbegin,$vend,$vtr['cautoend'],$vtr['cnot'],$vtr['cbem']); |
159 $stmt -> bind_param('ssissiisi',$vtr["cname"],$vtr["clong"],$vtr['vtyp'],$vbegin,$vend,$vtr['cautoend'],$vtr['cnot'],$vtr['cbem'],$vtr["email"]); |
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. |