Advertisement
Guest User

Untitled

a guest
Nov 22nd, 2014
148
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.90 KB | None | 0 0
  1. $fieldset->addField('item', 'select', array(
  2. 'label' => Mage::helper('frame')->__('Select Item'),
  3. 'name' => 'item',
  4. 'values' => Mage::getModel('frame')->toOptionArray(),
  5. ));
  6.  
  7. public function toOptionArray()
  8. {
  9. $r_connection = Mage::getSingleton('core/resource')->getConnection('core_read');
  10.  
  11. /* Write Select query */
  12. $sql = "SELECT * FROM manage_item";
  13.  
  14. /* Run query*/
  15. $item_data = $r_connection->fetchAll($sql);
  16.  
  17. $itemarray = array(
  18. array(
  19. 'value'=>-1,
  20. 'label'=>'Please Select'
  21. )
  22. );
  23. foreach ($item_data as $itemList){
  24. $itemarray[] = array(
  25. 'value'=>$itemList['item_id'],
  26. 'label'=>$itemList['item_name']
  27. );
  28. }
  29. return $itemarray;
  30. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement