Is not registering in db
Posted: Sat Aug 01, 2009 6:33 am
Code: Select all
<!-- Inregistrare -->
<?php
// Conectare la db
mysql_connect("localhost","root","") or die(mysql_error());
mysql_select_db("agenda") or die(mysql_error());
//Formularul de inregistrare
if(isset($_POST['Submit']))
{
if (!$_POST['nume'] | !$_POST['prenume'] | !$_POST['email']| !$_POST['parola'] | !$_POST['parola2'] )
{
die("Nu ai complectat toate campurile.");
}
//verificare daca exista acel email
if (!get_magic_quotes_gpc())
{
$_POST['email'] = addslashes($_POST['email']);
}
$echeck = $_POST['email'];
$check = mysql_query("SELECT email FROM user WHERE email = '$echeck'")or die(mysql_error());
$check2 = mysql_num_rows($check);
if ($check2 != 0)
{
die('Adresa de email '.$_POST['email'].' exista deja.');
}
if ($_POST['parola'] != $_POST['parola2'])
{
die('Parola introdusa nu este corecta. ');
}
//encriptez parola in md5
$_POST['parola'] = md5($_POST['parola']);
if (!get_magic_quotes_gpc())
{
$_POST['parola'] = addslashes($_POST['parola']);
$_POST['nume'] = addslashes($_POST['nume']);
}
//introducem in database
$inserare = "INSERT INTO user (nume, prenume, email, parola) VALUES ('".$_POST['nume']."', '".$_POST['prenume']."','".$_POST['email']."', '".$_POST['parola']."')";
$adaugare = mysql_query($inserare);
}
?>
<form action="register.php" method="post">
<table border="0">
<tr><td>Nume:</td><td>
<input type="text" name="nume" maxlength="60">
</td></tr>
<tr><td>Prenume:</td><td>
<input type="text" name="prenume" maxlength="60">
</td></tr>
<tr><td>Email:</td><td>
<input type="text" name="email" maxlength="60">
</td></tr>
<tr><td>Parola:</td><td>
<input type="password" name="parola" maxlength="10">
</td></tr>
<tr><td>Confirmare Parola:</td><td>
<input type="password" name="parola2" maxlength="10">
</td></tr>
<tr><th colspan=2><input type="submit" name="submit" value="Register"></th></tr> </table>
</form>