summaryrefslogtreecommitdiffstats
path: root/Website
diff options
context:
space:
mode:
authoraa1112011-07-21 20:32:20 +0200
committeraa1112011-07-21 20:32:20 +0200
commit934707705e36b8322a9f9fbe268b27bbc089167e (patch)
treec91b7f47b6f83881ba442d0704afd98282ff0644 /Website
parentMerge branch 'master' of lab.ks.uni-freiburg.de:lsfks/projekte/gsm-selftest (diff)
downloadgsm-selftest-934707705e36b8322a9f9fbe268b27bbc089167e.tar.gz
gsm-selftest-934707705e36b8322a9f9fbe268b27bbc089167e.tar.xz
gsm-selftest-934707705e36b8322a9f9fbe268b27bbc089167e.zip
working on website.
Diffstat (limited to 'Website')
-rw-r--r--Website/index.php35
-rw-r--r--Website/insert.php46
2 files changed, 29 insertions, 52 deletions
diff --git a/Website/index.php b/Website/index.php
index 71f05d2..b94872e 100644
--- a/Website/index.php
+++ b/Website/index.php
@@ -29,57 +29,26 @@
document.form1.sip_gsmrz3.checked = true
document.form1.sip_landln.checked = true
document.form1.sip_sipuniv.checked = true
- document.form1.gsmrz1_sip.checked = false
- document.form1.gsmrz2_sip.checked = false
- document.form1.gsmrz3_sip.checked = false
- document.form1.gsmrz1_gsmrz2.checked = false
- document.form1.gsmrz1_gsmrz3.checked = false
- document.form1.gsmrz2_gsmrz3.checked = false
- document.form1.landline_sip.checked = false
- document.form1.landline_gsmrz1.checked = false
- document.form1.landline_gsmrz2.checked = false
- document.form1.landline_gsmrz3.checked = false
}
function gsmClicked()
{
- document.form1.sip_gsmrz1.checked = false
- document.form1.sip_gsmrz2.checked = false
- document.form1.sip_gsmrz3.checked = false
- document.form1.sip_landln.checked = false
- document.form1.sip_sipuniv.checked = false
document.form1.gsmrz1_sip.checked = true
document.form1.gsmrz2_sip.checked = true
document.form1.gsmrz3_sip.checked = true
document.form1.gsmrz1_gsmrz2.checked = true
document.form1.gsmrz1_gsmrz3.checked = true
document.form1.gsmrz2_gsmrz3.checked = true
- document.form1.landline_sip.checked = false
- document.form1.landline_gsmrz1.checked = false
- document.form1.landline_gsmrz2.checked = false
- document.form1.landline_gsmrz3.checked = false
}
function landlineClicked()
{
- document.form1.sip_gsmrz1.checked = false
- document.form1.sip_gsmrz2.checked = false
- document.form1.sip_gsmrz3.checked = false
- document.form1.sip_landln.checked = false
- document.form1.sip_sipuniv.checked = false
- document.form1.gsmrz1_sip.checked = false
- document.form1.gsmrz2_sip.checked = false
- document.form1.gsmrz3_sip.checked = false
- document.form1.gsmrz1_gsmrz2.checked = false
- document.form1.gsmrz1_gsmrz3.checked = false
- document.form1.gsmrz2_gsmrz3.checked = false
document.form1.landline_sip.checked = true
document.form1.landline_gsmrz1.checked = true
document.form1.landline_gsmrz2.checked = true
document.form1.landline_gsmrz3.checked = true
}
-
function clearCheckboxes()
{
document.form1.sip_gsmrz1.checked = false
@@ -106,7 +75,7 @@
<BODY>
<H2>Dude!! Select Some Stuff!!</H2>
<BR>
- <FORM NAME="form1">
+ <FORM NAME="form1" form action="insert.php" method="POST">
<INPUT TYPE=CHECKBOX NAME="sip_gsmrz1"> SIP to RZ-GSM 1<BR>
<INPUT TYPE=CHECKBOX NAME="sip_gsmrz2"> SIP to RZ-GSM 2<BR>
<INPUT TYPE=CHECKBOX NAME="sip_gsmrz3"> SIP to RZ-GSM 3<BR>
@@ -123,7 +92,7 @@
<INPUT TYPE=CHECKBOX NAME="landline_gsmrz2"> Landline to RZ-GSM 2<BR>
<INPUT TYPE=CHECKBOX NAME="landline_gsmrz3"> Landline to RZ-GSM 3<BR>
<BR>
- <INPUT TYPE=button VALUE="All Test" ONCLICK="allClicked()" > <INPUT TYPE=button VALUE="SIP Test" ONCLICK="sipClicked()" > <INPUT TYPE=button VALUE="GSM Test" ONCLICK="gsmClicked()" > <INPUT TYPE=button VALUE="Landline Test" ONCLICK="landlineClicked()"> <INPUT TYPE=SUBMIT VALUE="Submit"> <INPUT TYPE=button VALUE="Unchecked All" onclick="clearCheckboxes()">
+ <INPUT TYPE=button VALUE="All Test" NAME="allTest" ONCLICK="allClicked()" > <INPUT TYPE=button VALUE="SIP Test" NAME="allSip" ONCLICK="sipClicked()" > <INPUT TYPE=button VALUE="GSM Test" NAME="allGSM" ONCLICK="gsmClicked()" > <INPUT TYPE=button VALUE="Landline Test" NAME="allLandline" ONCLICK="landlineClicked()"> <INPUT TYPE=SUBMIT VALUE="Submit"> <INPUT TYPE=button VALUE="Unchecked All" onclick="clearCheckboxes()">
</FORM>
</BODY>
diff --git a/Website/insert.php b/Website/insert.php
index 1d7ef8f..dbcec31 100644
--- a/Website/insert.php
+++ b/Website/insert.php
@@ -1,21 +1,29 @@
<?php
-$con = mysql_connect("localhost","peter","abc123");
-if (!$con)
- {
- die('Could not connect: ' . mysql_error());
- }
+ $con = mysql_connect("localhost","root","mysqlroot11");
+ if (!$con) {
+?> <p>There is something wrong about your connection to database!</p>
+<?php }
-mysql_select_db("my_db", $con);
-
-$sql="INSERT INTO temptasktable (FirstName, LastName, Age)
-VALUES
-('$_POST[from]','$_POST[destination]','$_POST[timestamp]')";
-
-if (!mysql_query($sql,$con))
- {
- die('Error: ' . mysql_error());
- }
-echo "1 record added";
-
-mysql_close($con)
-?> \ No newline at end of file
+ mysql_select_db("gsmselftesting", $con);
+
+ if(!empty($_POST)) {
+
+ if($_POST["sip_gsmrz1"]) {
+
+ $query1 = "INSERT INTO `TaskTable` (`taskNo`, `from`, `to`) VALUES(5, 'sip', 'gsmRZ1')";
+ $result1 = mysql_query($query1);
+ $query2 = "SELECT @taskID := LAST_INSERT_ID()";
+ $result2 = mysql_query($query2);
+ $query3 = "INSERT INTO `TempTaskTable` (`taskID`, `taskNo`, `from`, `to`) VALUES(@taskID, 5, 'sip', 'gsmRZ1')";
+ $result3 = mysql_query($query3);
+
+ if(!$result1 || !$result2 || !$result3){
+ die('Invalid query: ' . mysql_error());
+ }
+ else {
+?> <p> Relevant information was put in the database! </p>
+<?php }
+ }
+ }
+ mysql_close($con)
+?>