IzKuFeLiQqQqQ
Registered
Дойде време и аз да питам за страницирането 
доста сложничко е
имам този код
искам да го страницирам с този код
но когато се опитам да наместя заявките за mysql хем да страницира хем да count поръчките всичко се обърква
някой сеща ли се как ще стане ??? :? :shock:
доста сложничко еимам този код
Код:
<?php header('Content-type: text/html; encoding: UTF-8');
$url = htmlspecialchars($_GET['do']);
if($url=="view"){
if(!$_POST['submit']){
echo "<meta http-equiv='refresh' content='0;order.php'>";
}
else {
$name = htmlspecialchars($_POST['name']);
$gsm = htmlspecialchars($_POST['gsm']);
$email = htmlspecialchars($_POST['email']);
include ('./files/config.php');
$select = mysql_query("SELECT * FROM `services` WHERE `name` = '$name' AND `gsm` = '$gsm' AND `email` = '$email' ORDER BY `id` DESC") or die (mysql_error());
$count = mysql_fetch_object(mysql_query("SELECT COUNT(id) as `broi` FROM `services` WHERE `name` = '$name' AND `gsm` = '$gsm' AND `email` = '$email' ORDER BY `id` DESC")) or die (mysql_error());
if($count->broi=="0"){
echo "Няма регистрирани поръчки с тези данни.";
}
else
{
echo "
"; ?>
<?php
while($row=mysql_fetch_object($select)){
$id = $row->id;
$vid = $row->vid;
$name = $row->name;
$gsm = $row->gsm;
$email = $row->email;
$statsorder = $row->statsorder;
if($statsorder=='unchecked') {echo "Непроверена";}
elseif($statsorder=='accepted') {echo "Приета";}
if($statsorder=='rejected') {echo "Отхвърлена";}
elseif($statsorder=='finished') {echo "Завършена";}
echo "</td><td width='20%'>$vid</td>
<td width='20%'>$name</td><td width='20%'>$gsm</td><td width='20%'>$email</td>
<td width='7%'><a href='./viewmyorder.php?id=$id'><img style='border:0;text-decoration:none;' widt='28px' height='28px' src='./img/view.png'/></a></td>
<td width='7%'><a href='order.php?id=$id'><img style='border:0;text-decoration:none;' src='./img/give.png'/></а></td>
<td width='17%'><a href='delmyorder.php?id=$id'><img width='16px' height='16px' style='border:0;text-decoration:none;' src='./img/deleteorder.png'/></а></td>
</tr>
</table>";
}
}
}
}
else {
echo '<form action="?do=view" method="post">
Име:<br> <input type="text" name="name"><br />
E-mail:<br> <input type="text" name="email"><br>
GSM:<br> <input type="text" name="gsm"><br /><br>
<input type="submit" class="submit" name="submit" value="Вземи">
</form>'
;
}
?>искам да го страницирам с този код
Код:
<?php header( 'Content-Type:text/html; charset=UTF-8' );
$page = (int)$_GET['page'];
if($page == 0 || $page == NULL || $page < 0)
{
$page = 1;
}
$pp = 6;
$start = ($page*$pp) - $pp;
include ('./files/config.php');
$query = mysql_query("SELECT * FROM `newss` "); //pishesh tablicata
$broi = mysql_num_rows($query);
$total = ceil($broi/$pp);
$result = mysql_query("SELECT * FROM `newss` ORDER BY `id` DESC LIMIT $start,$pp "); //pishesh tablicata pak
while ($row = mysql_fetch_array($result))
{
}
echo "<div id = 'STR' style = 'width:572px; color:#fff;'>"; // tuka mojesh da si promenish stilovete (css) drugoto ne go barash
if ($page > 1) {
$prev = ($page - 1);
echo "<a style='text-decoration:none;' href=\"?page=$prev\"><font face=\"Trebuchet MS\" style=' margin-right:7px; margin-top:-1px; color:#fff;'>Предишна </font></a> ";
}
else echo "<font face=\"Trebuchet MS\" style=' margin-right:7px; margin-top:-1px; text-decoration:none;'>Предишна </font> ";
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; padding-left:8px; padding-right:8px; padding-bottom:1px; '>$i</b> ";
}
else {
echo "<a style=' background: url(images/STR.jpg) no-repeat; color:#fff; 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; 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; 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; 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; 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; 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; 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; 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; 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; 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; 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; 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; 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; padding-right:8px; padding-bottom:1px; ' href=\"?page=".$i."\">".$i."</a> ";
}
}
}
if ($page < $total) {
$next = ($page + 1);
echo "<a style='text-decoration:none;' href=\"?page=$next\"><font face=\"Trebuchet MS\" style=' margin-left:7px; margin-top:-1px; color:#fff;'>Следваща </font></a> ";
}
else echo "<font face=\"Trebuchet MS\" style=' margin-left:7px; margin-top:-1px;'>Следваща </font>";
echo"</div>";
?>но когато се опитам да наместя заявките за mysql хем да страницира хем да count поръчките всичко се обърква
някой сеща ли се как ще стане ??? :? :shock:
