summaryrefslogtreecommitdiffstats
path: root/Website/insertData.php
diff options
context:
space:
mode:
Diffstat (limited to 'Website/insertData.php')
-rw-r--r--Website/insertData.php82
1 files changed, 82 insertions, 0 deletions
diff --git a/Website/insertData.php b/Website/insertData.php
new file mode 100644
index 0000000..6a9bdb4
--- /dev/null
+++ b/Website/insertData.php
@@ -0,0 +1,82 @@
+<?
+/*
+//Connection stuff
+//DB
+$dbhost = 'localhost';
+$dbuser = 'root';
+$dbpass = 'randompasswordSQL';
+
+
+$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die('Error connecting to mysql');
+
+$dbname = 'gsmselftesting';
+mysql_select_db($dbname);
+//End of connection stuff
+*/
+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
+ }
+}
+ //include 'post.php';
+?>