/**
* load functions, to help controller
*
* 裡面包裹的 help function
* 僅給 controller 使用
* 並不給予 view 使用
*/
protected function loadHelper(array $args)
{
$request = $args[0];
$response = $args[1];
$args = $args[2];
LoadHelper::init($request, $response, $args);
}
public function get_student_courses($order = null)
{
LoadHelper::model('course');
$student_list = array();
//connect to database
$this->db->connect();
//query
$sql = "SELECT s.id,s.first_name,s.last_name,s.email,s.contact_no,c.id as course_id,c.course_name ";
$sql .= " FROM students s JOIN courses c on s.course_id=c.id";
if (isset($order)) {
$sql = $sql . " ORDER BY " . $order;
}
//fetchquery
$result = $this->db->fetchquery($sql);
while ($row = $result->fetch_assoc()) {
$student = new Students();
$student->set_id($row['id']);
$student->set_first_name($row['first_name']);
$student->set_last_name($row['last_name']);
$student->set_email($row['email']);
$student->set_contact_no($row['contact_no']);
$course = new Course();
$course->set_id($row['course_id']);
$course->set_course_name($row['course_name']);
$student->set_course($course);
array_push($student_list, $student);
}
$this->db->close();
return $student_list;
}
public function add()
{
LoadHelper::model("course");
LoadHelper::repository("courserepository");
$course_repository = new CourseRepository();
if (isset($_POST['submit'])) {
$student = $this->map_data();
$this->studentrepository->insert($student);
header("Location: index.php?page=student&action=success");
exit;
}
include_once ROOT_PATH . "view/student/add.php";
}
/**
* load functions, to help controller
*
* 裡面包裹的 help function
* 僅給 controller 使用
* 並不給予 view 使用
*/
protected function loadHelper(array $args)
{
// 目前並不是使用 controller 的方式, 所以這裡不進行以下動作
return;
if (isCli()) {
// TODO: 找時間對 console 指令的格式, 做解析
return;
}
$request = $args[0];
$response = $args[1];
$args = $args[2];
LoadHelper::init($request, $response, $args);
}
public static function getData($game)
{
$data = LoadHelper::loadCached('https://promoterapp.com/dopresskit/' . $game->promoter['product'], PROMOTER_CACHE_DURATION);
if ($data == null) {
return;
}
$promoterxml = simplexml_load_string($data);
$promoter = XMLHelper::xml2array($promoterxml);
XMLHelper::collapse($promoter, 'reviews', 'review');
if (!isset($promoter['reviews'])) {
return;
}
if (PROMOTER_OVERWRITE || !isset($game->quotes)) {
$game->quotes = array();
}
foreach ($promoter['reviews'] as $review) {
$game->quotes[] = array('link' => $review['url'], 'description' => $review['quote'], 'name' => $review['reviewerName'], 'website' => $review['publicationName']);
}
}
public static function getFilename($url)
{
return LoadHelper::getCacheDir() . md5($url) . '.cache';
}
/**
* load functions, to help controller
*
* 裡面包裹的 help function
* 僅給 controller 使用
* 並不給予 view 使用
*/
protected function loadHelper(array $args)
{
LoadHelper::init($args);
}
<?php
LoadHelper::model("course");
LoadHelper::repository("courserepository");
?>
<?php
class CourseController
{
private $courserepository;
public function __construct()
{
$this->courserepository = new courserepository();
}
public function index()
{
if (isset($_POST['sort'])) {
$order = $_POST['sort'];
} else {
$order = null;
}
include_once ROOT_PATH . "view/Course/index.php";
}
public function add()
{
if (isset($_POST['submit'])) {
$Course = $this->map_data();
$this->courserepository->insert($Course);
header("Location: index.php?page=course&action=success");
private static function getTempPath()
{
return realpath(LoadHelper::getCacheDir() . UpdateHelper::tmp_path);
}
