function is not working

[karthikanov24]

hi

the PASSWORD( ) used in the following code, is used to take the newly added password from user to database

 

 

   function addUser()
{
    $userName = $_POST['txtUserName'];
$password = $_POST['txtPassword'];

// check if the username is taken
$sql = "SELECT user_name
        FROM tbl_user
		WHERE user_name = '$userName'";
$result = dbQuery($sql);

if (dbNumRows($result) == 1) {
	header('Location: index.php?view=add&error=' . urlencode('Username already taken. Choose another one'));	
} else {			
	$sql   = "INSERT INTO tbl_user (user_name, user_password, user_regdate)
	          VALUES ('$userName',PASSWORD('$password'), NOW())";

	dbQuery($sql);
	header('Location: index.php');	
}
}

 

 

But here in the admin login code as follow,the PASSWORD( ) is not working. If a call is made to this funtion it shows error as:UNDEFINED FUNCTION PASSWORD( )

 

function doLogin()
{

$userName = $_POST['txtUserName'];
$password=$_POST['txtPassword'];
        

// first, make sure the username & password are not empty
if ($userName == '') {
	$errorMessage = 'You must enter your username';
} else if ($password == '') {
	$errorMessage = 'You must enter the password';
} else {
	// check the database and see if the username and password combo do match
	$sql = "SELECT user_id
	        FROM tbl_user 
			WHERE user_name = '$userName' AND user_password =PASSWORD('$password')";

$result = dbQuery($sql);

 

 

what is the correct codes.....?

 

 

Thanks

karthikanov24

 

[mrMarcus]

the correct code would be making sure the code above has access to the function PASSWORD().

 

the error you posted is stating that there is no defined function PASSWORD() .. you will either need to create that function or make it available.

[karthikanov24]

hi

The PASSWORD() is not user defined funtion,its mysql PASSWORD()......

so what should be done,please...

 

thanks

karthikanov24

[highrevhosting]

Honestly,

 

I'd use MD5() over Password()

 

The downside you cant really reverse MD5, so forgot password would have to set a new one for them.