/
parent-time.php
100 lines (83 loc) · 3.72 KB
/
parent-time.php
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
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
<?php ob_start();
session_start();
if(!isset($_SESSION['user_session']))
{
header("Location: index.php");
}
$camper_id = $_POST['camper_id'];
$signin_time = $_POST['signin_time'];
$signout_time = $_POST['signout_time'];
$parent_signin_name = $_POST['parent_signin_name'];
$parent_signout_name = $_POST['parent_signout_name'];
$camper_first_name = $_POST['camper_first_name'];
$camper_last_name = $_POST['camper_last_name'];
$parent_signin_name2 = null;
$parent_signout_name2 = null;
$signin_status = null;
$signout_status = null;
try{
// connect to the db
require('db.php');
$sql = "SELECT * FROM tbl_parents WHERE parent_signin_time =:signin_time
AND camper_id =:camper_id ";
// create a command object
$cmd = $conn->prepare($sql);
// put each input value into the proper field
$cmd->bindParam(':camper_id', $camper_id, PDO::PARAM_INT);
$cmd->bindParam(':signin_time', $signin_time, PDO::PARAM_STR);
// execute the save
$cmd->execute();
$result= $cmd->fetchAll();
foreach($result as $row){
$parent_signin_time2 = $row['parent_signin_time'];
$parent_signout_time2 = $row['parent_signout_time'];
$parent_signin_name2 = $row['parent_signin_name'];
$parent_signout_name2 = $row['parent_signout_name'];
$camper_id2 = $row['camper_id'];
$signin_status = $row['signin_status'];
$signout_status = $row['signout_status'];
}
if ($signin_status == 0){
$sql_insert = "INSERT INTO tbl_parents (camper_first_name,camper_last_name,parent_signin_name,parent_signin_time,camper_id,signin_status)
VALUES (:camper_first_name,:camper_last_name,:parent_signin_name,now(),:camper_id,1)";
$cmd = $conn->prepare($sql_insert);
$cmd->bindParam(':camper_id', $camper_id, PDO::PARAM_INT);
$cmd->bindParam(':parent_signin_name', $parent_signin_name, PDO::PARAM_STR);
$cmd->bindParam(':camper_first_name', $camper_first_name, PDO::PARAM_STR);
$cmd->bindParam(':camper_last_name', $camper_last_name, PDO::PARAM_STR);
$cmd->execute();
}
else if($signout_status == 0){
if(empty($parent_signout_name)){
echo 'please enter the signout name';
} else {
$sql_update ="UPDATE tbl_parents SET parent_signout_name=:parent_signout_name, parent_signout_time =now() , signout_status =1
WHERE parent_signin_time =:parent_signin_time AND camper_id =:camper_id";
$cmd = $conn->prepare($sql_update);
$cmd->bindParam(':camper_id', $camper_id, PDO::PARAM_INT);
$cmd->bindParam(':parent_signin_time', $signin_time, PDO::PARAM_STR);
$cmd->bindParam(':parent_signout_name', $parent_signout_name, PDO::PARAM_STR);
$cmd->execute();
}
}
/* else {
if(($signin_status != 0) && !empty($parent_signin_time2) && $camper_id == $camper_id2){
echo 'already signed in';
}
else if(($signout_status != 0) && empty($parent_signout_time2) && $camper_id == $camper_id2){
echo 'already signed out';
}
}*/
/* else{
echo 'ok';
}*/
// disconnect
$conn = null;
header('location:registered-camper-list.php');
}// end of try
//catch exception
catch(Exception $e) {
echo 'Message: ' .$e->getMessage();
}
ob_flush();
?>