how get the value from assoc array using php

Question

   Array([0] => stdClass Object([max(Transaction_id)] => 10251))

My php sql query returns the answer in this format.
How can i display the only value from this format.
Thanks in advance

simple way you will convert stdclass to array type, after you can get data easily. for more clarity see this post . stackoverflow.com/questions/19495068/… — parthi
– parthi, Commented Mar 23, 2018 at 8:02
you can also get sql query result as array as well.post your code here .. — Rajeev Ranjan
– Rajeev Ranjan, Commented Mar 23, 2018 at 8:32

Del · Accepted Answer · 2018-03-23 08:02:04Z

1

In your query add the as then the name of the column that you want to retreive.

SELECT MAX(COLUMNNAME) AS example example FROM TABLENAME

And then in your php file

echo $result[0]['example'];

answered Mar 23, 2018 at 8:02

Del

1621 silver badge7 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

@Obulisathish.v if its works well .you need to accept answer.if given code works for you.try to understand stackoverflow rules and docs.thanks

Atural · Accepted Answer · 2018-03-23 09:21:05Z

0

if for some reasons you are unable to convert the sql query you can access to this variable in the following way

echo $obj->{"max(Transaction_id)"};

answered Mar 23, 2018 at 9:21

Atural

5,4505 gold badges21 silver badges36 bronze badges