dobbel post
Hvordan forhindre jeg denne kode i at smide tomme felter ind i mysql databasen når jeg trykker på Opdater...?<?php
$db = mysql_connect("localhost", "root", "xxxxxx") or die (mysql_error());
mysql_select_db("domains") or die (mysql_error());
mysql_query("INSERT INTO vhosts (domain, docroot) VALUES ('" . $_POST["domain"] . "','" . $_POST["docroot"] . "')") or die(mysql_error());
?>
<form action="<? $PHP_SELF ?>" method="post">
<table border="0" width="100%" style="border-collapse: collapse" bordercolor="#111111" cellpadding="0" cellspacing="0" height="101">
<tr>
<td width="100%" height="16"><font color="000000" face="verdana" size="1">Domain:</font></td>
<td width="100%" height="16" ></td>
</tr>
<tr>
<td width="50%" height="22">
<input type="text" name="domain" size="20" maxlength="20">
</font></td>
</tr>
<tr>
<td width="100%" height="16"><font color="000000" face="verdana" size="1">Docroot:</td>
<td width="100%" height="16" ></td>
</tr>
<tr>
<td width="50%" height="22">
<input type="text" name="docroot" size="20" maxlength="20">
</font></td>
</tr>
<tr>
<td width="50%" height="26">
<input type="submit" value="Opret">
<input type="submit" class="button" name="clear" value="Clear">
<input type="submit" class="button" name="update" value="Opdater"></font></td><br><br><p>
</tr>
</tabel>
</form>
<tr>
<td width="50%">
<?
$result = mysql_query("select id, domain, docroot FROM vhosts order by id desc LIMIT 0, 50");
while($row = mysql_fetch_array($result)){
echo "
<table border=\"1\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse; border-top: 1px solid #BBB5A5\" bordercolor=\"#111111\" width=\"15%\" height=\"1\">
<tr>
<td width=\"35%\" valign=\"top\" height=\"1\">
<font face=\"Verdana\" size=\"1\">$row[id]</td>
<td width=\"35%\" valign=\"top\" height=\"1\">
<font face=\"Verdana\" size=\"1\">$row[domain]</td>
<td width=\"35%\" valign=\"top\" height=\"1\">
<font face=\"Verdana\" size=\"1\"> $row[docroot]<br>
</td>
</font></td>
</tr></table>
";
}
?>
