Auto naming associative array fields

[Tekime]

Hello all,

I am using a class to load values from a db and store those values in an instance of the class. So far I have been manually setting all of the values I load with the same names as the values in the db. Here's a bit of the script I am using so far (this is part of a class function - loadUser():

 	$query = "SELECT * FROM users WHERE userid='$userid';";
  	$result = $this->fDB->dbQuery($query, "fcms_auth");

if($result) {
  	$row = $this->fDB->dbFetchArray($result);
	$this->user[$userid]["username"] = $row["username"];
	$this->user[$userid]["firstname"] = $row["firstname"];
	$this->user[$userid]["lastname"] = $row["lastname"];
	$this->user[$userid]["email"] = $row["email"];
	$this->user[$userid]["created"] = $row["created"];
	$this->user[$userid]["lastlogon"] = $row["lastlogon"];                                                  
} else {
	$this->errors[] = "Error loading user information in fUser->loadUser";
}

I am trying to make a loop that will load all of the values in $row[] to $this->user[$userid] with the same field names in the associative array (i.e. $this->user[$userid]["username"], etc.). I know there is a way to do this by dereferencing the values (if that's what you would call it), but I am having a hard time with the syntax. Could someone point me in the right direction?

Thanks in advance,
Tek

[viper21634]

damn, you just made it a lot more complicated then it needs to be, php will make the array for you watch(i am going to use mssql for you, but will work just fine with others:

$server = "localhost";
$user = "user";
$pass = "pass";
$db = "mydb";
$query = "SELECT * FROM users WHERE userid='$userid';";
$conn = mssql_connect($server,$user,$pass);
mssql_select_db($db,$conn);
$result = mssql_query($query,$conn);
$sqlarray = mssql_fetch_assoc($result,$conn);

foreach($sqlarray as $key => $value)
{
echo "$key = $value";
//that will print all of the keynames and values from the array
}

not hard at all

[Tekime]

No, I realize that I am getting back an associative array. But I don't just want to print them out, etc., I need a new associative array created with the same field names and values inside my class.

fetcharray returns this:
$row["username"]
$row["firstname"]
$row["lastname"]
...et cetera

I need this array in $fUser->user[x], like this:
$fUser->user[1]["username"]
$fUser->user[1]["firstname"]
$fUser->user[1]["lastname"]
...et cetera

I can't just do $fUser->user[x] = $row[] can I?

Thanks for the post, and sorry if I'm missing the glaringly obvious :o

[Tekime]

Originally posted by Tekime
I can't just do $fUser->user[x] = $row[] can I?

NM, I just answered my own question, this works fine.

Thanks for the post, and sorry if I'm missing the glaringly obvious :o

It appears I was :p