模块-----向数据库里面建表，写入数据，在读取数据

coolsooner

浏览: 1341018 次

最近访客更多访客>>

lwvermds

神乎其技1412

枫叶灬

jacket233

博主相关

博客

微博

相册

留言

关于我

文章分类

全部博客 (1948)

社区版块

存档分类

2012-02 ( 3)
2012-01 ( 250)
2011-12 ( 113)
更多存档...

1

首先建立模块等一系列的文件，文件

2

etc/config.xml文件：

<?xml version="1.0"?>
<config>
<modules>
<RichardMason_Profile>
<version>1.10</version>
</RichardMason_Profile>
</modules>
<frontend>
<routers>
<profile>
<use>standard</use>
<args>
<module>RichardMason_Profile</module>
<frontName>profile</frontName>
</args>
</profile>
</routers>
<layout>
<updates>
<profile>
<file>profile.xml</file>
</profile>
</updates>
</layout>
</frontend>
<admin>
<routers>
<profile>
<use>admin</use>
<args>
<module>RichardMason_Profile</module>
<frontName>profile</frontName>
</args>
</profile>
<adminhtml>
<args>
<modules>
<RichardMason_Profile_Override before="Mage_Adminhtml">RichardMason_Profile_Override_Admin</RichardMason_Profile_Override>
</modules>
</args>
</adminhtml>

</routers>
</admin>
<adminhtml>
<menu>
<cms>
<children>
<news module="profile">
<title>News</title>
<sort_order>60</sort_order>
<action>profile/adminhtml_profile/news</action>
</news>
</children>
<children>
<testimonials module="profile">
<title>Testimonials</title>
<sort_order>61</sort_order>
<action>profile/adminhtml_profile/testimonials</action>
</testimonials>
</children>
<children>
<pressreleases module="profile">
<title>Press Releases</title>
<sort_order>62</sort_order>
<action>profile/adminhtml_profile/pressreleases</action>
</pressreleases>
</children>
<children>
<pressarticles module="profile">
<title>Press Articles</title>
<sort_order>63</sort_order>
<action>profile/adminhtml_profile/pressarticles</action>
</pressarticles>
</children>
</cms>
</menu>
<layout>
<updates>
<profile>
<file>profile.xml</file>
</profile>
</updates>
</layout>
<acl>
<resources>
<all>
<title>Allow Everything</title>
</all>
<admin>
<children>
<RichardMason_Profile>
<title>Profile Module</title>
<sort_order>10</sort_order>
</RichardMason_Profile>
</children>
</admin>
</resources>
</acl>

</adminhtml>
<global>
<models>
<profile>
<class>RichardMason_Profile_Model</class>
<resourceModel>profile_mysql4</resourceModel>
</profile>
<profile_mysql4>
<class>RichardMason_Profile_Model_Mysql4</class>
<entities>
<profile>
<table>profile</table>
</profile>
<profile_store>
<table>profile_store</table>
</profile_store>
</entities>
</profile_mysql4>
</models>
<resources>
<profile_setup>
<setup>
<module>RichardMason_Profile</module>
</setup>
<connection>
<use>core_setup</use>
</connection>
</profile_setup>
<profile_write>
<connection>
<use>core_write</use>
</connection>
</profile_write>
<profile_read>
<connection>
<use>core_read</use>
</connection>
</profile_read>
</resources>
<blocks>
<profile>
<class>RichardMason_Profile_Block</class>
</profile>
</blocks>
<helpers>
<profile>
<class>RichardMason_Profile_Helper</class>
</profile>
</helpers>
</global>
</config>
3

数据库文件

sql/profile_setup/mysql4-install-0.1.0.php

<?php

$installer = $this;

$installer->startSetup();

$installer->run("
DROP TABLE IF EXISTS `{$this->getTable('profile/profile')}`;
CREATE TABLE {$this->getTable('profile/profile')} (
`profile_id` smallint(6) NOT NULL AUTO_INCREMENT,
`category_id` int(11) NOT NULL,
`thumbnail` varchar(255) NOT NULL,
`thumbnail_position` int(11) NOT NULL,
`picture` varchar(255) NOT NULL,
`file` varchar(255) NOT NULL,
`content_heading` varchar(255) NOT NULL DEFAULT '',
`content` mediumtext,
`meta_keywords` text NOT NULL,
`meta_description` text NOT NULL,
`creation_time` datetime DEFAULT NULL,
`update_time` datetime DEFAULT NULL,
`is_active` tinyint(1) NOT NULL DEFAULT '1',
PRIMARY KEY (`profile_id`),
KEY `identifier` (`content_heading`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `{$this->getTable('profile/profile_store')}`;
CREATE TABLE {$this->getTable('profile/profile_store')} (
`profile_id` smallint(6) NOT NULL,
`store_id` smallint(5) unsigned NOT NULL,
PRIMARY KEY (`profile_id`,`store_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='CMS Profiles to Stores';

INSERT INTO `{$this->getTable('profile/profile')}` VALUES(1, 0, 'profile_examples/a5.jpg', 0, '', '', 'Example number 1', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Vestibulum et neque neque. Vestibulum id aliquet dolor. Etiam porta nulla ac odio pharetra venenatis euismod risus pulvinar. Donec tempor molestie faucibus. Aenean tempus, mi sed scelerisque tincidunt, nunc dui tristique dui, auctor auctor eros ipsum nec augue. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Donec consectetur erat quis nisi feugiat sit amet tempus mi aliquam. Nam mattis tortor eu lectus laoreet eu dignissim turpis rhoncus. Proin eu mi neque, et hendrerit tellus. Ut sed tortor nisi, id sodales lacus. Nulla ac elit tortor. Nulla eleifend turpis ac dui venenatis convallis. Etiam quis augue justo. Nunc eget tortor magna.', 'keywords, keywords,...', 'this is a new', '2010-05-24 00:00:00', '2010-05-25 11:16:10', 1);
INSERT INTO `{$this->getTable('profile/profile')}` VALUES(2, 0, 'profile_examples/a4.jpg', 0, '', '', 'Example number 2', 'Donec vitae consequat nibh. Morbi blandit convallis rhoncus. Sed vel sapien urna, in rhoncus eros. In quis viverra urna. Donec bibendum nunc eget dolor scelerisque aliquam. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Suspendisse potenti. Proin dictum urna rutrum sapien pellentesque semper. Etiam vulputate odio et orci imperdiet eu sollicitudin neque sodales. Nunc quis quam tortor. Quisque viverra massa in tellus malesuada sed bibendum massa sollicitudin. Donec cursus purus aliquet nibh ultricies hendrerit. Suspendisse potenti. Vivamus egestas dictum arcu, vitae fringilla tortor egestas ac.', '', '', '2010-05-25 00:00:00', '2010-05-25 11:15:47', 1);
INSERT INTO `{$this->getTable('profile/profile')}` VALUES(3, 0, 'profile_examples/a3.jpg', 1, '', '', 'Example number 3', 'Phasellus feugiat euismod orci at adipiscing. Proin bibendum velit cursus mauris dapibus elementum. Mauris ultrices nisl felis. Sed lacinia tempor varius. Fusce venenatis rhoncus sem, et imperdiet lectus adipiscing sit amet. Pellentesque ut vulputate nisl. Sed ac mauris nunc, quis dignissim augue. Quisque et tincidunt augue. Vivamus in nisl id nulla pretium bibendum. Sed pharetra ullamcorper aliquam. Sed nec est diam, vel laoreet mauris.', '', '', '2010-05-26 00:00:00', '2010-05-25 11:15:15', 1);
INSERT INTO `{$this->getTable('profile/profile')}` VALUES(4, 1, '', 0, '', '', 'Mr. Natoque et Magnis', '/'The service was brilliant! Ut luctus rhoncus mauris eu pharetra. Fusce dapibus aliquam nisl, non lacinia ligula pretium sit amet. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus./'/r/nMr. Natoque et Magnis', '', '', '2010-05-25 00:00:00', '2010-05-25 11:23:40', 1);
INSERT INTO `{$this->getTable('profile/profile')}` VALUES(5, 1, '', 0, '', '', 'Mss. Nulla Amet', '/'Good quality of the products. Quisque fringilla diam quis lacus venenatis varius. Fusce imperdiet fringilla justo eu malesuada. Sed id nisl vulputate risus scelerisque suscipit. Nulla sit amet lorem non felis interdum venenatis. Fusce sollicitudin lorem ac erat varius sed mollis magna scelerisque./'/r/nMss. Nulla Amet', '', '', '2010-05-25 00:00:00', '2010-05-25 11:23:56', 1);
INSERT INTO `{$this->getTable('profile/profile')}` VALUES(6, 2, '', 0, '', 'profile_examples/press1.pdf', 'How can I capture credit card information without a payment gateway?', 'If you do not have a payment gateway, but still want to accept Credit Cards for processing offline you can capture the credit card information using the Saved Credit Card payment method./r/nTo set this up go to System -> Configuration and select Payment Methods from the left navigation. Once there you will see Saved CC as one of the available methods./r/n<img style=/'padding: 0px; margin: 0px; border: 0px initial initial;/' src=/'http://www.magentocommerce.com/images/uploads/admin_payment_savedcc.jpg/' alt=/'image/' />/r/nTo enable this option you will want to set the Enabled dropdown to Yes./r/nYou can change the Title of the method to whatever you like in the Title field./r/nBelow this you can set the preferences of this payment method just as you do with all other payment methods. This includes the status of new orders placed with this method, the sort order as it will appear in the front-end in relation to the other methods, whether your customers must enter a card verification number, and the country and order amount filters for your customer to be able to use this method./r/nWhen you are finished, select the Save Config button and you will be able to accept credit cards without integrating with a payment gateway./r/nOrders placed using this method will appear in the admin with the card number, name on card and expiration date displayed to the store owner. You can then take this information and use it to charge your customers using your preferred method. ', '', '', '2010-02-09 00:00:00', '2010-05-25 11:36:50', 1);
INSERT INTO `{$this->getTable('profile/profile')}` VALUES(7, 2, '', 0, '', 'profile_examples/press2.pdf', 'How Do I Accept Checks and Money Orders as Payment?', 'To accept checks and money orders as payment for orders go to System -> Configuration. Select Payment Methods from the left navigation. The current release of Magento supports offline payment using checks and money orders. Future releases will support the acceptance of electronic checks on the site./r/n<img style=/'padding: 0px; margin: 0px; border: 0px initial initial;/' src=/'http://www.magentocommerce.com/images/uploads/admin_payment_checks_thumb.jpg/' alt=/'image/' />/r/nTo display this method to customers in the checkout process you must select Yes from the enabled dropdown./r/nYou are able to edit the title of the payment method by entering the text in the title field. The text entered here is what is displayed on the payment information page and on all order correspondence with the customer, including order confirmation emails, invoices, and the order history in the customer’s account. If you only want to accept Money Orders and not Checks, for example, you can rename the method to Money Orders./r/nYou can then select the status you want orders placed using Checks and Money Orders. Any orders placed using the Checks / Money Orders payment method will be displayed in the admin panel with this status./r/nEnter the name and address of your company so that your customers know where the send the checks and to whom the checks will be payable. This information will appear in the checkout process for your customers to see./r/nAs with all payment methods, you can add country and order amount filters to determine which customers will be able to use this payment method. You will also be able to move the positioning of the Checks / Money Orders method around on the payment page by changing the sort order. The lowest number will be displayed in the highest position on the page./r/nBelow this payment method is the Purchase Orders option. This is also an offline method, but it is different from Checks and Money Orders. This is intended to be used when you and the customer have established a credit system, where they are given a Purchase Order number to enter during the checkout process and you can cross-reference this number with a payment option that you have or will arrange with the customer. ', '', '', '2010-05-25 00:00:00', '2010-05-25 11:33:08', 1);
INSERT INTO `{$this->getTable('profile/profile')}` VALUES(8, 2, '', 0, '', 'profile_examples/press3.pdf', 'What are Tax Rules and How Do I Use Them?', 'Tax Rules are defined as a combination of a Customer Tax Class and a Product Tax Class with a Tax Rate (see <a style=/'color: #0068b7; text-decoration: none; padding: 0px; margin: 0px;/' title=/'What are tax classes? (product and customer)/' href=/'http://www.magentocommerce.com/knowledge-base/entry/what-are-tax-classes-product-and-customer/'>What are tax classes? (product and customer)</a>). Each customer will be assigned a class and each product is assigned a tax class. Each region is assigned a set of up to five tax rates. Based on the class of the customer and the class of the products in the shopping cart, and the region (this can be the shipping address, billing address, or shipping origin) the system will calculate out the appropriate tax./r/nTo create a Tax Rule go to Sales -> Tax -> Manage Tax Rules. Once there you will see a grid list of the Tax Rules you have created. To create a Tax Rule you will also have to create Tax Rates, along with the Tax Classes. See <a style=/'color: #0068b7; text-decoration: none; padding: 0px; margin: 0px;/' title=/'How do I define tax rates?/' href=/'http://www.magentocommerce.com/knowledge-base/entry/how-do-i-define-tax-rates-per-product-tax-rules//'>How do I define tax rates?</a> for more on setting Tax Rates./r/nOnce you have created your Tax Classes and Tax Rates you can create rules. In this case we are going to create four rules. We have two different customer types, Retail customers and Wholesale Customers, and two different types of products, taxable and downloadable./r/nIn this example we are a store in California and we have created a tax rate of 8.25%. (NOTE: This is for example purposes only. Consult your state laws for tax rates). We have also left a rate as being 0%./r/nThe first Tax Rule we create is for Retail Customers buying taxable goods./r/n<img style=/'padding: 0px; margin: 0px; border: 0px initial initial;/' src=/'http://www.magentocommerce.com/images/uploads/admin_tax_rule1.jpg/' alt=/'image/' width=/'455/' height=/'210/' />/r/nWe select the Customer and Product class from the dropdowns and then select the Rate we want to use for this combination. In this case we want to use the first rate, 8.25%./r/nSelect Save Rule and Retail customers with a shipping address in California will be charged a rate of 8.25% on all items marked as being Taxable Goods. That is set, but let’s say we have downloadable items we don’t want charge tax on. We create a new rule with the combination of the Retail Customer Tax Class and the Downloadable Items Product Tax Class and select the rate we want to charge./r/nIn this case the rate is the second we created, 0.0%, so customers will not be charged tax on these items./r/nNow that we have our retail customers set up with tax rates we need to set up the two rules for Wholesale Customers. We select the Wholesale Customer from the tax class, select Taxable Items and Rate 2. Then we do the same for Downloadable Items and we have our four tax rates created:/r/n<img style=/'padding: 0px; margin: 0px; border: 0px initial initial;/' src=/'http://www.magentocommerce.com/images/uploads/admin_taxrule2.jpg/' alt=/'image/' width=/'598/' height=/'203/' />/r/nIf you need to charge tax on shipping, you can do so by creating a Tax Rule for shipping. This means that you should create a Product Tax Class that will be applied to shipping. Navigate to System -> Configuration, and click the Sales tab. In the Tax Calculation section, you can select which product tax class will be applied to the shipping, if you choose to tax shipping. You can also determine whether tax will apply before or after discounts, and how the region of the Tax Rate will be determined (billing address, shipping destination, or shipping origin).', '', '', '2010-03-17 00:00:00', '2010-05-25 11:37:07', 1);
INSERT INTO `{$this->getTable('profile/profile')}` VALUES(9, 3, 'profile_examples/article1pic.jpg', 0, 'profile_examples/article1.jpg', '', 'cnet Wireless', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin ut dolor sit amet nisl elementum rhoncus et at lorem. Pellentesque quis felis quis eros fermentum interdum. Curabitur nibh lacus, varius quis fermentum sit amet, pretium ut enim. Proin euismod enim a ligula tristique volutpat.', '', '', '2010-05-25 00:00:00', '2010-05-25 11:54:31', 1);
INSERT INTO `{$this->getTable('profile/profile')}` VALUES(10, 3, 'profile_examples/article2pic.jpg', 0, 'profile_examples/article2.jpg', '', 'cnet Security', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin ut dolor sit amet nisl elementum rhoncus et at lorem. Pellentesque quis felis quis eros fermentum interdum. Curabitur nibh lacus, varius quis fermentum sit amet, pretium ut enim. Proin euismod enim a ligula tristique volutpat.', '', '', '2010-05-25 00:00:00', '2010-05-25 12:12:54', 1);
INSERT INTO `{$this->getTable('profile/profile')}` VALUES(11, 3, 'profile_examples/article3pic.jpg', 0, 'profile_examples/article3.jpg', '', 'cnet Webware', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin ut dolor sit amet nisl elementum rhoncus et at lorem. Pellentesque quis felis quis eros fermentum interdum. Curabitur nibh lacus, varius quis fermentum sit amet, pretium ut enim. Proin euismod enim a ligula tristique volutpat.', '', '', '2010-05-25 00:00:00', '2010-05-25 12:13:33', 1);
INSERT INTO `{$this->getTable('profile/profile')}` VALUES(12, 3, 'profile_examples/article4pic.jpg', 1, 'profile_examples/article4.jpg', '', 'cnet Business', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin ut dolor sit amet nisl elementum rhoncus et at lorem. Pellentesque quis felis quis eros fermentum interdum. Curabitur nibh lacus, varius quis fermentum sit amet, pretium ut enim. Proin euismod enim a ligula tristique volutpat.', '', '', '2010-05-25 00:00:00', '2010-05-25 12:14:21', 1);

INSERT INTO `{$this->getTable('profile/profile_store')}` VALUES(1, 0);
INSERT INTO `{$this->getTable('profile/profile_store')}` VALUES(2, 0);
INSERT INTO `{$this->getTable('profile/profile_store')}` VALUES(3, 0);
INSERT INTO `{$this->getTable('profile/profile_store')}` VALUES(4, 0);
INSERT INTO `{$this->getTable('profile/profile_store')}` VALUES(5, 0);
INSERT INTO `{$this->getTable('profile/profile_store')}` VALUES(6, 0);
INSERT INTO `{$this->getTable('profile/profile_store')}` VALUES(7, 0);
INSERT INTO `{$this->getTable('profile/profile_store')}` VALUES(8, 0);
INSERT INTO `{$this->getTable('profile/profile_store')}` VALUES(9, 0);
INSERT INTO `{$this->getTable('profile/profile_store')}` VALUES(10, 0);
INSERT INTO `{$this->getTable('profile/profile_store')}` VALUES(11, 0);
INSERT INTO `{$this->getTable('profile/profile_store')}` VALUES(12, 0);
");

$installer->endSetup();

复制进去即可

4
资源模型
Model/Profile.php
Model/Mysql4/Profile.php
Model/Mysql4/Profile/Collection.php
三个文件，默认是这个顺序，
其中
Model/Mysql4/Profile.php由配置文件决定路径
Model/Mysql4/Profile/Collection.php由继承的一个文件决定，详细参看上面的帖子。

4.1
Model/Profile.php

<?php
/**
* Mason Web Development
*
* @category RichardMason
* @package RichardMason_Profile
* @copyright Copyright (c) 2009 Irubin Consulting Inc. DBA Varien (http://www.varien.com)
* @license http://opensource.org/licenses/osl-3.0.php Open Software License (OSL 3.0)
*/
class RichardMason_Profile_Model_Profile extends Mage_Core_Model_Abstract
{
public function _construct()
{
parent::_construct();
$this->_init('profile/profile');
}
}

4.2
Model/Mysql4/Profile.php
<?php
/**
* Mason Web Development
*
* NOTICE OF LICENSE
* This source file is subject to the Open Software License (OSL 3.0)
* Part of the code of this file was obtained from:
* -category Mage
* -package Mage_Adminhtml
* -copyright Copyright (c) 2009 Irubin Consulting Inc. DBA Varien (http://www.varien.com)
* -license http://opensource.org/licenses/osl-3.0.php Open Software License (OSL 3.0)
*
* @category RichardMason
* @package RichardMason_Profile
* @copyright Copyright (c) 2009 Irubin Consulting Inc. DBA Varien (http://www.varien.com)
* @license http://opensource.org/licenses/osl-3.0.php Open Software License (OSL 3.0)
*/
class RichardMason_Profile_Model_Mysql4_Profile extends Mage_Core_Model_Mysql4_Abstract
{

/**
* Store model
*
* @var null|Mage_Core_Model_Store
*/
protected $_store = null;
public function _construct()
{
// Note that the profiles_id refers to the key field in your database table.
$this->_init('profile/profile', 'profile_id');
}
}

4.3

Model/Mysql4/Profile/Collection.php

<?php
/**
* Mason Web Development
*
* NOTICE OF LICENSE
* This source file is subject to the Open Software License (OSL 3.0)
* Part of the code of this file was obtained from:
* -category Mage
* -package Mage_Adminhtml
* -copyright Copyright (c) 2009 Irubin Consulting Inc. DBA Varien (http://www.varien.com)
* -license http://opensource.org/licenses/osl-3.0.php Open Software License (OSL 3.0)
*
* @category RichardMason
* @package RichardMason_Profile
* @copyright Copyright (c) 2009 Irubin Consulting Inc. DBA Varien (http://www.varien.com)
* @license http://opensource.org/licenses/osl-3.0.php Open Software License (OSL 3.0)
*/
class RichardMason_Profile_Model_Mysql4_Profile_Collection extends Mage_Core_Model_Mysql4_Collection_Abstract
{
protected $_previewFlag;
public function _construct()
{
parent::_construct();
$this->_init('profile/profile');
$this->_map['fields']['profile_id'] = 'main_table.profile_id';
}
/**
* Add Filter by store
*
* @param int|Mage_Core_Model_Store $store
* @return Mage_Cms_Model_Mysql4_Page_Collection
*/
public function addStoreFilter($store, $withAdmin = true)
{
if (!$this->getFlag('store_filter_added')) {
if ($store instanceof Mage_Core_Model_Store) {
$store = array($store->getId());
}
$this->getSelect()->join(
array('store_table' => $this->getTable('profile/profile_store')),
'main_table.profile_id = store_table.profile_id',
array()
)
->where('store_table.store_id in (?)', ($withAdmin ? array(0, $store) : $store))
->group('main_table.profile_id');
$this->setFlag('store_filter_added', true);
}
return $this;
}

}

5
IndexController.php

<?php
/**
* Mason Web Development
*
* @category RichardMason
* @package RichardMason_Profile
* @copyright Copyright (c) 2009 Irubin Consulting Inc. DBA Varien (http://www.varien.com)
* @license http://opensource.org/licenses/osl-3.0.php Open Software License (OSL 3.0)
*/
class RichardMason_Profile_IndexController extends Mage_Core_Controller_Front_Action
{
public function indexAction(){
$profiles = Mage::getModel('profile/profile')->getCollection()->addStoreFilter(Mage::app()->getStore()->getId());
$profiles->addFieldToFilter('category_id', 3);
$profiles->setOrder("creation_time", "DESC");
//print_r($profiles);
// echo $profiles->getData("content");
foreach($profiles as $n){
echo $n->getData("content");
echo " ";

}

echo " 222";
$profiles1 = Mage::getModel('profile/profile')->load(2);
echo $profiles1->getData("content");
echo " 222";
}
}

6
访问这个路径。。

7会出现下面的结果：

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin ut dolor sit amet nisl elementum rhoncus et at lorem. Pellentesque quis felis quis eros fermentum interdum. Curabitur nibh lacus, varius quis fermentum sit amet, pretium ut enim. Proin euismod enim a ligula tristique volutpat.

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin ut dolor sit amet nisl elementum rhoncus et at lorem. Pellentesque quis felis quis eros fermentum interdum. Curabitur nibh lacus, varius quis fermentum sit amet, pretium ut enim. Proin euismod enim a ligula tristique volutpat.

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin ut dolor sit amet nisl elementum rhoncus et at lorem. Pellentesque quis felis quis eros fermentum interdum. Curabitur nibh lacus, varius quis fermentum sit amet, pretium ut enim. Proin euismod enim a ligula tristique volutpat.

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin ut dolor sit amet nisl elementum rhoncus et at lorem. Pellentesque quis felis quis eros fermentum interdum. Curabitur nibh lacus, varius quis fermentum sit amet, pretium ut enim. Proin euismod enim a ligula tristique volutpat.

后续：

public function indexAction(){

$resource = Mage::getModel('profile/profile')->_getResource();
$select = $resource->_getReadAdapter()->select()
->from($resource->getTable('profile/profile'))
->where('profile_id = ?', 2);

$data = $resource->_getReadAdapter()->fetchAll($select);

foreach($data as $da){
var_dump($da);
}

将_getAdapter()函数改成public，可执行，

分享到：

不好受 | 插件

2011-01-11 23:55
浏览 931
评论(0)
查看更多

发表评论

您还没有登录,请您登录后再发表评论

最近访客更多访客>>

博主相关

文章分类

社区版块

存档分类

最新评论