Non capisco perchè questo script mi da errore...
Codice PHP:
<?
require("../Cart.php");
$pwd = "prova";
$usr = "prova";
if(isset($_COOKIE['user']) && isset($_COOKIE['password']))
{
$user = $_COOKIE['user'];
$password = $_COOKIE['password'];
if(($pwd == $password) && ($usr == $user))
{
admin();
}
}
else
{
if(!isset($_SERVER['PHP_AUTH_USER']))
{
Header("WWW-Authenticate: Basic realm=\"Shop Cart Admin Zone\"");
Header("HTTP/1.0 401 Unauthorized");
echo "Impossibile eseguire l'autorizzazione\n";
exit;
}
else
{
if (($_SERVER['PHP_AUTH_USER'] == $usr) && ( $_SERVER['PHP_AUTH_PW'] == $pwd))
{
setcookie("user","$usr",time()+3600);
setcookie("password","$pwd",time()+3600);
admin();
}
else
{
echo "Password o username non corretti";
}
}
}
function admin()
{
$Yr=date("Y");
$Dy=date("z");
mysql_connect("$DBHost","$DBUser","$DBPass");
mysql_select_db("$DBName");
$result = mysql_query("SELECT Date,BuyerID,OrderNumber FROM Buyers");
while($row = mysql_fetch_row($result)) //riga di errore
{
$Da=$row[0];
$BI=$row[1];
$ON=$row[2];
$pieces=explode(":",$Da);
if ($Yr > $pieces[0] AND $Dy > $pieces[1])
{
mysql_query("DELETE FROM Buyers WHERE BuyerID='$BI'");
mysql_query("DELETE FROM Orders WHERE OrderNumber='$ON'");
mysql_query("DELETE FROM Receipts WHERE OrderNumber='$ON'");
}
}
echo "<html>
<head>
<title>Pannello di Amministrazione</title>
</head>
<body>";
echo "[b]Elenco delle funzioni...[/b]
";
echo "<ul>";
echo "[*][url='./searchReceipts.php']Get A Receipt[/url]";
echo "[*][url='./addCategory.php']Add A Category[/url]";
echo "[*][url='./addItem.php']Add An Item[/url]";
echo "[*][url='./updateItem.php']Update An Item[/url]";
echo "[*][url='./addPicture.php']Modify/Update A Picture[/url]";
echo "[*][url='./removeCategory.php']Remove A Category[/url]";
echo "[*][url='./removeItem.php']Remove An Item[/url]";
echo "[/list]";
}
?>
questo è l'errore che viene stampato
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in i:\programmi\apache group\apache\htdocs\shop\admin\index.php on line 50
Rispondi quotando
