Помощ за админ панел!!!

H

HKOne

Registered
Здравейте правя един сайт и изглежда че имам грешка в кода за бановете, но немога да разбера защо ми дава тази грешка. Моля помогнете ми!
Изписва ми :

Код: 
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\xampp\htdocs\fansite\admin\banlist.php on line 48

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\xampp\htdocs\fansite\admin\banlist.php on line 54

А ето го и кода!

PHP: 
<?php
session_start();
$admin = $_SESSION['username'];
if($admin != "HKOne") {
    header("Location: ../index.php");
}
define('IN_VALID', true);
require "../config.php";
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
	<head>
		<title>Админ панел</title>
		<meta http-equiv="content-language" content="bg-us" />
        <meta name="author" content="HKOne"/>
		<link type="text/css" rel="stylesheet" href="../style/style.css" />
		<link href="../favicon.png" rel="shortcut icon" type="image/x-icon" />
		<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
	</head>
	<body>
            <div><br /></div>
            <table cellpadding="0" cellspacing="0" border="0" width="700px" style="margin: 0 auto; padding-bottom: 5px;">
                <tr>
                    <td class="adminheader" colspan="2"></td>
                </tr>
            </table>
            <table cellpadding="0" cellspacing="0" border="0" width="700px" style="margin: 0 auto; padding: 5px;" class="admincontent">
                <tr>
                    <td class="adminleftmenu">
                        МЕНЮ
                        <div class="adminlineleft"></div>
                        <?php include_once 'menu.php'; ?>
                    </td>
                    <td style="width: 10px"></td>
                    <td class="adminrightmenu">
                        БАНЛИСТ
                        <div class="adminlineright"></div>
                        <div style="width: 100%; text-align: right;"><a href="addban.php">Добави бан</a></div>
                        <?php
                        $page =  (int)$_GET['page'];
                        if($page == 0 || $page == NULL || $page <0)
                        {
                            $page = 1;
                        }
                        $pp = 10;
                        $start = ($page*$pp) - $pp;
                        $zaqvka = mysql_query("SELECT * FROM banlist");
                        $broi = mysql_num_rows($zaqvka);
                        $total = ceil($broi/$pp);
                        $quary = mysql_query("SELECT * FROM banlist ORDER BY ban_id DESC LIMIT $start,$pp");
                        echo "<table cellpadding='0' cellspacing='0' border='0' width='100%'>";
                        echo "<tr><td style='border-bottom: 1px solid #ccc;'><font color='dodgerblue'>#</font></td><td style='border-bottom: 1px solid #ccc;'><font color='dodgerblue'>IP</font></td><td style='border-bottom: 1px solid #ccc;'><font color='dodgerblue'>Причина</font></td><td style='border-bottom: 1px solid #ccc;'><font color='dodgerblue'>Дата / Час на бан</font></td><td style='border-bottom: 1px solid #ccc;'></td><td style='border-bottom: 1px solid #ccc;'></td></tr>";
                        $i = 1;
                        while($row = mysql_fetch_array($quary))
                        {
                            echo "<tr><td style='width: 15px; border-bottom: 1px solid #ccc;'>$i</td><td style='border-bottom: 1px solid #ccc;'>$row[ban_ip]</td><td style='border-bottom: 1px solid #ccc;'>$row[reason]</td><td style='border-bottom: 1px solid #ccc;'>$row[date]</td><td style='border-bottom: 1px solid #ccc;'><a href='editban.php?ban_id=$row[ban_id]'><font color='dodgerblue'>Редактирай</font></a></td><td style='border-bottom: 1px solid #ccc;'><a href='delban.php?ban_id=$row[ban_id]'><font color='red'>Изтрий</font></a></td></tr>";
                            $i++;
                        }
                        echo "</table>";
                        $prev = $page - 1;
                        $next = $page + 1;
                        if($page == 1)
                        {
                            print " ";
                        }
                        else
                        {
                            print "<a href='?page=$prev'>Предишна страница  </a>";
                        }
                        if($page >= $total)
                        {
                            print " ";
                        }
                        else
                        {
                            print "<a href='?page=$next'> Следваща страница</a>";
                        }
                        ?>
                    </td>
                </tr>
            </table>
            <table cellpadding="0" cellspacing="0" border="0" width="700px" style="margin: 0 auto; margin-top: 5px;">
                <tr>
                    <td class="adminfooter" colspan="2">Всички права запазени © 2012 </td>
                </tr>
            </table>
	</body>
</html>
[/php]
 
Кода ти за странициране е грешен, направи го така


PHP: 
  $zaqvka = mysql_query("SELECT COUNT(user) FROM banlist");
  $run = mysql_query($zaqvka);
  $row = mysql_fetch_row($run);
  $obshto_temi = $row[0];
  $total = ceil($obshto_temi / 10);

На мястото на user си слагаш съответната колона от твоята таблица
 
Някой може ли да ми даде целия код, пробвах това на Radko но не мисля че го направих като хората :)
 
Виж aleks какво те пита. Защото май това ти е проблема. Сложи от горе на заявката ето това:

Като разбира се попълваш полетата с вярно информация за теб.

PHP: 
mysql_connect('localhost', 'ПОТРЕБИТЕЛСКО ИМЕ НА PHPMYADMIN', 'ПАРОЛА');
mysql_select_db('ГЛАВНАТА ТИ БАЗА ДАННИ КЪМ САЙТА');



Ето така:
PHP: 
mysql_connect('localhost', 'ПОТРЕБИТЕЛСКО ИМЕ НА PHPMYADMIN', 'ПАРОЛА');
mysql_select_db('ГЛАВНАТА ТИ БАЗА ДАННИ КЪМ САЙТА');

$quary = mysql_query("SELECT * FROM banlist ORDER BY ban_id DESC LIMIT $start,$pp");
 
Ако не е това проблема. Провери дали задаваш точни данни на заявката. Дали наистина тези полета съществуват в базата данни. Може да си допуснал някъде правописна грешка. Виж полетата в базата данни дали имат вярна информация и така.
 
Ето кода след редакция:
PHP: 
<?php
session_start();
$admin = $_SESSION['username'];
if($admin != "HKOne") {
    header("Location: ../index.php");
}
define('IN_VALID', true);
require "../config.php";
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
	<head>
		<title>Админ панел</title>
		<meta http-equiv="content-language" content="bg-us" />
        <meta name="author" content="Todor Todorov"/>
		<link type="text/css" rel="stylesheet" href="../style/style.css" />
		<link href="../favicon.png" rel="shortcut icon" type="image/x-icon" />
		<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
	</head>
	<body>
            <div><br /></div>
            <table cellpadding="0" cellspacing="0" border="0" width="700px" style="margin: 0 auto; padding-bottom: 5px;">
                <tr>
                    <td class="adminheader" colspan="2"></td>
                </tr>
            </table>
            <table cellpadding="0" cellspacing="0" border="0" width="700px" style="margin: 0 auto; padding: 5px;" class="admincontent">
                <tr>
                    <td class="adminleftmenu">
                        МЕНЮ
                        <div class="adminlineleft"></div>
                        <?php include_once 'menu.php'; ?>
                    </td>
                    <td style="width: 10px"></td>
                    <td class="adminrightmenu">
                        БАНЛИСТ
                        <div class="adminlineright"></div>
                        <div style="width: 100%; text-align: right;"><a href="addban.php">Добави бан</a></div>
                        <?php
                        $page =  (int)$_GET['page'];
                        if($page == 0 || $page == NULL || $page <0)
                        {
                            $page = 1;
                        }
                        $pp = 10;
                        $start = ($page*$pp) - $pp;
                        $zaqvka = mysql_query("SELECT * FROM banlist");
                        $broi = mysql_num_rows($zaqvka);
                        $total = ceil($broi/$pp);
						
						mysql_connect('localhost', 'root', 'sasasa');
                        mysql_select_db('fansite');
						
                        $quary = mysql_query("SELECT * FROM banlist ORDER BY ban_id DESC LIMIT $start,$pp");
                        echo "<table cellpadding='0' cellspacing='0' border='0' width='100%'>";
                        echo "<tr><td style='border-bottom: 1px solid #ccc;'><font color='dodgerblue'>#</font></td><td style='border-bottom: 1px solid #ccc;'><font color='dodgerblue'>IP</font></td><td style='border-bottom: 1px solid #ccc;'><font color='dodgerblue'>Причина</font></td><td style='border-bottom: 1px solid #ccc;'><font color='dodgerblue'>Дата / Час на бан</font></td><td style='border-bottom: 1px solid #ccc;'></td><td style='border-bottom: 1px solid #ccc;'></td></tr>";
                        $i = 1;
                        while($row = mysql_fetch_array($quary))
                        {
                            echo "<tr><td style='width: 15px; border-bottom: 1px solid #ccc;'>$i</td><td style='border-bottom: 1px solid #ccc;'>$row[ban_ip]</td><td style='border-bottom: 1px solid #ccc;'>$row[reason]</td><td style='border-bottom: 1px solid #ccc;'>$row[date]</td><td style='border-bottom: 1px solid #ccc;'><a href='editban.php?ban_id=$row[ban_id]'><font color='dodgerblue'>Редактирай</font></a></td><td style='border-bottom: 1px solid #ccc;'><a href='delban.php?ban_id=$row[ban_id]'><font color='red'>Изтрий</font></a></td></tr>";
                            $i++;
                        }
                        echo "</table>";
                        $prev = $page - 1;
                        $next = $page + 1;
                        if($page == 1)
                        {
                            print " ";
                        }
                        else
                        {
                            print "<a href='?page=$prev'>Предишна страница  </a>";
                        }
                        if($page >= $total)
                        {
                            print " ";
                        }
                        else
                        {
                            print "<a href='?page=$next'> Следваща страница</a>";
                        }
                        ?>
                    </td>
                </tr>
            </table>
            <table cellpadding="0" cellspacing="0" border="0" width="700px" style="margin: 0 auto; margin-top: 5px;">
                <tr>
                    <td class="adminfooter" colspan="2">Всички права запазени © 2011  </td>
                </tr>
            </table>
	</body>
</html>

Ето грешка:
Код: 
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\xampp\htdocs\fansite\admin\banlist.php on line 48
 
PHP: 
<?php
session_start();
$admin = $_SESSION['username'];
if($admin != "HKOne") {
    header("Location: ../index.php");
}
define('IN_VALID', true);
require "../config.php";
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
        <head>
                <title>Админ панел</title>
                <meta http-equiv="content-language" content="bg-us" />
        <meta name="author" content="Todor Todorov"/>
                <link type="text/css" rel="stylesheet" href="../style/style.css" />
                <link href="../favicon.png" rel="shortcut icon" type="image/x-icon" />
                <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
        </head>
        <body>
            <div><br /></div>
            <table cellpadding="0" cellspacing="0" border="0" width="700px" style="margin: 0 auto; padding-bottom: 5px;">
                <tr>
                    <td class="adminheader" colspan="2"></td>
                </tr>
            </table>
            <table cellpadding="0" cellspacing="0" border="0" width="700px" style="margin: 0 auto; padding: 5px;" class="admincontent">
                <tr>
                    <td class="adminleftmenu">
                        МЕНЮ
                        <div class="adminlineleft"></div>
                        <?php include_once 'menu.php'; ?>
                    </td>
                    <td style="width: 10px"></td>
                    <td class="adminrightmenu">
                        БАНЛИСТ
                        <div class="adminlineright"></div>
                        <div style="width: 100%; text-align: right;"><a href="addban.php">Добави бан</a></div>
                        <?php
                        $page =  (int)$_GET['page'];
                        if($page == 0 || $page == NULL || $page <0)
                        {
                            $page = 1;
                        }
                        $pp = 10;
                        $start = ($page*$pp) - $pp;
                        mysql_connect('localhost', 'root', 'sasasa');
                        mysql_select_db('fansite');
                        $zaqvka = mysql_query("SELECT * FROM banlist");
                        $broi = mysql_num_rows($zaqvka);
                        $total = ceil($broi/$pp);

                                                

                        $quary = mysql_query("SELECT * FROM banlist ORDER BY ban_id DESC LIMIT $start,$pp");
                        echo "<table cellpadding='0' cellspacing='0' border='0' width='100%'>";
                        echo "<tr><td style='border-bottom: 1px solid #ccc;'><font color='dodgerblue'>#</font></td><td style='border-bottom: 1px solid #ccc;'><font color='dodgerblue'>IP</font></td><td style='border-bottom: 1px solid #ccc;'><font color='dodgerblue'>Причина</font></td><td style='border-bottom: 1px solid #ccc;'><font color='dodgerblue'>Дата / Час на бан</font></td><td style='border-bottom: 1px solid #ccc;'></td><td style='border-bottom: 1px solid #ccc;'></td></tr>";
                        $i = 1;
                        while($row = mysql_fetch_array($quary))
                        {
                            echo "<tr><td style='width: 15px; border-bottom: 1px solid #ccc;'>$i</td><td style='border-bottom: 1px solid #ccc;'>$row[ban_ip]</td><td style='border-bottom: 1px solid #ccc;'>$row[reason]</td><td style='border-bottom: 1px solid #ccc;'>$row[date]</td><td style='border-bottom: 1px solid #ccc;'><a href='editban.php?ban_id=$row[ban_id]'><font color='dodgerblue'>Редактирай</font></a></td><td style='border-bottom: 1px solid #ccc;'><a href='delban.php?ban_id=$row[ban_id]'><font color='red'>Изтрий</font></a></td></tr>";
                            $i++;
                        }
                        echo "</table>";
                        $prev = $page - 1;
                        $next = $page + 1;
                        if($page == 1)
                        {
                            print " ";
                        }
                        else
                        {
                            print "<a href='?page=$prev'>Предишна страница  </a>";
                        }
                        if($page >= $total)
                        {
                            print " ";
                        }
                        else
                        {
                            print "<a href='?page=$next'> Следваща страница</a>";
                        }
                        ?>
                    </td>
                </tr>
            </table>
            <table cellpadding="0" cellspacing="0" border="0" width="700px" style="margin: 0 auto; margin-top: 5px;">
                <tr>
                    <td class="adminfooter" colspan="2">Всички права запазени © 2011  </td>
                </tr>
            </table>
        </body>
</html>
 
Трябва да си влезнал или регистриран, за да отговориш тук.

Back
Горе