/**
* Test Create
*
* Create a table without setting headings first
*
* @return void
*
*/
public function testCreate_withoutHeadings()
{
$tbl = new CHTMLTable();
// Test without column definitions
$res = $tbl->create($this->objects);
$this->assertEquals($this->expNoHeadings, $res, "Mismatch for table without column definitions");
// Test with column definitions
$tbl->setColumns($this->colDefs);
$res = $tbl->create($this->objects);
$this->assertEquals($this->expWithHeadings, $res, "Mismatch for table with column definitions");
}
<?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";
}
// Get parameters for sorting
$title = isset($_GET['title']) ? $_GET['title'] : null;
$year1 = isset($_GET['year1']) ? $_GET['year1'] : null;
$year2 = isset($_GET['year2']) ? $_GET['year2'] : null;
if ($title) {
$params = array($title);
$res = $db->ExecuteSelectQueryAndFetchAll("SELECT * FROM Movie WHERE title LIKE ?;", $params);
} else {
if ($year1) {
$params = array($year1, $year2);
$res = $db->ExecuteSelectQueryAndFetchAll("SELECT * FROM Movie WHERE year >= ? and year <= ?;", $params);
} else {
$res = $db->ExecuteSelectQueryAndFetchAll("SELECT * FROM Movie;");
}
}
$htmlTable = new CHTMLTable();
$output = $htmlTable->drawHTML($res);
$Orange['title'] = "Movie Search";
$Orange['main'] = <<<EOD
<h1>SEARCH TITLE</h1>
<form>
<fieldset>
<legend>Sök</legend>
</form>
<form>
<p><label>Titel: <input type='search' name='title' value='{$title}'/></label></p>
<p>
<label>Skapad mellan åren:
<input type='text' name='year1' value='{$year1}'/>
