Странициране на код

haus · 27 Януари 2011

Искам да попитам може ли някои да ми страницира този код защото аз се пробвах но не успях ето код

Код:

<?php
$u = "index.php?a=u&id";
$query = "SELECT * FROM users WHERE id='$id'";
$result = mysql_query($query);
while($row=mysql_fetch_array($result)) {
$usersid= ($row['id']);
}
?> 
<?php
$sql = mysql_query("SELECT * FROM `news` order by `id` DESC limit 14") or die(mysql_error());
$i = 0;
echo "<table><tr><td>";

while($raw = mysql_fetch_array($sql)) {
$i += 1;
$zaglavie = ($raw['zaglavie']);
$content = nl2br($raw['content']);
$avtor = ($raw['avtor']);
$id = ($raw['idd']);
$go1=(mysql_query("SELECT imgr FROM users WHERE name='$avtor'"));
$img=$go1['img'];
echo "<div id='header5'>
<div><a href=\"$u=$id\" class='nad'><span class='u-of nw'>Автор - $avtor</span><b><br>$content</a></div></div>";


if($i == 1) { echo "</td><td>"; } else { $i = 0; echo "</td></tr><tr><td>"; }
}
echo "</td></tr></table>";
}
?>

Искам ако може да вади по 10 новини на страница

nom3r1 · 27 Януари 2011

PHP:

<?php
$u = "index.php?a=u&id";
$query = "SELECT * FROM users WHERE id='$id'";
$result = mysql_query($query);
while($row=mysql_fetch_array($result)) {
$usersid= ($row['id']);
}
$broinastranica = 10;//колко броя да изкарва на страница 
$pageNum = 1; 
if(isset($_GET['page'])) { 
        $pageNum = $_GET['page'];
} 
$redove = ($pageNum - 1) * $broinastranica; 
$query = mysql_query(" SELECT * FROM `news` ORDER BY id DESC" . " LIMIT $redove, $broinastranica"); 
while ($row = mysql_fetch_array($query)) { 
		$id = $row['idd'];
		$zaglavie = $row['zaglavie'];
		$avtor = $row['avtor'];
		$content = nl2br($row['content']);
		$go1 = mysql_query("SELECT imgr FROM `users` WHERE name='$avtor'");
		$img = $go1['img'];
		echo "<div id='header5'>
		<div><a href=\"$u=$id\" class='nad'><span class='u-of nw'>Автор - $avtor</span><b><br>$content</a></div></div>";
}
$query = mysql_query("SELECT COUNT(idd) AS broi FROM news") or die (mysql_error());  
$row = mysql_fetch_array($query, MYSQL_ASSOC); 
$numrows = $row['broi']; 
$maxPage = ceil($numrows/$broinastranica); 
$self = $_SERVER['PHP_SELF']; 
$nomeranastranici = ''; 
for($page = 1; $page <= $maxPage; $page++) { 
if ($page == $pageNum) {
        $nomeranastranici .= " <a href='#top'><b>$page</b></a> "; 
} else {
        $nomeranastranici .= " <a href=\"$self?page=$page\">$page</a> ";
}
} if ($pageNum > 1) {
        $page = $pageNum - 1; 
        predishna = " <a href=\"$self?page=$page\"> <b>«</b> </a> "; 
} else {
        $predishna = ' ';
} if ($pageNum < $maxPage) {
        $page = $pageNum + 1;
        $sledvashta = " <a href=\"$self?page=$page\"> <b>»</b> </a> ";
} else {
        $sledvashta = ' ';
}
echo "". $predishna . $nomeranastranici . $sledvashta;
?>

haus · 27 Януари 2011

Нищо не изкарва страницата изчезва

kikity_94 · 27 Януари 2011

PHP:

<?php
	$u = "index.php?a=u&id";
	$query = "SELECT * FROM users WHERE id='$id'";
	$result = mysql_query($query);
	while($row=mysql_fetch_array($result)) {
		$usersid= ($row['id']);
	}

	$pp = "10"; 
	$page = $_GET['page'];
	if(!$_GET['page']) { $page="1"; } 								
	$limit = ($pp*$page)-$pp;
	mysql_connect($dbHost, $dbUser, $dbPass)or die("1111"); 
	@mysql_select_db($dbName) or die("2222"); 
	$redove = mysql_query("SELECT * FROM users"); 
	$max = mysql_num_rows($redove);
	$total = ceil($max/$pp); 								
	$our = mysql_query("SELECT * FROM news ORDER BY user_id DESC LIMIT $limit,$pp");
	$num = mysql_num_rows($our); 
	mysql_close(); 
	$i=0; 
	$sql = mysql_query("SELECT * FROM `news` order by `id` DESC limit 14") or die(mysql_error());
	$i = 0;
	echo "<table><tr><td>";

	while($raw = mysql_fetch_array($sql)) {
		$i += 1;
		$zaglavie = ($raw['zaglavie']);
		$content = nl2br($raw['content']);
		$avtor = ($raw['avtor']);
		$id = ($raw['idd']);
		$go1=(mysql_query("SELECT imgr FROM users WHERE name='$avtor'"));
		$img=$go1['img'];
		echo "<div id='header5'>
		<div><a href=\"$u=$id\" class='nad'><span class='u-of nw'>Автор - $avtor</span><b><br>$content</a></div></div>";


		if($i == 1) { echo "</td><td>"; } else { $i = 0; echo "</td></tr><tr><td>"; }
	}
		if ($page > 1) {
		$prev = ($page - 1);
		echo "<a href=\"?page=$prev\"><font face=\"Trebuchet MS\">Предишна страница</font></a> ";
		}
		else echo "<font face=\"Trebuchet MS\">Предишна страница</font> ";

		if (!$page or ($page > $total)) {
		$page="1";
		}

		if ($total < 10) {
		for($i=1 ; $i<=$total ; $i++) {
		if ( ($page)==$i ) {
		echo "<b>$i</b> ";
		}
		else {
		echo "<a href=\"?page=".$i."\">".$i."</a> ";
		}
		}
		}
		else {
		for($i=1 ; $i<=3 ; $i++) {
		if ( ($page)==$i ) {
		echo "<b>$i</b> ";
		}
		else {
		echo "<a href=\"?page=".$i."\">".$i."</a> ";
		}
		}

		if ($page <= 3) {
		if ($page == 3) echo "<a href=\"?page=4\">4</a> ";
		echo "... ";
		for ($i=$total-2; $i<=$total; $i++)
		echo "<a href=\"?page=".$i."\">".$i."</a> ";
		}
		if ($page == 5) $parva.= "<a href=\"?page=4\">4</a> ";

		if ( ($page == 4) or ($page == 5) ) {
		for ($i=$page; $i<=$page+1; $i++) {
		if ($page == $i) echo "<b>$i</b> ";
		else echo "<a href=\"?page=".$i."\">".$i."</a> ";
		}
		echo "... ";
		for ($i=$total-2; $i<=$total; $i++)
		echo "<a href=\"?page=".$i."\">".$i."</a> ";
		}

		if ( ($page > 5) and ($page < ($total - 4)) ) {
		echo "... ";
		for ($i=$page-1; $i<=$page+1; $i++) {
		if ($page == $i) echo "<b>$i</b> ";
		else echo "<a href=\"?page=".$i."\">".$i."</a> ";
		}
		echo "... ";
		for ($i=$total-2; $i<=$total; $i++)
		echo "<a href=\"?page=".$i."\">".$i."</a> ";
		}

		if ( $page > ($total - 5) ) {
		echo "... ";
		for ($i=$total-5; $i<=$total; $i++) {
		if ($page == $i) echo "<b>$i</b> ";
		else echo "<a href=\"?page=".$i."\">".$i."</a> ";
		}
		}
		}

		if ($page < $total) {
		$next = ($page + 1);
		echo "<a href=\"?page=$next\"><font face=\"Trebuchet MS\">Следваща страница</font></a> ";
		}
		else echo "<font face=\"Trebuchet MS\">Следваща страница</font>"; 	
	echo "</td></tr></table>";

?>

исползвал съм страницирането на jooorooo
само си пригоди в таблицата и си оправи заявките ако има нещо

nom3r1 · 27 Януари 2011

PHP:

<?php
$u = "index.php?a=u&id";
$query = "SELECT * FROM users WHERE id='$id'";
$result = mysql_query($query);
while($row=mysql_fetch_array($result)) {
$usersid= ($row['id']);
}
$broinastranica = 10;//колко броя да изкарва на страница 
$pageNum = 1; 
if(isset($_GET['page'])) { 
        $pageNum = $_GET['page'];
} 
$redove = ($pageNum - 1) * $broinastranica; 
$query = mysql_query(" SELECT * FROM `news` ORDER BY idd DESC" . " LIMIT $redove, $broinastranica"); 
while ($row = mysql_fetch_array($query)) { 
                $id = $row['idd'];
                $zaglavie = $row['zaglavie'];
                $avtor = $row['avtor'];
                $content = nl2br($row['content']);
                $go1 = mysql_query("SELECT imgr FROM `users` WHERE name='$avtor'");
                $img = $go1['img'];
                echo "<div id='header5'>
                <div><a href=\"$u=$id\" class='nad'><span class='u-of nw'>Автор - $avtor</span><b><br>$content</a></div></div>";
}
$query = mysql_query("SELECT COUNT(idd) AS broi FROM news") or die (mysql_error());  
$row = mysql_fetch_array($query, MYSQL_ASSOC); 
$numrows = $row['broi']; 
$maxPage = ceil($numrows/$broinastranica); 
$self = $_SERVER['PHP_SELF']; 
$nomeranastranici = ''; 
for($page = 1; $page <= $maxPage; $page++) { 
if ($page == $pageNum) {
        $nomeranastranici .= " <a href='#top'><b>$page</b></a> "; 
} else {
        $nomeranastranici .= " <a href=\"$self?page=$page\">$page</a> ";
}
} if ($pageNum > 1) {
        $page = $pageNum - 1; 
        $predishna = " <a href=\"$self?page=$page\"> <b>«</b> </a> "; 
} else {
        $predishna = ' ';
} if ($pageNum < $maxPage) {
        $page = $pageNum + 1;
        $sledvashta = " <a href=\"$self?page=$page\"> <b>»</b> </a> ";
} else {
        $sledvashta = ' ';
}
echo "". $predishna . $nomeranastranici . $sledvashta;
?>

haus · 27 Януари 2011

и със двете изчезва страницата

nom3r1 · 27 Януари 2011

Дай структурата на таблицата, ако не стане кода по долу!

PHP:

<?php
$u = "index.php?a=u&id";
$broinastranica = 10;//колко броя да изкарва на страница 
$pageNum = 1; 
if(isset($_GET['page'])) { 
        $pageNum = $_GET['page'];
} 
$redove = ($pageNum - 1) * $broinastranica; 
$query = mysql_query(" SELECT * FROM `news` ORDER BY id DESC" . " LIMIT $redove, $broinastranica") or die(mysql_error());
while ($row = mysql_fetch_array($query)) { 
                $id = $row['id'];
                $zaglavie = $row['zaglavie'];
                $avtor = $row['avtor'];
                $content = nl2br($row['content']);
                $go1 = mysql_query("SELECT imgr FROM `users` WHERE name='$avtor'");
                $img = $go1['img'];
                echo "<div id='header5'>
                <div><a href=\"$u=$id\" class='nad'><span class='u-of nw'>Автор - $avtor</span><b><br>$content</a></div></div>";
}
$query = mysql_query("SELECT COUNT(id) AS broi FROM news") or die (mysql_error());  
$row = mysql_fetch_array($query, MYSQL_ASSOC); 
$numrows = $row['broi']; 
$maxPage = ceil($numrows/$broinastranica); 
$self = $_SERVER['PHP_SELF']; 
$nomeranastranici = ''; 
for($page = 1; $page <= $maxPage; $page++) { 
if ($page == $pageNum) {
        $nomeranastranici .= " <a href='#top'><b>$page</b></a> "; 
} else {
        $nomeranastranici .= " <a href=\"$self?page=$page\">$page</a> ";
}
} if ($pageNum > 1) {
        $page = $pageNum - 1; 
        $predishna = " <a href=\"$self?page=$page\"> <b>«</b> </a> "; 
} else {
        $predishna = ' ';
} if ($pageNum < $maxPage) {
        $page = $pageNum + 1;
        $sledvashta = " <a href=\"$self?page=$page\"> <b>»</b> </a> ";
} else {
        $sledvashta = ' ';
}
echo "". $predishna . $nomeranastranici . $sledvashta;
?>

haus · 27 Януари 2011

Извинявам се много дал съм малко по различен код ето го кода
и таблицата

Код:

<?php
$profile = "index.php?a=profile&id";
$query = "SELECT * FROM users WHERE id='$id'";
$result = mysql_query($query);
while($row=mysql_fetch_array($result)) {
$usersid= ($row['id']);
}
?> 
<?php
$sql = mysql_query("SELECT * FROM `vesnik` order by `id` DESC limit 14") or die(mysql_error());
$i = 0;
echo "<table><tr><td>";

while($raw = mysql_fetch_array($sql)) {
$i += 1;
$zaglavie = ($raw['zaglavie']);
$content = nl2br($raw['content']);
$avtor = ($raw['avtor']);
$id = ($raw['idd']);
$go1=(mysql_query("SELECT avatar FROM users WHERE name='$avtor'"));
$avatar=$go1['avatar'];
echo "<div id='header5'>
<div><a href=\"$profile=$id\" class='nad'><img width='50' height='50' src='$my[avatar]' alt='' 'float:center' border='0'/><br /><span class='u-of nw'>Автор - $avtor</span><b><br>$content</a></div></div>";


if($i == 1) { echo "</td><td>"; } else { $i = 0; echo "</td></tr><tr><td>"; }
}
echo "</td></tr></table>";
}
?>

Код:

CREATE TABLE `vesnik` (
  `id` int(11) NOT NULL auto_increment,
  `zaglavie` varchar(255) NOT NULL,
  `avtor` varchar(255) NOT NULL,
  `idd` varchar(255) NOT NULL,
  `content` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=31 ;

nom3r1 · 27 Януари 2011

PHP:

<?php
$profile = "index.php?a=profile&id";
$query = "SELECT * FROM users WHERE id='$id'";
$result = mysql_query($query);
while($row=mysql_fetch_array($result)) {
$usersid= ($row['id']);
}
$broinastranica = 10;//колко броя да изкарва на страница 
$pageNum = 1; 
if(isset($_GET['page'])) { 
        $pageNum = $_GET['page'];
} 
$redove = ($pageNum - 1) * $broinastranica; 
$query = mysql_query(" SELECT * FROM `vesnik` ORDER BY idd DESC" . " LIMIT $redove, $broinastranica") or die(mysql_error());
while ($row = mysql_fetch_array($query)) { 
		$zaglavie = $raw['zaglavie'];
		$content = nl2br($raw['content']);
		$avtor = $raw['avtor'];
		$id = $raw['idd'];
		$go1 = mysql_query("SELECT avatar FROM users WHERE name='$avtor'") or die(mysql_error());
		$avatar = $go1['avatar'];
			echo "<div id='header5'>
			<div><a href=\"$profile=$id\" class='nad'><img width='50' height='50' src='$my[avatar]' alt='' 'float:center' border='0'/><br />
			<span class='u-of nw'>Автор - $avtor</span><b><br>$content</a></div></div>";
}
$query = mysql_query("SELECT COUNT(idd) AS broi FROM vesnik") or die (mysql_error());  
$row = mysql_fetch_array($query, MYSQL_ASSOC); 
$numrows = $row['broi']; 
$maxPage = ceil($numrows/$broinastranica); 
$self = $_SERVER['PHP_SELF']; 
$nomeranastranici = ''; 
for($page = 1; $page <= $maxPage; $page++) { 
if ($page == $pageNum) {
        $nomeranastranici .= " <a href='#top'><b>$page</b></a> "; 
} else {
        $nomeranastranici .= " <a href=\"$self?page=$page\">$page</a> ";
}
} if ($pageNum > 1) {
        $page = $pageNum - 1; 
        $predishna = " <a href=\"$self?page=$page\"> <b>«</b> </a> "; 
} else {
        $predishna = ' ';
} if ($pageNum < $maxPage) {
        $page = $pageNum + 1;
        $sledvashta = " <a href=\"$self?page=$page\"> <b>»</b> </a> ";
} else {
        $sledvashta = ' ';
}
echo "". $predishna . $nomeranastranici . $sledvashta;
?>

haus · 27 Януари 2011

Parse error: syntax error, unexpected $end in

nom3r1 · 27 Януари 2011

PHP:

<?php
$profile = "index.php?a=profile&id";
$query2 = mysql_query("SELECT * FROM users WHERE id='$id'") or die(mysql_error());
while($row = mysql_fetch_array($query2)) {
	$usersid= $row['id'];
}
$broinastranica = 10;//колко броя да изкарва на страница 
$pageNum = 1; 
if(isset($_GET['page'])) {
        $pageNum = $_GET['page'];
} 
$redove = ($pageNum - 1) * $broinastranica; 
$query = mysql_query(" SELECT * FROM `vesnik` ORDER BY id DESC" . " LIMIT $redove, $broinastranica");
while ($row = mysql_fetch_array($query)) {
                $zaglavie = $raw['zaglavie'];
                $content = nl2br($raw['content']);
                $avtor = $raw['avtor'];
                $id = $raw['id'];
                $go1 = mysql_query("SELECT avatar FROM users WHERE name='$avtor'") or die(mysql_error());
                $avatar = $go1['avatar'];
                        echo "<div id='header5'>
                        <div><a href=\"$profile=$id\" class='nad'><img width='50' height='50' src='$avatar' alt='' 'float:center' border='0'/><br />
                        <span class='u-of nw'>Автор - $avtor</span><b><br>$content</a></div></div>";
}
$query = mysql_query("SELECT COUNT(id) AS broi FROM vesnik") or die (mysql_error());  
$row = mysql_fetch_array($query, MYSQL_ASSOC); 
$numrows = $row['broi']; 
$maxPage = ceil($numrows/$broinastranica); 
$self = $_SERVER['PHP_SELF']; 
$nomeranastranici = ''; 
for($page = 1; $page <= $maxPage; $page++) { 
if ($page == $pageNum) {
        $nomeranastranici .= " <a href='#top'><b>$page</b></a> "; 
} else {
        $nomeranastranici .= " <a href=\"$self?page=$page\">$page</a> ";
}
} if ($pageNum > 1) {
        $page = $pageNum - 1; 
        $predishna = " <a href=\"$self?page=$page\"> <b>«</b> </a> "; 
} else {
        $predishna = ' ';
} if ($pageNum < $maxPage) {
        $page = $pageNum + 1;
        $sledvashta = " <a href=\"$self?page=$page\"> <b>»</b> </a> ";
} else {
        $sledvashta = ' ';
}
echo "". $predishna . $nomeranastranici . $sledvashta;
?>

haus · 27 Януари 2011

Parse error: syntax error, unexpected $end in C:\AppServ\www\new\vestnik.php on line 49

nom3r1 · 27 Януари 2011

PHP:

<?php
$profile = "index.php?a=profile&id";
$query2 = mysql_query("SELECT * FROM users WHERE id='$id'") or die(mysql_error());
while($row = mysql_fetch_array($query2)) {
        $usersid= $row['id'];
}
$broinastranica = 10;//колко броя да изкарва на страница 
$pageNum = 1; 
if(isset($_GET['page'])) {
        $pageNum = $_GET['page'];
} 
$redove = ($pageNum - 1) * $broinastranica; 
$query = mysql_query(" SELECT * FROM `vesnik` ORDER BY id DESC" . " LIMIT $redove, $broinastranica");
while ($row = mysql_fetch_array($query)) {
                $zaglavie = $row['zaglavie'];
                $content = nl2br($row['content']);
                $avtor = $row['avtor'];
                $id = $row['id'];
                $go1 = mysql_query("SELECT avatar FROM users WHERE name='$avtor'") or die(mysql_error());
                $avatar = $go1['avatar'];
                        echo "<div id='header5'>
                        <div><a href=\"$profile=$id\" class='nad'><img width='50' height='50' src='$avatar' alt='' 'float:center' border='0'/><br />
                        <span class='u-of nw'>Автор - $avtor</span><b><br>$content</a></div></div>";
}
$query = mysql_query("SELECT COUNT(id) AS broi FROM vesnik") or die (mysql_error());  
$row = mysql_fetch_array($query, MYSQL_ASSOC); 
$numrows = $row['broi']; 
$maxPage = ceil($numrows/$broinastranica); 
$self = $_SERVER['PHP_SELF']; 
$nomeranastranici = ''; 
for($page = 1; $page <= $maxPage; $page++) { 
if ($page == $pageNum) {
        $nomeranastranici .= " <a href='#top'><b>$page</b></a> "; 
} else {
        $nomeranastranici .= " <a href=\"$self?page=$page\">$page</a> ";
}
} if ($pageNum > 1) {
        $page = $pageNum - 1; 
        $predishna = " <a href=\"$self?page=$page\"> <b>«</b> </a> "; 
} else {
        $predishna = ' ';
} if ($pageNum < $maxPage) {
        $page = $pageNum + 1;
        $sledvashta = " <a href=\"$self?page=$page\"> <b>»</b> </a> ";
} else {
        $sledvashta = ' ';
}
echo "". $predishna . $nomeranastranici . $sledvashta;
?>

haus · 27 Януари 2011

пак същото

Странициране на код

haus

Registered

nom3r1

Registered

haus

Registered

kikity_94

Registered

nom3r1

Registered

haus

Registered

nom3r1

Registered

haus

Registered

nom3r1

Registered

haus

Registered

nom3r1

Registered

haus

Registered

nom3r1

Registered

haus

Registered