CI 2.0 and sqlite - Printable Version

CI 2.0 and sqlite - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: CI 2.0 and sqlite (/showthread.php?tid=38896)

CI 2.0 and sqlite - El Forum - 02-22-2011

[eluser]Andy Fraley[/eluser]
Has anyone been able to get CI 2.0 to work with sqlite3?

I can get it to work with sqlite2, however, I've run into some road blocks with the way some queries are returned. Take the following table called users:

user_id first_name last_name

If I do

Code:
select * from users

everything works fine. If I do a print_r on the query->result() I get

Code:
stdClass Object ( [user_id] => 1 [first_name] => john [last_name] => doe )

However, if I do

Code:
select users.user_id, users.first_name, users.lastname from users

then do a print_r I get

Code:
stdClass Object ( [users.user_id] => 1 [users.first_name] => john [users.last_name] => doe )

I then cannot access the object normally. In the first query I can do

Code:
echo $user->user_id;

but with the results returned by the second query it doesn't work. I'm not sure how to even address it. I can't do

Code:
echo $user->users.user_id