4 реда на страница !

T

taneca

Registered
Искам да направя така, на страница да имам по 4 реда клипове и да се прави нова страница като са повече клипове... Ето кода, дано сте ме разбрали какво точно искам:

Код: 
<b><img src="images/new.gif"> >>> <a href="index.php?m=uploadvideo">Добави клип</a> <<< <img src="images/new.gif"></b><br><br>
<?php
$chars="set character set latin1";
mysql_query($chars);
$pp = "5";
//клипчета на страница
$table = "clips";

$total = mysql_result(mysql_query("SELECT COUNT(id) FROM $table "),0);
$numofpages = $total / $pp;
if (!isset($_GET['page'])) {
$page = 1;
}
else {
$page = $_GET['page'];
}
$limitvalue = $page * $pp - ($pp);

echo"<table align=\"center\" border=\"1\">";

$i="0";
$nared="4";
$query="SELECT * FROM $table ORDER BY id DESC";
$result=mysql_query($query);
while ( $r = mysql_fetch_array( $result )){
$i++;
$width=ceil(100/$nared);
$ime=$r[ime];
$pic=$r[pic];
$klik=$r[klik];
if (strlen($ime)>16)
{$t='...';}
$ime = substr($ime,0,16);
echo"<td width=\"130\" align=\"center\" border=\"1\" background=\"images/b.gif\">
<a href=\"index.php?m=viewvideo&id=$r[id]\" onmouseover=\"return overlib('$r[ime]')\" onmouseout=\"return nd();\"><img src=\"$pic\" border=\"0\" width=\"140\" height=\"100\"></div><br><b>$ime$t</a>";
if ($i==$nared)
{
echo "</tr>
<tr>";
$i=0;
}
}
echo"</table>"; ?>
 
Код: 
<b><img src="images/new.gif"> >>> <a href="index.php?m=uploadvideo">Добави клип</a> <<< <img src="images/new.gif"></b><br><br>
<?php
$chars="set character set latin1";
mysql_query($chars);
$pp = "4"; // <-----
//клипчета на страница
$table = "clips";

$total = mysql_result(mysql_query("SELECT COUNT(id) FROM $table "),0);
$numofpages = $total / $pp;
if (!isset($_GET['page'])) {
$page = 1;
}
else {
$page = $_GET['page'];
}
$limitvalue = $page * $pp - ($pp);

echo"<table align=\"center\" border=\"1\">";

$i="0";
$nared="4";
$query="SELECT * FROM $table ORDER BY id DESC";
$result=mysql_query($query);
while ( $r = mysql_fetch_array( $result )){
$i++;
$width=ceil(100/$nared);
$ime=$r[ime];
$pic=$r[pic];
$klik=$r[klik];
if (strlen($ime)>16)
{$t='...';}
$ime = substr($ime,0,16);
echo"<td width=\"130\" align=\"center\" border=\"1\" background=\"images/b.gif\">
<a href=\"index.php?m=viewvideo&id=$r[id]\" onmouseover=\"return overlib('$r[ime]')\" onmouseout=\"return nd();\"><img src=\"$pic\" border=\"0\" width=\"140\" height=\"100\"></div><br><b>$ime$t</a>";
if ($i==$nared)
{
echo "</tr>
<tr>";
$i=0;
}
}
echo"</table>"; ?>
:?
 
Код: 
<?php
$conn = mysql_connect('localhost', 'root', '1234567890') or die("Грешка! Моля съобщете на администраторите!");
$rez = mysql_select_db('test', $conn) or die("Грешка! Моля съобщете на администраторите!");

$the_limit = "4";
$the_query = "SELECT * FROM clips order by id";
$listed = "";
$listed_end = "";

$page = trim($_GET['page']);
if(is_numeric($page)){
$page = $page * $the_limit;
if( (!$page) or ($page == "0") ){
$a = "0";
$b = $the_limit;
} else {
$a = $page;
$b = $a + $the_limit;
}
} else {
$a = "0";
$b = $the_limit;
}


$query = $the_query." limit $a, $the_limit";
$result = mysql_query($query, $conn) or die (mysql_error());
$result_all = mysql_query($the_query, $conn) or die (mysql_error());
$num_all = mysql_num_rows($result_all);
while($red = mysql_fetch_array($result)){
$listed.= $red['pic'].", ";
}
$num_pages = ceil($num_all / $the_limit);
for($i=0;$i<$num_pages;$i++){
$name = $i;
$name++;
if($name != $num_pages){
$last = " | ";
} else $last = "";


$pages.= "<a href=\"?page=".$i."\">".$name."</a>".$last;
}


echo "Показване на резултати от ".$a." до ".$b."<br /><br />";
echo $listed.$listed_end;
echo "<br /><br />";
echo $pages;
?>
Пробвай така. Кода е от урока на Soul_Stealler.
 
Аз да пробвам :P

Код: 
<b><img src="images/new.gif"> >>> <a href="index.php?m=uploadvideo">Добави клип</a> <<< <img src="images/new.gif"></b><br><br>
<?php
$chars="set character set latin1";
mysql_query($chars);
$pp = "5";
//клипчета на страница
$table = "clips";

$total = mysql_result(mysql_query("SELECT COUNT(id) FROM $table "),0);
$numofpages = $total / $pp;
if (!isset($_GET['page'])) {
$page = 1;
}
else {
$page = $_GET['page'];
}
$limitvalue = $page * $pp - ($pp);

echo"<table align=\"center\" border=\"1\">";

$i = 0;
echo "<tr>";
$query="SELECT * FROM $table ORDER BY id DESC";
$result=mysql_query($query);
while ( $r = mysql_fetch_array( $result )){
if($i%3 == 0 && $i != 0) {
echo "</tr><tr>";
}
$ime=$r[ime];
$pic=$r[pic];
$klik=$r[klik];
if (strlen($ime)>16)
{$t='...';}
$ime = substr($ime,0,16);
echo"<td width=\"130\" align=\"center\" border=\"1\" background=\"images/b.gif\">
<a href=\"index.php?m=viewvideo&id=$r[id]\" onmouseover=\"return overlib('$r[ime]')\" onmouseout=\"return nd();\"><img src=\"$pic\" border=\"0\" width=\"140\" height=\"100\"></div><br><b>$ime$t</a>";
$i++;
}
echo"</table>"; ?>
:?:
 
Пак не става, дава грешка:

Parse error: syntax error, unexpected '}' in /home/a3083472/public_html/modules/video/index.php on line 39
 
Код: 
<b><img src="images/new.gif"> >>> <a href="index.php?m=uploadvideo">Добави клип</a> <<< <img src="images/new.gif"></b><br><br>
<?php
$chars="set character set latin1";
mysql_query($chars);
$pp = "5";
//клипчета на страница
$table = "clips";

$total = mysql_result(mysql_query("SELECT COUNT(id) FROM $table "),0);
$numofpages = $total / $pp;
if (!isset($_GET['page'])) {
$page = 1;
}
else {
$page = $_GET['page'];
}
$limitvalue = $page * $pp - ($pp);

echo"<table align=\"center\" border=\"1\">";

$i = 0;
echo "<tr>";
$query="SELECT * FROM $table ORDER BY id DESC";
$result=mysql_query($query);
while ( $r = mysql_fetch_array( $result )){
if($i%3 == 0 && $i != 0) {
echo "</tr><tr>";
}
$ime=$r[ime];
$pic=$r[pic];
$klik=$r[klik];
if (strlen($ime)>16)
{$t='...';}
$ime = substr($ime,0,16);
echo"<td width=\"130\" align=\"center\" border=\"1\" background=\"images/b.gif\">
<a href=\"index.php?m=viewvideo&id=$r[id]\" onmouseover=\"return overlib('$r[ime]')\" onmouseout=\"return nd();\"><img src=\"$pic\" border=\"0\" width=\"140\" height=\"100\"></div><br><b>$ime$t</a>";
$i++;
}
echo"</table>"; ?>
:?:
 
Така ми ги дава на 7 реда по 3 колони, а аз искам да са максимум 5 реда с по 4 колони на страница :?
 
Код: 
<b><img src="images/new.gif"> >>> <a href="index.php?m=uploadvideo">Добави клип</a> <<< <img src="images/new.gif"></b><br><br>
<?php
$chars="set character set latin1";
mysql_query($chars);
$pp = "5";
//клипчета на страница
$table = "clips";

$total = mysql_result(mysql_query("SELECT COUNT(id) FROM $table "),0);
$numofpages = $total / $pp;
if (!isset($_GET['page'])) {
$page = 1;
}
else {
$page = $_GET['page'];
}
$limitvalue = $page * $pp - ($pp);

echo"<table align=\"center\" border=\"1\">";

$i = 0;
echo "<tr>";
$query="SELECT * FROM $table ORDER BY id DESC";
$result=mysql_query($query);
while ( $r = mysql_fetch_array( $result )){
if($i%4 == 0 && $i != 0) {
echo "</tr><tr>";
}
$ime=$r[ime];
$pic=$r[pic];
$klik=$r[klik];
if (strlen($ime)>16)
{$t='...';}
$ime = substr($ime,0,16);
echo"<td width=\"130\" align=\"center\" border=\"1\" background=\"images/b.gif\">
<a href=\"index.php?m=viewvideo&id=$r[id]\" onmouseover=\"return overlib('$r[ime]')\" onmouseout=\"return nd();\"><img src=\"$pic\" border=\"0\" width=\"140\" height=\"100\"></div><br><b>$ime$t</a>";
$i++;
}
echo"</table>"; ?>

:?:
 
Така е както искам 4 колони, но пак не са на максимум 5 реда и нова страница, а са много редове :( искам да е на страници с по 5 реда страницата...
 
Код: 
<b><img src="images/new.gif"> >>> <a href="index.php?m=uploadvideo">Добави клип</a> <<< <img src="images/new.gif"></b><br><br>
<?php
$chars="set character set latin1";
mysql_query($chars);
$pp = "5";
//клипчета на страница
$table = "clips";

$total = mysql_result(mysql_query("SELECT COUNT(id) FROM $table "),0);
$numofpages = $total / $pp;
if (!isset($_GET['page'])) {
$page = 1;
}
else {
$page = $_GET['page'];
}
$limitvalue = $page * $pp - ($pp);

echo"<table align=\"center\" border=\"1\">";

$i = 0;
echo "<tr>";
$query="SELECT * FROM $table ORDER BY id DESC LIMIT $limitvalue, $pp";
$result=mysql_query($query);
while ( $r = mysql_fetch_array( $result )){
if($i%4 == 0 && $i != 0) {
echo "</tr><tr>";
}
$ime=$r[ime];
$pic=$r[pic];
$klik=$r[klik];
if (strlen($ime)>16)
{$t='...';}
$ime = substr($ime,0,16);
echo"<td width=\"130\" align=\"center\" border=\"1\" background=\"images/b.gif\">
<a href=\"index.php?m=viewvideo&id=$r[id]\" onmouseover=\"return overlib('$r[ime]')\" onmouseout=\"return nd();\"><img src=\"$pic\" border=\"0\" width=\"140\" height=\"100\"></div><br><b>$ime$t</a>";
$i++;
}
echo"</table>"; ?>

:?:
 
Стана, направих го да показва по 20 клипа на страница и стана, само остава да направим да ги страницира...
 
Трябва да си влезнал или регистриран, за да отговориш тук.

Back
Горе