Tjek datafelt med database
Hej jeg skal havde tjekket om indholdet af username != db_username fra databasen. Så vis der er en bruger med samme navn i databasen kan man ikke oprette sig og er der ikke en bruger med navnet i databasen kan man godt. er en min insert og tjek side.<? if($_POST['username'] != "" and $_POST['password'] != "" and $_POST['passwordtest'] != "" and $_POST['name'] != "" and $_POST['password'] == $_POST['passwordtest']){
session_start();
include("func.php");
Db::Conn(open);
$do = $_POST['do'];
if($do == "insert db_users"){
$username = $_POST['username'];
$password = md5($_POST['password']);
$name = $_POST['name'];
mysql_query("INSERT INTO db_users ( username , password , name ) VALUES ('$username' , '$password' , '$name' )") or die (Java::Alert("MySQL Error: ".mysql_error()));
Java::GoToURL("index.php");
}elseif($do == ""){
}
Db::Conn(close);
}else{ ?>
<table>
<tr>
<td>
</td>
</tr>
</table>
<table bgcolor="#FFFF00" align="center" style="border: 1px gray solid;">
<tr>
<td align="center">
Warning
</td>
</tr>
<? if($_POST['username'] == ""){ ?>
<tr>
<td>
The <strong>"Username:"</strong> field is empty?
</td>
</tr>
<? } ?>
<? if($_POST['password'] == ""){ ?>
<tr>
<td>
The <strong>"Password:"</strong> field is empty?
</td>
</tr>
<? } ?>
<? if($_POST['passwordtest'] == ""){ ?>
<tr>
<td>
The <strong>"Retype Password:"</strong> is empty?
</td>
</tr>
<? } ?>
<? if($_POST['password'] != $_POST['passwordtest']){ ?>
<tr>
<td>
The <strong>"Password:"</strong> and the <strong>"Retype Password:"</strong> do not match?
</td>
</tr>
<? } ?>
<? if($_POST['name'] == ""){ ?>
<tr>
<td>
The <strong>"Full Name:"</strong> field is empty?
</td>
</tr>
<? } ?>
</table>
<table align="center">
<tr>
<td>
<a href="java script:history.go(-1)">Go Back</a>
</td>
</tr>
</table>
<? }?>
