Help

Status
Niet open voor verdere reacties.
H

hawkins

Gebruiker
Lid geworden
18 jun 2009
Berichten
57
Wat is hier fout aan??

PHP: 
<?php
include"config.php";


$time = date(s);
$addr = $_SERVER["REMOTE_ADDR"];
$naam = mysql_fetch_array(mysql_query("SELECT * FROM users WHERE ip ='$addr'"));
$addg = mysql_query("update `Geld` SET `Geld`+'$more' FROM products WHERE Naam ='{$naam['username']}'");
$more = "25";

if ("$time" == "1"){
mysql_query("update `Geld` SET `Geld`+'$more' FROM products WHERE Naam ='{$naam['username']}'");
}
elseif ($time == "2"){
mysql_query("update `Geld` SET `Geld`+'$more' FROM products WHERE Naam ='{$naam['username']}'");
}
elseif ($time == "3"){
mysql_query("update `Geld` SET `Geld`+'$more' FROM products WHERE Naam ='{$naam['username']}'");
}
elseif ($time == "4"){
mysql_query("update `Geld` SET `Geld`+'$more' FROM products WHERE Naam ='{$naam['username']}'");
}
elseif ($time == "5"){
mysql_query("update `Geld` SET `Geld`+'$more' FROM products WHERE Naam ='{$naam['username']}'");
}
elseif ($time == "6"){
mysql_query("update `Geld` SET `Geld`+'$more' FROM products WHERE Naam ='{$naam['username']}'");
}
elseif ($time == "7"){
mysql_query("update `Geld` SET `Geld`+'$more' FROM products WHERE Naam ='{$naam['username']}'");
}
elseif ($time == "8"){
mysql_query("update `Geld` SET `Geld`+'$more' FROM products WHERE Naam ='{$naam['username']}'");
}
elseif ($time == "9"){
mysql_query("update `Geld` SET `Geld`+'$more' FROM products WHERE Naam ='{$naam['username']}'");
}
elseif ($time == "10"){
mysql_query("update `Geld` SET `Geld`+'$more' FROM products WHERE Naam ='{$naam['username']}'");
}
elseif ($time == "11"){
mysql_query("update `Geld` SET `Geld`+'$more' FROM products WHERE Naam ='{$naam['username']}'");
}
elseif ($time == "12"){
mysql_query("update `Geld` SET `Geld`+'$more' FROM products WHERE Naam ='{$naam['username']}'");
}
elseif ($time == "13"){
mysql_query("update `Geld` SET `Geld`+'$more' FROM products WHERE Naam ='{$naam['username']}'");
}
elseif ($time == "14"){
mysql_query("update `Geld` SET `Geld`+'$more' FROM products WHERE Naam ='{$naam['username']}'");
}
elseif ($time == "15"){
mysql_query("update `Geld` SET `Geld`+'$more' FROM products WHERE Naam ='{$naam['username']}'");
}
elseif ($time == "16"){
mysql_query("update `Geld` SET `Geld`+'$more' FROM products WHERE Naam ='{$naam['username']}'");
}
elseif ($time == "17"){
mysql_query("update `Geld` SET `Geld`+'$more' FROM products WHERE Naam ='{$naam['username']}'");
}
elseif ($time == "18"){
mysql_query("update `Geld` SET `Geld`+'$more' FROM products WHERE Naam ='{$naam['username']}'");
}
elseif ($time == "19"){
mysql_query("update `Geld` SET `Geld`+'$more' FROM products WHERE Naam ='{$naam['username']}'");
}
elseif ($time == "20"){
mysql_query("update `Geld` SET `Geld`+'$more' FROM products WHERE Naam ='{$naam['username']}'");
}
elseif ($time == "21"){
mysql_query("update `Geld` SET `Geld`+'$more' FROM products WHERE Naam ='{$naam['username']}'");
}
elseif ($time == "22"){
mysql_query("update `Geld` SET `Geld`+'$more' FROM products WHERE Naam ='{$naam['username']}'");
}
elseif ($time == "23"){
mysql_query("update `Geld` SET `Geld`+'$more' FROM products WHERE Naam ='{$naam['username']}'");
}
elseif ($time == "24"){
mysql_query("update `Geld` SET `Geld`+'$more' FROM products WHERE Naam ='{$naam['username']}'");
}
elseif ($time == "25"){
mysql_query("update `Geld` SET `Geld`+'$more' FROM products WHERE Naam ='{$naam['username']}'");
}
elseif ($time == "26"){
mysql_query("update `Geld` SET `Geld`+'$more' FROM products WHERE Naam ='{$naam['username']}'");
}
elseif ($time == "27"){
mysql_query("update `Geld` SET `Geld`+'$more' FROM products WHERE Naam ='{$naam['username']}'");
}
elseif ($time == "28"){
mysql_query("update `Geld` SET `Geld`+'$more' FROM products WHERE Naam ='{$naam['username']}'");
}
elseif ($time == "29"){
mysql_query("update `Geld` SET `Geld`+'$more' FROM products WHERE Naam ='{$naam['username']}'");
}
elseif ($time == "30"){
mysql_query("update `Geld` SET `Geld`+'$more' FROM products WHERE Naam ='{$naam['username']}'");
}
elseif ($time == "31"){
mysql_query("update `Geld` SET `Geld`+'$more' FROM products WHERE Naam ='{$naam['username']}'");
}
elseif ($time == "32"){
mysql_query("update `Geld` SET `Geld`+'$more' FROM products WHERE Naam ='{$naam['username']}'");
}
elseif ($time == "33"){
mysql_query("update `Geld` SET `Geld`+'$more' FROM products WHERE Naam ='{$naam['username']}'");
}
elseif ($time == "34"){
mysql_query("update `Geld` SET `Geld`+'$more' FROM products WHERE Naam ='{$naam['username']}'");
}
elseif ($time == "35"){
mysql_query("update `Geld` SET `Geld`+'$more' FROM products WHERE Naam ='{$naam['username']}'");
}
elseif ($time == "36"){
mysql_query("update `Geld` SET `Geld`+'$more' FROM products WHERE Naam ='{$naam['username']}'");
}
elseif ($time == "37"){
mysql_query("update `Geld` SET `Geld`+'$more' FROM products WHERE Naam ='{$naam['username']}'");
}
elseif ($time == "38"){
mysql_query("update `Geld` SET `Geld`+'$more' FROM products WHERE Naam ='{$naam['username']}'");
}
elseif ($time == "39"){
mysql_query("update `Geld` SET `Geld`+'$more' FROM products WHERE Naam ='{$naam['username']}'");
}
elseif ($time == "40"){
mysql_query("update `Geld` SET `Geld`+'$more' FROM products WHERE Naam ='{$naam['username']}'");
}
elseif ($time == "41"){
mysql_query("update `Geld` SET `Geld`+'$more' FROM products WHERE Naam ='{$naam['username']}'");
}
elseif ($time == "42"){
mysql_query("update `Geld` SET `Geld`+'$more' FROM products WHERE Naam ='{$naam['username']}'");
}
elseif ($time == "43"){
mysql_query("update `Geld` SET `Geld`+'$more' FROM products WHERE Naam ='{$naam['username']}'");
}
elseif ($time == "44"){
mysql_query("update `Geld` SET `Geld`+'$more' FROM products WHERE Naam ='{$naam['username']}'");
}
elseif ($time == "45"){
mysql_query("update `Geld` SET `Geld`+'$more' FROM products WHERE Naam ='{$naam['username']}'");
}
elseif ($time == "46"){
mysql_query("update `Geld` SET `Geld`+'$more' FROM products WHERE Naam ='{$naam['username']}'");
}
elseif ($time == "47"){
mysql_query("update `Geld` SET `Geld`+'$more' FROM products WHERE Naam ='{$naam['username']}'");
}
elseif ($time == "48"){
mysql_query("update `Geld` SET `Geld`+'$more' FROM products WHERE Naam ='{$naam['username']}'");
}
elseif ($time == "49"){
mysql_query("update `Geld` SET `Geld`+'$more' FROM products WHERE Naam ='{$naam['username']}'");
}
elseif ($time == "50"){
mysql_query("update `Geld` SET `Geld`+'$more' FROM products WHERE Naam ='{$naam['username']}'");
}
elseif ($time == "51"){
mysql_query("update `Geld` SET `Geld`+'$more' FROM products WHERE Naam ='{$naam['username']}'");
}
elseif ($time == "52"){
mysql_query("update `Geld` SET `Geld`+'$more' FROM products WHERE Naam ='{$naam['username']}'");
}
elseif ($time == "53"){
mysql_query("update `Geld` SET `Geld`+'$more' FROM products WHERE Naam ='{$naam['username']}'");
}
elseif ($time == "54"){
mysql_query("update `Geld` SET `Geld`+'$more' FROM products WHERE Naam ='{$naam['username']}'");
}
elseif ($time == "55"){
mysql_query("update `Geld` SET `Geld`+'$more' FROM products WHERE Naam ='{$naam['username']}'");
}
elseif ($time == "56"){
mysql_query("update `Geld` SET `Geld`+'$more' FROM products WHERE Naam ='{$naam['username']}'");
}
elseif ($time == "57"){
mysql_query("update `Geld` SET `Geld`+'$more' FROM products WHERE Naam ='{$naam['username']}'");
}
elseif ($time == "58"){
mysql_query("update `Geld` SET `Geld`+'$more' FROM products WHERE Naam ='{$naam['username']}'");
}
elseif ($time == "59"){
mysql_query("update `Geld` SET `Geld`+'$more' FROM products WHERE Naam ='{$naam['username']}'");
}
elseif ($time == "60"){
mysql_query("update `Geld` SET `Geld`+'$more' FROM products WHERE Naam ='{$naam['username']}'");
}
?>
 
De fout is dat je niet uitlegt wat je ziet gebeuren en wat je verwacht dat er zou gebeuren en wij je dus niet kunnen helpen :)

Ik zie trouwens wel iets wat er fout gaat, je kunt geen array aanspreken binnen dubbele haken.

Dit is fout:
PHP: 
$string = "Hoi $_POST['naam]!";

Het moet zo:
PHP: 
$string = "Hoi " . $_POST['naam'] . "!";
 
Laatst bewerkt door een moderator:
Het kan wel, echter niet op de gebruikte manier.

Dit kan niet
PHP: 
$string = "Hoi $_POST['naam']!";
Maar dit kan wel:
PHP: 
$string = "Hoi $_POST[naam]!";

Toegegeven, dit is niet overzichtelijk dus de beste manier is inderdaad dit van Frats (Hoewel ik zelf eerder single-quotes voor de echo zou gebruiken)

Verder kijk ik naar veel onnozele code...
Waarom elke keer dezelfde query?
Wat voor nut hebben die IF-statements dan nog als je toch steeds dezelfde query uitvoert?
 
Status
Niet open voor verdere reacties.
                    Steun ons                    

Nieuwste berichten

Terug
Bovenaan Onderaan