Member Avatar for azegurb

hi everyone
i want to build pagination with PHP but i cannot
for ex i have 100 number of news and i like my page show only 10 news per page so let it displays 10 page and below let it is written
page1, page2, page3, and whenever i want to click on this pages let it goes the page which is clicked
this my database sql.

CREATE TABLE `news` (
  id int(11) NOT NULL auto_increment,
  theme varchar(200) NOT NULL default '',
  author varchar(100) NOT NULL default '',
  date date NOT NULL default '0000-00-00',
  text text NOT NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

i did like this but it doesnt work

<?


@$db=mysql_connect('localhost','username','parol');
mysql_select_db('db_name');



$per_page=10;






$q="SELECT count(*) FROM `news`";
$res=mysql_query($q);
$row=mysql_fetch_row($res);
$total_rows=$row[0];
$num_pages=ceil($total_rows/$per_page);

echo '<h1>news</h1>';
$sql="SELECT * FROM `news` ";
$result=mysql_query($sql);
$num_results=mysql_num_rows($result);
for ($i=0; $i<$num_results; $i++)
    {
    $row=mysql_fetch_array($result);

    $id=$row["id"];
    $author=$row["author"];
    $date=$row["date"];
    $tema=$row["tema"];    
    $text=$row["text"];

    echo '<b>'.$theme.'</b><br>

    <a href="/news/'.$id.'/">added by</a>: <b>'.$author.'</b> 

('.$date.')<p> '.$text.' <hr>';
    }

i need this script
if possible pls see it
Thanks for attention

  • 2 Contributors
  • 3 Replies
  • 81 Views
  • 12 Hours Discussion Span
  • Latest Post Latest Post by damnpoet
Member Avatar for damnpoet

i would recommend to use a pagination lib instead of making pagination yourself. I've used PHP Paginator a couple a times. It's a very simple pagination class, and very easy to use.

Member Avatar for azegurb

i saw it but didnt understand. i need to apply it on my code
thank you for attention
if possible pls make changes on my code

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.