return multiple OUT using PDO

[jrahma]

Hi,

I am using the following code in PDO to insert member details in my database.

	$mysql_query = $mysql_connection->prepare($mysql_command);
	$mysql_query->bindParam(':param_member_email', $member_email, PDO::PARAM_STR);
	$mysql_query->bindParam(':param_member_first_name', $member_first_name, PDO::PARAM_STR);
	$mysql_query->bindParam(':param_member_last_name', $member_last_name, PDO::PARAM_STR);
	$mysql_query->bindParam(':param_member_password', $member_password, PDO::PARAM_STR);

$mysql_query->execute();

I would like to know how can I can using the above code return multiple OUT parameters from the database such as:

1. member_guid

2. member_activation_code

[laserlight]

You would use $mysql_query->fetch().

[jrahma]

How? you mean to call another SELECT stored procedure?

the procedure which I am executing here is an INSERT procedure.

[laserlight]

Oh, I missed the part where you wrote that the code was "to insert member details". Maybe you should have shown the value of $mysql_command.

Since it is an INSERT statement, there isn't anything that you are retrieving, hence your question does not make sense. It might be the case that you want to use an auto-incremented id in another statement, in which case there are database specific methods of doing so, so you should provide more details. As for member_activation_code: if you didn't insert a value, then there's nothing to retrieve, unless say, you have a trigger that populates it, in which case you should do a SELECT.

[jrahma]

in the .net I am passing the member_id and activation_code as OUT, setting the member_id as LAST_INSERT_ID and activation_code as UUID in the MySQL that's how I will be able to read..

I would like to know how to o the same in php?