Follow along with the video below to see how to install our site as a web app on your home screen.
Бележка: This feature may not be available in some browsers.
http://web-tourist.net/login/login/newsearch.php?wtsearch=n&newsearch=%D1%F2%F0%E0%ED%E8%F6%E8%F0%E0%ED%E5&x=0&y=0DirectX каза:Добър на всички. Някой ще може ли да ми даде един лек и кратък код за едно просто странициране от рода на 1 | 2 | 3 | 4 | 5 и т.н. Тия които съм пробвам в сайта или нито един от тях не работи или аз не правя нещо като хората ?!
<?php
$page = (int)$_GET['page'];
if($page == 0 || $page == NULL || $page < 0)
{
$page = 1;
}
$pp = 10; // По колко резултата да показва на страница
$start = ($page*$pp) - $pp;
$query = mysql_query("SELECT * FROM blanka "); // Смени името на таблицата с твоята
$broi = mysql_num_rows($query);
$total = ceil($broi/$pp);
$result = mysql_query("SELECT * FROM `blanka` ORDER BY id DESC LIMIT $start,$pp "); // Тук също сменяш името на таблицата
if (mysql_num_rows($result) > 0)
{
while ($row = mysql_fetch_array($result))
{
// Тук в ечото е това което ще страницираш оставил съм пример аз какво съм страницирал
$id = $row['id'];
$uname = $row['uname'];
$desc = $row['desc'];
$ip = long2ip($row['ip']);
$data = $row['added'];
$url = $desc;
if(preg_match("/youtube/si",$url)){
parse_str(parse_url($url, PHP_URL_QUERY ));
$id = $v;
echo"<iframe width="450" height="403" src="http://www.youtube.com/embed/'.$id.'?rel=0" frameborder="0" allowfullscreen></iframe>
<br>Добавено от: <a href='{$row['uname']}'>потребител</a><br /a><br /a>";
}
elseif(preg_match("/vbox7/si",$url)){
$id = end(explode('play:',$url));
echo"<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=8,0,0,0" width="450" height="403"><param name="movie" value="http://i47.vbox7.com/player/ext.swf?vid='.$id.'"><param name="quality" value="high"><embed src="http://i48.vbox7.com/player/ext.swf?vid='.$id.'" quality="high" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" width="450" height="403"></embed></object>
<br>Добавено от: <a href='{$row['uname']}'>потребител</a><br /a><br /a>";
}
}
}
//Тука можеш да си сложиш картинки на бутончетата или просто да им зададеш цвят за бекграунд, разгледай го със стиловете можеш да си играеш останалото не го пипай.
echo "<div id = 'STR' style = 'width:560px;'>";
if ($page > 1) {
$prev = ($page - 1);
echo "<a href=\"?page=$prev\" style=' margin-right:7px; margin-top:-1px; color:#666; text-decoration:none;'> Предишна </a> ";
}
else echo "<a style=' margin-right:7px; margin-top:-1px; color:#666; text-decoration:none; '>Предишна </a> ";
if (!$page or ($page > $total)) {
$page="1";
}
if ($total < 10) {
for($i=1 ; $i<=$total ; $i++) {
if ( ($page)==$i ) {
echo "<b style=' background: url(images/STR_ACTIVE.jpg) no-repeat; color:#666; padding-left:8px; padding-right:8px; padding-bottom:1px; '>$i</b> ";
}
else {
echo "<a style=' background: url(images/STR.jpg) no-repeat; color:#666; padding-left:8px; padding-right:8px; padding-bottom:1px; ' href=\"?page=".$i."\"><b>".$i."</b></a> ";
}
}
}
else {
for($i=1 ; $i<=3 ; $i++) {
if ( ($page)==$i ) {
echo "<b style='background: url(images/STR_ACTIVE.jpg) no-repeat; color:#666; padding-left:8px; padding-right:8px; padding-bottom:1px;'>$i</b> ";
}
else {
echo "<a style=' background: url(images/STR.jpg) no-repeat; color:#666; padding-left:8px; padding-right:8px; padding-bottom:1px;' href=\"?page=".$i."\">".$i."</a> ";
}
}
if ($page <= 3) {
if ($page == 3) echo "<a style=' background: url(images/STR.jpg) no-repeat; color:#666; padding-left:8px; padding-right:8px; padding-bottom:1px;' href=\"?page=4\">4</a> ";
echo "... ";
for ($i=$total-2; $i<=$total; $i++)
echo "<a style=' background: url(images/STR.jpg) no-repeat; color:#666; padding-left:8px; padding-right:8px; padding-bottom:1px;' href=\"?page=".$i."\">".$i."</a> ";
}
if ($page == 5) $parva.= "<a style=' background: url(images/STR.jpg) no-repeat; color:#666; padding-left:8px; padding-right:8px; padding-bottom:1px;' href=\"?page=4\">4</a> ";
if ( ($page == 4) or ($page == 5) ) {
for ($i=$page; $i<=$page+1; $i++) {
if ($page == $i) echo "<b style='background: url(images/STR_ACTIVE.jpg) no-repeat; color:#666; padding-left:8px; padding-right:8px; padding-bottom:1px;'>$i</b> ";
else echo "<a style=' background: url(images/STR.jpg) no-repeat; padding-left:8px; color:#666; padding-right:8px; padding-bottom:1px;' href=\"?page=".$i."\">".$i."</a> ";
}
echo "... ";
for ($i=$total-2; $i<=$total; $i++)
echo "<a style=' background: url(images/STR.jpg) no-repeat; padding-left:8px; color:#666; padding-right:8px; padding-bottom:1px;' 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 style='background: url(images/STR_ACTIVE.jpg) no-repeat; color:#666; padding-left:8px; padding-right:8px; padding-bottom:1px;'>$i</b> ";
else echo "<a style=' background: url(images/STR.jpg) no-repeat; color:#666; padding-left:8px; padding-right:8px; padding-bottom:1px; ' href=\"?page=".$i."\">".$i."</a> ";
}
echo "... ";
for ($i=$total-2; $i<=$total; $i++)
echo "<a style=' background: url(images/STR.jpg) no-repeat; padding-left:8px; color:#666; padding-right:8px; padding-bottom:1px; ' href=\"?page=".$i."\">".$i."</a> ";
}
if ( $page > ($total - 5) ) {
echo "... ";
for ($i=$total-5; $i<=$total; $i++) {
if ($page == $i) echo "<b style='background: url(images/STR_ACTIVE.jpg) no-repeat; color:#666; padding-left:8px; padding-right:8px; padding-bottom:1px;'>$i</b> ";
else echo "<a style=' background: url(images/STR.jpg) no-repeat; color:#666; padding-left:8px; padding-right:8px; padding-bottom:1px; ' href=\"?page=".$i."\">".$i."</a> ";
}
}
}
if ($page < $total) {
$next = ($page + 1);
echo "<a href=\"?page=$next\" style=' margin-left:7px; margin-top:-1px; color:#666; text-decoration:none;'> Следваща </a> ";
}
else echo "<a style=' margin-left:7px; margin-top:-1px; color:#666; text-decoration:none; '>Следваща </a>";
echo"</div>";
?>
<?php
require_once 'config.php';
require_once '_inc.php';
//add files to connect with the dbase
$query = mysql_query("SELECT * FROM `blanka` ORDER BY id DESC")or die(mysql_error()."<br />??????: ".__LINE__);
while($row = mysql_fetch_array($query)){
$id = $row['id'];
$uname = $row['uname'];
$desc = $row['desc'];
$ip = long2ip($row['ip']);
$data = $row['added'];
$url = $desc;
if(preg_match("/youtube/si",$url)){
parse_str(parse_url($url, PHP_URL_QUERY ));
$id = $v;
echo'<iframe width="450" height="403" src="http://www.youtube.com/embed/'.$id.'?rel=0" frameborder="0" allowfullscreen></iframe>';
echo "<br>Добавено от: <a href='{$row['uname']}'>потребител</a><br /a><br /a>";
}elseif(preg_match("/vbox7/si",$url)){
$id = end(explode('play:',$url));
echo'<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=8,0,0,0" width="450" height="403"><param name="movie" value="http://i47.vbox7.com/player/ext.swf?vid='.$id.'"><param name="quality" value="high"><embed src="http://i48.vbox7.com/player/ext.swf?vid='.$id.'" quality="high" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" width="450" height="403"></embed></object>' ;
echo "<br>Добавено от: <a href='{$row['uname']}'>потребител</a><br /a><br /a>";
}}
?>
<?php
include '_inc.php';
include 'config.php';
$page = (int)$_GET['page'];
if($page == 0 || $page == NULL || $page < 0)
{
$page = 1;
}
$pp = 10; // По колко резултата да показва на страница
$start = ($page*$pp) - $pp;
$query = mysql_query("SELECT * FROM blanka "); // Смени името на таблицата с твоята
$broi = mysql_num_rows($query);
$total = ceil($broi/$pp);
$result = mysql_query("SELECT * FROM `blanka` ORDER BY id DESC LIMIT $start,$pp "); // Тук също сменяш името на таблицата
if (mysql_num_rows($result) > 0)
{
while ($row = mysql_fetch_array($result))
{
$query = mysql_query("SELECT * FROM `blanka` ORDER BY id DESC")or die(mysql_error()."<br />??????: ".__LINE__);
while($row = mysql_fetch_array($query)){
$id = $row['id'];
$uname = $row['uname'];
$desc = $row['desc'];
$ip = long2ip($row['ip']);
$data = $row['added'];
$url = $desc;
if(preg_match("/youtube/si",$url)){
parse_str(parse_url($url, PHP_URL_QUERY ));
$id = $v;
echo'<iframe width="450" height="403" src="http://www.youtube.com/embed/'.$id.'?rel=0" frameborder="0" allowfullscreen></iframe>';
echo "<br>Добавено от: <a href='{$row['uname']}'>потребител</a><br /a><br /a>";
}elseif(preg_match("/vbox7/si",$url)){
$id = end(explode('play:',$url));
echo'<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=8,0,0,0" width="450" height="403"><param name="movie" value="http://i47.vbox7.com/player/ext.swf?vid='.$id.'"><param name="quality" value="high"><embed src="http://i48.vbox7.com/player/ext.swf?vid='.$id.'" quality="high" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" width="450" height="403"></embed></object>' ;
echo "<br>Добавено от: <a href='{$row['uname']}'>потребител</a><br /a><br /a>";
}}
}
}
//Тука можеш да си сложиш картинки на бутончетата или просто да им зададеш цвят за бекграунд, разгледай го със стиловете можеш да си играеш останалото не го пипай.
echo "<div id = 'STR' style = 'width:560px;'>";
if ($page > 1) {
$prev = ($page - 1);
echo "<a href=\"?page=$prev\" style=' margin-right:7px; margin-top:-1px; color:#666; text-decoration:none;'> Предишна </a> ";
}
else echo "<a style=' margin-right:7px; margin-top:-1px; color:#666; text-decoration:none; '>Предишна </a> ";
if (!$page or ($page > $total)) {
$page="1";
}
if ($total < 10) {
for($i=1 ; $i<=$total ; $i++) {
if ( ($page)==$i ) {
echo "<b style=' background: url(images/STR_ACTIVE.jpg) no-repeat; color:#666; padding-left:8px; padding-right:8px; padding-bottom:1px; '>$i</b> ";
}
else {
echo "<a style=' background: url(images/STR.jpg) no-repeat; color:#666; padding-left:8px; padding-right:8px; padding-bottom:1px; ' href=\"?page=".$i."\"><b>".$i."</b></a> ";
}
}
}
else {
for($i=1 ; $i<=3 ; $i++) {
if ( ($page)==$i ) {
echo "<b style='background: url(images/STR_ACTIVE.jpg) no-repeat; color:#666; padding-left:8px; padding-right:8px; padding-bottom:1px;'>$i</b> ";
}
else {
echo "<a style=' background: url(images/STR.jpg) no-repeat; color:#666; padding-left:8px; padding-right:8px; padding-bottom:1px;' href=\"?page=".$i."\">".$i."</a> ";
}
}
if ($page <= 3) {
if ($page == 3) echo "<a style=' background: url(images/STR.jpg) no-repeat; color:#666; padding-left:8px; padding-right:8px; padding-bottom:1px;' href=\"?page=4\">4</a> ";
echo "... ";
for ($i=$total-2; $i<=$total; $i++)
echo "<a style=' background: url(images/STR.jpg) no-repeat; color:#666; padding-left:8px; padding-right:8px; padding-bottom:1px;' href=\"?page=".$i."\">".$i."</a> ";
}
if ($page == 5) $parva.= "<a style=' background: url(images/STR.jpg) no-repeat; color:#666; padding-left:8px; padding-right:8px; padding-bottom:1px;' href=\"?page=4\">4</a> ";
if ( ($page == 4) or ($page == 5) ) {
for ($i=$page; $i<=$page+1; $i++) {
if ($page == $i) echo "<b style='background: url(images/STR_ACTIVE.jpg) no-repeat; color:#666; padding-left:8px; padding-right:8px; padding-bottom:1px;'>$i</b> ";
else echo "<a style=' background: url(images/STR.jpg) no-repeat; padding-left:8px; color:#666; padding-right:8px; padding-bottom:1px;' href=\"?page=".$i."\">".$i."</a> ";
}
echo "... ";
for ($i=$total-2; $i<=$total; $i++)
echo "<a style=' background: url(images/STR.jpg) no-repeat; padding-left:8px; color:#666; padding-right:8px; padding-bottom:1px;' 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 style='background: url(images/STR_ACTIVE.jpg) no-repeat; color:#666; padding-left:8px; padding-right:8px; padding-bottom:1px;'>$i</b> ";
else echo "<a style=' background: url(images/STR.jpg) no-repeat; color:#666; padding-left:8px; padding-right:8px; padding-bottom:1px; ' href=\"?page=".$i."\">".$i."</a> ";
}
echo "... ";
for ($i=$total-2; $i<=$total; $i++)
echo "<a style=' background: url(images/STR.jpg) no-repeat; padding-left:8px; color:#666; padding-right:8px; padding-bottom:1px; ' href=\"?page=".$i."\">".$i."</a> ";
}
if ( $page > ($total - 5) ) {
echo "... ";
for ($i=$total-5; $i<=$total; $i++) {
if ($page == $i) echo "<b style='background: url(images/STR_ACTIVE.jpg) no-repeat; color:#666; padding-left:8px; padding-right:8px; padding-bottom:1px;'>$i</b> ";
else echo "<a style=' background: url(images/STR.jpg) no-repeat; color:#666; padding-left:8px; padding-right:8px; padding-bottom:1px; ' href=\"?page=".$i."\">".$i."</a> ";
}
}
}
if ($page < $total) {
$next = ($page + 1);
echo "<a href=\"?page=$next\" style=' margin-left:7px; margin-top:-1px; color:#666; text-decoration:none;'> Следваща </a> ";
}
else echo "<a style=' margin-left:7px; margin-top:-1px; color:#666; text-decoration:none; '>Следваща </a>";
echo"</div>";
?>
echo "<div id = 'STR' style = 'width:560px;'>";
$get = $_GET;
$url = $_SERVER['PHP_SELF'] . '?' .
http_build_query($get);
if ($page > 1) {
$prev = ($page - 1);
echo "<a href=\"{$url}&page=$prev\" style=' margin-right:7px; margin-top:-1px; color:#666; text-decoration:none;'> Предишна </a> ";
}
else echo "<a style=' margin-right:7px; margin-top:-1px; color:#666; text-decoration:none; '>Предишна </a> ";
if (!$page or ($page > $total)) {
$page="1";
}
if ($total < 10) {
for($i=1 ; $i<=$total ; $i++) {
if ( ($page)==$i ) {
echo "<b style='background: url(images/STR_ACTIVE.jpg) no-repeat; color:#666; padding-left:8px; padding-right:8px; padding-bottom:1px;'>$i</b> ";
}
else {
echo "<a style=' background: url(images/STR.jpg) no-repeat; color:#666; padding-left:8px; padding-right:8px; padding-bottom:0px;' href=\"{$url}&page=".$i."\"><b>".$i."</b></a> ";
}
}
}
else {
for($i=1 ; $i<=3 ; $i++) {
if ( ($page)==$i ) {
echo "<b style='background: url(images/STR_ACTIVE.jpg) no-repeat; color:#666; padding-left:8px; padding-right:8px; padding-bottom:1px;'>$i</b> ";
}
else {
echo "<a style=' background: url(images/STR.jpg) no-repeat; color:#666; padding-left:8px; padding-right:8px; padding-bottom:0px; ' href=\"{$url}&page=".$i."\">".$i."</a> ";
}
}
if ($page <= 3) {
if ($page == 3) echo "<a style=' background: url(images/STR.jpg) no-repeat; color:#666; padding-left:8px; padding-right:8px; padding-bottom:0px;' href=\"{$url}&page=4\">4</a> ";
echo "... ";
for ($i=$total-2; $i<=$total; $i++)
echo "<a style=' background: url(images/STR.jpg) no-repeat; padding-left:8px; color:#666; padding-right:8px; padding-bottom:0px; ' href=\"{$url}&page=".$i."\">".$i."</a> ";
}
if ($page == 5) $parva.= "<a style=' background: url(images/STR.jpg) no-repeat; color:#666; padding-left:8px; padding-right:8px; padding-bottom:0px; ' href=\"{$url}&page=4\">4</a> ";
if ( ($page == 4) or ($page == 5) ) {
for ($i=$page; $i<=$page+1; $i++) {
if ($page == $i) echo "<b style='background: url(images/STR_ACTIVE.jpg) no-repeat; color:#666; padding-left:8px; padding-right:8px; padding-bottom:1px;'>$i</b> ";
else echo "<a style=' background: url(images/STR.jpg) no-repeat; padding-left:8px; color:#666; padding-right:8px; padding-bottom:0px;' href=\"{$url}&page=".$i."\">".$i."</a> ";
}
echo "... ";
for ($i=$total-2; $i<=$total; $i++)
echo "<a style=' background: url(images/STR.jpg) no-repeat; color:#666; padding-left:8px; padding-right:8px; padding-bottom:0px; ' href=\"{$url}&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 style='background: url(images/STR_ACTIVE.jpg) no-repeat; color:#666; padding-left:8px; padding-right:8px; padding-bottom:1px;'>$i</b> ";
else echo "<a style=' background: url(images/STR.jpg) no-repeat; padding-left:8px; color:#666; padding-right:8px; padding-bottom:0px; ' href=\"{$url}&page=".$i."\">".$i."</a> ";
}
echo "... ";
for ($i=$total-2; $i<=$total; $i++)
echo "<a style=' background: url(images/STR.jpg) no-repeat; color:#666; padding-left:8px; padding-right:8px; padding-bottom:0px; ' href=\"{$url}&page=".$i."\">".$i."</a> ";
}
if ( $page > ($total - 5) ) {
echo "... ";
for ($i=$total-5; $i<=$total; $i++) {
if ($page == $i) echo "<b style='background: url(images/STR_ACTIVE.jpg) no-repeat; color:#666; padding-left:8px; padding-right:8px; padding-bottom:1px;'>$i</b> ";
else echo "<a style=' background: url(images/STR.jpg) no-repeat; padding-left:8px; color:#666; padding-right:8px; padding-bottom:0px;' href=\"{$url}&page=".$i."\">".$i."</a> ";
}
}
}
if ($page < $total) {
$next = ($page + 1);
echo "<a href=\"{$url}&page=$next\" style=' margin-left:7px; margin-top:-1px; color:#666; text-decoration:none;'> Следваща </a> ";
}
else echo "<a style=' margin-left:7px; margin-top:-1px; color:#666; text-decoration:none; '>Следваща </a>";
echo"</div>";