From 65dc06eab2305800ad862b4621807fd7d4f7fe8d Mon Sep 17 00:00:00 2001
From: Horus3
Date: Sun, 9 Feb 2014 17:21:59 +0100
Subject: Init

---
 insert.php | 64 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 64 insertions(+)
 create mode 100644 insert.php

(limited to 'insert.php')

diff --git a/insert.php b/insert.php
new file mode 100644
index 0000000..cca6118
--- /dev/null
+++ b/insert.php
@@ -0,0 +1,64 @@
+<?php include('auth.php');
+include("header.php");
+
+if ($_SERVER['REQUEST_METHOD'] == 'POST') {
+	$db = new SQLite3('/var/www/jungegemeinde/database/jg.db');
+
+	$safe1 = SQLite3::escapeString("$_POST[name]");
+	$safe2 = SQLite3::escapeString("$_POST[adresse]");
+	$safe3 = SQLite3::escapeString("$_POST[telefonnummer]");
+	$safe4 = SQLite3::escapeString("$_POST[handynummer]");
+	$safe5 = SQLite3::escapeString("$_POST[email]");
+	$safe6 = SQLite3::escapeString("$_POST[geburtstag]");
+	$query = "INSERT INTO member(id, name, adresse, telefonnummer, handynummer, email, geburtstag) VALUES(NULL,'$safe1','$safe2','$safe3','$safe4','$safe5','$safe6');";
+	$result = $db->exec("$query");
+}
+
+echo "
+
+<div id='content_container' align='center'>
+        <br>
+        <div class='kleineschrift'>
+                <div class='ueberschrift'><p>JUNGE GEMEINDE ADLERSHOF</p>
+                </div>
+        </div>
+";
+     if ($_SERVER['REQUEST_METHOD'] == 'POST') {
+echo "
+<center>
+<br>
+Vielen Dank, der Eintrag zu $_POST[name] wurde erfolgreich hinzugefügt.<br>
+<br>
+
+<tr>
+      <td align='center'><img src='http://i.imgur.com/UQDEVQy.png' alt='Teh wizzard'></td>
+</tr>
+<br>
+<br>
+Einen Moment, sie werden gleich weitergeleitet.
+
+";
+header("Refresh: 4; /liste.php");
+
+	} else {
+	echo "
+        <br><a2>Trage einfach die Daten von unserem neuen Mitglied  ein: </a2><br>
+                <form method='post' action='insert.php' ><table><tr>
+                <td align='right'><a2>Name: <input type='text' name='name' ></a2> </td>
+                        <td align='right'><a2>Adresse: <input type='text' name='adresse' > </a2></td>
+                        <td align='right'><a2>Telefon: <input type='text' name='telefonnummer'></a2> </td></tr>
+                        <tr align='right'><td><a2>Handy: <input type='text' name='handynummer' ></a2> </td>
+                        <td align='right'><a2>E-Mail: <input type='text' name='email' ></a2> </td>
+                        <td align='right'><a2>Geburtstag: <input type='text' name='geburtstag' ></a2> </td></tr>
+                        <tr><td>&#160;</td><td align='center'><input type='submit' name='submit' value='Hinzufügen'/></td><td>&#160;</td></tr>
+                        </table></form>
+        ";
+
+}
+/*
+</body>";
+*/
+
+//echo '<br><a href="login.php?x=$cryptedip">Zur&uuml;ck</a></center>';
+
+?>
-- 
cgit v1.2.3