|
@@ 125-134 (lines=10) @@
|
| 122 |
|
return $result; |
| 123 |
|
} |
| 124 |
|
|
| 125 |
|
public function prepareAndFetchAll($sql,$parameters=null){ |
| 126 |
|
$result=false; |
| 127 |
|
$statement=$this->getStatement($sql); |
| 128 |
|
if($statement->execute ($parameters)){ |
| 129 |
|
Logger::info("Database", $sql,"prepareAndFetchAll",$parameters); |
| 130 |
|
$result = $statement->fetchAll (); |
| 131 |
|
} |
| 132 |
|
$statement->closeCursor (); |
| 133 |
|
return $result; |
| 134 |
|
} |
| 135 |
|
|
| 136 |
|
public function prepareAndFetchAllColumn($sql,$parameters=null,$column=null){ |
| 137 |
|
$result=false; |
|
@@ 136-145 (lines=10) @@
|
| 133 |
|
return $result; |
| 134 |
|
} |
| 135 |
|
|
| 136 |
|
public function prepareAndFetchAllColumn($sql,$parameters=null,$column=null){ |
| 137 |
|
$result=false; |
| 138 |
|
$statement=$this->getStatement($sql); |
| 139 |
|
if($statement->execute ($parameters)){ |
| 140 |
|
Logger::info("Database", $sql,"prepareAndFetchAllColumn",$parameters); |
| 141 |
|
$result = $statement->fetchAll(\PDO::FETCH_COLUMN,$column); |
| 142 |
|
} |
| 143 |
|
$statement->closeCursor (); |
| 144 |
|
return $result; |
| 145 |
|
} |
| 146 |
|
|
| 147 |
|
public function prepareAndFetchColumn($sql,$parameters=null,$column=null){ |
| 148 |
|
$statement=$this->getStatement($sql); |