Съкратяване на РНР код

[Ozka]

Здравейте някой ще ми помогне ли да съкратим този код
за изкарване на резултатите от ДБ

<?php

if(!$ip and !$port){
$user = "username";
$pass = "password";
$db = "database";
$host = "localhost";
include"isonline.php";
$connection = mysql_connect($host, $user, $pass);
$db = mysql_select_db($db,$connection);
mysql_query('set names cp1251', $connection);
$pp = "45"; 

$page = addslashes(htmlspecialchars($_GET['page']));	

if(!$_GET['page'])
{
$page="1";
}

$limit = ($pp*$page)-$pp;
$table_name="servers";
$redove=mysql_query("SELECT * FROM $table_name"); 
$max=@mysql_num_rows($redove);
$total=ceil($max/$pp);
echo"<table width=\"100%\" style=\"border-collapse:collapse; border-color:#000\" border=\"1\" cellspacing=\"0\"  cellpadding=\"2\" align=\"center\">

<tr bgcolor=\"#FFCC00\" align=\"center\">
<td></td>
<td>Име</td>
<td>IP</td>
<td>Тип</td>
<td>Играчи</td>
<td>Карта</td>
<td>Статус</td>
</tr>"; 

$i="0"; 
$nared="4"; 
$query="SELECT * FROM $table_name ORDER BY `id` DESC LIMIT $limit,$pp"; 
$result=mysql_query($query); 
if($max==0){echo"Няма сървъри";}else{
$alternate = "2"; 
while ( $r = @mysql_fetch_array( $result )){ 
if ($alternate == "1") {

$colour = "#CCCCCC"; 
$alternate = "2";
}

else {
$colour = "#FFFFFF";
$alternate = "1"; 
}
$ip=$r[ipurl];
$port=$r[pburl];
$adres=str_replace(' ','',$adres);
list($mapname,$players,$maxplayers,$isonline,$password,$hostname) = serverinfo($ip,$port);
$map = $mapname;
$players = "$players/$maxplayers";
$status = $isonline;
$map = wordwrap($map, 13, "\n", true);

echo"<tr>
<td style=\"background: $colour;\"><img src=\"lgsl/lgsl_files/icons/source/cstrike.gif\" align=\"top\" alt=\"Counter Strike 1.6 Servers\" /></td>
<td style=\"background: $colour;\"><a><b>$r[ime]</b></a><br /></td>
<td style=\"background: $colour;\"><b>$r[ipurl]:$r[pburl]</b><br /></td>
<td style=\"background: $colour;\" align=\"center\">$r[type]</td>
<td style=\"background: $colour;\" align=\"center\">$players</td>
<td style=\"background: $colour;\" align=\"center\">$map</td>
<td style=\"background: $colour;\" align=\"center\"><img alt=\"\" src=\"forum/styles/subsilver2/imageset/bg/icon_user_".$status.".png\" /></td>
</tr>"; 

} 
}
echo"</table>";
}

?>

Благодаря!

 

[proba]

По-къс от това немога да го направя:

<?php
if(!$ip and !$port){
include "isonline.php";
mysql_connect("localhost", "username", "password");
mysql_select_db("database");
mysql_query('set names cp1251', $connection);
$pp = "45";
$page = addslashes(htmlspecialchars($_GET['page']));
if(!$_GET['page'])
{
$page="1";
}
$limit = ($pp*$page)-$pp;
$redove=mysql_query("SELECT * FROM servers");
$max=@mysql_num_rows($redove);
$total=ceil($max/$pp);
echo"<table width=\"100%\" style=\"border-collapse:collapse; border-color:#000\" border=\"1\" cellspacing=\"0\" cellpadding=\"2\" align=\"center\">
<tr bgcolor=\"#FFCC00\" align=\"center\">
<td></td>
<td>Име</td>
<td>IP</td>
<td>Тип</td>
<td>Играчи</td>
<td>Карта</td>
<td>Статус</td>
</tr>";
$i="0";
$nared="4";
$result=mysql_query("SELECT * FROM servers ORDER BY `id` DESC LIMIT $limit,$pp");
if($max==0){echo"Няма сървъри";}else{
$alternate = "2";
while ( $r = @mysql_fetch_array( $result )){
if ($alternate == "1") {
$colour = "#CCCCCC";
$alternate = "2";
}
else {
$colour = "#FFFFFF";
$alternate = "1";
}
$ip=$r['ipurl'];
$port=$r['pburl'];
$adres=str_replace(' ','',$adres);
list($mapname,$players,$maxplayers,$isonline,$password,$hostname) = serverinfo($ip,$port);
$map = $mapname;
$players = "$players/$maxplayers";
$status = $isonline;
$map = wordwrap($map, 13, "\n", true);
echo"<tr>
<td style=\"background: $colour;\"><img src=\"lgsl/lgsl_files/icons/source/cstrike.gif\" align=\"top\" alt=\"Counter Strike 1.6 Servers\" /></td>
<td style=\"background: $colour;\"><a><b>$r[ime]</b></a><br /></td>
<td style=\"background: $colour;\"><b>$r[ipurl]:$r[pburl]</b><br /></td>
<td style=\"background: $colour;\" align=\"center\">$r[type]</td>
<td style=\"background: $colour;\" align=\"center\">$players</td>
<td style=\"background: $colour;\" align=\"center\">$map</td>
<td style=\"background: $colour;\" align=\"center\"><img alt=\"\" src=\"forum/styles/subsilver2/imageset/bg/icon_user_".$status.".png\" /></td>
</tr>";
}
}
echo"</table>";
}
?>

 

[relax15pyt]

Защо ти е да го съкратяваш? Съкратения код после ще го четеш много трудно. Най-добре го подреди както трябва.

И защо числови стойности ги предавате като стринг ?

$i = "0"; ?

Числови стойности се подават по този начин

$i = 0;