Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $host="localhost";
- $korisnik="root";
- $lozinka="";
- $baza="test";
- mysql_connect($host,$korisnik,$lozinka) or die ("Nemoguce se spojiti");
- mysql_select_db($baza) or die ("Nemoguce se spojiti na bazu");
- $upit="SELECT * FROM tabela";
- $izvrsi=mysql_query($upit);
- $izbroji=mysql_num_rows($izvrsi);
- $po_stranici=6;
- $zadnja=ceil($izbroji/$po_stranici);
- if(!isset($_GET['page']))
- {
- $page=1;
- }
- else
- {
- $page=$_GET['page'];
- }
- $from =0;
- $limit = "LIMIT $from, $po_stranici";
- echo $limit;
- exit;
- $upit2="SELECT * FROM tabela LIMIT $from, $po_stranici;";
- $izvrsi2=mysql_query($upit2) or die (mysql_error());
- while($red=mysql_fetch_array($izvrsi2))
- {
- echo $red['name'];
- }
- for ($i = 1; $i<=$zadnja; $i++)
- {
- echo "<a href='".$_SERVER['PHP_SELF']."?page=".$i."'>$i</a> ";
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement