@@ -35,8 +35,7 @@ discard block |
||
35 | 35 | if($config->getDsn()){ |
36 | 36 | try{ |
37 | 37 | return new PDO($config->getDsn(),$config->getUser(),$config->getPassword(),$options); |
38 | - } |
|
39 | - catch(Exception $e){ |
|
38 | + } catch(Exception $e){ |
|
40 | 39 | if(!$config->getUseOnMemoryDB()){ |
41 | 40 | throw new Exception("Could not create a db connection. Check permissions, configuration, and documentation. ".$e->getMessage()); |
42 | 41 | } |
@@ -46,8 +45,7 @@ discard block |
||
46 | 45 | if($config->getUseOnMemoryDB()){ |
47 | 46 | try{ |
48 | 47 | return new PDO("sqlite::memory:",$options); |
49 | - } |
|
50 | - catch(Exception $e){ |
|
48 | + } catch(Exception $e){ |
|
51 | 49 | throw new Exception("Could not create a db connection. Check permissions, configuration, and documentation. ".$e->getMessage()); |
52 | 50 | } |
53 | 51 | } |
@@ -77,8 +75,7 @@ discard block |
||
77 | 75 | $stmt->execute(); |
78 | 76 | $stmt = $pdo->prepare("CREATE TABLE $db_url_table (id VARCHAR(255), url VARCHAR(255), count INT)"); |
79 | 77 | $stmt->execute(); |
80 | - } |
|
81 | - catch(Exception $e){ |
|
78 | + } catch(Exception $e){ |
|
82 | 79 | throw new Exception("Could not create the database. ".$e->getMessage()); |
83 | 80 | } |
84 | 81 | return true; |
@@ -119,8 +116,7 @@ discard block |
||
119 | 116 | $stmt = $pdo->prepare("DROP TABLE $tableName"); |
120 | 117 | $stmt->execute(); |
121 | 118 | |
122 | - } |
|
123 | - catch(Exception $e){ |
|
119 | + } catch(Exception $e){ |
|
124 | 120 | throw new Exception("Problem deleting the table $tableName. ".$e->getMessage()); |
125 | 121 | } |
126 | 122 | return true; |
@@ -140,8 +136,7 @@ discard block |
||
140 | 136 | $resp = $resp && Persistence::checkOptionsTable($pdo, $config); |
141 | 137 | $resp = $resp && Persistence::checkFromTable($pdo, $config); |
142 | 138 | $resp = $resp && Persistence::checkUrlTable($pdo, $config); |
143 | - } |
|
144 | - catch(Exception $e){ |
|
139 | + } catch(Exception $e){ |
|
145 | 140 | return false; |
146 | 141 | } |
147 | 142 | return $resp; |
@@ -158,8 +153,7 @@ discard block |
||
158 | 153 | $stmt = $pdo->prepare("SELECT * FROM $db_from_table WHERE 1==0"); |
159 | 154 | $stmt->execute(); |
160 | 155 | |
161 | - } |
|
162 | - catch(Exception $e){ |
|
156 | + } catch(Exception $e){ |
|
163 | 157 | return false; |
164 | 158 | } |
165 | 159 | return true; |
@@ -174,8 +168,7 @@ discard block |
||
174 | 168 | $db_url_table = $config->getUrlTableName(); |
175 | 169 | $stmt = $pdo->prepare("SELECT * FROM $db_url_table WHERE 1==0"); |
176 | 170 | $stmt->execute(); |
177 | - } |
|
178 | - catch(Exception $e){ |
|
171 | + } catch(Exception $e){ |
|
179 | 172 | return false; |
180 | 173 | } |
181 | 174 | return true; |
@@ -192,8 +185,7 @@ discard block |
||
192 | 185 | $db_options_table = $config->getOptionsTableName(); |
193 | 186 | $stmt = $pdo->prepare("SELECT * FROM $db_options_table WHERE 1==0"); |
194 | 187 | $stmt->execute(); |
195 | - } |
|
196 | - catch(Exception $e){ |
|
188 | + } catch(Exception $e){ |
|
197 | 189 | return false; |
198 | 190 | } |
199 | 191 | return true; |
@@ -208,8 +200,7 @@ discard block |
||
208 | 200 | $db_hit_table = $config->getHitTableName(); |
209 | 201 | $stmt = $pdo->prepare("SELECT * FROM $db_hit_table WHERE 1==0"); |
210 | 202 | $stmt->execute(); |
211 | - } |
|
212 | - catch(Exception $e){ |
|
203 | + } catch(Exception $e){ |
|
213 | 204 | return false; |
214 | 205 | } |
215 | 206 | return true; |
@@ -234,14 +225,12 @@ discard block |
||
234 | 225 | |
235 | 226 | if(array_key_exists('url', $options)){ |
236 | 227 | $url = $options['url']; |
237 | - } |
|
238 | - else if(array_key_exists('HTTP_HOST',$_SERVER)){ |
|
228 | + } else if(array_key_exists('HTTP_HOST',$_SERVER)){ |
|
239 | 229 | $url = "http://".$_SERVER['HTTP_HOST']; |
240 | 230 | if(array_key_exists('REQUEST_URI',$_SERVER)){ |
241 | 231 | $url=$url.$_SERVER['REQUEST_URI']; |
242 | 232 | } |
243 | - } |
|
244 | - else{ |
|
233 | + } else{ |
|
245 | 234 | $url = "No Info"; |
246 | 235 | } |
247 | 236 | |
@@ -251,8 +240,7 @@ discard block |
||
251 | 240 | |
252 | 241 | if(array_key_exists('id', $options)){ |
253 | 242 | $id = $options['id']; |
254 | - } |
|
255 | - else{ |
|
243 | + } else{ |
|
256 | 244 | $id = $url; |
257 | 245 | } |
258 | 246 | |
@@ -275,8 +263,7 @@ discard block |
||
275 | 263 | |
276 | 264 | if(array_key_exists('from_id', $options)){ |
277 | 265 | $ids = [$options['from_id']]; |
278 | - } |
|
279 | - else{ |
|
266 | + } else{ |
|
280 | 267 | $from_url = isset($_SERVER['HTTP_REFERER']) ? $_SERVER['HTTP_REFERER'] : 'No referer info'; |
281 | 268 | $ids = Persistence::findHitIdsByUrl($pdo,$config,$from_url); |
282 | 269 | if(count($ids)==0){ |
@@ -328,8 +315,7 @@ discard block |
||
328 | 315 | $resp[] = $row['id']; |
329 | 316 | } |
330 | 317 | } |
331 | - } |
|
332 | - catch(Exception $e){ |
|
318 | + } catch(Exception $e){ |
|
333 | 319 | throw new Exception("Error executing function 'findHitsByUrl'. ".$e->getMessage()); |
334 | 320 | } |
335 | 321 | return $resp; |
@@ -354,8 +340,7 @@ discard block |
||
354 | 340 | } |
355 | 341 | } |
356 | 342 | |
357 | - } |
|
358 | - catch(Exception $e){ |
|
343 | + } catch(Exception $e){ |
|
359 | 344 | throw new Exception("Error executing function 'getAllHits'. ".$e->getMessage()); |
360 | 345 | } |
361 | 346 | return $resp; |
@@ -395,8 +380,7 @@ discard block |
||
395 | 380 | } |
396 | 381 | } |
397 | 382 | |
398 | - } |
|
399 | - catch(Exception $e){ |
|
383 | + } catch(Exception $e){ |
|
400 | 384 | throw new Exception("Error executing function 'getAllUrls'. ".$e->getMessage()); |
401 | 385 | } |
402 | 386 | return $resp; |
@@ -440,8 +424,7 @@ discard block |
||
440 | 424 | } |
441 | 425 | } |
442 | 426 | |
443 | - } |
|
444 | - catch(Exception $e){ |
|
427 | + } catch(Exception $e){ |
|
445 | 428 | throw new Exception("Error executing function 'getAllUrls'. ".$e->getMessage()); |
446 | 429 | } |
447 | 430 | return $resp; |
@@ -464,16 +447,13 @@ discard block |
||
464 | 447 | if(array_key_exists('url',$by) && array_key_exists('id',$by)){ |
465 | 448 | $qdata = [$by['url'], $by['id']]; |
466 | 449 | $tquery = "SELECT f.* FROM $dbFromtable f,$dbUrltable u WHERE (f.from_id = u.id and f.url = ?) or f.from_id = ?"; |
467 | - } |
|
468 | - else if(array_key_exists('url',$by)){ |
|
450 | + } else if(array_key_exists('url',$by)){ |
|
469 | 451 | $qdata = [$by['url']]; |
470 | 452 | $tquery = "SELECT f.* FROM $dbFromtable f,$dbUrltable u where f.from_id = u.id and u.url = ?"; |
471 | - } |
|
472 | - else if(array_key_exists('id',$by)){ |
|
453 | + } else if(array_key_exists('id',$by)){ |
|
473 | 454 | $qdata = [$by['id']]; |
474 | 455 | $tquery = "SELECT f.* FROM $dbFromtable f where f.from_id = ?"; |
475 | - } |
|
476 | - else{ |
|
456 | + } else{ |
|
477 | 457 | $qdata = []; |
478 | 458 | $tquery = "SELECT f.* FROM $dbFromtable f"; |
479 | 459 | } |
@@ -485,8 +465,7 @@ discard block |
||
485 | 465 | } |
486 | 466 | } |
487 | 467 | |
488 | - } |
|
489 | - catch(Exception $e){ |
|
468 | + } catch(Exception $e){ |
|
490 | 469 | throw new Exception("Error executing function 'findByFrom'. ".$e->getMessage()); |
491 | 470 | } |
492 | 471 | return $resp; |
@@ -514,8 +493,7 @@ discard block |
||
514 | 493 | } |
515 | 494 | |
516 | 495 | $stmt = null; |
517 | - } |
|
518 | - catch(Exception $e){ |
|
496 | + } catch(Exception $e){ |
|
519 | 497 | throw new Exception("Error reading the database. Method getCounts().".$e->getMessage()); |
520 | 498 | } |
521 | 499 | return $resp; |
@@ -540,8 +518,7 @@ discard block |
||
540 | 518 | } |
541 | 519 | |
542 | 520 | $stmt = null; |
543 | - } |
|
544 | - catch(Exception $e){ |
|
521 | + } catch(Exception $e){ |
|
545 | 522 | throw new Exception("Error reading the database. Method getCounts().".$e->getMessage()); |
546 | 523 | } |
547 | 524 | return $resp; |
@@ -198,8 +198,7 @@ |
||
198 | 198 | { |
199 | 199 | try{ |
200 | 200 | return $configFile[$section][$varname]; |
201 | - } |
|
202 | - catch(Exception $e){ |
|
201 | + } catch(Exception $e){ |
|
203 | 202 | throw new Exception( "Error loading config file. Variable $varname in section [$section] not found. Check the configuration file."); |
204 | 203 | } |
205 | 204 | } |
@@ -30,20 +30,17 @@ discard block |
||
30 | 30 | |
31 | 31 | if(array_key_exists('pdo',$options)){ |
32 | 32 | $pdo = $options['pdo']; |
33 | - } |
|
34 | - else{ |
|
33 | + } else{ |
|
35 | 34 | $pdo = Persistence::getPDO($config); |
36 | 35 | } |
37 | 36 | |
38 | 37 | try{ |
39 | 38 | return Persistence::updateCount($pdo,$config,$options); |
40 | - } |
|
41 | - catch(Exception $e) { |
|
39 | + } catch(Exception $e) { |
|
42 | 40 | try{ |
43 | 41 | Persistence::crateDatabase($pdo, $config); |
44 | 42 | return Persistence::updateCount($pdo,$config,$options); |
45 | - } |
|
46 | - catch(Exception $e) { |
|
43 | + } catch(Exception $e) { |
|
47 | 44 | throw new Exception("Site Analyzer could connect to the database.".$e->getMessage()); |
48 | 45 | }; |
49 | 46 | |
@@ -60,12 +57,10 @@ discard block |
||
60 | 57 | $config = NULL; |
61 | 58 | try{ |
62 | 59 | $config = new Configuration("../../../../site-analyzer.ini",$pdoProvided); |
63 | - } |
|
64 | - catch(Exception $e){ |
|
60 | + } catch(Exception $e){ |
|
65 | 61 | try{ |
66 | 62 | $config = new Configuration("site-analyzer.ini",$pdoProvided); |
67 | - } |
|
68 | - catch(Exception $e){ |
|
63 | + } catch(Exception $e){ |
|
69 | 64 | throw Exception("Config file not found."); |
70 | 65 | } |
71 | 66 | } |
@@ -126,8 +121,7 @@ discard block |
||
126 | 121 | foreach ($data as $row){ |
127 | 122 | if(array_key_exists($row['user'],$count)){ |
128 | 123 | $count[$row['user']]++; |
129 | - } |
|
130 | - else{ |
|
124 | + } else{ |
|
131 | 125 | $count[$row['user']]=1; |
132 | 126 | } |
133 | 127 | } |