summaryrefslogtreecommitdiffstats
path: root/Under-Testing/Website/insertData.php
diff options
context:
space:
mode:
authorgsmselftest2011-11-16 18:06:02 +0100
committergsmselftest2011-11-16 18:06:02 +0100
commit8a7755d6f96e599fe75ac8e5e1c6994138f4b99e (patch)
tree9b320feb695cfbadd605808b2db5795e240e9399 /Under-Testing/Website/insertData.php
parent delete dummy comment (diff)
downloadgsm-selftest-8a7755d6f96e599fe75ac8e5e1c6994138f4b99e.tar.gz
gsm-selftest-8a7755d6f96e599fe75ac8e5e1c6994138f4b99e.tar.xz
gsm-selftest-8a7755d6f96e599fe75ac8e5e1c6994138f4b99e.zip
under Testing folder
Diffstat (limited to 'Under-Testing/Website/insertData.php')
-rw-r--r--Under-Testing/Website/insertData.php69
1 files changed, 69 insertions, 0 deletions
diff --git a/Under-Testing/Website/insertData.php b/Under-Testing/Website/insertData.php
new file mode 100644
index 0000000..2facf1c
--- /dev/null
+++ b/Under-Testing/Website/insertData.php
@@ -0,0 +1,69 @@
+<?
+
+function getNewTaskNo()
+{
+ $sql = "SELECT MAX(taskNo) FROM TaskTable"; //the SQL command to find the max value in taskNo
+ $execute = mysql_query($sql); //execute the command
+ $result = mysql_result($execute,0);
+
+ if ($result == NULL)
+ {
+ // there is no single job in the table
+ return 1;
+ }
+ else
+ {
+ //increment the new taskNo
+ return $result + 1;
+ }
+}
+
+
+function insertTask($taskNo, $from, $to)
+{
+ $trans = "START TRANSACTION;";
+ $execute = mysql_query($trans);
+
+ if ($execute!=1)
+ {
+ return 3; //could not start transaction
+ }
+
+ $sql = "INSERT INTO `TaskTable` (`taskNo`, `from`, `to`) VALUES($taskNo, '$from', '$to')";
+ $execute = mysql_query($sql); //insert new task into the TaskTable
+
+ if ($execute == 1) //I added to the DB the task!
+ {
+ $sql = "SELECT @taskID := LAST_INSERT_ID()"; //find the last taskId
+ $execute = mysql_query($sql);
+ $taskId = mysql_result($execute,0); //I have the last taskId which I will use to insert it into TempTaskTable
+
+ $sql = "INSERT INTO `TempTaskTable` (`taskID`, `taskNo`, `from`, `to`) VALUES($taskId, $taskNo, '$from', '$to')";
+ $execute = mysql_query($sql); //insert new task into the TempTaskTable
+
+ if ($execute == 1)
+ {
+ $trans = "COMMIT;"; //command to end the transaction
+ $execute = mysql_query($trans);//finish the transaction
+
+ if ($execute == 1)
+ {
+ return 1; //task was successfuly added to both tables, TaskTable and TempTaskTable
+ }
+ else
+ {
+ return 0; //nothing was added to the tables
+ }
+ }
+ else
+ {
+ return 2; //the task is in the TaskTable but not in TempTaskTable
+ }
+ }
+ else
+ {
+ return 0; //nothing was added to the table, some error occured
+ }
+}
+
+?>