-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathinsert.php
More file actions
executable file
·110 lines (85 loc) · 2.65 KB
/
Copy pathinsert.php
File metadata and controls
executable file
·110 lines (85 loc) · 2.65 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
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
101
102
103
104
105
106
107
108
109
110
<?php
require_once('check_session.php');
check_session_with_target('saliva.php');
include_once('connect_db.php');
$conn = connect_to_db();
$ID_all = $_POST["Id"];
$ID_initial = $_POST["Id_initial"];
$ID_final = $_POST["Id_final"];
$today = date("Y-m-d");
//echo $ID_all;
if($ID_all!=""){
$ID_array=explode(",",$ID_all);
$NumofID=count($ID_array);
$success_time=0;
for($i=0;$i<$NumofID;$i++){
if((int)$ID_array[$i]<10){
$ID_t="CT_0000";
}elseif((int)$ID_array[$i]<100){
$ID_t="CT_000";
}elseif((int)$ID_array[$i]<1000){
$ID_t="CT_00";
}elseif((int)$ID_array[$i]<10000){
$ID_t="CT_0";
}else{
$ID_t="CT_";
}
$ID =$ID_t.(int)$ID_array[$i];
//echo $ID;
$query_check= "SELECT CassetteId FROM Saliva WHERE CassetteId ='$ID'";
//echo $query_check;
$chk_success = mysql_query($query_check);
//echo $chk_success;
if(mysql_num_rows($chk_success)!=0){
echo $ID;
echo " Exists ";
}else{
$query ="INSERT INTO Saliva (CreateDate, CassetteId, IsUsed,Week) VALUES('$today','$ID',0,-1)";
$success = mysql_query($query);
// echo $query;
if($success){
$success_time++;
}
//echo $success_time;
}
}
mysql_close($conn);
if($success_time==$NumofID)
header('Location:saliva.php');
} else{
$ID_ini_int=(int)$ID_initial;
$ID_fin_int=(int)$ID_final;
$query_t ="INSERT INTO Saliva (CreateDate, CassetteId, IsUsed,Week) VALUES";
//echo $query_t;
for( $j=$ID_ini_int;$j<=$ID_fin_int;$j++){
if($j<10){
$ID_t="CT_0000";
}elseif($j<100){
$ID_t="CT_000";
}elseif($j<1000){
$ID_t="CT_00";
}elseif($j<10000){
$ID_t="CT_0";
}else{
$ID_t="CT_";
}
$ID_str=strval($j);
// echo $ID_str;
$ID=$ID_t.$ID_str;
// echo $ID;
if($j!=$ID_fin_int){
$query_t=$query_t."('$today','$ID',0,-1),";
}else{
$query=$query_t."('$today','$ID',0,-1)";
}
}
$success = mysql_query($query);
mysql_close($conn);
if($success)
header('Location:saliva.php');
}
/*
// $sql = "INSERT INTO CopingSkill (UserId,Date,Time,Timestamp,Timeslot,SkillType,
// SkillSelect,Recreation,Score,Week) VALUES ('$uid','$date','$time',$timestamp,$time_slot,$skill_type,$skill_select,'$recreation',$score, $week)";
*/
?>