summaryrefslogtreecommitdiffstats
path: root/notFinishedCode/web/insertData.php
diff options
context:
space:
mode:
Diffstat (limited to 'notFinishedCode/web/insertData.php')
-rw-r--r--notFinishedCode/web/insertData.php81
1 files changed, 0 insertions, 81 deletions
diff --git a/notFinishedCode/web/insertData.php b/notFinishedCode/web/insertData.php
deleted file mode 100644
index fe77587..0000000
--- a/notFinishedCode/web/insertData.php
+++ /dev/null
@@ -1,81 +0,0 @@
-<?
-/*
-//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';
-?>