@@ -175,6 +175,11 @@ discard block |
||
| 175 | 175 | } |
| 176 | 176 | |
| 177 | 177 | // After SELECT. |
| 178 | + |
|
| 179 | + /** |
|
| 180 | + * @param integer $row_index |
|
| 181 | + * @param string $column_name |
|
| 182 | + */ |
|
| 178 | 183 | public function field($row_index, $column_name) { |
| 179 | 184 | if ($this->rows > 0) |
| 180 | 185 | return $this->data[$row_index][$column_name]; |
@@ -187,6 +192,10 @@ discard block |
||
| 187 | 192 | } |
| 188 | 193 | |
| 189 | 194 | // After SELECT. |
| 195 | + |
|
| 196 | + /** |
|
| 197 | + * @param integer $row_index |
|
| 198 | + */ |
|
| 190 | 199 | public function row($row_index) { |
| 191 | 200 | if ($this->success && $this->rows > 0) |
| 192 | 201 | return $this->data[$row_index]; |
@@ -224,6 +233,9 @@ discard block |
||
| 224 | 233 | return $html; |
| 225 | 234 | } |
| 226 | 235 | |
| 236 | + /** |
|
| 237 | + * @param string $errormsg |
|
| 238 | + */ |
|
| 227 | 239 | public function error($errormsg) { |
| 228 | 240 | // When a query goes wrong... |
| 229 | 241 | $this->success = false; |
@@ -72,7 +72,6 @@ |
||
| 72 | 72 | * - `$this->field(n,col)` returns an empty string. |
| 73 | 73 | * - `$this->insert_id()` returns `null`. |
| 74 | 74 | * - `$this->affected_rows()` returns `null`. |
| 75 | - |
|
| 76 | 75 | */ |
| 77 | 76 | |
| 78 | 77 | class Query { |
@@ -78,16 +78,16 @@ discard block |
||
| 78 | 78 | class Query { |
| 79 | 79 | |
| 80 | 80 | public $success = true; |
| 81 | - public $rows = NULL; |
|
| 81 | + public $rows = null; |
|
| 82 | 82 | public $data = array(); |
| 83 | - public $insert_id = NULL; |
|
| 84 | - public $affected_rows = NULL; |
|
| 83 | + public $insert_id = null; |
|
| 84 | + public $affected_rows = null; |
|
| 85 | 85 | |
| 86 | 86 | public function __construct($conn) { |
| 87 | 87 | $this->conn = $conn; |
| 88 | 88 | } |
| 89 | 89 | |
| 90 | - public function query($sql="", $params = NULL) { |
|
| 90 | + public function query($sql="", $params = null) { |
|
| 91 | 91 | |
| 92 | 92 | if (empty($sql)) { |
| 93 | 93 | $this->success = false; |
@@ -104,7 +104,7 @@ discard block |
||
| 104 | 104 | twfy_debug ("SQL", $sql); |
| 105 | 105 | twfy_debug ("SQL", print_r($params, 1)); |
| 106 | 106 | |
| 107 | - if ($params !== NULL) { |
|
| 107 | + if ($params !== null) { |
|
| 108 | 108 | // Prepare and execute a statement |
| 109 | 109 | $pdoStatement = $this->conn->prepare($sql); |
| 110 | 110 | |
@@ -87,7 +87,7 @@ discard block |
||
| 87 | 87 | $this->conn = $conn; |
| 88 | 88 | } |
| 89 | 89 | |
| 90 | - public function query($sql="", $params = NULL) { |
|
| 90 | + public function query($sql = "", $params = NULL) { |
|
| 91 | 91 | |
| 92 | 92 | if (empty($sql)) { |
| 93 | 93 | $this->success = false; |
@@ -101,8 +101,8 @@ discard block |
||
| 101 | 101 | return; |
| 102 | 102 | } |
| 103 | 103 | |
| 104 | - twfy_debug ("SQL", $sql); |
|
| 105 | - twfy_debug ("SQL", print_r($params, 1)); |
|
| 104 | + twfy_debug("SQL", $sql); |
|
| 105 | + twfy_debug("SQL", print_r($params, 1)); |
|
| 106 | 106 | |
| 107 | 107 | if ($params !== NULL) { |
| 108 | 108 | // Prepare and execute a statement |
@@ -133,7 +133,7 @@ discard block |
||
| 133 | 133 | |
| 134 | 134 | if (!$this->success) return; |
| 135 | 135 | |
| 136 | - if ( (!$pdoStatement) or (empty($pdoStatement)) ) { |
|
| 136 | + if ((!$pdoStatement) or (empty($pdoStatement))) { |
|
| 137 | 137 | // A failed query. |
| 138 | 138 | $this->success = false; |
| 139 | 139 | |
@@ -155,7 +155,7 @@ discard block |
||
| 155 | 155 | } |
| 156 | 156 | $this->affected_rows = $pdoStatement->rowCount(); |
| 157 | 157 | |
| 158 | - twfy_debug ("SQLRESULT", array($this, 'displayResult')); |
|
| 158 | + twfy_debug("SQLRESULT", array($this, 'displayResult')); |
|
| 159 | 159 | // mysql_free_result($q); |
| 160 | 160 | } |
| 161 | 161 | } |
@@ -55,7 +55,7 @@ |
||
| 55 | 55 | * @param string $db_pass The password for the database user |
| 56 | 56 | * @param string $db_name The name of the database |
| 57 | 57 | * |
| 58 | - * @return true If the connection has been created successfully. |
|
| 58 | + * @return boolean If the connection has been created successfully. |
|
| 59 | 59 | */ |
| 60 | 60 | |
| 61 | 61 | public function init($db_host, $db_user, $db_pass, $db_name) { |
@@ -102,7 +102,7 @@ |
||
| 102 | 102 | * @return Query An object containing the results of the query. |
| 103 | 103 | */ |
| 104 | 104 | |
| 105 | - public function query($sql, $params = NULL) { |
|
| 105 | + public function query($sql, $params = null) { |
|
| 106 | 106 | |
| 107 | 107 | $start = getmicrotime(); |
| 108 | 108 | $q = new \MySociety\TheyWorkForYou\Db\Query($this->conn); |
@@ -111,7 +111,7 @@ discard block |
||
| 111 | 111 | $duration = getmicrotime() - $start; |
| 112 | 112 | global $mysqltotalduration; |
| 113 | 113 | $mysqltotalduration += $duration; |
| 114 | - twfy_debug ("SQL", "Complete after $duration seconds."); |
|
| 114 | + twfy_debug("SQL", "Complete after $duration seconds."); |
|
| 115 | 115 | // We could also output $q->mysql_info() here, but that's for |
| 116 | 116 | // PHP >= 4.3.0. |
| 117 | 117 | return $q; |
@@ -126,7 +126,7 @@ discard block |
||
| 126 | 126 | |
| 127 | 127 | public function display_total_duration() { |
| 128 | 128 | global $mysqltotalduration; |
| 129 | - twfy_debug ("TIME", "Total time for MySQL queries on this page: " . $mysqltotalduration . " seconds."); |
|
| 129 | + twfy_debug("TIME", "Total time for MySQL queries on this page: " . $mysqltotalduration . " seconds."); |
|
| 130 | 130 | } |
| 131 | 131 | |
| 132 | 132 | /** |
@@ -92,7 +92,7 @@ |
||
| 92 | 92 | include_once (INCLUDESPATH."easyparliament/user.php"); |
| 93 | 93 | |
| 94 | 94 | // Test to see if this is a new-style template using the renderer class. |
| 95 | -if (! isset($new_style_template) OR $new_style_template !== TRUE) { |
|
| 95 | +if (! isset($new_style_template) or $new_style_template !== true) { |
|
| 96 | 96 | |
| 97 | 97 | // This is an old-style page. Use the old page classes. |
| 98 | 98 | include_once (INCLUDESPATH."easyparliament/page.php"); |
@@ -4,7 +4,7 @@ discard block |
||
| 4 | 4 | First some things to help make our PHP nicer and betterer |
| 5 | 5 | ********************************************************************************/ |
| 6 | 6 | |
| 7 | -error_reporting (E_ALL); |
|
| 7 | +error_reporting(E_ALL); |
|
| 8 | 8 | |
| 9 | 9 | /******************************************************************************** |
| 10 | 10 | Now some constants that are the same for live and dev versions |
@@ -12,22 +12,22 @@ discard block |
||
| 12 | 12 | ********************************************************************************/ |
| 13 | 13 | |
| 14 | 14 | // In case we need to switch these off globally at some point... |
| 15 | -define ("ALLOWCOMMENTS", true); |
|
| 16 | -define ("ALLOWTRACKBACKS", true); |
|
| 15 | +define("ALLOWCOMMENTS", true); |
|
| 16 | +define("ALLOWTRACKBACKS", true); |
|
| 17 | 17 | |
| 18 | 18 | // These variables are so we can keep date/time formats consistent across the site |
| 19 | 19 | // and change them easily. |
| 20 | 20 | // Formats here: http://www.php.net/manual/en/function.date.php |
| 21 | -define ("LONGERDATEFORMAT", "l, j F Y");// Monday, 31 December 2003 |
|
| 22 | -define ("LONGDATEFORMAT", "j F Y"); // 31 December 2003 |
|
| 23 | -define ("SHORTDATEFORMAT", "j M Y"); // 31 Dec 2003 |
|
| 24 | -define ("TIMEFORMAT", "g:i a"); // 11:59 pm |
|
| 21 | +define("LONGERDATEFORMAT", "l, j F Y"); // Monday, 31 December 2003 |
|
| 22 | +define("LONGDATEFORMAT", "j F Y"); // 31 December 2003 |
|
| 23 | +define("SHORTDATEFORMAT", "j M Y"); // 31 Dec 2003 |
|
| 24 | +define("TIMEFORMAT", "g:i a"); // 11:59 pm |
|
| 25 | 25 | |
| 26 | -define ("SHORTDATEFORMAT_SQL", "%e %b %Y"); // 31 Dec 2003 |
|
| 27 | -define ("TIMEFORMAT_SQL", "%l:%i %p"); // 11:59 PM |
|
| 26 | +define("SHORTDATEFORMAT_SQL", "%e %b %Y"); // 31 Dec 2003 |
|
| 27 | +define("TIMEFORMAT_SQL", "%l:%i %p"); // 11:59 PM |
|
| 28 | 28 | |
| 29 | 29 | // Where we store the postcode of users if they search for an MP by postcode. |
| 30 | -define ('POSTCODE_COOKIE', 'eppc'); |
|
| 30 | +define('POSTCODE_COOKIE', 'eppc'); |
|
| 31 | 31 | |
| 32 | 32 | /******************************************************************************** |
| 33 | 33 | And now all the files we'll include on every page. |
@@ -41,7 +41,7 @@ discard block |
||
| 41 | 41 | twfy_debug_timestamp("after including utility.php"); |
| 42 | 42 | |
| 43 | 43 | // Set the default timezone |
| 44 | -if(function_exists('date_default_timezone_set')) date_default_timezone_set(TIMEZONE); |
|
| 44 | +if (function_exists('date_default_timezone_set')) date_default_timezone_set(TIMEZONE); |
|
| 45 | 45 | |
| 46 | 46 | // Only do clever things with errors if we're not testing, otherwise show as default |
| 47 | 47 | |
@@ -70,42 +70,42 @@ discard block |
||
| 70 | 70 | |
| 71 | 71 | // The time the page starts, so we can display the total at the end. |
| 72 | 72 | // getmicrotime() is in utiltity.php. |
| 73 | -define ("STARTTIME", getmicrotime()); |
|
| 73 | +define("STARTTIME", getmicrotime()); |
|
| 74 | 74 | if (!isset($_SERVER['WINDIR'])) { |
| 75 | 75 | $rusage = getrusage(); |
| 76 | - define ('STARTTIMES', $rusage['ru_stime.tv_sec']*1000000 + $rusage['ru_stime.tv_usec']); |
|
| 77 | - define ('STARTTIMEU', $rusage['ru_utime.tv_sec']*1000000 + $rusage['ru_utime.tv_usec']); |
|
| 76 | + define('STARTTIMES', $rusage['ru_stime.tv_sec'] * 1000000 + $rusage['ru_stime.tv_usec']); |
|
| 77 | + define('STARTTIMEU', $rusage['ru_utime.tv_sec'] * 1000000 + $rusage['ru_utime.tv_usec']); |
|
| 78 | 78 | } |
| 79 | 79 | |
| 80 | 80 | $DATA = new \MySociety\TheyWorkForYou\Data; |
| 81 | 81 | |
| 82 | 82 | class ParlDB extends \MySociety\TheyWorkForYou\Db\Connection { |
| 83 | 83 | public function __construct() { |
| 84 | - $this->init (OPTION_TWFY_DB_HOST, OPTION_TWFY_DB_USER, OPTION_TWFY_DB_PASS, OPTION_TWFY_DB_NAME); |
|
| 84 | + $this->init(OPTION_TWFY_DB_HOST, OPTION_TWFY_DB_USER, OPTION_TWFY_DB_PASS, OPTION_TWFY_DB_NAME); |
|
| 85 | 85 | } |
| 86 | 86 | } |
| 87 | 87 | |
| 88 | -include_once (INCLUDESPATH."url.php"); |
|
| 88 | +include_once (INCLUDESPATH . "url.php"); |
|
| 89 | 89 | |
| 90 | 90 | $filter = new \MySociety\TheyWorkForYou\Utility\LibFilter; |
| 91 | 91 | |
| 92 | -include_once (INCLUDESPATH."easyparliament/user.php"); |
|
| 92 | +include_once (INCLUDESPATH . "easyparliament/user.php"); |
|
| 93 | 93 | |
| 94 | 94 | // Test to see if this is a new-style template using the renderer class. |
| 95 | -if (! isset($new_style_template) OR $new_style_template !== TRUE) { |
|
| 95 | +if (!isset($new_style_template) OR $new_style_template !== TRUE) { |
|
| 96 | 96 | |
| 97 | 97 | // This is an old-style page. Use the old page classes. |
| 98 | - include_once (INCLUDESPATH."easyparliament/page.php"); |
|
| 98 | + include_once (INCLUDESPATH . "easyparliament/page.php"); |
|
| 99 | 99 | |
| 100 | 100 | } |
| 101 | 101 | |
| 102 | -include_once (INCLUDESPATH."easyparliament/hansardlist.php"); |
|
| 103 | -include_once (INCLUDESPATH."dbtypes.php"); |
|
| 104 | -include_once (INCLUDESPATH."easyparliament/commentlist.php"); |
|
| 105 | -include_once (INCLUDESPATH."easyparliament/comment.php"); |
|
| 106 | -include_once (INCLUDESPATH."easyparliament/trackback.php"); |
|
| 102 | +include_once (INCLUDESPATH . "easyparliament/hansardlist.php"); |
|
| 103 | +include_once (INCLUDESPATH . "dbtypes.php"); |
|
| 104 | +include_once (INCLUDESPATH . "easyparliament/commentlist.php"); |
|
| 105 | +include_once (INCLUDESPATH . "easyparliament/comment.php"); |
|
| 106 | +include_once (INCLUDESPATH . "easyparliament/trackback.php"); |
|
| 107 | 107 | |
| 108 | 108 | // Added in as new module by Richard Allan MP |
| 109 | -include_once (INCLUDESPATH."easyparliament/alert.php"); |
|
| 109 | +include_once (INCLUDESPATH . "easyparliament/alert.php"); |
|
| 110 | 110 | |
| 111 | 111 | twfy_debug_timestamp("at end of init.php"); |