//create databasae connection $db = new CDatabase($urbax['database']); // Get max pages from table, for navigation $sql = "SELECT COUNT(id) AS rows FROM VMovie"; $res = $db->ExecuteSelectQueryAndFetchAll($sql); // Get maximal pages $max = ceil($res[0]->rows / $hits); //if current page is larger than max chose start-page if ($page > $max) { $page = 1; } // Do SELECT from a table $sql = "SELECT * FROM VMovie LIMIT {$hits} OFFSET " . ($page - 1) * $hits; $res = $db->ExecuteSelectQueryAndFetchAll($sql); //print hit-buttons echo "<p>" . getHitsPerPage(array(1, 2, 3, 4, 5, 10)) . "<a href='?p=paginate' class='aButton'>Visa alla</a></p>"; ?> <table class='table'> <tr><th>Rad</th><th>Id</th><th>Bild</th><th>Titel</th><th>År</th></tr> <?php foreach ($res as $i => $row) { echo "<tr><td style='width:10%;'>{$i}</td><td style='width:10%;'>{$row->id}</td>" . "<td style='width:15%;'><img src='{$row->image}' alt='bild på film' width='100' height='50'></td>" . "<td>{$row->title}</td><td style='width:10%;'>{$row->year}</td></tr>"; } ?> </table> <div style="text-align: center; margin-top: 5px;"> <?php
} // Complete the sql statement $where = $where ? " WHERE 1 {$where}" : null; $sql = $sqlOrig . $where . $groupby . $sort . $limit; $res = $db->ExecuteSelectQueryAndFetchAll($sql, $params); // Put results into a HTML-table $tr = "<tr><th>Rad</th><th>Id " . orderby('id') . "</th><th>Bild</th><th>Titel " . orderby('title') . "</th><th>År " . orderby('year') . "</th><th>Genre</th></tr>"; foreach ($res as $key => $val) { $tr .= "<tr><td>{$key}</td><td>{$val->id}</td><td><img width='80' height='40' src='{$val->image}' alt='{$val->title}' /></td><td>{$val->title}</td><td>{$val->year}</td><td>{$val->genre}</td></tr>"; } // Get max pages for current query, for navigation $sql = "\n SELECT\n COUNT(id) AS rows\n FROM \n (\n {$sqlOrig} {$where} {$groupby}\n ) AS Movie\n"; $res = $db->ExecuteSelectQueryAndFetchAll($sql, $params); $rows = $res[0]->rows; $max = ceil($rows / $hits); $hitsPerPage = getHitsPerPage(array(2, 4, 8), $hits); $navigatePage = getPageNavigation($hits, $page, $max); $sqlDebug = $db->Dump(); ?> <h1 class="center">Sök efter en film </h1> <form method="get"> <input type=hidden name=p value='moviesearchall'/> <input type=hidden name=hits value='<?php echo $hits; ?> '/> <input type=hidden name=page value='1'/>