Проблем с PHP Код

mitaka961 · 25 Януари 2011

Здравейте значи преди време пуснах тема дали някой може да ми направи странициране на новините,но бързо разбрах че няма да намеря такъв човек и минах към план "Б".А той е един урок от http://www.videotutorials-bg.com/lessons.php?action=search&id=&t=446 . Като за начало добре се справях до 5:40мин. в клипа където трябва да се изкарат линковете "Предишна" и "Следваща" страница.Обаче като вкарам кода:

Код:

$prev = $page - 1;
$next = $page +1;
if($page == 1)
{
   print "Предишна ";
}

else

{
   print "<a href='?page=$prev'>Предишна</a>
} ?>

Във index.php

Код:

<?
session_start();
include("conn.php");
?><head>
<link href="css.css" rel="stylesheet" type="text/css">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1251">
</head>
<?php $page = (int)$_GET['page'];
if ($page == 0 || $page ==NULL || $page < 0)
{
  $page =1;
}
$pp = 2;
$start = ($page*$pp) - $pp; 
$query = mysql_query("SELECT * FROM novini") or die (mysql_error () ) ;
$broi = mysql_num_rows($query); 
$total = ceil($broi/$pp); ?>

<?
$sql = "SELECT * FROM novini ORDER BY id DESC LIMIT $start,$pp";
$do = mysql_query($sql);
while ($row = mysql_fetch_array($do)) {
$newstext = $row['newstext'];
$newsauthor = $row['newsauthor'];
$newsname = $row['newsname'];
$id = $row['id'];

$prev = $page - 1;
$next = $page +1;
if($page == 1)
{
   print "Предишна ";
}

else

{
   print "<a href='?page=$prev'>Предишна</a>";
} ?>

if($_SESSION['admin']) { $edit = "<a href='admin.php?act=editnews&id=$id'>Промени новината</a><br><a href='admin.php?act=dellnews&id=$id'>Изтрий новината</a>"; }
echo "

<center><table border='0' width='580' id='table1' cellspacing='0' cellpadding='0'>
        <tr>

                <td id='title' align='center'>
                <table border='0' width='93%' id='table2' cellspacing='6' cellpadding='0'>
                        <tr>
                                <td>$newsname</td>
                        </tr>
                </table>
                </td>
        </tr>
        <tr>
                <td id='bg' align='center'><font size='3'>$newstext</font><br>$edit</td>
        </tr>
        <tr>
                <td id='footer'></td>
        </tr>
</table><center><br>
"; }
?>

Вижте какво се получава бяла страница
http://cska-bg.info/news
Къде е грешката в кода?

nom3r1 · 25 Януари 2011

PHP:

<?php
session_start();
include("conn.php");
echo '<head>
<link href="css.css" rel="stylesheet" type="text/css">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1251">
</head>';
$page = (int)$_GET['page'];
if ($page == 0 || $page == NULL || $page < 0){
  $page =1;
}
	$pp = 2;
$start = ($page*$pp) - $pp;
$broi = mysql_num_rows(mysql_query("SELECT * FROM novini"));
$total = ceil($broi/$pp);
$query = mysql_query("SELECT * FROM novini ORDER BY id DESC LIMIT $start,$pp");
	$row = mysql_fetch_array($query);
	$newstext = $row['newstext'];
	$newsauthor = $row['newsauthor'];
	$newsname = $row['newsname'];
	$id = $row['id'];
	$prev = $page - 1;
	$next = $page +1;
	if($page == 1){
	   echo "Предишна ";
	} else {
	   echo "<a href='?page=$prev'>Предишна</a>";
	}
	if($_SESSION['admin']) {
		$edit = "<a href='admin.php?act=editnews&id=$id'>Промени новината</a><br><a href='admin.php?act=dellnews&id=$id'>Изтрий новината</a>";
	}
	echo "
	<center><table border='0' width='580' id='table1' cellspacing='0' cellpadding='0'>
			<tr>
					<td id='title' align='center'>
					<table border='0' width='93%' id='table2' cellspacing='6' cellpadding='0'>
							<tr>
									<td>$newsname</td>
							</tr>
					</table>
					</td>
			</tr>
			<tr>
					<td id='bg' align='center'><font size='3'>$newstext</font><br>$edit</td>
			</tr>
			<tr>
					<td id='footer'></td>
			</tr>
	</table><center><br>";
?>

Може да пробваш и този вариант:

PHP:

<?php
session_start();
include("conn.php");
echo '<head>
<link href="css.css" rel="stylesheet" type="text/css">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1251">
</head>';
$page = (int)$_GET['page'];
if ($page == 0 || $page == NULL || $page < 0){
  $page =1;
}
	$pp = 2;
$start = ($page*$pp) - $pp;
$broi = mysql_num_rows(mysql_query("SELECT * FROM novini"));
$total = ceil($broi/$pp);
$query = mysql_query("SELECT * FROM novini ORDER BY id DESC LIMIT $start,$pp");
	while ($row = mysql_fetch_array($query)) {
	$newstext = $row['newstext'];
	$newsauthor = $row['newsauthor'];
	$newsname = $row['newsname'];
	$id = $row['id'];
	if($_SESSION['admin']) {
		$edit = "<a href='admin.php?act=editnews&id=$id'>Промени новината</a><br><a href='admin.php?act=dellnews&id=$id'>Изтрий новината</a>";
	}
	echo "
	<center><table border='0' width='580' id='table1' cellspacing='0' cellpadding='0'>
			<tr>
					<td id='title' align='center'>
					<table border='0' width='93%' id='table2' cellspacing='6' cellpadding='0'>
							<tr>
									<td>$newsname</td>
							</tr>
					</table>
					</td>
			</tr>
			<tr>
					<td id='bg' align='center'><font size='3'>$newstext</font><br>$edit</td>
			</tr>
			<tr>
					<td id='footer'></td>
			</tr>
	</table><center><br>";
	}
	$prev = $page - 1;
	$next = $page +1;
	if($page == 1){
	   echo "Предишна ";
	} else {
	   echo "<a href='?page=$prev'>Предишна</a>";
	}
?>

kikity_94 · 25 Януари 2011

Този код

PHP:

$prev = $page - 1;
$next = $page +1;
if($page == 1)
{
   print "Предишна ";
}

else

{
   print "<a href='?page=$prev'>Предишна</a>
} ?>

Се слага извън цикъла while

mitaka961 · 25 Януари 2011

При първия код който си дава само текст предишна а при втория не ми изкарва новината

nom3r1 · 25 Януари 2011

PHP:

<?php
$broinastranica = 10;//колко броя да изкарва на страница 
$pageNum = 1; 
if(isset($_GET['page'])) { 
	$pageNum = $_GET['page'];
} 
$redove = ($pageNum - 1) * $broinastranica; 
$query = mysql_query(" SELECT * FROM `novini` ORDER BY id DESC" . " LIMIT $redove, $broinastranica"); 
while ($row = mysql_fetch_array($query)) { 
        $newstext = $row['newstext'];
        $newsauthor = $row['newsauthor'];
        $newsname = $row['newsname'];
        $id = $row['id'];
        if($_SESSION['admin']) {
                $edit = "<a href='admin.php?act=editnews&id=$id'>Промени новината</a><br><a href='admin.php?act=dellnews&id=$id'>Изтрий новината</a>";
        }
        echo "
        <center><table border='0' width='580' id='table1' cellspacing='0' cellpadding='0'>
                        <tr>
                                        <td id='title' align='center'>
                                        <table border='0' width='93%' id='table2' cellspacing='6' cellpadding='0'>
                                                        <tr>
                                                                        <td>$newsname</td>
                                                        </tr>
                                        </table>
                                        </td>
                        </tr>
                        <tr>
                                        <td id='bg' align='center'><font size='3'>$newstext</font><br>$edit</td>
                        </tr>
                        <tr>
                                        <td id='footer'></td>
                        </tr>
        </table><center><br>";
}
$query = mysql_query("SELECT COUNT(id) AS broi FROM novini") 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;
?>

mitaka961 · 25 Януари 2011

Ама кажи къде точно трябва да го сложа в индекса де

nom3r1 · 25 Януари 2011

Това ти е целия код:

PHP:

<?php
session_start();
include("conn.php");
echo '<head>
<link href="css.css" rel="stylesheet" type="text/css">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1251">
</head>';
$broinastranica = 10;//колко броя да изкарва на страница 
$pageNum = 1; 
if(isset($_GET['page'])) { 
        $pageNum = (int)$_GET['page'];
} 
$redove = ($pageNum - 1) * $broinastranica; 
$query = mysql_query(" SELECT * FROM `novini` ORDER BY id DESC" . " LIMIT $redove, $broinastranica"); 
while ($row = mysql_fetch_array($query)) { 
        $newstext = $row['newstext'];
        $newsauthor = $row['newsauthor'];
        $newsname = $row['newsname'];
        $id = $row['id'];
        if($_SESSION['admin']) {
                $edit = "<a href='admin.php?act=editnews&id=$id'>Промени новината</a><br><a href='admin.php?act=dellnews&id=$id'>Изтрий новината</a>";
        }
        echo "
        <center><table border='0' width='580' id='table1' cellspacing='0' cellpadding='0'>
                        <tr>
                                        <td id='title' align='center'>
                                        <table border='0' width='93%' id='table2' cellspacing='6' cellpadding='0'>
                                                        <tr>
                                                                        <td>$newsname</td>
                                                        </tr>
                                        </table>
                                        </td>
                        </tr>
                        <tr>
                                        <td id='bg' align='center'><font size='3'>$newstext</font><br>$edit</td>
                        </tr>
                        <tr>
                                        <td id='footer'></td>
                        </tr>
        </table><center><br>";
}
$query = mysql_query("SELECT COUNT(id) AS broi FROM novini") 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;
?>

mitaka961 · 25 Януари 2011

Еми едно и също не става и нестава и аз пробвах всекакви варианит и това но не става виж: http://cska-bg.info/news

nom3r1 · 25 Януари 2011

PHP:

<?php
session_start();
include("config.php");
echo '<head>
<link href="css.css" rel="stylesheet" type="text/css">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1251">
</head>';
$broinastranica = 10;//колко броя да изкарва на страница 
$pageNum = 1; 
if(isset($_GET['page'])) { 
        $pageNum = (int)$_GET['page'];
} 
$redove = ($pageNum - 1) * $broinastranica; 
$query = mysql_query(" SELECT * FROM `novini` ORDER BY id DESC" . " LIMIT $redove, $broinastranica"); 
while ($row = mysql_fetch_array($query)) { 
        $newstext = $row['newstext'];
        $newsauthor = $row['newsauthor'];
        $newsname = $row['newsname'];
        $id = $row['id'];
        if($_SESSION['admin']) {
                $edit = "<a href='admin.php?act=editnews&id=$id'>Промени новината</a><br><a href='admin.php?act=dellnews&id=$id'>Изтрий новината</a>";
        }
        echo "
        <center><table border='0' width='580' id='table1' cellspacing='0' cellpadding='0'>
                        <tr>
                                        <td id='title' align='center'>
                                        <table border='0' width='93%' id='table2' cellspacing='6' cellpadding='0'>
                                                        <tr>
                                                                        <td>$newsname</td>
                                                        </tr>
                                        </table>
                                        </td>
                        </tr>
                        <tr>
                                        <td id='bg' align='center'><font size='3'>$newstext</font><br>$edit</td>
                        </tr>
                        <tr>
                                        <td id='footer'></td>
                        </tr>
        </table><center><br>";
}
$query = mysql_query("SELECT COUNT(id) AS broi FROM novini") 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;
?>

Проблем с PHP Код

mitaka961

Registered

nom3r1

Registered

kikity_94

Registered

mitaka961

Registered

nom3r1

Registered

mitaka961

Registered

nom3r1

Registered

mitaka961

Registered

nom3r1

Registered