Може ли да направите този код да се страницира ?

F

farzy

Registered
PHP: 
<?php
require("includes/smileys.php");
if(!defined('IN_PHPBB')) {
exit;
}
echo "<center>";
if(isset($_POST['submit']))
{

   if(!$user->data['is_registered']) {
   
    exit("За да пишеш в чата трябва да се регистрираш!");
   
    }

$chat = addslashes(htmlspecialchars($_POST['chat']));
$avtor = $user->data['username'];
$date = date("Y-m-d");
$ip = $_SERVER['REMOTE_ADDR'];
if($chat == null || $avtor == null)
{
echo 'Попълни полетата';

}else{
if( $_POST[''] )
{

}else{
$sql = mysql_query("INSERT INTO shoutbox (chat,avtor,date,ip) VALUES ('$chat','$avtor','$date','$ip')") or die (mysql_error());
echo 'Добавено';
echo "</center>";
}

}
}

?>

<?php if($user->data['is_registered']) { ?>
В чата се пише на кирилица!<br />
<form action='' method='post'>

<center>


<b>Текст:</b>
<br />
<textarea name='chat' rows='3' id='styled' cols='18' style="resize:vertical;"></textarea><br />

<input type='submit' name='submit' value='Публикувай' />
<input type='reset' name='submit' value='Изчисти' />

<script type="text/javascript">
 function addemo2(newemo){
 var emoid =  document.getElementById('styled').value;
 emoid = document.getElementById('styled').value+= newemo;
 document.getElementById('styled').focus();
 }
</script>

<script type="text/javascript">
function showContent(vThis)
{

// alert(vSibling.className + " " + vDef_Key);
vParent = vThis.parentNode;
vSibling = vParent.nextSibling;
while (vSibling.nodeType==3) { 
vSibling = vSibling.nextSibling;
};
if(vSibling.style.display == "none")
{
vThis.value = "Скрий емоций";
vSibling.style.display = "block";
} else {
vSibling.style.display = "none";
vThis.value = "Виж емоций";
}
return;
}
</script>



<script type="text/JavaScript">
function showlaptop(theTable)
{
if (document.getElementById(theTable).style.display == 'none')
{
document.getElementById(theTable).style.display = 'block';
}
}

function hidelaptop(theTable)
{
if (document.getElementById(theTable).style.display == 'none')
{
document.getElementById(theTable).style.display = 'none';
}
else
{
document.getElementById(theTable).style.display = 'none';
}
}
//-->
</script>



<div style="margin-bottom:2px">

<input type="button" value="Емоции и BBCodes" style="width:117px;font-size:10px;margin:0px;padding:0px;" 
onclick="if (this.parentNode.parentNode.getElementsByTagName('div')[1].getElementsByTagName('div')[0].style.display != '') 
{ 
this.parentNode.parentNode.getElementsByTagName('div')[1].getElementsByTagName('div')[0].style.display = '';
this.innerText = ''; this.value = 'Емоции и BBCodes'; 
} else {
 this.parentNode.parentNode.getElementsByTagName('div')[1].getElementsByTagName('div')[0].style.display = 'none'; 
this.innerText = ''; this.value = 'Емоции и BBCodes'; 
}">
</div>
	

<div style="margin: 0px; padding: 6px; border: 1px ;">
  <div style="display: none;">
  
  <a href="javascript:addemo2('[b][/b]');" title="[b][/b]" class="vtip">
<img src="images/bold.gif" border="0"></a>

<a href="javascript:addemo2('[i][/i]');" title="[i][/i]" class="vtip">
<img src="http://cms-bg.com/public/style_images/elegant-blue/rte_icons/italic.png" border="0"></a>

<a href="javascript:addemo2('[u][/u]');" title="[u][/u]" class="vtip">
<img src="http://cms-bg.com/public/style_images/elegant-blue/rte_icons/underline.png" border="0"></a>

<a href="javascript:addemo2('[s][/s]');" title="[s][/s]" class="vtip">
<img src="http://cms-bg.com/public/style_images/elegant-blue/rte_icons/strike.png" border="0"></a>

<a href="javascript:addemo2('[center][/center]');" title="[center][/center]" class="vtip">
<img src="http://cms-bg.com/public/style_images/elegant-blue/rte_icons/align_center.png" border="0"></a>




<a href="javascript:addemo2('[img][/img]');" title="[img][/img]" class="vtip">
<img src="http://cms-bg.com/public/style_images/elegant-blue/rte_icons/picture.png" border="0"></a>


<a href="javascript:addemo2(' (pilot)');" title="Пилот" class="vtip">
<img src="images/smiles/pilot.gif" border="0"></a>





<a href="javascript:addemo2(' (fuck)');" title="О да" class="vtip">
	<img src='images/smiles/fuck.gif'></a>

<a href="javascript:addemo2(' (yahoo)');" title="Ухаа" class="vtip">

	<img src='images/smiles/yahoo.gif'></a>

<a href="javascript:addemo2(' (rules)');" title="Чети правилата @" class="vtip">
	<img src='images/smiles/rules.gif'></a>

<a href="javascript:addemo2(' (vestnik)');" title="Чете вестник" class="vtip">
	<img src='images/smiles/read2.gif'></a>

<a href="javascript:addemo2(' (pisatel)');" title="Писател" class="vtip">
	<img src='images/smiles/mr47_05.gif'></a>

<a href="javascript:addemo2(' (nono)');" title="НеНеНе" class="vtip">
	<img src='images/smiles/nono.gif'></a>

<a href="javascript:addemo2(' (bg)');" title="Бг Флаг" class="vtip">
	<img src='images/smiles/bgflag.gif'></a>

<a href="javascript:addemo2(' (bravo)');" title="Браво ! Браво !" class="vtip">
	<img src='images/smiles/i_clapping.gif'></a>

<a href="javascript:addemo2(' (usernew)');" title="Нов потрабител" class="vtip">
	<img src='images/smiles/new-user.gif'></a>

<a href="javascript:addemo2(' (rofl)');" title="Хахаха" class="vtip">
	<img src='images/smiles/rlol.gif'></a>

<a href="javascript:addemo2(' (noi)');" title="Не бйх аз" class="vtip">
	<img src='images/smiles/notme2.gif'></a>

<a href="javascript:addemo2(' (welcome) ');" title="Добре дошъл" class="vtip">
	<img src='images/smiles/welcome.gif'></a>

<a href="javascript:addemo2(' (bigbos)');" title="Пошач" class="vtip">
	<img src='images/smiles/big_boss.gif'></a>

<a href="javascript:addemo2(' (crazy)');" title="Лудааак съъмммм" class="vtip">
	<img src='images/smiles/crazy.gif'></a>

<a href="javascript:addemo2(' (coffe)');" title="Сутрешен вестник и кафенце" class="vtip">
	<img src='images/smiles/csbg_sleepy_coffee.gif'></a>

<a href="javascript:addemo2(' (bira)');" title="Бира" class="vtip">
	<img src='images/smiles/drinks.gif'></a>

<a href="javascript:addemo2(' (fayer)');" title="Огъън" class="vtip">
	<img src='images/smiles/fa111.gif'></a>

<a href="javascript:addemo2(' (lovec)');" title="Ловеца" class="vtip">
	<img src='images/smiles/hunter.gif'></a>

<a href="javascript:addemo2(' (music)');" title="Свиркане" class="vtip">

	<img src='images/smiles/whistle.gif'></a>

<a href="javascript:addemo2(' (kickme)');" title="Кикни ме" class="vtip">
	<img src='images/smiles/kickme.gif'></a>

<a href="javascript:addemo2(' (king)');" title="Цар незнам си кой" class="vtip">
	<img src='images/smiles/king2.gif'></a>

<a href="javascript:addemo2(' (crys)');" title="Збогом" class="vtip">
	<img src='images/smiles/l_bye_boy.gif'></a>

<a href="javascript:addemo2(' (stroitel)');" title="Строител" class="vtip">
	<img src='images/smiles/moil.gif'> </a>


<a href="javascript:addemo2(' (star)');" title="Ударен по главата" class="vtip">
	<img src='images/smiles/stars.gif'> </a>


<a href="javascript:addemo2(' (tnx)');" title="Благодаря ти" class="vtip">
	<img src='images/smiles/tnx.gif'> </a>



<a href="javascript:addemo2(' (4itatel)');" title="Читател" class="vtip">
	<img src='images/smiles/Vishenka_30.gif'> </a>


</p>
  </div>
</div>
</center>


  <script type="text/javascript">
   function showStuff(id) {
      document.getElementById(id).style.display = 'block';
   }
   function hideStuff(id) {
      document.getElementById(id).style.display = 'none';
   }
</script>




</center>
<?php } else { ?>
<a href="forum/ucp.php?mode=register" >Регистирай</a> се или <a href="forum/ucp.php?mode=login" >влез</a> в акаунта си за да пишеш.</center>
</br />
<?php } ?>
</form>







<?php
$result = mysql_query("SELECT * FROM shoutbox ORDER BY id DESC  LIMIT 8") or die (mysql_error());
while($data = mysql_fetch_assoc($result)) {
echo str_replace($find_smileys, $replace_smileys, "<table align='center' style='border: 1px solid #e1e1e1; background: #fff;' width='100%'>
<tr style='border: 1px solid #e1e1e1; background: #fff;'>
<td align='left' style='background: #fff; font-size:10px;'>
 <img src='images/chat.gif' align='left' /><b><span style='font-size:10px; color: black'>$data[avtor]</span></b><br />
<b style='color:#ccc;'><span style='font-size:10px;'>$data[date]</span></b><br />
<span style='font-size:11px; color: black'>$data[chat]</span><br />
</td></tr></table>");
}


?>
 
Ето заповядай

PHP: 
<?php
require("includes/smileys.php");
if(!defined('IN_PHPBB')) {
exit;
}
echo "<center>";
if(isset($_POST['submit']))
{

   if(!$user->data['is_registered']) {
   
    exit("За да пишеш в чата трябва да се регистрираш!");
   
    }

$chat = addslashes(htmlspecialchars($_POST['chat']));
$avtor = $user->data['username'];
$date = date("Y-m-d");
$ip = $_SERVER['REMOTE_ADDR'];
if($chat == null || $avtor == null)
{
echo 'Попълни полетата';

}else{
if( $_POST[''] )
{

}else{
$sql = mysql_query("INSERT INTO shoutbox (chat,avtor,date,ip) VALUES ('$chat','$avtor','$date','$ip')") or die (mysql_error());
echo 'Добавено';
echo "</center>";
}

}
}

?>

<?php if($user->data['is_registered']) { ?>
В чата се пише на кирилица!<br />
<form action='' method='post'>

<center>


<b>Текст:</b>
<br />
<textarea name='chat' rows='3' id='styled' cols='18' style="resize:vertical;"></textarea><br />

<input type='submit' name='submit' value='Публикувай' />
<input type='reset' name='submit' value='Изчисти' />

<script type="text/javascript">
 function addemo2(newemo){
 var emoid =  document.getElementById('styled').value;
 emoid = document.getElementById('styled').value+= newemo;
 document.getElementById('styled').focus();
 }
</script>

<script type="text/javascript">
function showContent(vThis)
{

// alert(vSibling.className + " " + vDef_Key);
vParent = vThis.parentNode;
vSibling = vParent.nextSibling;
while (vSibling.nodeType==3) { 
vSibling = vSibling.nextSibling;
};
if(vSibling.style.display == "none")
{
vThis.value = "Скрий емоций";
vSibling.style.display = "block";
} else {
vSibling.style.display = "none";
vThis.value = "Виж емоций";
}
return;
}
</script>



<script type="text/JavaScript">
function showlaptop(theTable)
{
if (document.getElementById(theTable).style.display == 'none')
{
document.getElementById(theTable).style.display = 'block';
}
}

function hidelaptop(theTable)
{
if (document.getElementById(theTable).style.display == 'none')
{
document.getElementById(theTable).style.display = 'none';
}
else
{
document.getElementById(theTable).style.display = 'none';
}
}
//-->
</script>



<div style="margin-bottom:2px">

<input type="button" value="Емоции и BBCodes" style="width:117px;font-size:10px;margin:0px;padding:0px;" 
onclick="if (this.parentNode.parentNode.getElementsByTagName('div')[1].getElementsByTagName('div')[0].style.display != '') 
{ 
this.parentNode.parentNode.getElementsByTagName('div')[1].getElementsByTagName('div')[0].style.display = '';
this.innerText = ''; this.value = 'Емоции и BBCodes'; 
} else {
 this.parentNode.parentNode.getElementsByTagName('div')[1].getElementsByTagName('div')[0].style.display = 'none'; 
this.innerText = ''; this.value = 'Емоции и BBCodes'; 
}">
</div>
        

<div style="margin: 0px; padding: 6px; border: 1px ;">
  <div style="display: none;">
  
  <a href="javascript:addemo2('');" title="" class="vtip">
<img src="images/bold.gif" border="0"></a>

<a href="javascript:addemo2('');" title="" class="vtip">
<img src="http://cms-bg.com/public/style_images/elegant-blue/rte_icons/italic.png" border="0"></a>

<a href="javascript:addemo2('');" title="" class="vtip">
<img src="http://cms-bg.com/public/style_images/elegant-blue/rte_icons/underline.png" border="0"></a>

<a href="javascript:addemo2('[s][/s]');" title="[s][/s]" class="vtip">
<img src="http://cms-bg.com/public/style_images/elegant-blue/rte_icons/strike.png" border="0"></a>

<a href="javascript:addemo2('[center][/center]');" title="[center][/center]" class="vtip">
<img src="http://cms-bg.com/public/style_images/elegant-blue/rte_icons/align_center.png" border="0"></a>




<a href="javascript:addemo2('[img][/img]');" title="[img][/img]" class="vtip">
<img src="http://cms-bg.com/public/style_images/elegant-blue/rte_icons/picture.png" border="0"></a>


<a href="javascript:addemo2(' (pilot)');" title="Пилот" class="vtip">
<img src="images/smiles/pilot.gif" border="0"></a>





<a href="javascript:addemo2(' (fuck)');" title="О да" class="vtip">
        <img src='images/smiles/fuck.gif'></a>

<a href="javascript:addemo2(' (yahoo)');" title="Ухаа" class="vtip">

        <img src='images/smiles/yahoo.gif'></a>

<a href="javascript:addemo2(' (rules)');" title="Чети правилата @" class="vtip">
        <img src='images/smiles/rules.gif'></a>

<a href="javascript:addemo2(' (vestnik)');" title="Чете вестник" class="vtip">
        <img src='images/smiles/read2.gif'></a>

<a href="javascript:addemo2(' (pisatel)');" title="Писател" class="vtip">
        <img src='images/smiles/mr47_05.gif'></a>

<a href="javascript:addemo2(' (nono)');" title="НеНеНе" class="vtip">
        <img src='images/smiles/nono.gif'></a>

<a href="javascript:addemo2(' (bg)');" title="Бг Флаг" class="vtip">
        <img src='images/smiles/bgflag.gif'></a>

<a href="javascript:addemo2(' (bravo)');" title="Браво ! Браво !" class="vtip">
        <img src='images/smiles/i_clapping.gif'></a>

<a href="javascript:addemo2(' (usernew)');" title="Нов потрабител" class="vtip">
        <img src='images/smiles/new-user.gif'></a>

<a href="javascript:addemo2(' (rofl)');" title="Хахаха" class="vtip">
        <img src='images/smiles/rlol.gif'></a>

<a href="javascript:addemo2(' (noi)');" title="Не бйх аз" class="vtip">
        <img src='images/smiles/notme2.gif'></a>

<a href="javascript:addemo2(' (welcome) ');" title="Добре дошъл" class="vtip">
        <img src='images/smiles/welcome.gif'></a>

<a href="javascript:addemo2(' (bigbos)');" title="Пошач" class="vtip">
        <img src='images/smiles/big_boss.gif'></a>

<a href="javascript:addemo2(' (crazy)');" title="Лудааак съъмммм" class="vtip">
        <img src='images/smiles/crazy.gif'></a>

<a href="javascript:addemo2(' (coffe)');" title="Сутрешен вестник и кафенце" class="vtip">
        <img src='images/smiles/csbg_sleepy_coffee.gif'></a>

<a href="javascript:addemo2(' (bira)');" title="Бира" class="vtip">
        <img src='images/smiles/drinks.gif'></a>

<a href="javascript:addemo2(' (fayer)');" title="Огъън" class="vtip">
        <img src='images/smiles/fa111.gif'></a>

<a href="javascript:addemo2(' (lovec)');" title="Ловеца" class="vtip">
        <img src='images/smiles/hunter.gif'></a>

<a href="javascript:addemo2(' (music)');" title="Свиркане" class="vtip">

        <img src='images/smiles/whistle.gif'></a>

<a href="javascript:addemo2(' (kickme)');" title="Кикни ме" class="vtip">
        <img src='images/smiles/kickme.gif'></a>

<a href="javascript:addemo2(' (king)');" title="Цар незнам си кой" class="vtip">
        <img src='images/smiles/king2.gif'></a>

<a href="javascript:addemo2(' (crys)');" title="Збогом" class="vtip">
        <img src='images/smiles/l_bye_boy.gif'></a>

<a href="javascript:addemo2(' (stroitel)');" title="Строител" class="vtip">
        <img src='images/smiles/moil.gif'> </a>


<a href="javascript:addemo2(' (star)');" title="Ударен по главата" class="vtip">
        <img src='images/smiles/stars.gif'> </a>


<a href="javascript:addemo2(' (tnx)');" title="Благодаря ти" class="vtip">
        <img src='images/smiles/tnx.gif'> </a>



<a href="javascript:addemo2(' (4itatel)');" title="Читател" class="vtip">
        <img src='images/smiles/Vishenka_30.gif'> </a>


</p>
  </div>
</div>
</center>


  <script type="text/javascript">
   function showStuff(id) {
      document.getElementById(id).style.display = 'block';
   }
   function hideStuff(id) {
      document.getElementById(id).style.display = 'none';
   }
</script>




</center>
<?php } else { ?>
<a href="forum/ucp.php?mode=register" >Регистирай</a> се или <a href="forum/ucp.php?mode=login" >влез</a> в акаунта си за да пишеш.</center>
</br />
<?php } ?>
</form>
<?
$pp = "25";//колко резултата да ти вади на страница 
$page=$_GET['page']; //присвояваме стойността на page

if(!$_GET['page']) //ако не е взета page да върне 1-ца
{
$page="1";
}

$limit = ($pp*$page)-$pp; //определяме лимитирането


$redove=mysql_query("SELECT * FROM  shoutbox ORDER BY id")  or die (mysql_error());
$max=mysql_numrows($redove); //преброяваме редовете
$total=ceil($max/$pp); //пресмятаме броя на страниците

$query="SELECT * FROM  shoutbox ORDER BY id DESC  LIMIT $limit,$pp";
$result=mysql_query($query)  or die (mysql_error()); 
$num=mysql_numrows($result); 
$i=0;
while ($i < $num) {

$avtor=mysql_result($result,$i,"avtor");
$date=mysql_result($result,$i,"date");
$chat=mysql_result($result,$i,"chat");

echo str_replace($find_smileys, $replace_smileys, "<table align='center' style='border: 1px solid #e1e1e1; background: #fff;' width='100%'>
<tr style='border: 1px solid #e1e1e1; background: #fff;'>
<td align='left' style='background: #fff; font-size:10px;'>
 <img src='images/chat.gif' align='left' /><b><span style='font-size:10px; color: black'>$avtor</span></b><br />
<b style='color:#ccc;'><span style='font-size:10px;'>$data</span></b><br />
<span style='font-size:11px; color: black'>$chat</span><br />
</td></tr></table>");

$i++;
} 

echo "<br><br>";

//от тук започва кода за показването на страниците
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>";
?> 
?>
 
Мерси, но виж като му тествах защитата какво ми показа :
Код: 
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-25,25' at line 1
 
Трябва да си влезнал или регистриран, за да отговориш тук.

Back
Горе