Webwereld

Corne`s Php/Sql vragen *Nieuw*

Gestart doorWereldhotel22 reacties70 weergaven
Log in om mee te praten

23 berichten · pagina 2 van 2

Wereldhotel

Lid · Topicstarter

Berichten
542
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Reageert niet, als ik op Voeg toe aan Shop! klik gebeurt er niets.
0
Mauriceb

Lid

Berichten
545
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
[COLOR= #0000BB]<?php[/COLOR]
[URL="http://www.php.net/include"]include[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"config.php"[/COLOR][COLOR= #007700]);[/COLOR]

[URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/isset"]isset[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]Button1[/COLOR][COLOR= #007700]])) {[/COLOR]
    [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/empty"]empty[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]downurl[/COLOR][COLOR= #007700]]) ||[/COLOR] [URL="http://www.php.net/empty"]empty[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]price[/COLOR][COLOR= #007700]])) {[/COLOR]
        [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]U heeft niet alle velden ingevuld![/COLOR][COLOR= #007700];
        }[/COLOR] [URL="http://www.php.net/else"]else[/URL] [COLOR= #007700]{[/COLOR]
        [COLOR= #0000BB]$Url[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM dls WHERE downurl = "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]downurl[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]""[/COLOR][COLOR= #007700])[/COLOR] or [URL="http://www.php.net/die"]die[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_error"]mysql_error[/URL][COLOR= #007700]());[/COLOR]
        [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_num_rows"]mysql_num_rows[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$Url[/COLOR][COLOR= #007700]) ===[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700]) {[/COLOR]
            [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"INSERT INTO dls (downurl,price) VALUES ("[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]downurl[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]", "[/COLOR][COLOR= #007700].([/COLOR][COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]price[/COLOR][COLOR= #007700]]).[/COLOR][COLOR= #DD0000]")"[/COLOR][COLOR= #007700])[/COLOR] or [URL="http://www.php.net/die"]die[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_error"]mysql_error[/URL][COLOR= #007700]());[/COLOR]
            [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]De Download is Succesvol toegevoegd.[/COLOR][COLOR= #007700];
        }[/COLOR] [URL="http://www.php.net/else"]else[/URL] [COLOR= #007700]{[/COLOR]
            [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]Download Url is al in gebruik.[/COLOR][COLOR= #007700];
        }
    }
}[/COLOR] [URL="http://www.php.net/else"]else[/URL] [COLOR= #007700]{[/COLOR]
    [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<form method="post" style="width: 817px">[/COLOR][COLOR= #007700];[/COLOR]
    [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]Download Url:<br />[/COLOR][COLOR= #007700];[/COLOR]
    [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<input name="downurl" type="text" /><br />[/COLOR][COLOR= #007700];[/COLOR]
    [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]Prijs:<br />[/COLOR][COLOR= #007700];[/COLOR]
    [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<input name="price" type="text" />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;[/COLOR][COLOR= #007700];[/COLOR]
    [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<br />[/COLOR][COLOR= #007700];[/COLOR]
    [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<input name="Button1" type="submit" value="Voeg Toe aan Shop!" style="height: 42px; width: 136px" /></form>[/COLOR][COLOR= #007700];
}[/COLOR]    
?>
0
Wereldhotel

Lid · Topicstarter

Berichten
542
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
1. Kevmaus, Check je email biggrin
2. Nu ff een aanvraagje biggrin
0
Mauriceb

Lid

Berichten
545
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Shop.php

[COLOR= #0000BB]<?php[/COLOR]
[URL="http://www.php.net/include"]include[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"config.php"[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$count[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT count(downid) AS items FROM dls"[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$count2[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$count[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$count2[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$count2[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]items[/COLOR][COLOR= #007700]];[/COLOR]
[COLOR= #0000BB]$data[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM dls"[/COLOR][COLOR= #007700])[/COLOR] or [URL="http://www.php.net/die"]die[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_error"]mysql_error[/URL][COLOR= #007700]());[/COLOR]
[URL="http://www.php.net/while"]while[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$info[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_array"]mysql_fetch_array[/URL][COLOR= #007700]([/COLOR] [COLOR= #0000BB]$data[/COLOR] [COLOR= #007700])) {[/COLOR]

[URL="http://www.php.net/Print"]Print[/URL] [COLOR= #DD0000]"<b>ID:</b> "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$info[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]downid[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]" <br>"[/COLOR][COLOR= #007700];[/COLOR] 
[URL="http://www.php.net/Print"]Print[/URL] [COLOR= #DD0000]"<b>Price:</b> "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$info[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]price[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]" <br>"[/COLOR][COLOR= #007700];[/COLOR]
[URL="http://www.php.net/Print"]Print[/URL] [COLOR= #DD0000]"<a href=koop.php?id="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$info[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]downid[/COLOR][COLOR= #007700]] .[/COLOR][COLOR= #DD0000]">Koop nu!</a>"[/COLOR][COLOR= #007700];
}[/COLOR]
?>


Zo?

En
Koop.php

[COLOR= #0000BB]<?php[/COLOR]
[URL="http://www.php.net/include"]include[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"config.php"[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$saldo[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT `saldo` FROM `users` WHERE `id`={$_SESSION[uid]}"[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$usrData[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$saldo[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$buy[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$usrData[/COLOR][COLOR= #007700][[/COLOR]saldo[COLOR= #007700]];[/COLOR]

[URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$buy[/COLOR] [COLOR= #007700]>=[/COLOR] [COLOR= #0000BB]0.10[/COLOR][COLOR= #007700]) {[/COLOR]
[URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT `saldo` FROM `users`  SET `saldo`-0,10  WHERE `id`={$_SESSION[uid]}"[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$sid[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_real_escape_string"]mysql_real_escape_string[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]]);[/COLOR]
[COLOR= #0000BB]$dbres[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM dls WHERE downid = "[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$sid[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #DD0000]""[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$link[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$dbres[/COLOR][COLOR= #007700]);[/COLOR]
[URL="http://www.php.net/Header"]Header[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"Location: $link[downurl]"[/COLOR][COLOR= #007700]);
}[/COLOR]
?>


EDIT: Klaar, heb het script nu foutloos smile
0
Wereldhotel

Lid · Topicstarter

Berichten
542
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Edit: Oh ik zie dat jij het al gefixt heb, w8 ff ik test het.

Edit 2: Er gebeurt niks bij koop.php. Enneh nu staat er 0,10 als prijs maar zou je kunnen doen dat automatisch door de id van het product de prijs gezet word?
0
Mauriceb

Lid

Berichten
545
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Vervang:

[COLOR= #0000BB]<?php
$sid[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_real_escape_string"]mysql_real_escape_string[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]]);[/COLOR]
?>


door:

[COLOR= #0000BB]<?php
$sid[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_real_escape_string"]mysql_real_escape_string[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]]);[/COLOR]
?>
0
Wereldhotel

Lid · Topicstarter

Berichten
542
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Er gebeurt nog niks bij koop.php. Enneh nu staat er 0,10 als prijs maar zou je kunnen doen dat automatisch door de id van het product de prijs gezet word?
0
Mauriceb

Lid

Berichten
545
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
[COLOR= #0000BB]<?php[/COLOR]
[URL="http://www.php.net/include"]include[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"config.php"[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$saldo[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT `saldo` FROM `users` WHERE `id`={$_SESSION[uid]}"[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$usrData[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$saldo[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$sid[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_real_escape_string"]mysql_real_escape_string[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]]);[/COLOR]
[COLOR= #0000BB]$dbres[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM dls WHERE downid = "[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$sid[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #DD0000]""[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$link[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$dbres[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$buy[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$usrData[/COLOR][COLOR= #007700][[/COLOR]saldo[COLOR= #007700]];[/COLOR]

[URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$buy[/COLOR] [COLOR= #007700]>=[/COLOR] [COLOR= #0000BB]$link[/COLOR][COLOR= #007700][[/COLOR]price[COLOR= #007700]]) {[/COLOR]
[URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT `saldo` FROM `users`  SET `saldo`=`saldo`-{$link[price]}  WHERE `id`={$_SESSION[uid]}"[/COLOR][COLOR= #007700]);[/COLOR]
[URL="http://www.php.net/Header"]Header[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"Location: {$link[downurl]}"[/COLOR][COLOR= #007700]);
}[/COLOR]
?>


EDIT:

[COLOR= #0000BB]<?php[/COLOR]
[URL="http://www.php.net/include"]include[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"config.php"[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$saldo[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT `saldo` FROM `users` WHERE `id`={$_SESSION[uid]}"[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$usrData[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$saldo[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$sid[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_real_escape_string"]mysql_real_escape_string[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]]);[/COLOR]
[COLOR= #0000BB]$dbres[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM dls WHERE downid = "[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$sid[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #DD0000]""[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$link[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$dbres[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$buy[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$usrData[/COLOR][COLOR= #007700][[/COLOR]saldo[COLOR= #007700]];[/COLOR]

[URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$buy[/COLOR] [COLOR= #007700]>=[/COLOR] [COLOR= #0000BB]$link[/COLOR][COLOR= #007700][[/COLOR]price[COLOR= #007700]]) {[/COLOR]
[URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT `saldo` FROM `users`  SET `saldo`=`saldo`-"[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$link[/COLOR][COLOR= #007700][[/COLOR]price[COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]"  WHERE `id`={$_SESSION[uid]}"[/COLOR][COLOR= #007700]);[/COLOR]
[URL="http://www.php.net/Header"]Header[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"Location: "[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$link[/COLOR][COLOR= #007700][[/COLOR]downurl[COLOR= #007700]]} .[/COLOR] [COLOR= #DD0000]""[/COLOR][COLOR= #007700]);
}[/COLOR]
?>


Edit 2:

[COLOR= #0000BB]<?php[/COLOR]
[URL="http://www.php.net/include"]include[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"config.php"[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$saldo[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT `saldo` FROM `users` WHERE `id`={$_SESSION[uid]}"[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$usrData[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$saldo[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$sid[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_real_escape_string"]mysql_real_escape_string[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]]);[/COLOR]
[COLOR= #0000BB]$dbres[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM dls WHERE downid = "[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$sid[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #DD0000]""[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$link[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$dbres[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$buy[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$usrData[/COLOR][COLOR= #007700][[/COLOR]saldo[COLOR= #007700]];[/COLOR]

[URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$buy[/COLOR] [COLOR= #007700]>=[/COLOR] [COLOR= #0000BB]$link[/COLOR][COLOR= #007700][[/COLOR]price[COLOR= #007700]]) {[/COLOR]
[URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT `saldo` FROM `users`  SET `saldo`=`saldo`-"[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$link[/COLOR][COLOR= #007700][[/COLOR]price[COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]"  WHERE `id`={$_SESSION[uid]}"[/COLOR][COLOR= #007700]);[/COLOR]
[URL="http://www.php.net/Header"]Header[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"Location: "[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$link[/COLOR][COLOR= #007700][[/COLOR]downurl[COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]""[/COLOR][COLOR= #007700]);
}[/COLOR]
?>


EDIT 3:

[COLOR= #0000BB]<?php[/COLOR]
[URL="http://www.php.net/include"]include[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"config.php"[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$saldo[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT `saldo` FROM `users` WHERE `id`={$_SESSION[uid]}"[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$usrData[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$saldo[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$sid[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_real_escape_string"]mysql_real_escape_string[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]]);[/COLOR]
[COLOR= #0000BB]$dbres[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM dls WHERE downid = "[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$sid[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #DD0000]""[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$link[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$dbres[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$buy[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$usrData[/COLOR][COLOR= #007700][[/COLOR]saldo[COLOR= #007700]];[/COLOR]

[URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$buy[/COLOR] [COLOR= #007700]>=[/COLOR] [COLOR= #0000BB]$link[/COLOR][COLOR= #007700][[/COLOR]price[COLOR= #007700]]) {[/COLOR]
[URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"UPDATE `users` SET `saldo`=`saldo`-"[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$link[/COLOR][COLOR= #007700][[/COLOR]price[COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]"  WHERE `id`={$_SESSION[uid]}"[/COLOR][COLOR= #007700]);[/COLOR]
[URL="http://www.php.net/Header"]Header[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"Location: "[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$link[/COLOR][COLOR= #007700][[/COLOR]downurl[COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]""[/COLOR][COLOR= #007700]);
}[/COLOR]
?>
0

Jouw reactie

Deel je idee, stel een vraag of help een ander verder.

Editor laden…

Praat mee met de One2xs-community.

Inloggen om te reageren