Transformar Pesquisa com paginação em PDO.

[Abimael 0]

Pessoal eu tenho um código que baixei da internet e uso para pesquisa com paginação, gostaria que ele fosse transformado para utilizar PDO, alguém sabe como fazer, não estou conseguindo.

Index.php

<?php

mysql_connect("localhost", "root", "");

// Seleciona banco de dados

//mysql_select_db("tnd");

mysql_select_db("teste");

mysql_query("SET NAMES 'utf8'");

mysql_query('SET character_set_connection=utf8');

mysql_query('SET character_set_client=utf8');

mysql_query('SET character_set_results=utf8');

include_once ('function.php');

$_SESSION["busca"]="";

$page = (int) (!isset($_GET["page"]) ? 1 : $_GET["page"]);

$limit = 9;

$startpoint = ($page * $limit) - $limit;

//to make pagination

$statement = "`numeros` where `num` like '%".$_SESSION["busca"]."%'";

echo "<br>";

echo "SELECT * FROM {$statement} LIMIT {$startpoint} , {$limit}";

$query = mysql_query("SELECT * FROM {$statement} LIMIT {$startpoint} , {$limit}");

while ($row = mysql_fetch_assoc($query)) {

echo " - ". $row['num'];

echo "<br>";

}

echo pagination($statement,$limit,$page);

?>

--------------------------------------------------------
function.php if (empty($_SESSION["pagina"])) { $_SESSION["pagina"] = 1; } function pagination($query, $per_page = 10,$page = 1, $url = '?'){ $query = "SELECT COUNT(*) as `num` FROM {$query}"; $row = mysql_fetch_array(mysql_query($query)); $total = $row['num']; $adjacents = "2"; $page = ($page == 0 ? 1 : $page); $start = ($page - 1) * $per_page; $prev = $page - 1; $next = $page + 1; $lastpage = ceil($total/$per_page); $lpm1 = $lastpage - 1; $pagination = ""; if($lastpage > 1) { $pagination .= "<ul class='pagination'>"; $pagination .= "<li class='details'>Page $page of $lastpage</li>"; if ($lastpage < 7 + ($adjacents * 2)) { for ($counter = 1; $counter <= $lastpage; $counter++) { if ($counter == $page) $pagination.= "<li><a class='current'>$counter</a></li>"; else $pagination.= "<li><a href='{$url}page=$counter'>$counter</a></li>"; } } elseif($lastpage > 5 + ($adjacents * 2)) { if($page < 1 + ($adjacents * 2)) { for ($counter = 1; $counter < 4 + ($adjacents * 2); $counter++) { if ($counter == $page) $pagination.= "<li><a class='current'>$counter</a></li>"; else $pagination.= "<li><a href='{$url}page=$counter'>$counter</a></li>"; } $pagination.= "<li class='dot'>...</li>"; $pagination.= "<li><a href='{$url}page=$lpm1'>$lpm1</a></li>"; $pagination.= "<li><a href='{$url}page=$lastpage'>$lastpage</a></li>"; } elseif($lastpage - ($adjacents * 2) > $page && $page > ($adjacents * 2)) { $pagination.= "<li><a href='{$url}page=1'>1</a></li>"; $pagination.= "<li><a href='{$url}page=2'>2</a></li>"; $pagination.= "<li class='dot'>...</li>"; for ($counter = $page - $adjacents; $counter <= $page + $adjacents; $counter++) { if ($counter == $page) $pagination.= "<li><a class='current'>$counter</a></li>"; else $pagination.= "<li><a href='{$url}page=$counter'>$counter</a></li>"; } $pagination.= "<li class='dot'>..</li>"; $pagination.= "<li><a href='{$url}page=$lpm1'>$lpm1</a></li>"; $pagination.= "<li><a href='{$url}page=$lastpage'>$lastpage</a></li>"; } else { $pagination.= "<li><a href='{$url}page=1'>1</a></li>"; $pagination.= "<li><a href='{$url}page=2'>2</a></li>"; $pagination.= "<li class='dot'>..</li>"; for ($counter = $lastpage - (2 + ($adjacents * 2)); $counter <= $lastpage; $counter++) { if ($counter == $page) $pagination.= "<li><a class='current'>$counter</a></li>"; else $pagination.= "<li><a href='{$url}page=$counter'>$counter</a></li>"; } } } if ($page < $counter - 1){ $pagination.= "<li><a href='{$url}page=$next'>Próximo</a></li>"; $pagination.= "<li><a href='{$url}page=$lastpage'>Último</a></li>"; }else{ $pagination.= "<li><a class='current'>Próximo</a></li>"; $pagination.= "<li><a class='current'>Último</a></li>"; } $pagination.= "</ul>\n"; } $_SESSION["pagina"] =$page; // quando realizado uma pesquisa e sair da pagina ao retornar ficara na mesma paginação. return $pagination; } ?>

 

[Abimael 0]

function.php ficou ruim estou postando novamente

 

 

<?php

/**

* @link: http://www.Awcore.com/dev

*/

// quando realizado uma pesquisa e sair da pagina ao retornar ficara na mesma paginação.

if (empty($_SESSION["pagina"])) {

$_SESSION["pagina"] = 1;

}

function pagination($query, $per_page = 10,$page = 1, $url = '?'){

$query = "SELECT COUNT(*) as `num` FROM {$query}";

$row = mysql_fetch_array(mysql_query($query));

$total = $row['num'];

$adjacents = "2";

$page = ($page == 0 ? 1 : $page);

$start = ($page - 1) * $per_page;

$prev = $page - 1;

$next = $page + 1;

$lastpage = ceil($total/$per_page);

$lpm1 = $lastpage - 1;

$pagination = "";

if($lastpage > 1)

{

$pagination .= "<ul class='pagination'>";

$pagination .= "<li class='details'>Page $page of $lastpage</li>";

if ($lastpage < 7 + ($adjacents * 2))

{

for ($counter = 1; $counter <= $lastpage; $counter++)

{

if ($counter == $page)

$pagination.= "<li><a class='current'>$counter</a></li>";

else

$pagination.= "<li><a href='{$url}page=$counter'>$counter</a></li>";

}

}

elseif($lastpage > 5 + ($adjacents * 2))

{

if($page < 1 + ($adjacents * 2))

{

for ($counter = 1; $counter < 4 + ($adjacents * 2); $counter++)

{

if ($counter == $page)

$pagination.= "<li><a class='current'>$counter</a></li>";

else

$pagination.= "<li><a href='{$url}page=$counter'>$counter</a></li>";

}

$pagination.= "<li class='dot'>...</li>";

$pagination.= "<li><a href='{$url}page=$lpm1'>$lpm1</a></li>";

$pagination.= "<li><a href='{$url}page=$lastpage'>$lastpage</a></li>";

}

elseif($lastpage - ($adjacents * 2) > $page && $page > ($adjacents * 2))

{

$pagination.= "<li><a href='{$url}page=1'>1</a></li>";

$pagination.= "<li><a href='{$url}page=2'>2</a></li>";

$pagination.= "<li class='dot'>...</li>";

for ($counter = $page - $adjacents; $counter <= $page + $adjacents; $counter++)

{

if ($counter == $page)

$pagination.= "<li><a class='current'>$counter</a></li>";

else

$pagination.= "<li><a href='{$url}page=$counter'>$counter</a></li>";

}

$pagination.= "<li class='dot'>..</li>";

$pagination.= "<li><a href='{$url}page=$lpm1'>$lpm1</a></li>";

$pagination.= "<li><a href='{$url}page=$lastpage'>$lastpage</a></li>";

}

else

{

$pagination.= "<li><a href='{$url}page=1'>1</a></li>";

$pagination.= "<li><a href='{$url}page=2'>2</a></li>";

$pagination.= "<li class='dot'>..</li>";

for ($counter = $lastpage - (2 + ($adjacents * 2)); $counter <= $lastpage; $counter++)

{

if ($counter == $page)

$pagination.= "<li><a class='current'>$counter</a></li>";

else

$pagination.= "<li><a href='{$url}page=$counter'>$counter</a></li>";

}

}

}

if ($page < $counter - 1){

$pagination.= "<li><a href='{$url}page=$next'>Próximo</a></li>";

$pagination.= "<li><a href='{$url}page=$lastpage'>Último</a></li>";

}else{

$pagination.= "<li><a class='current'>Próximo</a></li>";

$pagination.= "<li><a class='current'>Último</a></li>";

}

$pagination.= "</ul>\n";

}

$_SESSION["pagina"] =$page; // quando realizado uma pesquisa e sair da pagina ao retornar ficara na mesma paginação.

return $pagination;

}

?>

[Beraldo 864]

Veja este artigo sobre PDO com MySQL