Need Urgent Help: User profiles

[danielhalawi]

Hi,
I've got a user accounts set up, now I'm trying to allow users to edit their profiles.
This is the code I'm using to call up the profile.

require("common.php");

$action="profile.php";

if (!$auth[error]) {
switch($invoke) {
case"Modify":
$data=$auth;
list($data[tahun],$data[bulan],$data[tanggal])=explode("-", $data[birthdate]);
$button=array("Update");
$content="phpmember/include/edit.php";
$bartitle="Change My Profile";
break;
case"Update":
if ($firstname && $lastname && $email) {

$data=$auth;

$data=$HTTP_POST_VARS;
$data[login]=$auth[login];
update_member($data, "member");
$content="Change Profile Succeed";
$bartitle="Profile Updated";
} else {$error="80";}
break;
default:
$data=$auth;
list($data[tahun],$data[bulan],$data[tanggal])=explode("-", $data[birthdate]);
$button=array("Modify");
$content="phpmember/include/detail.php";
$bartitle="My Profile Detail";
}
} else {$error=$auth[error];}

error_message($error);

When I add this to my template using $content, I get the following warning :

Fatal error: Call to undefined function: error_message() in /home/sites/site2/web/vmplay/profile.php on line 56

$auth is definded in

<?
require("phpmember/require/config.php");
require("phpmember/require/authentication.php");
$auth=authenticate($login, $password); # authentication
?>

Is there anyone who can help me thanx.

[xblue]

With the syntax you use the parser assumes error_message to be a function and complains because it obviously isn't existing.

There are 2 ways out I can think of:
Either define a function named error_message, or if you just want to display the error, use echo $error; instead of error_message($error);

Or (this is just a wild guess) do you happen to have an array called $error_message which maps error numbers to messages?
In this case, the syntax to display the error should be
echo $error_message[$error];

[hand]

The script calls a user defined function "error_message()" which doesn't exist.

[danielhalawi]

The error messages needed to be defined.
But more problems
The detail page is being displayed as it should be in $content.
However no actual details are being displayed.
This is how the details are called.

<?echo ucfirst($data[gender])?>

or

<?echo $data[lastname]?>

and the following

<?echo mysql_result(mysql_db_query($db_name, "SELECT occupation FROM $tbl_occupation WHERE occupation_id=$data[occupation]"),0);?>

gets this error.

Warning: Supplied argument is not a valid MySQL result resource in /home/sites/site2/web/vmplay/phpmember/include/detail.php on line 58

Thanx for help.

[hand]

Are all the variables are set correctly?
o $db_name
o $tbl_occupation
o $data[occupation]

Do the fields exist?
o occupation
o occupation_id

Add an OR-Statement to get further informations

mysql_result(mysql_db_query($db_name,
   "SELECT occupation FROM $tbl_occupation
      WHERE occupation_id=$data[occupation]"),0)
   or print "&gt;&gt;&gt; MySQL-Error: ".mysql_errno()." -&gt; ".mysql_error()."<br>\n";

[danielhalawi]

Everything in my detail and edit page was set to $data I've changed it all to $auth and all the details appeared.
Now when I press on the submit button I get the following error.

Fatal error: Call to undefined function: update_member() in /home/sites/site2/web/vmplay/profile.php on line 42

This is where the details should go when pressed on update:

case"Update":
if ($firstname && $lastname && $email) {

$data=$auth;

$auth=$HTTP_POST_VARS;
$auth[login]=$auth[login];
update_member($auth, "member");
$content="Change Profile Succeed";
} else {$error="80";}

and this is the code in the update in the updating database page.

function update_member ($auth, $user) {
global $db_name, $tbl_member;
if ($user == "admin") {
$oldpassword = mysql_result(mysql_db_query($db_name, "SELECT password FROM $tbl_member WHERE login='$auth[login]'"),0);
if ($oldpassword == $auth[password]) {$password="";}
else {$password="password='$auth[password]', ";}

else {$password="password='".crypt($auth[password], $auth[login])."', ";}

$active="active='$auth[active]', ";
}
$query = "UPDATE $tbl_member SET $active $password ";
$query.= "firstname='$auth[firstname]', lastname='$auth[lastname]', email='$auth[email]', ";
$query.= "occupation=$auth[occupation], organization='$auth[organization]', gender='$auth[gender]', ";
$query.= "birthdate='$auth[tahun]-$auth[bulan]-$auth[tanggal]', city='$auth[city]', ";
$query.= "zipcode='$auth[zipcode]', state='$auth[state]', country='$auth[country]', website='$auth[website]', ";
$query.= "phone='$auth[phone]', address='$auth[address]' ";
$query.= "WHERE login='$auth[login]'";
$hasil=mysql_db_query($db_name, $query) or die (mysql_error());
return $auth[error];

Whats wrong?

[hand]

The script calls a user defined function "update_member()" which doesn't exist at the moment of the call.

It's possible that this function exists in an other file. Is that file included or required anywhere in this script?

[danielhalawi]

I found that I was including the wrong file. whopps.

But now my records are not updating. Can someone have a look for me. I think it may because I have been changing $auth and $data around in my code. I have tried restoring but still not updating.

This is the code that gets submitted on submit:

case"Update":
		if ($firstname && $lastname && $email) {
#			$auth=$auth;
			$data=$HTTP_POST_VARS;
			$auth[login]=$auth[login];
			update_member($data, "member");
			$content="success.php";
		} else {$error="80";}

This is what happens in update_member:

function update_member ($data, $user) {
	global $db_name, $tbl_member;
	if ($user == "admin") {
		$oldpassword = mysql_result(mysql_db_query($db_name, "SELECT password FROM $tbl_member WHERE login='$auth[login]'"),0);
		if ($oldpassword == $auth[password]) {$password="";} 
		else {$password="password='$auth[password]', ";}
#		else {$password="password='".crypt($auth[password], $auth[login])."', ";}
		$active="active='$auth[active]', ";
	}
	$query = "UPDATE $tbl_member SET $active $password ";
	$query.= "firstname='$data[firstname]', lastname='$data[lastname]', email='$data[email]', ";
	$query.= "occupation=$data[occupation], organization='$data[organization]', gender='$data[gender]', ";
	$query.= "birthdate='$data[tahun]-$data[bulan]-$data[tanggal]', city='$data[city]', ";
	$query.= "zipcode='$data[zipcode]', state='$data[state]', country='$data[country]', website='$data[website]', ";
	$query.= "phone='$data[phone]', address='$data[address]' ";
	$query.= "WHERE login='$auth[login]'";
	$hasil=mysql_db_query($db_name, $query) or die (mysql_error());
return $auth[error];

My fields in my edit form all have this in the value respectivly:

<?echo $auth[something]?>

is there a problem in any of this code?
Thanks for help.

[danielhalawi]

Is there anyone who can help me? I would appriciate any help at all.

Thank You