function loadActivity($limit, $id)
{
$activities = array();
$img = new ImageDAO();
$query = "SELECT id,title,description,DATE_FORMAT(date,'%m-%Y'),price,ticketSales,scene,cat FROM activity where status='active' ";
if ($id > 0) {
$query = $query . " and id={$id}";
$imgLimit = 0;
} else {
$imgLimit = 1;
}
if ($limit > 0) {
$query = $query . " limit {$limit}";
}
$result = mysql_query($query, $this->con);
while ($row = mysql_fetch_row($result)) {
$activity = new Activity();
$activity->id = $row[0];
$activity->title = $row[1];
$activity->description = $row[2];
$activity->date = $row[3];
$activity->price = $row[4];
$activity->ticketSales = $row[5];
$activity->scene = $row[6];
$activity->category = $row[7];
$activity->images = $img->getImages($row[0], $imgLimit);
$activity->events = $this->loadEvent($row[0]);
$activities[] = $activity;
}
return $activities;
}
public static function getInstance()
{
if (!self::$instance) {
self::$instance = new ImageDAO();
}
return self::$instance;
}
<?php
include_once 'db/ImageDAO.php';
$image = new ImageDAO();
$GG = $image->getAllImages();
/*echo count($GG);
for($i = 0; $i < count($GG); $i++){
for($j = 0; $j < count($GG[$i]); $j++){
echo $GG[$i][$j];
}
}*/
/*$jsonReturn = json_encode($GG);*/
/*header("Content-type: application/json");*/
/*echo $jsonReturn;*/
echo $GG;
<?php
error_reporting(E_ALL);
ini_set("display_errors", 1);
header('Content-type: text/html; charset=utf-8');
require_once $_SERVER['DOCUMENT_ROOT'] . '/backend/DAO/CategoryDAO.php';
require_once $_SERVER['DOCUMENT_ROOT'] . '/backend/DAO/ActivityDAO.php';
require_once $_SERVER['DOCUMENT_ROOT'] . '/backend/DAO/ImageDAO.php';
require_once $_SERVER['DOCUMENT_ROOT'] . '/backend/model/Activity.php';
require_once $_SERVER['DOCUMENT_ROOT'] . '/backend/model/Image.php';
$cat = new CategoryDAO();
$act = new ActivityDAO();
$imgDAO = new ImageDAO();
require_once $_SERVER['DOCUMENT_ROOT'] . '/lib/upload.php';
foreach ($cat->getCategoryList() as $category) {
$catso[] = array($category->id => $category->name);
}
require_once $_SERVER['DOCUMENT_ROOT'] . '/libs.inc.php';
require_once $_SERVER['DOCUMENT_ROOT'] . '/Admin/view/menu/index.php';
$smarty->display("menu/menu.tpl");
require_once $_SERVER['DOCUMENT_ROOT'] . '/Admin/view/menu/activities.php';
$smarty->display("menu/activities.tpl");
$activities = $act->loadActivity(0, 0);
if (isset($_GET['mod'])) {
switch ($_GET['mod']) {
case 'list':
$smarty->assign('activities', $activities);
$smarty->display("activities/list.tpl");
break;
case 'new':
$smarty->assign('cats', $catso);
/**
* inicia internamente a DAO
* @return void
*/
public function startDAO()
{
$this->DAO = ImageDAO::getInstance();
}
