php 显示一张表格,PHP - 分页和地点结果是一张表格

我已经尝试了一些分页，但它给了我非常意想不到的结果....

首先，它在分页的第一页，它似乎覆盖了CSS，并将所有div对齐到了页面的右手边......然后，当你点击“下一页”查看接下来的三个结果，等等页面按照CSS告诉它返回！

第二个问题是显示结果的表似乎不起作用。分页的每个页面上的第一个结果在表格中，接下来的两个结果(每页三个结果)显示在页面上，但在下面而不是在表格中！

代码很长，但是我们现在去：

session_start();

if ( !isset($_SESSION['username']))

{

header("Location:index.php");

exit();

}

//connect to database

require "dbconn.php";

$per_page = 3;

$start = $_GET['start'];

$sort = @$_POST['order'];

if (!empty($sort)) {

$query = "SELECT bookname, bookauthor, bookpub, bookisbn

FROM booktable

ORDER BY ".mysql_real_escape_string($_POST['order'])." ASC";

}

else {

$query = "SELECT bookname, bookauthor, bookpub, bookisbn

FROM booktable

ORDER BY bookname ASC";

}

$results = mysql_query($query)

or die (mysql_error());

$record_count = mysql_num_rows($results);

if (!$start)

$start = 0;

$get = mysql_query("SELECT * FROM booktable LIMIT $start, $per_page");

?>

if (isset($_GET['showerror']))

$errorcode = $_GET['showerror'];

else

$errorcode = 0;

?>然后我将删除所有不需要的html

echo "

echo "

";

echo "

";

echo "

";

echo "

";

echo "Book Title";

echo "

";

echo "

";

echo "Book Author";

echo "

";

echo "

";

echo "Book Publisher";

echo "

";

echo "

";

echo "Book ISBN";

echo "

";

echo "

";

echo "

";

echo "

";

while ($row = mysql_fetch_assoc($get))

{

// get data

$bookname = $row['bookname'];

$bookauthor = $row['bookauthor'];

$bookpub = $row['bookpub'];

$bookisbn = $row['bookisbn'];

echo "

";

echo "

";

echo "Add to basket";

echo "

";

echo "

";

echo $bookname;

echo "

";

echo "

";

echo $bookauthor;

echo "

";

echo "

";

echo $bookpub;

echo "

";

echo "

";

echo $bookisbn;

echo "

";

echo "

";

echo "

";

}

$prev = $start - $per_page;

$next = $start + $per_page;

if (!($start<=0))

echo "Prev ";

//set variable for first page number

$i=1;

//show page numbers

for ($x = 0; $x < $record_count; $x = $x + $per_page)

{

if ($start != $x)

echo "$i";

else

echo "$i";

$i++;

}

//show next button

if (!($start >= $record_count - $per_page))

echo "Next";

?>

<?php echo $record_count; ?>这是页面的外观(图片1)(表格边框显示问题)

正如我之前所说的，当列表第一次显示时，我也会遇到问题，并且页面看起来像这样：(image2)

你可以看到他们有什么不同！

我希望我有道理！