public function __construct($dbSettings)
{
$this->dbh = new CDatabase($dbSettings);
$this->textfilter = new CTextFilter();
$this->genres = CMovieSearch::getGenres($this->dbh, "movies");
$this->latest3movies = $this->get3latestMovies();
$this->popular = $this->getMostPopularMovie();
$this->lastRent = $this->getLastRentMovie();
$this->blogs = $this->get3blogs();
}
<?php
// Jag valde att inte skapa en klass av denna kod eftersom att det i sådana fall skulle blivit en väldigt specifik klass.
// Jag ställde mig tveksam till att en sådan klass någonsin skulle bli aktuell att använda igen (dvs återanvändbar).
// Eftersom jag inte riktigt kunde se nyttan med en sådan klass så struntade jag i att göra det (lilla) jobb som skulle
// krävts för att skapa klassen...
// Connect to a MySQL database using PHP PDO
$db = new CDatabase($urbax['database']);
// Get parameters
$title = isset($_GET['title']) ? $_GET['title'] : null;
$genre = isset($_GET['genre']) ? $_GET['genre'] : null;
$hits = isset($_GET['hits']) ? $_GET['hits'] : 5;
$page = isset($_GET['page']) ? $_GET['page'] : 1;
$year1 = isset($_GET['year1']) && !empty($_GET['year1']) ? $_GET['year1'] : null;
$year2 = isset($_GET['year2']) && !empty($_GET['year2']) ? $_GET['year2'] : null;
$orderby = isset($_GET['orderby']) ? strtolower($_GET['orderby']) : 'id';
$order = isset($_GET['order']) ? strtolower($_GET['order']) : 'asc';
// Check that incoming parameters are valid
is_numeric($hits) or die('Check: Hits must be numeric.');
is_numeric($page) or die('Check: Page must be numeric.');
is_numeric($year1) || !isset($year1) or die('Check: Year must be numeric or not set.');
is_numeric($year2) || !isset($year2) or die('Check: Year must be numeric or not set.');
// Show search form
echo CMovieSearch::getSearchForm('generate', $page, $hits, $title, $year1, $year2, $db);
// Run SQL query
$res = CMovieSearch::ExecuteSelectQueryAndFetchAll($page, $hits, $title, $year1, $year2, $genre, $order, $orderby, $db);
// Display resulting table
if (count($res['resultset']) > 0) {
echo CHTMLTable::generateHTMLtableResult($res['resultset'], 'table', $hits, $page, $res['maxresults']);
} else {
echo "Inga filmer matchar angivna sökkriterier";
}
<?php
/**
* This is a Branax pagecontroller.
*
*/
// Include the essential config-file which also creates the $branax variable with its defaults.
include __DIR__ . '/config.php';
$movieSearch = new CMovieSearch($branax['database']);
$movieView = new CMovieView();
$contents = $movieView->getTable($movieSearch->getRes(), $movieSearch->getRows());
// Do it and store it all in variables in the Branax container.
$branax['title'] = $movieView->getTitle('Filmer');
$branax['stylesheets'][] = 'css/movies.css';
$branax['stylesheets'][] = 'css/breadcrumb.css';
$branax['main'] = <<<EOD
{$movieView->getBreadcrumb()}
<h1>{$movieView->getTitle('Våra filmer')}</h1>
{$contents}
EOD;
$debug = isset($disableDebug) ? null : CDatabase::dump();
// Finally, leave it all to the rendering phase of Branax.
include BRANAX_THEME_PATH;
/**
* The navbar
*
*/
//$anax['navbar'] = null; // To skip the navbar
// $content = new CContent($branax['database']);
// $blogItems = $content->getBlogItems();
// $pageItems = $content->getPageItems();
// $content = null;
$userId = CUser::isUser() ? '?id=' . CUser::isUser() : null;
$blogSubMenuItems = CUser::isAuthenticated() ? array('items' => array('view' => array('text' => 'Ändra', 'url' => 'content_view.php', 'title' => 'Ändra innehåll'), 'create' => array('text' => 'Lägg till', 'url' => 'content_create.php', 'title' => 'Nytt innehåll'), 'reset' => array('text' => 'Återställ', 'url' => 'content_reset.php', 'title' => 'Återställ innehåll'))) : null;
$movieSubMenuItems = CUser::isAuthenticated() ? array('items' => array('create' => array('text' => 'Lägg till', 'url' => 'movie_create.php', 'title' => 'Nytt innehåll'), 'reset' => array('text' => 'Återställ', 'url' => 'movie_reset.php', 'title' => 'Återställ innehåll'))) : null;
$userSubMenuItems = CUser::isUser() ? array('logout' => array('text' => 'Logout', 'url' => 'user_logout.php', 'title' => 'Utloggning')) : array();
$userSubMenuItems += array('login' => array('text' => 'Login', 'url' => 'user_login.php', 'title' => 'Inloggning'), 'status' => array('text' => 'Status', 'url' => 'user_status.php', 'title' => 'Inloggningsstatus'));
$userSubMenuItems += CUser::isAuthenticated() ? array('create' => array('text' => 'Lägg till', 'url' => 'user_create.php', 'title' => 'Nytt innehåll'), 'reset' => array('text' => 'Återställ', 'url' => 'user_reset.php', 'title' => 'Återställ')) : array();
$searchForm = CMovieSearch::getTitleForm('movies.php');
$branax['navbar'] = array('class' => 'navbar', 'items' => array('hem' => array('text' => 'Hem', 'url' => 'home.php', 'title' => 'RM Rental Movies'), 'filmer' => array('text' => 'Filmer', 'url' => 'movies.php', 'title' => 'Våra filmer', 'submenu' => $movieSubMenuItems), 'nyheter' => array('text' => 'Nyheter', 'url' => 'content_blog.php', 'title' => 'Blogg', 'submenu' => $blogSubMenuItems), 'dice' => array('text' => 'Tävling', 'url' => 'dice100.php', 'title' => 'Spela och vinn en film'), 'user' => array('text' => 'Användare', 'url' => "user_view.php{$userId}", 'title' => 'Användarprofiler', 'submenu' => array('items' => $userSubMenuItems)), 'about' => array('text' => 'Om RM', 'url' => 'about.php', 'title' => 'Om företaget')), 'callback' => function ($url) {
if (basename($_SERVER['SCRIPT_NAME']) == $url) {
return true;
}
if (in_array(basename($_SERVER['SCRIPT_NAME']), ['content_edit.php', 'content_delete.php', 'content_view.php']) && in_array($url, ['content_edit.php', 'content_delete.php', 'content_view.php'])) {
return true;
}
if (in_array(basename($_SERVER['SCRIPT_NAME']), ['movie_view.php', 'movie_edit.php', 'movie_delete.php']) && in_array($url, ['movies.php'])) {
return true;
}
if (in_array(basename($_SERVER['SCRIPT_NAME']), ['user_view.php', 'user_register.php', 'user_regedit.php', 'user_edit.php', 'user_delete.php']) && in_array(parse_url($url, PHP_URL_PATH), ['user_view.php'])) {
return true;
}
});
/**
