如何使用kohana从数据库中获取数据？

Question

Hy!

I configured the modules/database/database.php file. In controller/index.php I have:

$query = DB::query(Database::SELECT, 'SELECT * FROM posts ORDER By id DESC');

Using phpmyadmin, I created two blog posts, but the script doesn't seem to get them from the database. I don't see any errors and also the blog posts are not visible.

P.S. Sorry for my bad English, I am a schoolboy from Latvia and I'm learning English. :)

Answer 1

please read documentation: "Once you are done building, you can execute the query using execute() and use the results."

$query = DB::query(Database::SELECT, 'SELECT * FROM posts ORDER By id DESC')->execute();

Now you can use foreach.

foreach($query as $item){  ..  }