-
Notifications
You must be signed in to change notification settings - Fork 1
Expand file tree
/
Copy pathprocess.php
More file actions
78 lines (66 loc) · 2.22 KB
/
process.php
File metadata and controls
78 lines (66 loc) · 2.22 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
<?php
require('connection.php');
session_start();
if(isset($_POST['selects']))
{
greeting();
header('location:clock.php');
}
// $query = "SELECT * FROM users, clockins WHERE users.id ='{$_POST['select']}' and clockins.users_id = users.id ORDER BY clockins.id desc";
// var_dump($query);
// $query = fetch_record($query);
// var_dump($query);
// $_SESSION['clock_in'] = $query['clock_in'];
function greeting()
{
//WHERE id ='{$_POST['select']}'
// $_SESSION['name'] = $_POST['select'];
$greeting = "SELECT * FROM users where id='{$_POST['select']}'";
$greeting = fetch_record($greeting);
$query = "SELECT * FROM clockins, users WHERE users.id ='{$_POST['select']}' and clockins.users_id = users.id ORDER BY clockins.id desc";
// var_dump($query);
$query = fetch_record($query);
// var_dump($query);
$_SESSION['clock_in'] = $query['clock_in'];
$_SESSION['id'] = $greeting['id'];
$_SESSION['name'] = $greeting['first_name'];
// var_dump($_SESSION['name']);
if($query AND($query['clock_out'] == NULL))
{
echo "not clocked out yet";
$_SESSION['clocked_in'] = "<textarea name='message' rows=8 cols=50></textarea><input type='hidden' name='clock_out' value='nada'><input type='submit' value='clock out'>";
// $query = "UPDATE clockins set clock_out = NOW() where clock_in = '{$query['clock_in']}'";
// $query = mysql_query($query);
// echo $query;
}
else
{
$_SESSION['clocked_in'] = "<input type='hidden' name='clock_in'><input type='submit' value='clock in'>";
}
header('location:clock.php');
}
if(isset($_POST['clock_out']))
{
$query = "UPDATE clockins set clock_out = NOW(), note = '{$_POST['message']}' where clock_in = '{$_SESSION['clock_in']}'";
mysql_query($query);
// $query = mysql_query($query);
echo $query;
echo "hello";
//header('location:process.php');
}
if(isset($_POST['clock_in']))
{
$query = "INSERT INTO clockins (date, clock_in, users_id, updated_at, created_at) VALUES(NOW(), NOW(), '{$_SESSION['id']}', NOW(), NOW())";
var_dump($query);
mysql_query($query);
}
header('location:clock.php');
// else
// {
// if(isset($_POST['select'])){
// echo "why is this on?";
// }
// var_dump($_POST);
// echo "why is not set?";
// }
?>