страничиране на код

Pro_Lamer4e

Registered
а ето и код-а 2 дена вече се мъча и нещо не успявам с тези страницирания....
Код:
<?
require "conf.php";

if ($action == 'delete') {
   $sql = mysql_query("DELETE FROM servers WHERE id = '$nom'") or die(mysql_error());
   header("Location: admin.php");
}

if($_GET['id']){
$lyricid = $_GET['id'];
$query1 = "SELECT * FROM `servers` where id = '$lyricid'";
$result1=mysql_query($query1);
while($row = mysql_fetch_array($result1)) {
$id = $row['id'];
$name = $row['name'];
$ip = $row['ip'];
$port = $row['port'];
$cheat = $row['cheat'];
$type = $row['type'];
$author = $row['author'];
echo '
Име<br /><input name="name" value='.$name.' type="text" size="30" /><br />
Ип<br /><input name="ip" value='.$ip.' type="text" size="30" /><br />
Порт<br /><input name="port" value='.$port.' type="text" size="30" /><br>
Anti-Cheat<br />
<select name="cheat">
<option value="" selected="selected">Посочи</option>
      <option value="Няма">Няма</option>
   <option value="Cheating-Death">Cheating-Death</option>
    <option value="MyAC">MyAC</option>
    <option value="sXe Injected">sXe Injected</option>   
    <option value="HLGuard">HLGuard</option>   
    <option value="DonT Lie">DonT Lie</option>
    <option value="Flex">Flex</option> 
	<option value="CSF">CSF</option> 
<option value="Друг">Друг</option>
   </select><br>

Тип<br />

<select name="type">
<option value="" selected="selected">Посочи</option>
      <option value="Classic">Classic</option>
      <option value="Hide N Seek">Hide N Seek</option>
      <option value="Kreedz">Kreedz</option>
                <option value="Warcraft 3 / FT">Warcraft 3 / FT</option>
      <option value="Zombie">Zombie</option>
      <option value="Deathmatch">Deathmatch</option>
      <option value="Cups">Cups</option>
      <option value="5on5">5on5</option>
      <option value="Massive">Massive</option>
                <option value="Aim">Aim</option>
      <option value="SuperHero">SuperHero</option>
      <option value="GunGame">GunGame</option>
      <option value="Deathrun">Deathrun</option>
      <option value="PaintBall">PaintBall</option>
      <option value="Respawn">Respawn</option>
 
   </select><br>

Автор<br /><input name="author" value='.$author.' type="text" size="30" />
<br /><br />
<input name="submit" type="submit"  value="Добави" />
</form>
 ';

if($_POST['editl']){
$name = htmlspecialchars(addslashes($_POST['name']));
$ip = htmlspecialchars(addslashes($_POST['ip']));
$port = htmlspecialchars(addslashes($_POST['port']));
$cheat = htmlspecialchars(addslashes($_POST['cheat']));
$type = htmlspecialchars(addslashes($_POST['type']));
$author = htmlspecialchars(addslashes($_POST['author']));
if(empty($izpulnitel) or empty($pesen) or empty($text) or empty($link)){
//Това го показва, когато някой не е попълнил всички полета
echo "Попълни всички полета!";
}
else {
$query = mysql_query("INSERT into `servers` (`id`,`name`,`ip`,`port`,`cheat`,`type`,`author`) VALUES ('','$name','$ip','$port','$cheat','$type','$author' WHERE id = '$_GET[id]' ")
 or die(mysql_error());
//Това го показва, когато текста е добавен успешно
echo "Сървър е редактиран!";
echo "<meta http-equiv=Refresh content=0;url=admin.php>";
}
}
}
}
else {
$query = "SELECT * FROM `servers` ORDER BY id DESC";
$result=mysql_query($query);
while($row = mysql_fetch_array($result)) {
$id = $row['id'];
$name = $row['name'];
$ip = $row['ip'];
$port = $row['port'];
$cheat = $row['cheat'];
$type = $row['type'];
$author = $row['author'];

echo "<a href='admin.php?id=$id'><table align='center' bgcolor='' width='50%' border='1px'>
<tr>
<td  align='left' width='50%'>
$name <br />$ip:$port
</td>
<td align='left' width='30%'>
AC : $cheat
</td>
</td>
<td align='center' width='40%'>
<a href='info.php?id=$id'><font color=red>Инфо</font></a>
</td>
</tr>
</table><center>edit</a>
<a title=\"Изтрийте песента: $izpulnitel - $pesen\" href=\"javascript:;\"
onClick=\"cf=confirm('Сигурен ли сте че искате да изтриете песента: $izpulnitel - $pesen ?!?!');
if (cf)window.location='delserv.php?id=$id';
return false;\" valign='top'>Изтрий</a><br>";
}
}
?>
 
<?
require "conf.php";

if ($action == 'delete') {
$sql = mysql_query("DELETE FROM servers WHERE id = '$nom'") or die(mysql_error());
header("Location: admin.php");
}

if($_GET['id']){
$lyricid = $_GET['id'];
$query1 = "SELECT * FROM `servers` where id = '$lyricid'";
$result1=mysql_query($query1);
while($row = mysql_fetch_array($result1)) {
$id = $row['id'];
$name = $row['name'];
$ip = $row['ip'];
$port = $row['port'];
$cheat = $row['cheat'];
$type = $row['type'];
$author = $row['author'];
echo '
Име<br /><input name="name" value='.$name.' type="text" size="30" /><br />
Ип<br /><input name="ip" value='.$ip.' type="text" size="30" /><br />
Порт<br /><input name="port" value='.$port.' type="text" size="30" /><br>
Anti-Cheat<br />
<select name="cheat">
<option value="" selected="selected">Посочи</option>
<option value="Няма">Няма</option>
<option value="Cheating-Death">Cheating-Death</option>
<option value="MyAC">MyAC</option>
<option value="sXe Injected">sXe Injected</option>
<option value="HLGuard">HLGuard</option>
<option value="DonT Lie">DonT Lie</option>
<option value="Flex">Flex</option>
<option value="CSF">CSF</option>
<option value="Друг">Друг</option>
</select><br>

Тип<br />

<select name="type">
<option value="" selected="selected">Посочи</option>
<option value="Classic">Classic</option>
<option value="Hide N Seek">Hide N Seek</option>
<option value="Kreedz">Kreedz</option>
<option value="Warcraft 3 / FT">Warcraft 3 / FT</option>
<option value="Zombie">Zombie</option>
<option value="Deathmatch">Deathmatch</option>
<option value="Cups">Cups</option>
<option value="5on5">5on5</option>
<option value="Massive">Massive</option>
<option value="Aim">Aim</option>
<option value="SuperHero">SuperHero</option>
<option value="GunGame">GunGame</option>
<option value="Deathrun">Deathrun</option>
<option value="PaintBall">PaintBall</option>
<option value="Respawn">Respawn</option>

</select><br>

Автор<br /><input name="author" value='.$author.' type="text" size="30" />
<br /><br />
<input name="submit" type="submit" value="Добави" />
</form>
';

if($_POST['editl']){
$name = htmlspecialchars(addslashes($_POST['name']));
$ip = htmlspecialchars(addslashes($_POST['ip']));
$port = htmlspecialchars(addslashes($_POST['port']));
$cheat = htmlspecialchars(addslashes($_POST['cheat']));
$type = htmlspecialchars(addslashes($_POST['type']));
$author = htmlspecialchars(addslashes($_POST['author']));
if(empty($izpulnitel) or empty($pesen) or empty($text) or empty($link)){
//Това го показва, когато някой не е попълнил всички полета
echo "Попълни всички полета!";
}
else {
$query = mysql_query("INSERT into `servers` (`id`,`name`,`ip`,`port`,`cheat`,`type`,`author`) VALUES ('','$name','$ip','$port','$cheat','$type','$author' WHERE id = '$_GET[id]' ")
or die(mysql_error());
//Това го показва, когато текста е добавен успешно
echo "Сървър е редактиран!";
echo "<meta http-equiv=Refresh content=0;url=admin.php>";
}
}
}
}
else {
$query = "SELECT * FROM `servers` ORDER BY id DESC";
$result=mysql_query($query);
$limit = 5 // broq na stranica;
$maxnum = mysql_num_rows($result);
if((int)$_GET['page']<0) {
$page = 0;
}
else {
$page = (int)$_GET['page'];
}
$maxpages = ceil($maxnum/$limit);
$sql = "SELECT * FROM `servers` ORDER BY id DESC LIMIT ".$limit*$page.", ".$limit."";
$rs=mysql_query($sql);
while($row = mysql_fetch_array($rs)) {
$id = $row['id'];
$name = $row['name'];
$ip = $row['ip'];
$port = $row['port'];
$cheat = $row['cheat'];
$type = $row['type'];
$author = $row['author'];

echo "<a href='admin.php?id=$id'><table align='center' bgcolor='' width='50%' border='1px'>
<tr>
<td align='left' width='50%'>
$name <br />$ip:$port
</td>
<td align='left' width='30%'>
AC : $cheat
</td>
</td>
<td align='center' width='40%'>
<a href='info.php?id=$id'><font color=red>Инфо</font></a>
</td>
</tr>
</table><center>edit</a>
<a title=\"Изтрийте песента: $izpulnitel - $pesen\" href=\"javascript:;\"
onClick=\"cf=confirm('Сигурен ли сте че искате да изтриете песента: $izpulnitel - $pesen ?!?!');
if (cf)window.location='delserv.php?id=$id';
return false;\" valign='top'>Изтрий</a><br>";
}
echo 'Страници: ';
for($i=0;$i<$maxpages;$i++) {
echo "[ <a href='?page=$i'> $i </a> ]";
}
}
?>
 
тук ми дава грешка
Код:
$limit = 5 // broq na stranica;
$maxnum = mysql_num_rows($result);
if((int)$_GET['page']<0) {

Parse error: syntax error, unexpected T_VARIABLE in D:\AppServ\www\admin\admin.php on line 158

демек 158  ред е 
$maxnum = mysql_num_rows($result);
 
Така?
Код:
<?php
require "conf.php";

if ($action == 'delete') {
$sql = mysql_query("DELETE FROM servers WHERE id = '$nom'") or die(mysql_error());
header("Location: admin.php");
}

if($_GET['id']){
$lyricid = $_GET['id'];
$query1 = "SELECT * FROM `servers` where id = '$lyricid'";
$result1=mysql_query($query1);
while($row = mysql_fetch_array($result1)) {
$id = $row['id'];
$name = $row['name'];
$ip = $row['ip'];
$port = $row['port'];
$cheat = $row['cheat'];
$type = $row['type'];
$author = $row['author'];
echo '
Име<br /><input name="name" value='.$name.' type="text" size="30" /><br />
Ип<br /><input name="ip" value='.$ip.' type="text" size="30" /><br />
Порт<br /><input name="port" value='.$port.' type="text" size="30" /><br>
Anti-Cheat<br />
<select name="cheat">
<option value="" selected="selected">Посочи</option>
<option value="Няма">Няма</option>
<option value="Cheating-Death">Cheating-Death</option>
<option value="MyAC">MyAC</option>
<option value="sXe Injected">sXe Injected</option>
<option value="HLGuard">HLGuard</option>
<option value="DonT Lie">DonT Lie</option>
<option value="Flex">Flex</option>
<option value="CSF">CSF</option>
<option value="Друг">Друг</option>
</select><br>

Тип<br />

<select name="type">
<option value="" selected="selected">Посочи</option>
<option value="Classic">Classic</option>
<option value="Hide N Seek">Hide N Seek</option>
<option value="Kreedz">Kreedz</option>
<option value="Warcraft 3 / FT">Warcraft 3 / FT</option>
<option value="Zombie">Zombie</option>
<option value="Deathmatch">Deathmatch</option>
<option value="Cups">Cups</option>
<option value="5on5">5on5</option>
<option value="Massive">Massive</option>
<option value="Aim">Aim</option>
<option value="SuperHero">SuperHero</option>
<option value="GunGame">GunGame</option>
<option value="Deathrun">Deathrun</option>
<option value="PaintBall">PaintBall</option>
<option value="Respawn">Respawn</option>

</select><br>

Автор<br /><input name="author" value='.$author.' type="text" size="30" />
<br /><br />
<input name="submit" type="submit" value="Добави" />
</form>
';

if($_POST['editl']){
$name = htmlspecialchars(addslashes($_POST['name']));
$ip = htmlspecialchars(addslashes($_POST['ip']));
$port = htmlspecialchars(addslashes($_POST['port']));
$cheat = htmlspecialchars(addslashes($_POST['cheat']));
$type = htmlspecialchars(addslashes($_POST['type']));
$author = htmlspecialchars(addslashes($_POST['author']));
if(empty($izpulnitel) or empty($pesen) or empty($text) or empty($link)){
//Това го показва, когато някой не е попълнил всички полета
echo "Попълни всички полета!";
}
else {
$query = mysql_query("INSERT into `servers` (`id`,`name`,`ip`,`port`,`cheat`,`type`,`author`) VALUES ('','$name','$ip','$port','$cheat','$type','$author' WHERE id = '$_GET[id]' ")
or die(mysql_error());
//Това го показва, когато текста е добавен успешно
echo "Сървър е редактиран!";
echo "<meta http-equiv=Refresh content=0;url=admin.php>";
}
}
}
}
else { 
$stranici = 10;
$pageNum = 1;
if(isset($_GET['page'])) {
$pageNum = $_GET['page']; }
$reds = ($pageNum - 1) * $stranici;
$query = mysql_query(" SELECT * FROM servers ORDER BY id DESC" . " LIMIT $reds, $stranici");
while ($row = mysql_fetch_array($query)) {
$id = $row['id'];
$name = $row['name'];
$ip = $row['ip'];
$port = $row['port'];
$cheat = $row['cheat'];
$type = $row['type'];
$author = $row['author']; 

echo "<a href='admin.php?id=$id'><table align='center' bgcolor='' width='50%' border='1px'>
<tr>
<td align='left' width='50%'>
$name <br />$ip:$port
</td>
<td align='left' width='30%'>
AC : $cheat
</td>
</td>
<td align='center' width='40%'>
<a href='info.php?id=$id'><font color=red>Инфо</font></a>
</td>
</tr>
</table><center>edit</a>
<a title=\"Изтрийте песента: $izpulnitel - $pesen\" href=\"javascript:;\"
onClick=\"cf=confirm('Сигурен ли сте че искате да изтриете песента: $izpulnitel - $pesen ?!?!');
if (cf)window.location='delserv.php?id=$id';
return false;\" valign='top'>Изтрий</a><br>"; 

}
$query = "SELECT COUNT(id) AS broi FROM servers";
$result = mysql_query($query);
$row = mysql_fetch_array($result, MYSQL_ASSOC);
$numrows = $row['broi'];
$maxPage = ceil($numrows/$stranici);
$self = $_SERVER['PHP_SELF'];
$nstranica = '';
for($page = 1; $page <= $maxPage; $page++) {
if ($page == $pageNum) {
$nstranica .= "<a href='#top'><b>$page</b></a> ";
}
else {
$nstranica .= " <a href=\"$self?page=$page\">$page</a>";
}
}
if ($pageNum > 1) {
$page = $pageNum - 1;
$pred = " <a href=\"$self?page=$page\"> <b>«</b> </a>";
}
else {
$pred = ' ';
}
if ($pageNum < $maxPage) {
$page = $pageNum + 1;
$sled = " <a href=\"$self?page=$page\"> <b>»</b> </a>";
}
else {
$sled = ' ';
}
echo "<br /><br />". $pred . $nstranica . $sled;
?>
 

Back
Горе