php pagination query?

[simmsy]

Hi im having a little trouble with pagination its not letting me use this username verification as well as the forum?

Any help would be appreciated!

 

<? if(!session_is_registered("username")){

echo "<p> </p>

<form name='login' method='post' action='register.php'>

  <table border='0' width='400' align='center'>

                    <tr>

                        <td width='90'>Username:</td>

                      <td width='300'><input type='text' name='username' /></td>

                    </tr>

                <tr>

                    <td width='90'>Password:</td>

                    <td width='300'><input type='password' name='password' /></td>

                </tr>

                <tr>

                    <td width='90'>Email:</td>

                  <td width='300'><input type='text' name='email' maxlength='100' /></td>

                </tr>

<tr>

<td>Gender: </td><td><input name='gender' type='radio' value='male' /> Male

<input name='gender' type='radio' value='female' /> Female</td></tr>

                <tr>

                    <td width='90'> </td>

                        <td width='300'>

                            <p align='left'><input type='submit' name='submit' value='Submit'></p>                  </td>

                </tr>

  </table>

</form>";

 

}else{

 

include 'connect.php';

 

// find out how many rows are in the table

$sql = "SELECT COUNT(*) FROM newtopic";

$result = mysql_query($sql) or trigger_error("SQL", E_USER_ERROR);

$r = mysql_fetch_row($result);

$numrows = $r[0];

 

// number of rows to show per page

$rowsperpage = 10;

// find out total pages

$totalpages = ceil($numrows / $rowsperpage);

 

// get the current page or set a default

if (isset($_GET['currentpage']) && is_numeric($_GET['currentpage'])) {

  // cast var as int

  $currentpage = (int) $_GET['currentpage'];

} else {

  // default page num

  $currentpage = 1;

} // end if

 

// if current page is greater than total pages...

if ($currentpage > $totalpages) {

  // set current page to last page

  $currentpage = $totalpages;

} // end if

// if current page is less than first page...

if ($currentpage < 1) {

  // set current page to first page

  $currentpage = 1;

} // end if

 

// the offset of the list, based on current page

$offset = ($currentpage - 1) * $rowsperpage;

 

// get the info from the db

$sql = "SELECT * FROM newtopic LIMIT $offset, $rowsperpage";

$result = mysql_query($sql) or trigger_error("SQL", E_USER_ERROR);

 

echo "<table width='371' border='0' align='center'>

  <tr>

    <td height='50' colspan='2'><b>     Fight Talk </b><input name='forumtype' type='hidden' value='fighttalk' /></td>

  </tr>

  <tr>

    <td width='160' height='50' align='center' colspan='2'><a href='fighttalknewtopic.php'># New Topic</a></td>

  </tr>

  <tr>

  <td><b>Username:</b></td><td><b>Message:</b></td>

  </tr>";

while($row = mysql_fetch_array($result))

  {

  echo "<tr>";

  echo "<td>" . " <b> " . $row['username'] . "</b><br />" . $row['date'] . " : " . $row['time'] . "</td>";;

  echo "</td>";

  echo "<td>" . $row['title'] . "</td>";

  echo "</tr><tr>"; 

  echo "<td colspan='2'>" . $row['message'] . "</td>";

  echo "</tr>";

  }

  echo "</table>";

 

/******  build the pagination links ******/

// range of num links to show

$range = 3;

 

// if not on page 1, don't show back links

if ($currentpage > 1) {

  // show << link to go back to page 1

  echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=1'>First</a> ";

  // get previous page num

  $prevpage = $currentpage - 1;

  echo " - ";

  // show < link to go back to 1 page

  echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$prevpage'>Previous</a> ";

} // end if

 

// loop to show links to range of pages around current page

for ($x = ($currentpage - $range); $x < (($currentpage + $range) + 1); $x++) {

  // if it's a valid page number...

  if (($x > 0) && ($x <= $totalpages)) {

      // if we're on current page...

      if ($x == $currentpage) {

        // 'highlight' it but don't make a link

        echo " [<b>$x</b>] ";

      // if not current page...

      } else {

        // make it a link

        echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$x'>$x</a> ";

      } // end else

  } // end if

} // end for

               

// if not on last page, show forward and last page links       

if ($currentpage != $totalpages) {

  // get next page

  $nextpage = $currentpage + 1;

    // echo forward link for next page

  echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$nextpage'>Next</a> ";

  echo " - ";

  // echo forward link for lastpage

  echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$totalpages'>Last</a> ";

} // end if

/****** end build pagination links ******/

?>

 

Sorry about the long code but this is the part it errors with:

 

<? if(!session_is_registered("username")){

echo "<p> </p>

<form name='login' method='post' action='register.php'>

  <table border='0' width='400' align='center'>

                    <tr>

                        <td width='90'>Username:</td>

                      <td width='300'><input type='text' name='username' /></td>

                    </tr>

                <tr>

                    <td width='90'>Password:</td>

                    <td width='300'><input type='password' name='password' /></td>

                </tr>

                <tr>

                    <td width='90'>Email:</td>

                  <td width='300'><input type='text' name='email' maxlength='100' /></td>

                </tr>

<tr>

<td>Gender: </td><td><input name='gender' type='radio' value='male' /> Male

<input name='gender' type='radio' value='female' /> Female</td></tr>

                <tr>

                    <td width='90'> </td>

                        <td width='300'>

                            <p align='left'><input type='submit' name='submit' value='Submit'></p>                  </td>

                </tr>

  </table>

</form>";

 

}else{

 

Also does anyone know how I can center the the "First - Previous 1-2-3-4 Next - Last" part of the pagination script?

Thanks for the help

[Skewled]

When using HTML within PHP you have to escape the quotes

 

<form method =\"post\" action=\"here.php\" />

 

That's just a short example you'd have to do your entire form.

[simmsy]

ive only used single quotes which works within php

[sasa]

are you start session before use it?

[simmsy]

yea at the top of the page

[simmsy]

yea it gives this error

Parse error: syntax error, unexpected $end in /home/fightwa1/public_html/fighttalk.php on line 200

[sasa]

you don't close 1st else block

add } to the end of the script