Magento中如何调用SQL语句_magento教程_php教程

热线电话: #

Magento中如何调用SQL语句

时间:2010-11-10 17:50来源:未知作者:最模板点击:次

create table rooms(id int not null auto_increment, name varchar(100), primary key(id)); insert into rooms values(1,'Royal Room'); insert into rooms values(2,'Standard Room');

I. 创建表结构和测试数据

create table rooms(id int not null auto_increment, name varchar(100), primary key(id));
insert into rooms values(1,'Royal Room');
insert into rooms values(2,'Standard Room');

II.创建 controllers/RoomController.php:

源码打印？
<?php  
    class Cartz_Hotel_RoomController extends Mage_Core_Controller_Front_Action{  
       public function listingAction() {  
          $handle = Mage::getSingleton('core/resource')->getConnection('core_write');  
  
          $query  = $handle->query('select name from rooms');  
          while ($row = $query->fetch()) {  
             $row = new Varien_Object($row);  
             echo "<strong>" . $row->getName() . "</strong><br/>";  
          }  
  
       }  
}?>  