Търся пхп с крипт

Ето ти и пагинатион :

Код: 
///////////////////////////////////
    //start pagination !!!
    $targetpage = "all_article.php";
    $tableName = "artikuli";
    $limit = 10;
    $orderby = "name_artikuli";

    $query = "SELECT COUNT(*) as num FROM $tableName";
    $total_pages = mysql_fetch_array(mysql_query($query));
    $total_pages = $total_pages[num];

    $stages = 3;
    $page = mysql_escape_string($_GET['page']);
    if ($page) {
        $start = ($page - 1) * $limit;
    } else {
        $start = 0;
    }

    // Get page data
    $query1 = "SELECT * FROM $tableName  order by $orderby  LIMIT $start, $limit";
    $result = mysql_query($query1);


    // Initial page num setup
    if ($page == 0) {
        $page = 1;
    }
    $prev = $page - 1;
    $next = $page + 1;
    $lastpage = ceil($total_pages / $limit);
    $LastPagem1 = $lastpage - 1;


    $paginate = '';
    if ($lastpage > 1) {




        $paginate .= "<div class='paginate'>";
        // Previous
        if ($page > 1) {
            $paginate.= "<a href='$targetpage?page=$prev'>previous</a>";
        } else {
            $paginate.= "<span class='disabled'>previous</span>";
        }



        // Pages
        if ($lastpage < 7 + ($stages * 2)) { // Not enough pages to breaking it up
            for ($counter = 1; $counter <= $lastpage; $counter++) {
                if ($counter == $page) {
                    $paginate.= "<span class='current'>$counter</span>";
                } else {
                    $paginate.= "<a href='$targetpage?page=$counter'>$counter</a>";
                }
            }
        } elseif ($lastpage > 5 + ($stages * 2)) { // Enough pages to hide a few?
            // Beginning only hide later pages
            if ($page < 1 + ($stages * 2)) {
                for ($counter = 1; $counter < 4 + ($stages * 2); $counter++) {
                    if ($counter == $page) {
                        $paginate.= "<span class='current'>$counter</span>";
                    } else {
                        $paginate.= "<a href='$targetpage?page=$counter'>$counter</a>";
                    }
                }
                $paginate.= "...";
                $paginate.= "<a href='$targetpage?page=$LastPagem1'>$LastPagem1</a>";
                $paginate.= "<a href='$targetpage?page=$lastpage'>$lastpage</a>";
            }
            // Middle hide some front and some back
            elseif ($lastpage - ($stages * 2) > $page && $page > ($stages * 2)) {
                $paginate.= "<a href='$targetpage?page=1'>1</a>";
                $paginate.= "<a href='$targetpage?page=2'>2</a>";
                $paginate.= "...";
                for ($counter = $page - $stages; $counter <= $page + $stages; $counter++) {
                    if ($counter == $page) {
                        $paginate.= "<span class='current'>$counter</span>";
                    } else {
                        $paginate.= "<a href='$targetpage?page=$counter'>$counter</a>";
                    }
                }
                $paginate.= "...";
                $paginate.= "<a href='$targetpage?page=$LastPagem1'>$LastPagem1</a>";
                $paginate.= "<a href='$targetpage?page=$lastpage'>$lastpage</a>";
            }
            // End only hide early pages
            else {
                $paginate.= "<a href='$targetpage?page=1'>1</a>";
                $paginate.= "<a href='$targetpage?page=2'>2</a>";
                $paginate.= "...";
                for ($counter = $lastpage - (2 + ($stages * 2)); $counter <= $lastpage; $counter++) {
                    if ($counter == $page) {
                        $paginate.= "<span class='current'>$counter</span>";
                    } else {
                        $paginate.= "<a href='$targetpage?page=$counter'>$counter</a>";
                    }
                }
            }
        }

        // Next
        if ($page < $counter - 1) {
            $paginate.= "<a href='$targetpage?page=$next'>next</a>";
        } else {
            $paginate.= "<span class='disabled'>next</span>";
        }

        $paginate.= "</div>";
    }
//    echo $total_pages . ' Results';
    // pagination
    $res = run_q('SELECT * FROM artikuli WHERE article_active=1 order by name_artikuli LIMIT ' . $start . ',' . $limit . '');
///end pagination !!!
    ////////////////////////////////////

Където run_q() от query e function

Код: 
function run_q($sql) {
     mysql_query("SET NAMES utf8");
     $res=mysql_query($sql);
     if (mysql_error()) {
          echo mysql_error().' ===> Това беше вашата заявка : ===> '.$sql;
     }
     return $res;
}
 
macmen каза:
http://web-tourist.net/login/login/view.php?st=2984
само ти трябва да си страницизираш информацията
Увеличете...

Брат на мене ми трябва със странициране!

Аз си направих тази система за категории да излизат страници, ама немога да направя да се страницират само от дадената категория. Скрипта страницира всички от таблизата. Ето ако някой може да го оправи да страницира само от дадеената категория:

Код: 
<?php 
///////////////////Връзка с база данни//////////////////// 
mysql_connect("localhost","усер","*********"); 
mysql_select_db("DB"); 
mysql_query("SET CHARACTER SET cp1251"); 
///////////////////Край на връзка с база данни//////////////////// 
$broinastranica = 5;//колко броя да изкарва на страница 
$pageNum = 1; 
if(isset($_GET['page'])) 
{ 
$pageNum = $_GET['page']; 
} 
$redove = ($pageNum - 1) * $broinastranica; 
	$result = mysql_query("SELECT c.name, n.title FROM news as n LEFT OUTER JOIN categories as c ON n.catid = c.id WHERE n.catid = '".$category."'")
				or die("Не може да изпълни заявката");
	while($row = mysql_fetch_array($result)) {
echo "".$row['title']." в категория: ".$row['name']."\<br />"; 
} 
$query = "SELECT COUNT(id) AS broi FROM news   "; 
$result = mysql_query($query); 
$row = mysql_fetch_array($result, MYSQL_ASSOC); 
$numrows = $row['broi']; 
$maxPage = ceil($numrows/$broinastranica); 
$self = $_SERVER['PHP_SELF']; 
$nomeranastranici = ''; 
for($page = 1; $page <= $maxPage; $page++) 
{ 
if ($page == $pageNum) 
{ 
$nomeranastranici .= " $page "; 
} 
else 
{ 
$nomeranastranici .= " <a href="$self?page=$page">$page</a> "; 
} 
} 
if ($pageNum > 1) 
{ 
$page = $pageNum - 1; 
$predishna = " <a href="$self?page=$page"> [<<<<<] </a> "; 
$parva = " <a href="$self?page=1">[първа]</a> "; 
} 
else 
{ 
$predishna = ' '; 
$parva = ' '; 
} 
if ($pageNum < $maxPage) 
{ 
$page = $pageNum + 1; 
$sledvashta = " <a href="$self?page=$page"> [>>>>>] </a> "; 
$posledna = " <a href="$self?page=$maxPage">[последна]</a> "; 
} 
else 
{ 
$sledvashta = ' '; 
$posledna = ' '; 
} 
echo "<br><br>".$parva . $predishna . $nomeranastranici . $sledvashta . $posledna; 
?>
 
Трябва да си влезнал или регистриран, за да отговориш тук.

Back
Горе