store.php
2.38 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
111
112
113
114
115
116
117
118
<?php
//var_dump($_POST);
$aKeys = array_keys($_POST);
for ($i = 0; $i < count($aKeys); $i++) {
$sRowStart = $aKeys[$i];
$pos = strncasecmp("unique_start", $sRowStart, 12);
if ($pos == 0) {
$aColumns;
$aValues;
$aTypes;
settype($aColumns, "array");
settype($aValues, "array");
settype($aTypes, "array");
$i++;
$iPrimaryKey = $_POST[$aKeys[$i]];
$i++;
$sTableName = $_POST[$aKeys[$i]];
$i++;
$iColumnCount = 0;
//get all the values for the table
while (strncasecmp("unique_end", $sRowStart, 10) != 0) {
$aColumns[$iColumnCount] = $_POST[$aKeys[$i]];
$i++;
$aTypes[$iColumnCount]= $_POST[$aKeys[$i]];
$i++;
//uncheck checkboxes don't generate any name/value pairs
//so if the next key doesn't contain the word "value" and it's type
//is checkbox, then we have an unchecked check box
/*echo "Type: " . $aTypes[$iColumnCount] . "<br>";
if ($aTypes[$iColumnCount] == 2) {
if (strpos("value", $aKeys[$i]) == 0) {
//uncheck check box
$aValues[$iColumnCount] = 0;
} else {
$aValues[$iColumnCount] = 1;
$i++;
}
} else {
$aValues[$iColumnCount] = $_POST[$aKeys[$i]];
$i++;
}*/
$aValues[$iColumnCount] = $_POST[$aKeys[$i]];
$i++;
$sRowStart = $aKeys[$i];
$iColumnCount++;
}
if ($iPrimaryKey < 0) {
//perform an insert
$sQuery = "INSERT INTO $sTableName (";
for ($j = 0; $j < count($aColumns) - 1; $j++) {
$sQuery .= $aColumns[$j] . ", ";
}
$sQuery .= $aColumns[count($aColumns) -1] . ") VALUES (";
for ($j = 0; $j < count($aColumns) - 1; $j++) {
switch ($aTypes[$j]) {
case 0 :
$sQuery .= $aValues[$j] . ", ";
break;
case 1:
//text
$sQuery .= "'" . addslashes($aValues[$j]) . "', ";
break;
case 2:
//boolean
break;
case 3:
//drop down list
break;
default:
break;
}
}
switch ($aTypes[count($aColumns) - 1]) {
case 0:
//text
$sQuery .= $aValues[count($aColumns) - 1] . ") ";
break;
case 1:
//text
$sQuery .= "'" . addslashes($aValues[count($aColumns) - 1]) . "') ";
break;
case 2:
//boolean
break;
case 3:
//drop down list
break;
default:
break;
}
echo $sQuery. "<br>";
} else {
//perform an update
//$sQuery
}
}
}
?>