]>
Commit | Line | Data |
---|---|---|
c47f0dc2 JP |
1 | <?php |
2 | /* | |
3 | (c) 2005 Joe Presbrey | |
4 | joepresbrey@gmail.com | |
c47f0dc2 JP |
5 | */ |
6 | ||
9835a21d | 7 | function isPost() { |
c47f0dc2 JP |
8 | if($_SERVER['REQUEST_METHOD'] == 'POST') { |
9 | return true; | |
10 | } else { | |
11 | return false; | |
12 | } | |
13 | } | |
9835a21d | 14 | function isFormPost() { return isPost(); } |
c47f0dc2 JP |
15 | |
16 | function isSess($id) { | |
17 | return isset($_SESSION[$id]); | |
18 | } | |
19 | ||
9835a21d | 20 | function sess($id,$val=null) { |
c47f0dc2 | 21 | if (is_null($val)) { |
9835a21d | 22 | return (isSess($id)?$_SESSION[$id]:null); |
c47f0dc2 JP |
23 | } elseif (empty($val)) { |
24 | unset($_SESSION[$id]); | |
25 | } else { | |
26 | $prev = sess($id); | |
27 | $_SESSION[$id] = $val; | |
28 | return $prev; | |
29 | } | |
30 | } | |
31 | ||
32 | function stopSess() { | |
33 | $sid[] = session_id(); | |
34 | @session_destroy(); | |
35 | session_start(); | |
36 | $sid[] = session_id(); | |
37 | session_regenerate_id(); | |
38 | $sid[] = session_id(); | |
39 | session_write_close(); | |
40 | @session_destroy(); | |
41 | ||
42 | foreach($sid as $id) { | |
9835a21d | 43 | @unlink(session_save_path().'/sess_'.$id); |
c47f0dc2 JP |
44 | } |
45 | } | |
46 | ||
47 | function sessTime($query=null) { | |
9835a21d | 48 | global $timingc; |
c47f0dc2 JP |
49 | global $timings; |
50 | ||
51 | if(!isset($timings)) { | |
52 | $timings = array(); | |
53 | } | |
54 | ||
9835a21d JP |
55 | if (!isset($timingc) || empty($timingc)) { |
56 | $timingc = 1; | |
c47f0dc2 | 57 | } elseif (!is_null($query)) { |
9835a21d JP |
58 | $current = $timingc; |
59 | $timingc = ++$current; | |
c47f0dc2 | 60 | } |
9835a21d | 61 | $key = $timingc; |
c47f0dc2 JP |
62 | |
63 | if (is_null($query)) { | |
64 | $timings[$key]['time'] = microtime(true)-$timings[$key]['time']; | |
9835a21d JP |
65 | if (mysql_error()) |
66 | $timings[$key]['error'] = mysql_error(); | |
c47f0dc2 JP |
67 | return true; |
68 | } else { | |
69 | $timings[$key] = array(); | |
70 | $timings[$key]['time'] = microtime(true); | |
71 | $timings[$key]['query'] = $query; | |
72 | return false; | |
73 | } | |
74 | } | |
75 | ||
76 | function fetchRows($rs, $key = null) { | |
c47f0dc2 JP |
77 | if (!$rs) return array(); |
78 | $kn = is_null($key); | |
79 | $n = mysql_num_rows($rs); | |
80 | if ($n > 0) { | |
81 | $arr = array(); | |
82 | if (is_null($key)) { | |
83 | while ($r = mysql_fetch_assoc($rs)) { | |
84 | $arr[] = $r; | |
85 | } | |
86 | } elseif (is_numeric($key)) { | |
87 | while ($r = mysql_fetch_row($rs)) { | |
88 | $arr[$r[$key]] = $r; | |
89 | } | |
90 | } else { | |
91 | while ($r = mysql_fetch_assoc($rs)) { | |
92 | $arr[$r[$key]] = $r; | |
93 | } | |
94 | } | |
95 | mysql_free_result($rs); | |
96 | return $arr; | |
97 | } else { | |
98 | mysql_free_result($rs); | |
99 | return array(); | |
100 | } | |
101 | } | |
102 | ||
9835a21d JP |
103 | function printErrors($err) { printList('err', $err); } |
104 | function printMsgs($err) { printList('msg', $err); } | |
105 | ||
106 | function printList($class,$err) { | |
107 | if (is_array($err) && count($err)) { | |
108 | echo '<div class="',$class,'">',(count($err)>1?'<ul>':''); | |
109 | foreach($err as $e) { | |
110 | if (count($err)>1) { | |
111 | echo '<li><p>',$e,'</p></li>'; | |
112 | } else { | |
113 | echo '<p>',$e,'</p>'; | |
114 | } | |
c47f0dc2 | 115 | } |
9835a21d | 116 | echo (count($err)>1?'</ul>':''),'</div>'; |
c47f0dc2 JP |
117 | } |
118 | } | |
119 | ||
9835a21d | 120 | function buildSQLSet($fields, $values=null) { |
c47f0dc2 JP |
121 | $ex = array('NOW()','NULL'); |
122 | $sql = 'SET'; | |
123 | $c = 0; | |
124 | if (!is_null($values)) { | |
125 | foreach($fields as $field) { | |
126 | if ($c++) $sql .= ','; | |
3fd9e3cb | 127 | $sql .= " `$field`='".mysql_real_escape_string(array_shift($values))."'"; |
c47f0dc2 JP |
128 | } |
129 | } else { | |
130 | foreach($fields as $field=>$value) { | |
131 | if ($c++) $sql .= ','; | |
132 | if (in_array($value,$ex)) { | |
133 | $sql .= " `$field`= $value"; | |
134 | } else { | |
3fd9e3cb | 135 | $sql .= " `$field`='".mysql_real_escape_string($value)."'"; |
c47f0dc2 JP |
136 | } |
137 | } | |
138 | } | |
139 | return $sql; | |
140 | } | |
141 | ||
9835a21d | 142 | function buildSQLInsert($array, $table=null) { |
c47f0dc2 JP |
143 | $ex = array('NOW()','NULL'); |
144 | $sql = '('; | |
145 | $c = 0; | |
146 | foreach($array as $field=>$value) { | |
147 | if ($c++) $sql .= ','; | |
148 | $sql .= " `$field` "; | |
149 | } | |
150 | $sql .= ') VALUES ('; | |
151 | $c = 0; | |
152 | foreach($array as $field=>$value) { | |
3fd9e3cb | 153 | $v = mysql_real_escape_string($value); |
c47f0dc2 JP |
154 | if ($c++) $sql .= ','; |
155 | if (in_array($v, $ex)) | |
156 | $sql .= " $v "; | |
157 | else | |
158 | $sql .= " '$v' "; | |
159 | } | |
160 | $sql .= ')'; | |
3fd9e3cb | 161 | return (is_null($table)?$sql:('INSERT INTO `'.$table.'` '.$sql)); |
c47f0dc2 JP |
162 | } |
163 | ||
164 | function build_str($query_array) { | |
165 | $query_string = array(); | |
166 | foreach ($query_array as $k => $v) { | |
167 | $new = $k; | |
168 | if (strlen($v)) | |
169 | $new .= '='.$v; | |
170 | $query_string[] = $new; | |
171 | } | |
172 | return join('&', $query_string); | |
173 | } | |
174 | ||
9835a21d | 175 | function newQS($key, $val=null) { |
9835a21d | 176 | return newQSA(array($key=>$val)); |
c47f0dc2 JP |
177 | } |
178 | ||
179 | function newQSA($array=array()) { | |
180 | parse_str($_SERVER['QUERY_STRING'], $arr); | |
181 | $s = count($arr); | |
182 | foreach($array as $key=>$val) { | |
183 | $arr[$key] = $val; | |
184 | if (is_null($val)) | |
185 | unset($arr[$key]); | |
186 | } | |
187 | return (count($arr)||$s)?'?'.build_str($arr):''; | |
188 | } | |
189 | ||
190 | function formQSA($array=array()) { | |
191 | if (!count($array)) $array = $_SERVER['QUERY_STRING']; | |
192 | parse_str($array, $arr); | |
193 | $text = ''; | |
194 | foreach($arr as $key=>$val) { | |
195 | $text .= sprintf('<input type="hidden" name="%s" value="%s">', $key, $val); | |
196 | } | |
197 | return $text; | |
198 | } | |
199 | ||
200 | ?> |