|
1 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> |
|
2 <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> |
|
3 |
|
4 <head> |
|
5 <meta http-equiv="content-type" content="text/html; charset=iso-8859-1" /> |
|
6 <link href="css/db.css" rel="STYLESHEET" type="TEXT/CSS" /> |
|
7 |
|
8 <title>Eingabe Partner</title> |
|
9 </head> |
|
10 |
|
11 <body> |
|
12 <div class="float-r"><img src="img/group_gear.png" border="0" alt="Partnerdaten eingeben" title="Partnerdaten eingeben"/></div> |
|
13 |
|
14 <?php |
|
15 |
|
16 /** |
|
17 * @author Bettina Schwarzer, Fritz-Haber-Institut |
|
18 * @copyright 07/2011 |
|
19 * |
|
20 * INSERT Partnerdaten |
|
21 */ |
|
22 |
|
23 error_reporting(E_ALL ^ E_NOTICE); |
|
24 |
|
25 include_once($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/dbconnect.inc.php"); |
|
26 |
|
27 $ok = $_POST["ok"]; |
|
28 $ins = $_POST["ins"]; |
|
29 $part = $_POST["part"]; |
|
30 if (!$part['okn']) $ok=false; |
|
31 |
|
32 // print_r($part); |
|
33 |
|
34 if (!$ok || !$ins ) |
|
35 { |
|
36 $upd = $ins; // wegen filename-Pruefung bei Upload |
|
37 include_once("form/partner_form.inc.php"); |
|
38 |
|
39 if ($ins == "eingeben" ) |
|
40 { |
|
41 |
|
42 $frage = "Alle Angaben ok?"; |
|
43 echo "<tr> |
|
44 <td class=\"red\" valign=\"top\" align=\"left\">$frage</td> |
|
45 <td><input type=\"checkbox\" name=\"ok\" value=\"1\""; |
|
46 if ($ok) echo "checked"; |
|
47 echo "></td>\n</tr>\n"; |
|
48 } |
|
49 |
|
50 echo "<tr>\n"; |
|
51 echo " |
|
52 <td> </td> |
|
53 <td><input class=\"button\" type=\"submit\" value=\"eingeben\" name=\"ins\" title=\"insert\" /></td>\n"; |
|
54 echo "</tr>\n"; |
|
55 echo "</table>\n"; |
|
56 echo "</div>\n"; |
|
57 echo "</form>\n"; |
|
58 |
|
59 } |
|
60 else |
|
61 { |
|
62 echo "<div align='center'>\n"; |
|
63 //daten speichern |
|
64 if (!isset($dbc) || !$dbc) $dbc = new dbconnection(); |
|
65 $part["firma"] = substr($part["firma"],0,50); |
|
66 $part["nname"] = substr($part["nname"],0,30); |
|
67 $part["vname"] = substr($part["vname"],0,30); |
|
68 if ($part['anr']== -1) $part['anr']=null; |
|
69 $part["titel"] = substr($part["titel"],0,10); |
|
70 $part["tel"] = substr($part["tel"],0,20); |
|
71 $part["mobil"] = substr($part["motel"],0,20); |
|
72 $part["fax"] = substr($part["fax"],0,20); |
|
73 $part["email"] = substr($part["email"],0,20); |
|
74 $part["ort"] = substr($part["ort"],0,50); |
|
75 $part["str"] = substr($part["str"],0,50); |
|
76 $part["plz"] = substr($part["plz"],0,10); |
|
77 $part["bem"] = substr($part["bem"],0,500); |
|
78 foreach ($part as $key=>$value) |
|
79 { |
|
80 // NULL - Eintrag in Tabelle |
|
81 if (is_null($value) || $value < "!") $part["$key"] = null; |
|
82 } |
|
83 |
|
84 // vermeiden von SQL-Injection |
|
85 $stmt = $dbc -> stmtinit(); |
|
86 if (is_object($stmt)) |
|
87 { |
|
88 $stmt -> prepare("INSERT INTO fhiiqm.Partner (part_firma,part_nachname,part_vorname,part_titel,part_anrede, |
|
89 part_strasse,part_ort,part_plz,part_tel,part_fax,part_mobil,part_email,part_bemerkung) |
|
90 VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?)"); |
|
91 $stmt -> bind_param('sssssssssssss',$part["firma"],$part["nname"],$part["vname"],$part["titel"],$part['anr'], |
|
92 $part["str"],$part["ort"],$part["plz"],$part["tel"],$part["fax"],$part["motel"],$part["email"],$part["bem"]); |
|
93 $result = $stmt -> execute(); |
|
94 } |
|
95 if ($dbc->error) echo "error: " . $dbc->error . "<br><br>\n"; |
|
96 // $result=1; |
|
97 if ($result) |
|
98 { |
|
99 // INSERT o.k. |
|
100 // part_ID ermitteln |
|
101 $pid = $dbc -> insertId(); |
|
102 echo "<p class='green'><b>Partnerdaten zu ID '$pid' wurden erfolgreich gespeichert.</b></p>\n"; |
|
103 echo "<br /><br />\n"; |
|
104 |
|
105 // Anzeigen gespeicherte Partnerdaten |
|
106 include ("inc/partner_dat_show.inc.php"); |
|
107 } |
|
108 else |
|
109 echo "<p class='red'>Eingabe der Partnerdaten ist fehlgeschlagen!</p>\n"; |
|
110 $dbc -> close(); |
|
111 echo "</div>\n"; |
|
112 echo "<p> <a href=\"partner_ins.php\" target=\"_self\" title=\"Partner erfassen\">Weiteren Partner erfassen</a></p>\n"; |
|
113 } |
|
114 |
|
115 ?> |
|
116 </body> |
|
117 </html> |