How can I print Object's value in PHP which is fetched row from SQL?

Question

I have tried to print values of my PHP object '$mon' which is having average of all months.....

and My code for data fetch is as

$result = mysql_query("SELECT b_year, sum(m1) as m1, sum(m2) as m2, sum(m3) as m3, sum(m4) as m4, sum(m5) as m5, sum(m6) as m6, sum(m7) as m7, sum(m8) as m8, sum(m9) as m9, sum(m10) as m10, sum(m11) as m11, sum(m12) as m12  
            from s_budgets as b INNER JOIN users as u on b.u_id = u.id WHERE b_year=YEAR( CURDATE( ) )
GROUP BY b_year " );
$mon=mysql_fetch_array($result)

and my code for Displaying those values are as below....

 <?php echo $mon->m4;?>,
 <?php echo $mon->m5;?>,
 <?php echo $mon->m6;?>,

how can I print the object '$mon' with its several properties?

If it is for testing purpose just use print_r($mon) or you need to loop and do. — Nish
– Nish, Commented Oct 22, 2012 at 9:29

Tom B · Accepted Answer · 2012-10-22 09:29:18Z

2

You need to used mysql_fetch_object() rather than mysql_fetch_array() in order to access the data in an object format.

answered Oct 22, 2012 at 9:29

Tom B

2,9532 gold badges27 silver badges34 bronze badges

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

Comments

GBD · Accepted Answer · 2012-12-12 09:46:56Z

2

This $mon=mysql_fetch_array($result) fetch a result row as an associative array, a numeric array, or both..

echo $mon['m4'];

If you want result as object, then use following way

$mon = mysql_fetch_object($result)
$mon->m4

Please start to use Mysqli or PDO for new development.

edited Dec 12, 2012 at 9:46

answered Oct 22, 2012 at 9:28

GBD

16k2 gold badges49 silver badges52 bronze badges

Comments

user399666 · Accepted Answer · 2012-10-22 09:29:11Z

1

$mon isn't an object because mysql_fetch_array fetches an array from a MySQL resource. You'll have to access your array like so:

<?php echo $mon['m4']; ?>,
<?php echo $mon['m5']; ?>,
<?php echo $mon['m6']; ?>,

You'll need to use mysql_fetch_object if you're wanting an object.

answered Oct 22, 2012 at 9:29

user399666

20k7 gold badges49 silver badges68 bronze badges

Comments

acme · Accepted Answer · 2012-10-22 09:28:59Z

1

If you need it for debugging purposes, a simple

var_dump($mon);

gives you all properties of $mon.

Otherwise try iterating over the result array:

while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
     echo $row['m4']; // etc.
}

answered Oct 22, 2012 at 9:28

acme

14.9k8 gold badges77 silver badges114 bronze badges

1 Comment

user1386320 Over a year ago

you can also use "print_r", which is a great alternative for "var_dump"

Collectives™ on Stack Overflow

How can I print Object's value in PHP which is fetched row from SQL?

4 Answers 4

Comments

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related