/**
* Public class constructor
* @param LogController the controller for the log
* @access public
*/
public function __construct($controller)
{
$this->logController = $controller;
$config = Configuration::getMysqlConfiguration();
// Initialize database with data configuration
$this->database = new MySqlDatabase($config['dbHost'], $config['dbUser'], $config['dbPassword'], $config['dbName'], $config['dbPort']);
}
/**
* Public class constructor
* @access public
*/
public function __construct()
{
$config = Configuration::getMysqlConfiguration();
try {
$this->database = new MySqlDatabase($config['dbHost'], $config['dbUser'], $config['dbPassword'], $config['dbName'], $config['dbPort']);
$this->connection = $this->database->dbConnect();
} catch (Error $e) {
$e->printHtmlError();
$e->reportOnGitHub(array("mysql error", "news"));
}
}
/**
* Extract all images in database
* @access public
* @return hash hash of extracted images
* @static
*/
public static function selectAll()
{
$config = Configuration::getMysqlConfiguration();
$query = "select * from immagini";
try {
$database = new MySqlDatabase($config['dbHost'], $config['dbUser'], $config['dbPassword'], $config['dbName'], $config['dbPort']);
$connection = $database->dbConnect();
$result = $database->executeQuery($query, $connection);
$i = 0;
$images = array();
while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
$images[$i] = $row;
$i++;
}
return $images;
} catch (Error $e) {
$e->printHtmlError();
$e->reportOnGitHub(array("mysql error", "image"));
}
}
