Dit moet werken
PHP
<?php
error_reporting(E_ALL);
echo'
<div id=\"content_top\"> </div>
<div id=\"content\">
<h1 class=\"titel\">Drugs</h1>';
if(isset($_POST['submit'])) {
$drugs = mysql_fetch_query("SELECT id, eigenaar, hoeveelheid, totaalprijs FROM drugs WHERE id = '" . $_POST['id'] . "'");
if($own['cash'] >= $drugs['totaalprijs']) {
echo'<div class=\"dark\"><font color=\"green\" style=\"font-weight: bold\">Je hebt ' . $drugs['hoeveelheid'] . ' gekocht.</font></div>';
mysql_query("UPDATE users SET cash = cash - '" . $drugs['totaalprijs'] . "' WHERE id = '" . $own['id'] . "'");
mysql_query("UPDATE drugs SET eigenaar = 0 WHERE id = '" . $drugs['id'] . "'");
$own['cash'] -= $drugs['totaalprijs'];
} else {
echo"<div class=\"dark\"><font color=\"red\" style=\"font-weight: bold\">Je hebt niet genoeg geld om drugs te kopen.</font></div>";
}
} else {
echo"<div class=\"dark\"><font color=\"red\" style=\"font-weight: bold\">Het drugs is al verkocht.</font></div>";
}
echo'
Hier kan je drugs kopen!
<form method=\"post\">
<table width=\"100%\" cellpadding=\"0\" cellspacing=\"0\">
<tr>
<td class=\"start\" width=\"17\"> </td>
<td class=\"start\">ID</td>
<td class=\"start\" width=\"17\"> </td>
<td class=\"start\">Eigenaar</td>
<td class=\"start\" width=\"17\"> </td>
<td class=\"start\">Hoeveelheid</td>
<td class=\"start\" width=\"17\"> </td>
<td class=\"start\">Prijs</td>
</tr>';
$drugskoop = mysql_query("SELECT id, eigenaar, hoeveelheid, totaalprijs FROM drugs WHERE eigenaar > '0'") or die(mysql_error());
while($koop = mysql_fetch_assoc($drugskoop)) {
echo'
<tr>
<td class=\"list\"><input type=\"radio\" name=\"id\" value="' . $koop['id'] . '" /></td>
<td class=\"list\"><input type=\"radio\" name=\"eigenaar\" value="' . $koop['eigenaar'] . '" /></td>
<td class=\"list\"><input type=\"radio\" name=\"hoeveelheid\" value="' . $koop['hoeveelheid'] . '" /></td>
<td class=\"list\"><input type=\"radio\" name=\"prijs\" value="' . $koop['totaalprijs'] . '" /></td>
</tr>';
}
echo'
</table>
<input type="submit" name="submit" class="submit" value="vrijkopen" />
</div>
<div id="content_bottom"> </div>';
?>
