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(); }