Извеждане от Таблица

[haughtelf]

Трябвами с PHP да изведа от таблица zaglavie и tekst и да сложа и странициране ама нещо не става ще можетели да помогнете за едното от двете мерси

 

[lub4o]

За да извадиш резултата:
$sql = mysql_query("SELECT * FROM novini") or die (mysql_error());
while($row = mysql_fetch_assoc($sql)){
echo "Заглавие $row[title]<br />
Текст $row[tekst]";
}

Като в базата данни си правиш таблица примерно новини, и полета id,title,tekst

ето ти с странициране направо

<?php


$broinastranica = 3;
$pageNum = 1;
if(isset($_GET['page']))
{
$pageNum = $_GET['page'];
}
$redove = ($pageNum - 1) * $broinastranica;

$query = "SELECT COUNT(id) AS id FROM `novini`";
$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 .= " $page ";
}
else
{
$nomeranastranici .= " <a href=\"$self?page=$page\">$page</a> ";
}
}

if ($pageNum > 1)
{
$page = $pageNum - 1;
$predishna = " <font color=orange><a href=\"$self?page=$page\"> [<] </a></font> ";

$parva = " <font color=orange><a href=\"$self?page=1\">[първа]</a></font> ";
}
else
{
$predishna = ' ';
$parva = ' ';
}



echo "<center><font size=\"5\" color=\"black\">Файлове</font></center><hr color=\"black\">";

$query = mysql_query("SELECT * FROM `novini` ORDER BY `id` DESC LIMIT $redove, $broinastranica");
while($row = mysql_fetch_assoc($sql)){
echo "Заглавие $row[title]<br />
Текст $row[tekst]";
}
?>

 

[haughtelf]

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in

 

[lub4o]

<?php


$broinastranica = 3;
$pageNum = 1;
if(isset($_GET['page']))
{
$pageNum = $_GET['page'];
}
$redove = ($pageNum - 1) * $broinastranica;

$query = "SELECT COUNT(id) AS id FROM `novini`";
$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 .= " $page ";
}
else
{
$nomeranastranici .= " <a href=\"$self?page=$page\">$page</a> ";
}
}

if ($pageNum > 1)
{
$page = $pageNum - 1;
$predishna = " <font color=orange><a href=\"$self?page=$page\"> [<] </a></font> ";

$parva = " <font color=orange><a href=\"$self?page=1\">[първа]</a></font> ";
}
else
{
$predishna = ' ';
$parva = ' ';
}



echo "<center><font size=\"5\" color=\"black\">Файлове</font></center><hr color=\"black\">";

$query = mysql_query("SELECT * FROM `novini` ORDER BY `id` DESC LIMIT $redove, $broinastranica");
while($row = mysql_fetch_assoc($query)){
echo "Заглавие $row[title]<br />
Текст $row[tekst]";
}
?>

 

[haughtelf]

страницирането не работи

 

[lub4o]

Имаше малко грешки, ето този работи лично го тествах сега

<?php
include 'config.php';
$id = (int)$_GET['id'];
$broinastranica = 2;
$pageNum = 1;
if(isset($_GET['page']))
{
$pageNum = $_GET['page'];
}
$redove = ($pageNum - 1) * $broinastranica;

$query = mysql_query("SELECT COUNT(id) AS id FROM `novini`") or die (mysql_error());
$row = mysql_fetch_array($query);
$numrows = $row['id'];


$maxPage = ceil($numrows/$broinastranica);

$self = $_SERVER['PHP_SELF'];
$nomeranastranici = '';

for($page = 1; $page <= $maxPage; $page++)
{
if ($page == $pageNum)
{
$nomeranastranici .= " $page ";
}
else
{
$nomeranastranici .= " <a href=\"$self?page=$page\">$page</a> ";
}
}

if ($pageNum > 1)
{
$page = $pageNum - 1;
$predishna = " <font color=orange><a href=\"$self?page=$page\"> [<] </a></font> ";

$parva = " <font color=orange><a href=\"$self?page=1\">[първа]</a></font> ";
}
else
{
$predishna = ' ';
$parva = ' ';
}




$sql = mysql_query("SELECT * FROM novini ORDER BY id DESC LIMIT $redove, $broinastranica") or die(mysql_error());
echo "<center>";
while($row = mysql_fetch_assoc($sql)){
echo "
title: $row[title]<br />
novina: $row[opisanie]
<hr />
";

}

echo "stranica: $nomeranastranici";


?>