Welcome Guest, Not a member yet? Register   Sign In
Simple model question
#1

[eluser]DADE[/eluser]
Hey there,
I have a problem with model. I'm new in CI, so can you please answer more detailed. OK so:

I need drag from MySQL table random rows. And I want to create Model like:
Code:
$this->myModel->drag_user(user id here);
But I don't know how I can use this ID...

I need something like:

1. I load my model with ID 3.
Code:
$this->myModel->drag_user(3);

2. And now he loads user with ID 3 for me.
Code:
function drag_user(3) {
        $sql = "SELECT * FROM users WHERE id = 3";
        $q = $this->db->query($sql);
        return $q;
     }

How I can realize this? Smile
P.S: Sorry for bad english.
#2

[eluser]MaartenDeGroote[/eluser]
So what exactly is your question?
#3

[eluser]DADE[/eluser]
How I can make model work when I write
Code:
...->drag_user(3)
and it'll take user with ID 3 from database?
#4

[eluser]MaartenDeGroote[/eluser]
Do you mean this?

Code:
function drag_user($id)
{
$sql = "SELECT * FROM users WHERE id = ?";
$q = $this->db->query($sql, $id)->row();
return $q;
}
#5

[eluser]DADE[/eluser]
Yeap, thank you.




Theme © iAndrew 2016 - Forum software by © MyBB