Странициране

M

mitaka961

Registered
Здравейте имам една система за новини която притежава странициране.Съвсем наскоро си намерих система за видео в която клипчетата се добавят с линк от вибокс.Обаче искам да направя странициране и там моля някой да ми помогне.Ето ви кодовете от индекса на news.php и video.php

News.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 = 5;//колко броя да изкарва на страница 
$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;
?>


video.php


Код: 
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1251" />
<title>ПФК ЦСКА София-Видео</title>
<link href="css.css" rel="stylesheet" type="text/css">
<link rel='shortcut icon' href='images/favicon.ico' type='image/xicon' />
</head>

<body>

<center>

<table width="900" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td>
   
   <table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td width="328" bgcolor="#FFFFFF"><img src="images/logo.png" border="0" alt="ЦСКА София"></img></td>
    <td align="right" bgcolor="#FFFFFF">     </img></a></td>
  </tr>
</table>
</tr>
</table>



<table width="922" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td width="11" height="61" class="menu_up_left"></td>
    <td id="menu" align="center"><? include "menu.php"; ?></td>
    <td width="11" height="61" class="menu_up_right"></td>
  </tr>
</table>

<table width="900" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td>


<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td class="midtable">
<table width="100%" border="0" cellspacing="0" cellpadding="20">
  <tr>
    <td valign="top" width="70%">
    
 
 
 <table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td height="35" class="uptable">Видео</td>
  </tr>
  <tr>
    <td class="downtable"><div align="justify">
<?php
include "configvideo.php";
?>
<?php
$sql = mysql_query("SELECT * FROM klips ORDER by id DESC LIMIT 0,512321321") or die (mysql_error());
echo "<center><table width='532' border='1'>";
echo "<tr><td>Снимка</td><td>Име</td><td>Източник</td><td>Преглеждания</td></tr>";
while($rowQ = mysql_fetch_assoc($sql))
{
$kategoria = mysql_fetch_assoc(mysql_query("SELECT * FROM cats WHERE id='$rowQ[kategoria]'"));
$kategoria = $kategoria['kategoria'];
if($rowQ['kategoria'] == 1)
{
?>
<tr><td bgcolor="#FF0000"></td>
<td bgcolor="#FF0000"><a href="youtube.php?id=<?=$rowQ['id']?>" style="color:white;"/><?=$rowQ['title']?></a></td>
<td bgcolor="#FF0000"><?=$kategoria?></td>
<td bgcolor="#FF0000"><?=$rowQ['views']?></td>
</tr>
<?php
}
else{
$number = explode(":", $rowQ['link']);
$i = substr($number[2],0 ,2);
if(@fopen("http://media.vbox7.com/s/$i/$number[2].flv","r"))
{
$url = "http://media.vbox7.com/s/$i/$number[2].flv";
}
elseif(@fopen("http://media02.vbox7.com/s/$i/$number[2].flv","r"))
{
$url = "http://media02.vbox7.com/s/$i/$number[2].flv";
}
elseif(@fopen("http://media03.vbox7.com/s/$i/$number[2].flv","r"))
{
$url = "http://media03.vbox7.com/s/$i/$number[2].flv";
}
elseif(@fopen("http://media04.vbox7.com/s/$i/$number[2].flv","r"))
{
$url = "http://media04.vbox7.com/s/$i/$number[2].flv";
}
elseif(@fopen("http://media05.vbox7.com/s/$i/$number[2].flv","r"))
{
$url = "http://media05.vbox7.com/s/$i/$number[2].flv";
}
elseif(@fopen("http://media06.vbox7.com/s/$i/$number[2].flv","r"))
{
$url = "http://media06.vbox7.com/s/$i/$number[2].flv";
}
elseif(@fopen("http://media07.vbox7.com/s/$i/$number[2].flv","r"))
{
$url = "http://media07.vbox7.com/s/$i/$number[2].flv";
}
elseif(@fopen("http://media08.vbox7.com/s/$i/$number[2].flv","r"))
{
$url = "http://media08.vbox7.com/s/$i/$number[2].flv";
}
elseif(@fopen("http://media09.vbox7.com/s/$i/$number[2].flv","r"))
{
$url = "http://media09.vbox7.com/s/$i/$number[2].flv";
}
elseif(@fopen("http://media10.vbox7.com/s/$i/$number[2].flv","r"))
{
$url = "http://media10.vbox7.com/s/$i/$number[2].flv";
}
elseif(@fopen("http://media11.vbox7.com/s/$i/$number[2].flv","r"))
{
$url = "http://media11.vbox7.com/s/$i/$number[2].flv";
}
elseif(@fopen("http://media12.vbox7.com/s/$i/$number[2].flv","r"))
{
$url = "http://media12.vbox7.com/s/$i/$number[2].flv";
}
elseif(@fopen("http://media13.vbox7.com/s/$i/$number[2].flv","r"))
{
$url = "http://media13.vbox7.com/s/$i/$number[2].flv";
}
elseif(@fopen("http://media14.vbox7.com/s/$i/$number[2].flv","r"))
{
$url = "http://media14.vbox7.com/s/$i/$number[2].flv";
}
elseif(@fopen("http://media15.vbox7.com/s/$i/$number[2].flv","r"))
{
$url = "http://media15.vbox7.com/s/$i/$number[2].flv";
}
elseif(@fopen("http://media16.vbox7.com/s/$i/$number[2].flv","r"))
{
$url = "http://media16.vbox7.com/s/$i/$number[2].flv";
}
elseif(@fopen("http://media17.vbox7.com/s/$i/$number[2].flv","r"))
{
$url = "http://media17.vbox7.com/s/$i/$number[2].flv";
}
list($width, $height, $type, $attr) = getimagesize("http://i47.vbox7.com/p/$number[2]3.jpg");
$string = file_get_contents($rowQ['link']);
$pet=explode('<title>',$string);
$edno=explode('</title>',$pet[1]);
?>
<tr><td bgcolor="#CCCCCC"><a href="view.php?id=<?=$rowQ['id']?>" style="color:red;"/><img src='http://i47.vbox7.com/p/<?=$number[2]?>3.jpg'></td>
<td bgcolor="#99CCCC"><a href="view.php?id=<?=$rowQ['id']?>" style="color:red;"/><?=$rowQ['title']?></a></td>
<td bgcolor="#00FFCC"><?=$kategoria?></td>
<td bgcolor="#66CCCC"><?=$rowQ['views']?></td>
</tr>
<?php
}
}
echo "</table>"; 

?>
</div></td>
  </tr>
</table><center>
<p> </p>
<p>  </p></td>
    <td valign="top" width="30%">    <? include "rightmenu.php"; ?><? include "pool.php"; ?><br><? include "stats.php"; ?></td>
  </tr>
</table>
    
    </td>
  </tr>
</table>



<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td width="10" height="45" class="menu_down_left"></td>
    <td class="menu_down">
    
    <table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr>
<? include "footer.php"; ?>
  </tr>
</table>

    </td>
    <td width="10" height="45" class="menu_down_right"></td>
  </tr>
</table>


    </td>
  </tr>
</table>

</center>

</body>

</html>

</body>
</html>

Новините имат странициране просто направете така че и video.php да се страницира.
Благодаря предварително. :)
 
Я пробвай така
PHP: 
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1251" />
<title>ПФК ЦСКА София-Видео</title>
<link href="css.css" rel="stylesheet" type="text/css">
<link rel='shortcut icon' href='images/favicon.ico' type='image/xicon' />
</head>

<body>

<center>

<table width="900" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td>
   
   <table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td width="328" bgcolor="#FFFFFF"><img src="images/logo.png" border="0" alt="ЦСКА София"></img></td>
    <td align="right" bgcolor="#FFFFFF">     </img></a></td>
  </tr>
</table>
</tr>
</table>



<table width="922" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td width="11" height="61" class="menu_up_left"></td>
    <td id="menu" align="center"><? include "menu.php"; ?></td>
    <td width="11" height="61" class="menu_up_right"></td>
  </tr>
</table>

<table width="900" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td>


<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td class="midtable">
<table width="100%" border="0" cellspacing="0" cellpadding="20">
  <tr>
    <td valign="top" width="70%">
   
 
 
 <table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td height="35" class="uptable">Видео</td>
  </tr>
  <tr>
    <td class="downtable"><div align="justify">
<?php
include "configvideo.php";
$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 klips"); 
$max = mysql_num_rows($redove);
$total = ceil($max/$pp); 								
$sql = mysql_query("SELECT * FROM klips ORDER by id DESC LIMIT $limit,$pp") or die (mysql_error());
$num = mysql_num_rows($sql); 
mysql_close(); 
$i=0; 

echo "<center><table width='532' border='1'>";
echo "<tr><td>Снимка</td><td>Име</td><td>Източник</td><td>Преглеждания</td></tr>";
while($rowQ = mysql_fetch_assoc($sql))
{
$kategoria = mysql_fetch_assoc(mysql_query("SELECT * FROM cats WHERE id='$rowQ[kategoria]'"));
$kategoria = $kategoria['kategoria'];
if($rowQ['kategoria'] == 1)
{
?>
<tr><td bgcolor="#FF0000"></td>
<td bgcolor="#FF0000"><a href="youtube.php?id=<?=$rowQ['id']?>" style="color:white;"/><?=$rowQ['title']?></a></td>
<td bgcolor="#FF0000"><?=$kategoria?></td>
<td bgcolor="#FF0000"><?=$rowQ['views']?></td>
</tr>
<?php
}
else{
$number = explode(":", $rowQ['link']);
$i = substr($number[2],0 ,2);
if(@fopen("http://media.vbox7.com/s/$i/$number[2].flv","r"))
{
$url = "http://media.vbox7.com/s/$i/$number[2].flv";
}
elseif(@fopen("http://media02.vbox7.com/s/$i/$number[2].flv","r"))
{
$url = "http://media02.vbox7.com/s/$i/$number[2].flv";
}
elseif(@fopen("http://media03.vbox7.com/s/$i/$number[2].flv","r"))
{
$url = "http://media03.vbox7.com/s/$i/$number[2].flv";
}
elseif(@fopen("http://media04.vbox7.com/s/$i/$number[2].flv","r"))
{
$url = "http://media04.vbox7.com/s/$i/$number[2].flv";
}
elseif(@fopen("http://media05.vbox7.com/s/$i/$number[2].flv","r"))
{
$url = "http://media05.vbox7.com/s/$i/$number[2].flv";
}
elseif(@fopen("http://media06.vbox7.com/s/$i/$number[2].flv","r"))
{
$url = "http://media06.vbox7.com/s/$i/$number[2].flv";
}
elseif(@fopen("http://media07.vbox7.com/s/$i/$number[2].flv","r"))
{
$url = "http://media07.vbox7.com/s/$i/$number[2].flv";
}
elseif(@fopen("http://media08.vbox7.com/s/$i/$number[2].flv","r"))
{
$url = "http://media08.vbox7.com/s/$i/$number[2].flv";
}
elseif(@fopen("http://media09.vbox7.com/s/$i/$number[2].flv","r"))
{
$url = "http://media09.vbox7.com/s/$i/$number[2].flv";
}
elseif(@fopen("http://media10.vbox7.com/s/$i/$number[2].flv","r"))
{
$url = "http://media10.vbox7.com/s/$i/$number[2].flv";
}
elseif(@fopen("http://media11.vbox7.com/s/$i/$number[2].flv","r"))
{
$url = "http://media11.vbox7.com/s/$i/$number[2].flv";
}
elseif(@fopen("http://media12.vbox7.com/s/$i/$number[2].flv","r"))
{
$url = "http://media12.vbox7.com/s/$i/$number[2].flv";
}
elseif(@fopen("http://media13.vbox7.com/s/$i/$number[2].flv","r"))
{
$url = "http://media13.vbox7.com/s/$i/$number[2].flv";
}
elseif(@fopen("http://media14.vbox7.com/s/$i/$number[2].flv","r"))
{
$url = "http://media14.vbox7.com/s/$i/$number[2].flv";
}
elseif(@fopen("http://media15.vbox7.com/s/$i/$number[2].flv","r"))
{
$url = "http://media15.vbox7.com/s/$i/$number[2].flv";
}
elseif(@fopen("http://media16.vbox7.com/s/$i/$number[2].flv","r"))
{
$url = "http://media16.vbox7.com/s/$i/$number[2].flv";
}
elseif(@fopen("http://media17.vbox7.com/s/$i/$number[2].flv","r"))
{
$url = "http://media17.vbox7.com/s/$i/$number[2].flv";
}
list($width, $height, $type, $attr) = getimagesize("http://i47.vbox7.com/p/$number[2]3.jpg");
$string = file_get_contents($rowQ['link']);
$pet=explode('<title>',$string);
$edno=explode('</title>',$pet[1]);
?>
<tr><td bgcolor="#CCCCCC"><a href="view.php?id=<?=$rowQ['id']?>" style="color:red;"/><img src='http://i47.vbox7.com/p/<?=$number[2]?>3.jpg'></td>
<td bgcolor="#99CCCC"><a href="view.php?id=<?=$rowQ['id']?>" style="color:red;"/><?=$rowQ['title']?></a></td>
<td bgcolor="#00FFCC"><?=$kategoria?></td>
<td bgcolor="#66CCCC"><?=$rowQ['views']?></td>
</tr>
<?php
}
}
echo "</table>";
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>";
?>
</div></td>
  </tr>
</table><center>
<p> </p>
<p>  </p></td>
    <td valign="top" width="30%">    <? include "rightmenu.php"; ?><? include "pool.php"; ?><br><? include "stats.php"; ?></td>
  </tr>
</table>
   
    </td>
  </tr>
</table>



<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td width="10" height="45" class="menu_down_left"></td>
    <td class="menu_down">
   
    <table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr>
<? include "footer.php"; ?>
  </tr>
</table>

    </td>
    <td width="10" height="45" class="menu_down_right"></td>
  </tr>
</table>


    </td>
  </tr>
</table>

</center>

</body>

</html>

</body>
</html>
 
Трябва да си влезнал или регистриран, за да отговориш тук.

Back
Горе