summaryrefslogtreecommitdiffstats
path: root/Under-Testing/Website/insertData.php
diff options
context:
space:
mode:
Diffstat (limited to 'Under-Testing/Website/insertData.php')
-rw-r--r--Under-Testing/Website/insertData.php69
1 files changed, 0 insertions, 69 deletions
diff --git a/Under-Testing/Website/insertData.php b/Under-Testing/Website/insertData.php
deleted file mode 100644
index 2facf1c..0000000
--- a/Under-Testing/Website/insertData.php
+++ /dev/null
@@ -1,69 +0,0 @@
-<?
-
-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
- }
-}
-
-?>