Изкарване по 5 картинки на ред

W

WildBeast

Registered
Не успях да се справя с това чудо.. Искам на 1 ред (в един <tr></tr>) да има по 5 <td></td>, в които да има по 5 различни резултата от ДБ и така колкото резултата има, толкова да се показват на долу, като на ред да има по 5. Ето кода, който съм написал до момента:

Код: 
<?php
$broinastranica = 10;
$pageNum = 1;

if(isset($_GET['page'])) {
$pageNum = (int)$_GET['page'];
}
$redove = ($pageNum - 1) * $broinastranica;
if($_GET['id']){
$getid = (int)$_GET['id'];
$mysql = mysql_query("SELECT * FROM renders WHERE id = $getid AND validate='yes'") or die('Error, query failed');
while($mysql = mysql_fetch_array($mysql)) {
extract($r);
}
} else {

function formatBytes($bytes, $precision = 2) {
    $units = array('B', 'KB', 'MB', 'GB', 'TB');
   
    $bytes = max($bytes, 0);
    $pow = floor(($bytes ? log($bytes) : 0) / log(1024));
    $pow = min($pow, count($units) - 1);
   
    $bytes /= pow(1024, $pow);
   
    return round($bytes, $precision) . ' ' . $units[$pow];
}
echo '<table cellpadding="2" cellspacing="2" border="0"';
$result = mysql_query("SELECT * FROM renders WHERE game = 'cs1.6' AND validate='yes' ORDER by id asc LIMIT $redove, $broinastranica") or die(mysql_error());
while($r = mysql_fetch_array($result)) {
extract($r);
if($r['downs']== 1){$txt="път";}else{$txt="пъти";}
list($width, $height) = getimagesize("renders/".$r[bigimage]."");
if (isset($_SESSION['user'])){
$picturelink = 'smallimage/'.$r[smallimage].'';
} else {
$picturelink = 'smallregimage/'.$r[smallregimage].'';
}
echo '<tr><td align="center" class="renders">
<a href="renders/'.$r[bigimage].'"><img src="'.$picturelink.'" alt="Снимка на Counter-Strike 1.6 рендер" width="220" height="200" border="0"></a><hr>
<div align="left">Големина: <b>'.formatBytes($r[size_bigimage]).'</b></div>
<div align="left">Размери: <b>'.$width.' x '.$height.'</b></div>
<div align="left">Изтеглен: <b>'.$r[downs].' '.$txt.'</b></div>
<div align="left">Дата: <b>'.$r[day].'</b></div>
<div align="left">Качил: <b>'.$r[uploader].'</b></div><br>
<div align="center"><b><a href="download.php?id='.$r[id].'">Изтегли</a></b></div><br>
</td></tr>

';
}
echo '</table>';
echo '<table cellpading="5" cellspacing="0" width="100%" align="center"><tr><td align="center">';
$query = "SELECT COUNT(id) AS numrows FROM renders where game = 'cs1.6'";
$result = mysql_query($query) or die('Error, query failed');
$row = mysql_fetch_array($result, MYSQL_ASSOC);
$numrows = $row['numrows'];
$maxPage = ceil($numrows/$broinastranica);
$self = $_SERVER['PHP_SELF'];
$nomeranastranici = '';
for($page = 1; $page <= $maxPage; $page++) {
if ($page == $pageNum) {
$nomeranastranici .= " <font color='' class='stranica'>$page</font> ";
} else {
$nomeranastranici .= " <a href=\"$self?page=$page\" class=\"stranici\">$page</a> ";
}
}
if ($pageNum > 1) {
$page = $pageNum - 1;
$predishna = " <a href=\"$self?page=$page\" class=\"stranici\">[««]</a> ";
$parva = " <a href=\"$self?page=1\" class=\"stranici\">[първа]</a> ";
} else {
$predishna = ' ';
$parva = ' ';
}
if ($pageNum < $maxPage) {
$page = $pageNum + 1;
$sledvashta = " <a href=\"$self?page=$page\" class=\"stranici\">[»»]</a> ";
$posledna = " <a href=\"$self?page=$maxPage\" class=\"stranici\">[последна]</a> ";
} else {
$sledvashta = ' ';
$posledna = ' ';
}
echo "$parva  $predishna  $nomeranastranici  $sledvashta  $posledna";
echo '</td></tr></table>';
}
?>
 
разгледай това, тук излизат по 3 на ред, редактирай си го както желаеш

Код: 
         <?php

$result = mysql_query ("SELECT id,title,color,poster FROM ekskurzii ORDER BY id DESC",$db) or die ("<p>Не може да се свърже с базата данни</p>");
$i=0;
$x=3;
echo '<table align=center border=0 cellpadding=0 cellspacing=0 width=580><tr>';
while ($myrow = mysql_fetch_array ($result)) {
   
   echo "<td>
   <br><table border=0 cellpadding=0 cellspacing=0>
   <td>
   <img src='template/$myrow[color]/1.png' style='float:left;'>
   </td>
  </tr>
 
  <tr>
    <td>
	<a href='vij_ekskurzii.php?id=$myrow[id]'>
	<img border=0 src='$myrow[poster]' width='175' alt='$myrow[title]' class='$myrow[color]'></a>
   </td>
  </tr>
 
  <tr>
    <td>
   <div class='$myrow[color]2'><div class='links'><a href='vij_ekskurzii.php?id=$myrow[id]' title='$myrow[title]'>$myrow[title]</a></div></div>
   </td>
   </tr></table></td>";
   
   $i = $i+1;
   
   if ($i==$x){
   
   echo '</tr><tr>';
   $i=0;
   }}
echo '</tr></table>';
           
?>
[/code]
 
<?php
$broinastranica = 10;
$pageNum = 1;

if(isset($_GET['page'])) {
$pageNum = (int)$_GET['page'];
}
$redove = ($pageNum - 1) * $broinastranica;
if($_GET['id']){
$getid = (int)$_GET['id'];
$mysql = mysql_query("SELECT * FROM renders WHERE id = $getid AND validate='yes'") or die('Error, query failed');
while($mysql = mysql_fetch_array($mysql)) {
extract($r);
}
} else {

function formatBytes($bytes, $precision = 2) {
$units = array('B', 'KB', 'MB', 'GB', 'TB');

$bytes = max($bytes, 0);
$pow = floor(($bytes ? log($bytes) : 0) / log(1024));
$pow = min($pow, count($units) - 1);

$bytes /= pow(1024, $pow);

return round($bytes, $precision) . ' ' . $units[$pow];
}
echo '<table cellpadding="2" cellspacing="2" border="0"';
$result = mysql_query("SELECT * FROM renders WHERE game = 'cs1.6' AND validate='yes' ORDER by id asc LIMIT $redove, $broinastranica") or die(mysql_error());
$i = 0;
echo "<tr>";
while($r = mysql_fetch_array($result)) {
if($i%5 == 0 && $i != 0) {
echo "</tr><tr>";
}
extract($r);
if($r['downs']== 1){$txt="път";}else{$txt="пъти";}
list($width, $height) = getimagesize("renders/".$r[bigimage]."");
if (isset($_SESSION['user'])){
$picturelink = 'smallimage/'.$r[smallimage].'';
} else {
$picturelink = 'smallregimage/'.$r[smallregimage].'';
}
echo '<tr><td align="center" class="renders">
<a href="renders/'.$r[bigimage].'"><img src="'.$picturelink.'" alt="Снимка на Counter-Strike 1.6 рендер" width="220" height="200" border="0"></a><hr>
<div align="left">Големина: <b>'.formatBytes($r[size_bigimage]).'</b></div>
<div align="left">Размери: <b>'.$width.' x '.$height.'</b></div>
<div align="left">Изтеглен: <b>'.$r[downs].' '.$txt.'</b></div>
<div align="left">Дата: <b>'.$r[day].'</b></div>
<div align="left">Качил: <b>'.$r[uploader].'</b></div><br>
<div align="center"><b><a href="download.php?id='.$r[id].'">Изтегли</a></b></div><br>
</td></tr>

';
$i++;
}
echo '</table>';
echo '<table cellpading="5" cellspacing="0" width="100%" align="center"><tr><td align="center">';
$query = "SELECT COUNT(id) AS numrows FROM renders where game = 'cs1.6'";
$result = mysql_query($query) or die('Error, query failed');
$row = mysql_fetch_array($result, MYSQL_ASSOC);
$numrows = $row['numrows'];
$maxPage = ceil($numrows/$broinastranica);
$self = $_SERVER['PHP_SELF'];
$nomeranastranici = '';
for($page = 1; $page <= $maxPage; $page++) {
if ($page == $pageNum) {
$nomeranastranici .= " <font color='' class='stranica'>$page</font> ";
} else {
$nomeranastranici .= " <a href=\"$self?page=$page\" class=\"stranici\">$page</a> ";
}
}
if ($pageNum > 1) {
$page = $pageNum - 1;
$predishna = " <a href=\"$self?page=$page\" class=\"stranici\">[««]</a> ";
$parva = " <a href=\"$self?page=1\" class=\"stranici\">[първа]</a> ";
} else {
$predishna = ' ';
$parva = ' ';
}
if ($pageNum < $maxPage) {
$page = $pageNum + 1;
$sledvashta = " <a href=\"$self?page=$page\" class=\"stranici\">[»»]</a> ";
$posledna = " <a href=\"$self?page=$maxPage\" class=\"stranici\">[последна]</a> ";
} else {
$sledvashta = ' ';
$posledna = ' ';
}
echo "$parva $predishna $nomeranastranici $sledvashta $posledna";
echo '</td></tr></table>';
}
?>
Увеличете...

Така ?
 
Трябва да си влезнал или регистриран, за да отговориш тук.

Back
Горе