2 replies to this topic

[alex1]

Hi!
I have this code:

<?php

//Connect To Database

$connect = mysql_connect("localhost","parkingc_php","123");
if (!$connect)
{
die("MySQL could not connect!");
}

$DB = mysql_select_db('parkingc_php');

if(!$DB)
{
die("My SQL could not select Database!");
}

//Declare Variables

$name = $_POST['name'];
$email = $_POST['email'];
$email1 = "@";
$email_Check = strpos($email,$email1);
$password = $_POST['password'];
$passencr = md5($password);
$AFM = $_POST['AFM'];
$ADT = $_POST['ADT'];
$tel = $_POST['tel'];

//Check To See If some of the Information Is Correct

if($name == "")
{
die("Opps! You don't enter a username!");
}

if($password == "")
{
die("Opps! You didn't enter one of your passwords!");
}

if($Email_Check === false)
{
die("Opps! That's not an email!");
}

// Insert Information Into MySQL Database

if(!mysql_query("INSERT INTO Customer (Name, Surname, ADT, AFM, Tel, email, password,IP)
VALUES ('$name', '$surname', '$ADT', '$AFM', '$tel', '$email', '$passencr', '$email1')"))
{
die("error!");
}

?>

My problem is regarding - "$passencr = md5($password);"

When I'm running the query with the normal password variable everything is ok,but when I cange it to "$passencr" It can't run... I'm 100% sure that it's a super small problem,but my main language is not php,but I would like to learn it also.
Please don't mind the IP - I have not made the script getting it yet.
Any help is highly appreciated!

[gregwarner]

It looks fine to me. Can you please elaborate on "when I cange it to "$passencr" It can't run..."

[papabear]

please kindly check the field type on where you are storing the $passencr it might be a incompatible type error.
Is this giving you some sort of error when inserting? also you might want to take a look at this tutorial for hashing/encrypting password in PHP5

Creating A Simple Yet Secured Login/registration With Php5