如何调用SQL语句 ,
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:
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 "" . $row->getName() . "
"; } } }
在地址栏中输入: http://localhost/magento/index.php/hotel/room/listing, 页面将输出:
Royal Room Standard Room
转载请注明出处:https://www.onexin.net/how-to-call-sql-statements-magento/