MySQL with PHP talk

ddrummond

Hi !!!! I have this code to authenticate my user, looking in mysql database and i don\'t know whats happing because him goto always to the error page !!!!!!!!!!

<?php

require \'functions.php\';

if(authenticateUser($form_user_id, $form_password))
{
	setcookie(\"cookie_passwd\", $form_password);
	setcookie(\"cookie_user\", $form_user_id);

header(\"Location:http://$HTTP_HOST/$DOCROOT/menu.html\");
	exit();
} else {

header(\"Location:http://$HTTP_HOST/$DOCROOT/erro/erro_1.php\");
	exit();
}

?>

I\'m so sorry my english. tanks

amcgrath

Can you paste the code for the authenticateUser() function?

ddrummond

Yes !!!! this is my problem. in this code i talk to php check the user...and pass... in the mysql database if the user and pass ok goto the menu page if not ok goto the error page. but don't works, all time goto the error page....

ddrummond

//my code to authenticate user

mysql_select_db("$db");

if (!($result = mysql_query("select * from user_profile where user_id = '$form_user_id' ")))
{
DisplayErrMsg(sprintf("internal error %d:%s\n", mysql_errno(), mysql_error()));
return 0 ;
}

if (($row = mysql_fetch_array($result)) && ($form_password == $row ["password"] && $form_password != "")) 
{
	return 1;
}else{
	return 0;
}

amcgrath

ok. this is not good. Try this:

function authenticateuser($form_user_id,$form_password) {
global $db;
mysql_select_db("$db");

$result = mysql_query("select * from
user_profile
where user_id = '$form_user_id'
AND password = '$form_password'");
if (!mysql_num_rows($result) {
return 0 ;
} else {
return 1;
}
}

This insn't perfect, but it sohuld get you where you want to be. (And make absolutely sure the values you enter are correct).