Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $fieldset->addField('item', 'select', array(
- 'label' => Mage::helper('frame')->__('Select Item'),
- 'name' => 'item',
- 'values' => Mage::getModel('frame')->toOptionArray(),
- ));
- public function toOptionArray()
- {
- $r_connection = Mage::getSingleton('core/resource')->getConnection('core_read');
- /* Write Select query */
- $sql = "SELECT * FROM manage_item";
- /* Run query*/
- $item_data = $r_connection->fetchAll($sql);
- $itemarray = array(
- array(
- 'value'=>-1,
- 'label'=>'Please Select'
- )
- );
- foreach ($item_data as $itemList){
- $itemarray[] = array(
- 'value'=>$itemList['item_id'],
- 'label'=>$itemList['item_name']
- );
- }
- return $itemarray;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement