MYSQLI Fetch Array

Question

So far I have the code that gives me array(1) { [0]=> object(stdClass)#166 (1) { ["id"]=> string(2) "92" }} the following result but what do I have to do to enable me to use it via mysqli_num_rows?

Code:

$query = $this->db->query("SELECT `id` FROM $table WHERE $table.id ='$product_id'");

        $result = $query->result();

GautamD31 · Accepted Answer · 2013-06-12 06:59:50Z

2

Try with affected_rows() like

$query = $this->db->query("SELECT `id` FROM $table WHERE $table.id ='$product_id'");
$result = $query->result();

$row_cnt = $this->db->affected_rows();

answered Jun 12, 2013 at 6:59

GautamD31

28.8k10 gold badges66 silver badges86 bronze badges

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

2 Comments

Jess McKenzie Over a year ago

I am still getting ` mysqli_num_rows() expects parameter 1 to be mysqli_result, array given`

GautamD31 Over a year ago

previously i have given ans with mysqli_num_rows,but now given with affecte_rows()

tomexsans · Accepted Answer · 2013-06-12 07:16:58Z

1

when doing SELECT you must use num_rows()

when doing UPDATE,INSERT,DELETE use affected_rows()

answered Jun 12, 2013 at 7:16

tomexsans

4,5374 gold badges37 silver badges49 bronze badges

Comments

MrCode · Accepted Answer · 2013-06-12 07:16:16Z

0

The row count can be found with:

echo $query->num_rows;

Reference

answered Jun 12, 2013 at 7:16

MrCode

64.6k10 gold badges95 silver badges114 bronze badges

Collectives™ on Stack Overflow

MYSQLI Fetch Array

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related