Bookify söker ny ägare och kommer stängas ner under 2026. Intresserad av att driva Bookify vidare? Hör av dig till kontakt[at]bookify.se
include "../data/scripts/connect.php";
include "../data/scripts/functions.php";
$time = microtime();
$time = explode(' ', $time);
$time = $time[1] + $time[0];
$start = $time;
/*
$table_id = table_id($conn);
$nr_of_res = mysqli_query($conn,"SELECT MATCH(title, isbn, author) AGAINST ('$search_string') AS score from allproducts".$table_id." WHERE MATCH (title, isbn, author) AGAINST('$search_string') LIMIT 225");
$nr_of_res = mysqli_num_rows($nr_of_res);
*/
$page_rows = 25;
$max_matches =225;
if (!empty($_GET['page'])) {
$pagenum = intval($_GET['page']);
if (empty($pagenum) || $pagenum < 1) {$pagenum = 1;}
$currentOffset = ($pagenum -1)* $page_rows;
if ($currentOffset > ($max_matches-$page_rows) ) {
$pagenum = 9;
}
} else {
$pagenum = 1;
$currentOffset = 0;
}
include('../data/scripts/sphinxapi.php');
$s = new SphinxClient;
$s->setServer("127.0.0.1", 9312);
$s->SetLimits($currentOffset,$page_rows);
$s->setMatchMode(SPH_MATCH_EXTENDED2);
$s->SetSortMode(SPH_SORT_EXTENDED, $order_by);
$result = $s->Query($search_string);
$nr_of_res = $result['total'];
$nr_of_pages = ceil($result['total']/$page_rows);
if($nr_of_res > 225){
$nr_of_res = 225;
$nr_of_pages = 9;
}
/*
if($nr_of_res==225){
$nr_of_pages = 9;
}
else{
$nr_of_pages = ceil($nr_of_res/$page_rows);
}
if (!(isset($_GET['page'])))
{
$pagenum = 1;
}
if(isset($_GET['page']))
{
$page_get = $_GET['page'];
if ($page_get < 1)
{
$pagenum = 1;
}
else if ($page_get > $nr_of_pages)
{
$pagenum = $nr_of_pages;
}
else {
$pagenum = $page_get;
}
}
$limit_res = ($pagenum - 1) * $page_rows .',' .$page_rows;
*/
if($search_string == ""){
$nr_of_res = 0;
}
//$nr_of_res = 1; //om localhost
if($nr_of_res > 0){
$ids = array_keys($result['matches']); //om servern
$query = mysqli_query($conn, "select * from allproducts where isbn in(".implode(',',$ids).")"); //om servern
//$query = mysqli_query($conn, "select * from allproducts where isbn = ".$search_string.""); //om localhost
$res_this_page = mysqli_num_rows($query);
$rows = array();
//om servern
while ($row = mysqli_fetch_array($query)) {
$rows[$row['isbn']] = $row;
}
$ordered_rows = array();
foreach($ids as $index) {
$id_float = explode(".", $index);
$index = $id_float[0];
$ordered_rows[$index] = $rows[$index];
}
//om servern
}
$time = microtime();
$time = explode(' ', $time);
$time = $time[1] + $time[0];
$finish = $time;
$total_time = round(($finish - $start), 4);
//echo 'Sökningen tog '.$total_time.' sekunder.';
$result = mysqli_query($conn,"INSERT INTO search_log (query_time) values ('$total_time')");
function pagination_url($i){
$params = $_GET;
$params['page'] = $i;
$paramString = http_build_query($params);
echo "?".$paramString;
}
$pageID="compare-books";
include "../data/scripts/header-tag.php";
?>
-
Secret Lives of Great Authors (Häftad)
av Robert Schnakenberg
ISBN: 9781594742118 - UTGIVEN:
200801
Now it's time to leave the history classroom and go down the hall to the English lesson. "Secret Lives of Great Authors" contains irreverent and fun-filled bios of all the writers you were forced to read in school, from Shakespeare and Emily Dickinson to J. D. Salinger and Sylvia Plath. And guess wh[...]
Christopher Walken A to Z (Häftad)
av Robert Schnakenberg
ISBN: 9781594742590 - UTGIVEN:
200809
Is Christopher Walken from Mars? He must be. How else can you explain his incredible range of talents and experiences? He has worked as a lion tamer, he has danced in music videos for Madonna, Duran Duran, and Fatboy Slim, and he has appeared in 100+ films for some of Hollywood's hottest directors, [...]
Old Man Drinks (Inbunden)
av Robert Schnakenberg
ISBN: 9781594744501 - UTGIVEN:
201002
Dozens of books exist about sexy drinks: the Cosmo, Sex on the Beach, Buttery Nipple. But what about the old man drink? The Old Fashioned. The Sidecar. The Gibson. What about them? It's time to pay tribute to those timeless go-to drinks that the old man at the bar always orders. They're back in styl[...]
DC Comics (Häftad)
av Robert Schnakenberg, Paul Levitz
ISBN: 9781594744624 - UTGIVEN:
201009
"The Covers Collection" celebrates 75 years of DC Comics history by showcasing hundreds of their most famous covers - including 100 full-size posters that are perforated and ready-to-frame. Arranged in chronological order, each poster honors a milestone in DC Comics history with a full-page perforat[...]
