Magento – Create/Change Custom Table Dynamically

databasemagento-1.9module

I'm wondering if there is any possibility of creating Custom Table outside install or update script, and without using the query("CREATE TABLE statement"), in Magento 1.9+

Best Answer

The Magento way of creating tables in install scripts is not using raw SQL but the Zend API:

$table = $installer->getConnection()
    ->newTable($installer->getTable('my/custom_table'))
    ->addColumn('id', Varien_Db_Ddl_Table::TYPE_INTEGER, null, array(
        'identity'  => true,
        'unsigned'  => true,
        'nullable'  => false,
        'primary'   => true,
        ), 'ID')
    ->addColumn(...);
$installer->getConnection()->createTable($table);

More on the topic: http://inchoo.net/magento/magento-install-install-upgrade-data-and-data-upgrade-scripts/

You can do the same anywhere else if you replace $installer->getConnection() with Mage::getSingleton('core/resource')->getConnection('core_write');.

Related Solutions

Database – How to Create a Database Table from CSV

Never done this. Let's play!

After the createTable() call, or in a subsequent script:

/* @var $installer Mage_Core_Model_Resource_Setup */
$installer = $this;
$installer->startSetup();

//Extract data from CSV file
$csv = new Varien_File_Csv;
$data = $csv->getData('path/to/file.csv');

$resultNum = $installer->getConnection()->insertArray(
    $installer->getTable({TABLE NAME}),
    array({COL 1},{COL 2}),    //column names
    $data
);

//EDIT: if this is done using a data setup script, can even log the results:
Mage::log(
    __FILE__." added $resultNum records to $installer->getTable({TABLE NAME})",
    Zend_Log::INFO,
    "setup.log",
    true
);

$installer->endSetup();

Magento 1.9: How to Change Admin .PHTML Files

Without a module might be tricky. You will need a layout XML file and a template file.

You can find the code below as a module on my Bitbucket page

the layout XML

<adminhtml_sales_order_view>
   <reference name="order_info">
      <action method="setTemplate"><template>mymodule/sales/order/view/info.phtml</template></action>
      <block type="adminhtml/sales_order_view_info" name="original_order_info" template="sales/order/view/info.phtml"></block>
   </reference>
</adminhtml_sales_order_view>

And in the template file we'll call the old info.phtml and add any info you want extra above or below that. app/design/adminhtml/default/default/template/mymodule/sales/order/view/info.phtml

<?php
/**
 * here you can do whatever you want
 */
?>
<?php echo $this->getChildHtml('original_order_info');?>

Extending the _afterHtml method or using an observer means using code to fix a layout method. IMO not the best way to go about it.

Best Answer

Related Solutions

Database – How to Create a Database Table from CSV

Magento 1.9: How to Change Admin .PHTML Files

Related Topic