Commit | Line | Data |
---|---|---|
6a488035 TO |
1 | <?php |
2 | // vim: set si ai expandtab tabstop=4 shiftwidth=4 softtabstop=4: | |
3 | ||
4 | /** | |
5 | * File for the Utils class | |
6 | * | |
7 | * (PHP 5) | |
8 | * | |
6c6e6187 TO |
9 | * @author Walt Haas <walt@dharmatech.org> (801) 534-1262 |
10 | * @copyright Copyright CiviCRM LLC (C) 2009 | |
11 | * @license http://www.fsf.org/licensing/licenses/agpl-3.0.html | |
6a488035 | 12 | * GNU Affero General Public License version 3 |
6c6e6187 TO |
13 | * @version $Id: Utils.php 40328 2012-05-11 23:06:13Z allen $ |
14 | * @package CiviCRM | |
6a488035 TO |
15 | * |
16 | * This file is part of CiviCRM | |
17 | * | |
18 | * CiviCRM is free software; you can redistribute it and/or | |
19 | * modify it under the terms of the GNU Affero General Public License | |
20 | * as published by the Free Software Foundation; either version 3 of | |
21 | * the License, or (at your option) any later version. | |
22 | * | |
23 | * CiviCRM is distributed in the hope that it will be useful, | |
24 | * but WITHOUT ANY WARRANTY; without even the implied warranty of | |
25 | * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the | |
26 | * GNU Affero General Public License for more details. | |
27 | * | |
28 | * You should have received a copy of the GNU Affero General Public | |
29 | * License along with this program. If not, see | |
30 | * <http://www.gnu.org/licenses/>. | |
31 | */ | |
32 | ||
33 | /** | |
34 | * Utility functions | |
6c6e6187 | 35 | * @package CiviCRM |
6a488035 TO |
36 | */ |
37 | class Utils { | |
38 | ||
39 | /** | |
eceb18cc | 40 | * PDO for the database. |
6c6e6187 | 41 | * @var PDO |
6a488035 TO |
42 | */ |
43 | public $pdo; | |
44 | ||
45 | /** | |
eceb18cc | 46 | * Construct an object for this database. |
1e1fdcf6 EM |
47 | * @param $host |
48 | * @param $port | |
49 | * @param $user | |
50 | * @param $pass | |
6a488035 | 51 | */ |
fc3c781d | 52 | public function __construct($host, $port, $user, $pass) { |
6a488035 | 53 | try { |
fc3c781d | 54 | $this->pdo = new PDO("mysql:host={$host}" . ($port ? ";port=$port" : ""), |
6a488035 TO |
55 | $user, $pass, |
56 | array(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY => TRUE) | |
57 | ); | |
58 | } | |
92915c55 | 59 | catch (PDOException$e) { |
6a488035 TO |
60 | echo "Can't connect to MySQL server:" . PHP_EOL . $e->getMessage() . PHP_EOL; |
61 | exit(1); | |
62 | } | |
63 | } | |
64 | ||
65 | /** | |
eceb18cc | 66 | * Prepare and execute a query. |
6a488035 | 67 | * |
72b3a70c CW |
68 | * If the query fails, output a diagnostic message |
69 | * @param string $query | |
70 | * Query to run | |
71 | * @return bool | |
6a488035 | 72 | */ |
00be9182 | 73 | public function do_query($query) { |
6a488035 TO |
74 | // echo "do_query($query)\n"; |
75 | // $stmt = $this->pdo->query( $query, PDO::FETCH_ASSOC ); | |
76 | // echo "PDO returned"; | |
77 | // var_dump($stmt); | |
78 | $string = preg_replace("/^#[^\n]*$/m", "\n", $query); | |
79 | $string = preg_replace("/^(--[^-]).*/m", "\n", $string); | |
80 | ||
81 | $queries = preg_split('/;\s*$/m', $string); | |
82 | foreach ($queries as $query) { | |
83 | $query = trim($query); | |
84 | if (!empty($query)) { | |
85 | $result = $this->pdo->query($query); | |
86 | if ($this->pdo->errorCode() == 0) { | |
87 | continue; | |
88 | } | |
89 | else { | |
90 | var_dump($result); | |
91 | var_dump($this->pdo->errorInfo()); | |
92 | // die( "Cannot execute $query: " . $this->pdo->errorInfo() ); | |
93 | } | |
94 | } | |
95 | } | |
96 | ||
97 | /******* | |
92915c55 TO |
98 | * if ( $this->pdo->errorCode() == 0 ) { |
99 | * //echo "returning the PDOStmt\n"; | |
100 | * return $stmt; | |
101 | * } | |
102 | * | |
103 | * // operation failed, so output description of where and why | |
104 | * $errorInfo = $this->pdo->errorInfo(); | |
105 | * echo "Oops, can't do query:\n {$query}\n in " | |
106 | * . basename( __FILE__) . " line " . __LINE__.":\n " | |
107 | * . $errorInfo[0] . ": " . $errorInfo[2] . "\n Call stack:\n"; | |
108 | * $backtrace = debug_backtrace(); | |
109 | * $dir_name = dirname( __FILE__ ); | |
110 | * $cwd_len = strlen( $dir_name ) + 1; | |
111 | * foreach ($backtrace as $frame ) { | |
112 | * echo " "; | |
113 | * if ( array_key_exists( 'class', $frame ) ) { | |
114 | * echo " class {$frame['class']}"; | |
115 | * if ( array_key_exists( 'function', $frame ) ) { | |
116 | * echo " method {$frame['function']}"; | |
117 | * } | |
118 | * } | |
119 | * else { | |
120 | * if ( array_key_exists( 'function', $frame ) ) { | |
121 | * echo " function {$frame['function']}"; | |
122 | * } | |
123 | * } | |
124 | * if ( array_key_exists( 'file', $frame ) ) { | |
125 | * echo " file ". substr( $frame['file'], $cwd_len ); | |
126 | * } | |
127 | * if ( array_key_exists( 'line', $frame ) ) { | |
128 | * echo " line {$frame['line']}"; | |
129 | * } | |
130 | * echo "\n"; | |
131 | * } | |
6a488035 TO |
132 | ******/ |
133 | return TRUE; | |
134 | } | |
96025800 | 135 | |
6a488035 TO |
136 | } |
137 | // class Utils | |
138 | ||
139 | // -- set Emacs parameters -- | |
140 | // Local variables: | |
141 | // mode: php; | |
142 | // tab-width: 4 | |
143 | // c-basic-offset: 4 | |
144 | // c-hanging-comment-ender-p: nil | |
145 | // indent-tabs-mode: nil | |
146 | // End: |