CodeIgniter Forums

Full Version: very newbie question
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

El Forum

[eluser]Unknown[/eluser]
hey,
im new to php and codeigniter and i want to create something with ci.
here is my question, how can i create like this query

Code:
SELECT username,password FROM users WHERE username=$foo AND password=$bar

with codeigniter activerecord ? like this ?

Code:
$this->db->select('username,password');
$this->db->from('users');
$this->db->where('username', $foo);
$this->db->where('password', $bar);
$query = $this->db->get();

thanx form help.

El Forum

[eluser]louis w[/eluser]
Looks right to me. What happens?

El Forum

[eluser]pickledegg2[/eluser]
looks right to me too.

El Forum

[eluser]exodus7[/eluser]
you can also turn on the profiler by typing
Code:
$this->output->enable_profiler(TRUE);
which will allow you to view the queries that were generated.

El Forum

[eluser]pickledegg2[/eluser]
Quote:$this->output->enable_profiler(TRUE);
Every days a schoolday, thanks for the tip Wink