[RESOLVED] Catchable fatal error: Object of class stdClass could not be converted to string...

[ssmitra]

I have the following code, written in php 5, to extract an ID from the User table.

$userid="SELECT userid FROM user WHERE email='$email'";
$userid_result = mysql_query($userid) or die(mysql_error());
$userid_result_value = mysql_fetch_object($userid_result);

I then try and store this result into a session variable.

$_SESSION['uid']=$userid_result_value;

I then try and call this session variable else where in my website. Each, and everytime that I do, I get the error "Catchable fatal error: Object of class stdClass could not be converted to string in C:\Test\reg_form_step2.php on line 41". The code at line 41 is:

<?php echo $_SESSION['uid']; ?>

I've tried changing the 'userid' to 'firstname' from the SELECT statement, as I thought it might be something to do with the the fact that the ID is automactically generated. I used the LAST_INSERT_ID() command to store the ID into another table, I get the same error when I try to call the variable held in this field too.

What I really want to do is insert the user ID from the user table into another table along with another user ID as follows:

$insert_user_img = "INSERT INTO img(imgID,user_image) VALUES (null,'$u_img')";
mysql_query($insert_user_img) or die (mysql_error());

$img_insert = "INSERT INTO user_image(UserID,imgID)VALUES('$_SESSION['uid']', LAST_INSERT_ID())";
$img_insert_result = mysql_query($img_insert) or die (mysql_error());

But the way things are going, that's just a distant dream.

It'd be fair to say that this problem is driving me nuts, your help would be greatly appreciated.

Thank you in advance. 🙂

[suntra]

http://ca3.php.net/manual/en/ref.session.php

« Caution

If you do turn on session.auto_start then you cannot put objects into your sessions since the class definition has to be loaded before starting the session in order to recreate the objects in your session. »

[Weedpacket]

You could also use mysql_fetch_array() and not bother with the anaemic object that mysql_fetch_object() returns (as noted on the mysql_fetch_object() page, they're pretty much identical).

[ssmitra]

Firstly just a quick thank you for your help so far, I've tried both your suggestions.

I've changed the mysql_fetch_object() function to the mysql_fetch_array() function, and I have edited the session.auto_start line in my php.ini file by setting the default value of '0' to the value '1'.

Unfortunately, having done what you have said and by also restarting the apache server (Stop->Start) after editing the php.ini file, I came across a problem I had before. The error reads like this:

Parse error: parse error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in C:\Test\reg_form_step2.php on line 44

Line 44 of the reg_form_step2.php file reads as follows:

$insert_user_img = "INSERT INTO user_img(userID,imageID) VALUES ('$_SESSION['uid']',LAST_INSERT_ID())";

The above code comes immediately after I execute the following SQL query on line 42:

$insert_img = "INSERT INTO img(imgID,user_image) VALUES (null,'$u_img')";

Thank you in advance, if there's anymore information you require then please get in touch.

[ssmitra]

I should make clear what changes I have done to the executing of the code so as to prevent any confusion.

My first query related to printing the contents of a session variable to the screen using the echo command. It didn't involve inserting the session variable into the database.

When I edited my code in response to the replies, I commented out the echo command and tried doing what I intended to do initially and entered the session variable into the database, this resulted in the "parse error".

I've just commented out the insert request and uncommented the echo command. Having done so, I am still getting the "Catchable fatal error" message. Even after editing the php.ini file and changing the mysql_fetch_object to mysql_fetch_array() which, I should point out worked, but the array value returned was simply 'Array'.

Thanks again!

[Weedpacket]

$insert_user_img = "INSERT INTO user_img(userID,imageID) VALUES ('{$_SESSION['uid']}',LAST_INSERT_ID())";

[ssmitra]

Thank you Weedpacket! (Although I'm pretty sure that's not your real name.)

I did this instead and it worked equally the same:

$uid=$_SESSION['uid'];
$insert_user_img = "INSERT INTO user_img(userID,imageID) VALUES ('$uid',LAST_INSERT_ID())";

Thanks to everyone who has viewed and helped resolve this issue. Hopefully other programmers will find this useful too.