Get Query Binding array result in codeigniter

Question

I want to prevent injection on my codeigniter script. I used Query Binding array, but It's not fetching out the result... I get this error

Fatal error: Call to a member function result() on a non-object in C:\xampp\htdocs

code bellow

<php
$my = "Select * from gw_marge where amount != ? AND is_activated= ? ORDER BY RAND()";
$this->db->query($my, array(0, 1));
      foreach ($my->result() as $roww)
    {
    $pay = $roww->amount;
    $idd = $roww->id;
  }
 ?>
<p><?php echo $pay.' &'.$idd; ?></p>

Where did i get it wrong.

Not solved yet... i get error. Fatal error: Call to a member function result() on a non-object in C:\xampp\htdocs — Softtrees
– Softtrees, Commented Mar 29, 2017 at 18:03

DFriend · Accepted Answer · 2017-03-29 18:07:22Z

1

Change

$this->db->query($my, array(0, 1));
foreach ($my->result() as $roww)

to

$query = $this->db->query($my, array(0, 1));
foreach ($query->result() as $roww)

answered Mar 29, 2017 at 18:07

DFriend

8,9741 gold badge16 silver badges26 bronze badges

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

2 Comments

Abdulla Nilam Over a year ago

without giving(wrong) solution it's better to tell him why we use MVC. check this comment as well

DFriend Over a year ago

@AbdullaNilam, You are correct that his approach is not good MVC. But the question was "why do I get this error" and not "what's wrong with my MVC use." But the real reason I did not comment on MVC is that it wasn't known that his code was in the view until after I posted the answer. You've got the reputation to edit my answer - go ahead and explain the proper MVC structure. (I would, but must go back to work)

Collectives™ on Stack Overflow

Get Query Binding array result in codeigniter

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related