/
project_process_set.php
109 lines (75 loc) · 2.5 KB
/
project_process_set.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
101
102
103
104
105
106
107
108
109
<?php
include_once("dbconfig.php");
if($_POST['o'])
{
$data=json_decode ($_POST['o']);
foreach($data as $d)
{
$local_id=$d->id; $local_id=explode("_", $local_id);
if($local_id[0]=="newrow")
{
SaveRecord($d);
}//end if $d->id
else
{
UpdateRecord($d);
}
}///endforeach
}//end $_POST[o]
function UpdateRecord($d)
{
$query=" update `projects` set ";
$colname="`highlevelideano`='".$d->highlevelideano."'";
$colname.=",`name`='".$d->name."'";
$colname.=",`projectno`='".$d->projectno."'";
if($colname!='')
{
$query=$query.$colname." where `id`=".$d->id;
$db = mysql_connect("localhost", "root", "") or die("Connection Error: " . mysql_error());
mysql_select_db("samproject") or die("Error conecting to db.");
if(mysql_query($query))
{
echo $query;
//header("location:index.html");
}
else
{
echo "else of update:".$query;
}
}//colname endif
}//end update function
if($_GET['q']==1)
{
if($_POST['oper']=="del")
{
if($_POST["id"]>0)
$id=$_POST['id'];
$db = mysql_connect($dbhost, $dbuser, $dbpassword) or die("Connection Error: " . mysql_error());
mysql_select_db($database) or die("Error conecting to db.");
$sql="delete from projects where id=".$id;
if(mysql_query($sql))
{
echo "true:deleted successfully";
}
else
{
echo "false:error deleting data - ".mysql_error();
}
}//end del
}//end get q
function SaveRecord($d)
{
$query="INSERT INTO `projects` (`highlevelideano`, `name`, `projectno`) VALUES('".$d->highlevelideano."','".$d->name."','".$d->projectno."','".$aprov."','".$d->subprojectno."','".$d->ba."',')";
$db = mysql_connect("localhost", "root", "") or die("Connection Error: " . mysql_error());
mysql_select_db("samproject") or die("Error conecting to db.");
if(mysql_query($query))
{
echo $query;
//header("location:index.html");
}
else
{
echo 'else of insertion'.$query;
}
}//end function saverecord
?>