Errore parziale su script PHP

[filippo9639]

su uno script php mi da questo errore:
"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 '' at line 1"
lo fa solo quando clicco sul pulsante Approve per questa porzione di codice dello script:

Codice PHP:

if ($type=="referrals" && $option==approve && $username!=""){

$myDb->connect();
$checkpemaile = mysql_query("SELECT * FROM yob_users WHERE referer=''");
$pemail_existe = mysql_num_rows($checkpemaile);
$myDb->close();
if ($pemail_existe<$referrals){
echo "<p class='error'>Error. There are not ". $referrals ." users without referer.</p>";
}else{
$myDb->connect();
$sqlz = "SELECT * FROM yob_users WHERE username='$username'";
$resultz = mysql_query($sqlz);
$myrowz = mysql_fetch_array($resultz);
$numero=$myrowz["referals"] + $referrals;
$sqlex = "UPDATE yob_users SET referals='$numero' WHERE username='$username'";
mysql_query($sqlex) or die(mysql_error());
$bquery = "UPDATE yob_users SET referer='$username' WHERE referer='' AND referer!='$username' LIMIT $referrals";
mysql_query($bquery) or die(mysql_error());
$bquery2 = "DELETE FROM yob_purchases WHERE id='$id'";
mysql_query($bquery2) or die(mysql_error());
$myDb->close();
echo "<p class='success'><bReferral Request Approved.</b></p>";
}
} 


perche lo fa solo in questa porzione di codice??, inoltre non funziona neachè il tasto Remove gestito da questo codice:

Codice PHP:

if (isset($_GET["id"])){
$id=$_GET["id"];

if ($option==deny){

$myDb->connect();
$queryz = "DELETE FROM yob_purchases WHERE id='$id'";
mysql_query($queryz) or die(mysql_error());
$myDb->close();
echo "<p class='success'><b>Purchase Removed.</b></p>";
}
} 


non capisco dov'è l'errore.

[Mattia]

Prova a modificare la prima riga da:

Codice PHP:

if ($type=="referrals" && $option==approve && $username!=""){ 


A:

Codice PHP:

if($type=="referrals" && $option=="approve" && $username!=""){ 


[filippo9639]

(30-11-2008 15:12)Mattia Ha scritto:  Prova a modificare la prima riga da:

Codice PHP:

if ($type=="referrals" && $option==approve && $username!=""){ 


A:

Codice PHP:

if($type=="referrals" && $option=="approve" && $username!=""){ 


niente non funziona da sempre lo stesso errore, ma con questa porzione di codice il tasto approve funziona.

Codice PHP:

if ($type=="lottery" && $option==approve && $username!=""){

$myDb->connect();
$bquery = "INSERT INTO yob_lottoentries (pemail, username) VALUES('$pemail','$username')";
mysql_query($bquery) or die(mysql_error());
$bquery2 = "DELETE FROM yob_purchases WHERE id='$id'";
mysql_query($bquery2) or die(mysql_error());
$myDb->close();
echo "<p class='success'><b>Lottery Request Approved.</b></p>";
}

if ($type=="advertising" && $option==approve){

$myDb->connect();
$pemail=$_POST["pemail"];
$plan=$_POST["plan"];
$url=$_POST["url"];
$description=$_POST["description"];
$ip=$_POST["ip"];
$bold=$_POST["bold"];
$highlight=$_POST["highlight"];
$viewable=$_POST["viewable"];
$fechainicia=time();
if ($viewable == "All Members"){
$tipo='ads'; }
if ($viewable == "Premium Members Only"){
$tipo='adspremium'; }
$myDb->connect();
$query = "INSERT INTO yob_ads (fechainicia, paypalemail, plan, url, description, tipo, bold, highlight) VALUES('$fechainicia','$pemail','$plan','$url','$description','$tipo','$bold','$highlight')";
mysql_query($query) or die(mysql_error());
$query2 = "DELETE FROM yob_purchases WHERE id='$id'";
mysql_query($query2) or die(mysql_error());
$myDb->close();
echo "<p class='success'><b>Advertisement Request Approved.</b></p>";
}
} 


perchè??

[Mattia]

Scrivi il codice della prima riga e di quelle seguenti della pagina che ti dà il primo errore.

[filippo9639]

(30-11-2008 15:38)Mattia Ha scritto:  Scrivi il codice della prima riga e di quelle seguenti della pagina che ti dà il primo errore.

eccolo lo posto tutto il codice

Codice PHP:

<? include('header.php'); ?>
<h2> Advertisers Request</h2><br />
<?php

if (isset($_GET["type"])){
$type=$_GET["type"];
$id=$_GET["id"];
$option=$_GET["option"];
$username=$_GET["username"];
$ballnumber=$_GET["ballnumber"];
$referrals=$_GET["referals"];
$pemail=$_GET["pemail"];

if ($type=="premium" && $option==approve && $username!=""){

$myDb->connect();
$queryz = "UPDATE yob_users SET account='premium' WHERE username='$username'";
mysql_query($queryz) or die(mysql_error());
$query2 = "DELETE FROM yob_purchases WHERE id='$id'";
mysql_query($query2) or die(mysql_error());
$myDb->close();
echo "<p class='success'><b>Upgrade Request Approved.</b></p>";
}

if ($type=="bonusball" && $option==approve && $ballnumber!="" && $username!=""){

$myDb->connect();
$bquery = "UPDATE yob_bonusball SET username='$username' WHERE number='$ballnumber'";
mysql_query($bquery) or die(mysql_error());
$bquery2 = "DELETE FROM yob_purchases WHERE id='$id'";
mysql_query($bquery2) or die(mysql_error());
$myDb->close();
echo "<p class='success'><b>Bonus Ball Request Approved.</b></p>";
}

if ($type=="referrals" && $option=='approve' && $username!=""){

$myDb->connect();
$checkpemaile = mysql_query("SELECT * FROM yob_users WHERE referer=''");
$pemail_existe = mysql_num_rows($checkpemaile);
$myDb->close();
if ($pemail_existe<$referrals){
echo "<p class='error'>Error. There are not ". $referrals ." users without referer.</p>";
}else{
$myDb->connect();
$sqlz = "SELECT * FROM yob_users WHERE username='$username'";
$resultz = mysql_query($sqlz);
$myrowz = mysql_fetch_array($resultz);
$numero=$myrowz["referals"] + $referrals;
$sqlex = "UPDATE yob_users SET referals='$numero' WHERE username='$username'";
mysql_query($sqlex) or die(mysql_error());
$bquery = "UPDATE yob_users SET referer='$username' WHERE referer='' AND referer!='$username' LIMIT $referrals";
mysql_query($bquery) or die(mysql_error());
$bquery2 = "DELETE FROM yob_purchases WHERE id='$id'";
mysql_query($bquery2) or die(mysql_error());
$myDb->close();
echo "<p class='success'><bReferral Request Approved.</b></p>";
}
}

if ($type=="lottery" && $option==approve && $username!=""){

$myDb->connect();
$bquery = "INSERT INTO yob_lottoentries (pemail, username) VALUES('$pemail','$username')";
mysql_query($bquery) or die(mysql_error());
$bquery2 = "DELETE FROM yob_purchases WHERE id='$id'";
mysql_query($bquery2) or die(mysql_error());
$myDb->close();
echo "<p class='success'><b>Lottery Request Approved.</b></p>";
}

if ($type=="advertising" && $option==approve){

$myDb->connect();
$pemail=$_POST["pemail"];
$plan=$_POST["plan"];
$url=$_POST["url"];
$description=$_POST["description"];
$ip=$_POST["ip"];
$bold=$_POST["bold"];
$highlight=$_POST["highlight"];
$viewable=$_POST["viewable"];
$fechainicia=time();
if ($viewable == "All Members"){
$tipo='ads'; }
if ($viewable == "Premium Members Only"){
$tipo='adspremium'; }
$myDb->connect();
$query = "INSERT INTO yob_ads (fechainicia, paypalemail, plan, url, description, tipo, bold, highlight) VALUES('$fechainicia','$pemail','$plan','$url','$description','$tipo','$bold','$highlight')";
mysql_query($query) or die(mysql_error());
$query2 = "DELETE FROM yob_purchases WHERE id='$id'";
mysql_query($query2) or die(mysql_error());
$myDb->close();
echo "<p class='success'><b>Advertisement Request Approved.</b></p>";
}
}

if (isset($_GET["id"])){
$id=$_GET["id"];

if ($option==deny){

$myDb->connect();
$queryz = "DELETE FROM yob_purchases WHERE id='$id'";
mysql_query($queryz) or die(mysql_error());
$myDb->close();
echo "<p class='success'><b>Purchase Removed.</b></p>";
}
}
?>

<table class="table1">
    <tr>
        <th>Email</th>
        <th>Plan</th>
        <th>URL</th>
        <th>Description</th>
        <th>Bold</th>
        <th>Highlight</th>
        <th>Ip</th>
        <th>Show Ad To</th>
        <th></th>
        <th></th>
    </tr>
<? $myDb->connect(); $tabla = mysql_query("SELECT * FROM yob_purchases where package='advertising' ORDER BY id ASC"); $myDb->close(); while ($registro = mysql_fetch_array($tabla)) { echo "
<tr>
<td>". $registro["pemail"] ."</td>
<td>". $registro["amount"] ." Clicks</td>
<td><a href=\"".$registro["url"]."\" title=\"".$registro["url"]."\" target=\"_blank\">View</a></td>
<td><a href=\"#\" title=\"".$registro["description"]."\">Description</a></td>
<td>". $registro["bold"] ."</td>
<td>". $registro["highlight"] ."</td>
<td>". $registro["ip"] ."</td>"; if ($registro['viewable'] == "All Members"){ echo "<td>All Members</td>"; } if ($registro['viewable'] == "Premium Members Only"){ echo "<td>Premium Members</td>"; } ?>
<td>
<form method="post" action="pending_orders.php?type=advertising&id=<?= $registro["id"] ?>&option=approve">
<input type="hidden" name="pemail" value="<?= $registro["pemail"] ?>">
<input type="hidden" name="plan" value="<?= $registro["amount"] ?>">
<input type="hidden" name="url" value="<?= $registro["url"] ?>">
<input type="hidden" name="description" value="<?= $registro["description"] ?>">
<input type="hidden" name="ip" value="<?= $registro["ip"] ?>">
<input type="hidden" name="viewable" value="<?= $registro["viewable"] ?>">
<input type="hidden" name="bold" value="<?= $registro["bold"] ?>">
<input type="hidden" name="highlight" value="<?= $registro["highlight"] ?>">
<input type="submit" value="Approve" class="f-submit">
</form></td>
<td>
<form method="post" action="pending_orders.php?id=<?= $registro["id"] ?>&option=deny">
<input type="submit" value="Remove" class="f-submit">
</form>
</td>
</tr>

<? } ?>
</table>

<h2>Referral Request</h2><br />
<p>Users without referer: <b>
    <? $myDb->connect(); $checkpemail = mysql_query("SELECT * FROM yob_users WHERE referer=''"); $pemail_exist = mysql_num_rows($checkpemail); $myDb->close(); echo $pemail_exist; ?>
</b></p>

<table class="table1">
<tr>
<th>Customer</th>
<th>AlertPay Email</th>
<th>Amount Of Referrals Purchased</th>
<th></th>
<th></th>
</tr>

<? $myDb->connect(); $tabla = mysql_query("SELECT * FROM yob_purchases WHERE package='referrals' ORDER BY id ASC"); $myDb->close(); while ($registro = mysql_fetch_array($tabla)) { echo "
<tr>
<td>". $registro["username"] ."</td>
<td>". $registro["pemail"] ."</td>

<td>". $registro["amount"] ." referrals</td>
    "; ?>
<td>
<form method="post" action="pending_orders.php?type=referrals&id=<?= $registro["id"] ?>&username=<?= $registro["username"] ?>&referrals=<?= $registro["amount"] ?>&option=approve">
<input type="submit" value="Approve" class="f-submit">
</form></td>
<td>
<form method="post" action="pending_orders.php?id=<?= $registro["id"] ?>&option=deny">
<input type="submit" value="Remove" class="f-submit">
</form>
</td>
</tr>

<? } ?>
</table>

<h2>Lottery Request</h2><br />

<table class="table1">
<tr>
<th>Customer</th>
<th>AlertPay Email</th>
<th>Amount Of Entries Purchased</th>
<th></th>
<th></th>
</tr>

<? $myDb->connect(); $tabla = mysql_query("SELECT * FROM yob_purchases WHERE package='lottery' ORDER BY id ASC"); $myDb->close(); while ($registro = mysql_fetch_array($tabla)) { echo "
<tr>
<td>". $registro["username"] ."</td>
<td>". $registro["pemail"] ."</td>

<td>". $registro["amount"] ." Entry(s)</td>
    "; ?>
<td>
<form method="post" action="pending_orders.php?type=lottery&id=<?= $registro["id"] ?>&username=<?= $registro["username"] ?>&pemail=<?= $registro["pemail"] ?>&option=approve">
<input type="submit" value="Approve" class="f-submit">
</form></td>
<td>
<form method="post" action="pending_orders.php?id=<?= $registro["id"] ?>&option=deny">
<input type="submit" value="Remove" class="f-submit">
</form>
</td>
</tr>

<? } ?>
</table>

<h2>Upgrade Requests</h2><br />

<table class="table1">
<tr>
<th>Customer</th>
<th>AlertPay Email</th>
<th></th>
<th></th>
</tr>

<? $myDb->connect(); $tabla = mysql_query("SELECT * FROM yob_purchases WHERE package='premium' ORDER BY id ASC"); $myDb->close(); while ($registro = mysql_fetch_array($tabla)) { echo "
<tr>
<td>". $registro["username"] ."</td>
<td>". $registro["pemail"] ."</td>"; ?>
<td>
<form method="post" action="pending_orders.php?type=premium&id=<?= $registro["id"] ?>&username=<?= $registro["username"] ?>&option=approve">
<input type="submit" value="Approve" class="f-submit">
</form></td>
<td><form method="post" action="pending_orders.php?id=<?= $registro["id"] ?>&option=deny">
<input type="submit" value="Remove" class="f-submit"></td>
</form>
</tr>

<? } ?>
</table>

<h2>Bonus Ball Requests</h2><br />

<table class="table1">
<tr>
<th>Customer</th>
<th>AlertPay Email</th>
<th>Ball Number</th>
<th></th>
<th></th>
</tr>

<? $myDb->connect(); $tabla = mysql_query("SELECT * FROM yob_purchases WHERE package='bonusball' ORDER BY id ASC"); $myDb->close(); while ($registro = mysql_fetch_array($tabla)) { echo "
<tr>
<td>". $registro["username"] ."</td>
<td>". $registro["pemail"] ."</td>

<td> Number ". $registro["amount"] ."</td>
    "; ?>
<td>
<form method="post" action="pending_orders.php?type=bonusball&id=<?= $registro["id"] ?>&username=<?= $registro["username"] ?>&ballnumber=<?= $registro["amount"] ?>&option=approve">
<input type="submit" value="Approve" class="f-submit">
</form></td>
<td><form method="post" action="pending_orders.php?id=<?= $registro["id"] ?>&option=deny">
<input type="submit" value="Remove" class="f-submit">
</form>
</td>
</tr>

<? } ?>
</table>

<br />&nbsp;<br />&nbsp;<br />&nbsp;<br />&nbsp;<br />&nbsp;<br />&nbsp;<br />&nbsp;<br />&nbsp;<br />&nbsp;<br />&nbsp;<br />&nbsp;<br />&nbsp;<br />&nbsp;<br />&nbsp;<br />&nbsp;<br />&nbsp;<br />&nbsp;<br />&nbsp;<br />&nbsp;<br />&nbsp;<br />&nbsp;<br />&nbsp;<br />&nbsp;<br />&nbsp;<br />&nbsp;<br />&nbsp;<br />&nbsp;<br />&nbsp;<br />&nbsp;<br />&nbsp;<br />&nbsp;<br />&nbsp;<br />&nbsp;<br />&nbsp;<br />
<? include('footer.php'); ?>

[Mattia]

Non vedo errori nella prima riga. Forse l'errore è nel file "header.php".

[filippo9639]

(30-11-2008 15:49)Mattia Ha scritto:  Non vedo errori nella prima riga. Forse l'errore è nel file "header.php".

posto anche il file header.php, ma la cosa strana che il bottone approve funziona su tutto escluso quella porzione di codice.

Codice PHP:

<?php include('includes/config.inc.php'); if(isset($_COOKIE["usNick"]) && isset($_COOKIE["usPass"])){ $user = $_COOKIE["usNick"]; $myDb->connect(); $sql = "SELECT * FROM yob_users WHERE username='$user'"; $result = mysql_query($sql); $row = mysql_fetch_array($result); $myDb->close(); $is_admin = $row['user_status']; if($is_admin != "admin"){ $display_error = "* You must login as administrator to access this page.";  include ('error.php'); exit(); } }else{ $display_error = "* You must login as administrator to access this page.";  include ('error.php'); exit(); }?>

<!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>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title><?php echo SITENAME." - ".SITESLOGAN;?></title>
<link rel="stylesheet" type="text/css" href="css/main.css" media="screen" />
<link rel="stylesheet" type="text/css" href="css/print.css" media="print" />
<!--[if lte IE 6]>
<link rel="stylesheet" type="text/css" href="css/ie6_or_less.css" />
<![endif]-->
</head>
<body id="type-b">
<div id="wrap">

    <div id="header">
        <div id="site-name">Administration</div>
        <?php include('menu_top.php');?>
    </div>
    
    <div id="content-wrap">
    
        <div id="utility">
        <?php include('menu_left.php');?>
        </div>
        <div id="content"> 


[Mattia]

A questo potrebbe essere un altro dei file che includi. Scrivi l'errore completo che ti esce.

[filippo9639]

(30-11-2008 16:09)Mattia Ha scritto:  A questo potrebbe essere un altro dei file che includi. Scrivi l'errore completo che ti esce.

risolto parzialmente modificato questa riga del codice da così

Codice PHP:

$referrals=$_GET["referals"]; 


a così

Codice PHP:

$referrals=$_GET["referrals"]; 


l'unica cosa che non funziona adesso è il remove in nessun posto.

[Mattia]

Ma ti escono delle scritte predisposte o degli errori?

[filippo9639]

(30-11-2008 16:38)Mattia Ha scritto:  Ma ti escono delle scritte predisposte o degli errori?

no nessun errore solo che il tasto non fà quello che dovrebbe fare il codice incriminato è questo.

Codice PHP:

if (isset($_GET["id"])){
$id=$_GET["id"];

if ($option==deny){

$myDb->connect();
$queryz = "DELETE FROM yob_purchases WHERE id='$id'";
mysql_query($queryz) or die(mysql_error());
$myDb->close();
echo "<p class='success'><b>Purchase Removed.</b></p>";
}
} 


[Mattia]

Al posto di:

Codice PHP:

if ($option==deny){ 


Metti:

Codice PHP:

if($option=="deny"){ 


Se continua a non funzionare, controlla se $option è uguale a "deny".

[filippo9639]

(30-11-2008 17:06)Mattia Ha scritto:  Al posto di:

Codice PHP:

if ($option==deny){ 


Metti:

Codice PHP:

if($option=="deny"){ 


Se continua a non funzionare, controlla se $option è uguale a "deny".

gia provato ma non funziona lo stesso. Come faccio a controllare se $option è uguale a "deny" ???

---

(30-11-2008 17:17)filippo9639 Ha scritto:  

(30-11-2008 17:06)Mattia Ha scritto:  Al posto di:

Codice PHP:

if ($option==deny){ 


Metti:

Codice PHP:

if($option=="deny"){ 


Se continua a non funzionare, controlla se $option è uguale a "deny".

gia provato ma non funziona lo stesso. Come faccio a controllare se $option è uguale a "deny" ???

risolto anche il secondo problema della cancellazione

sostituito

Codice PHP:

if ($option==deny){ 


con

Codice PHP:

if ($option="deny"){