Magento – How to create and insert to a custom table in magento

magento-1.9

The question is clear from the title itself , what i need is creating a customer_token table and insert data to it upon registration ,

here is

what i have tried

in my_project/app/core/code/Mage/Customer/sql/mysql4-install-0.7.0

-- DROP TABLE IF EXISTS `{$this->getTable('customer_token')}`;
CREATE TABLE `{$this->getTable('customer_token')}` (
  `id` int(11) NOT NULL auto_increment,
  `customer_id` smallint(8) unsigned  default '0',
  `token` varchar(255)   default '0',
  `created_at` datetime NOT NULL default '0000-00-00 00:00:00',
  `expire_at` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`),
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

In my_project/app/core/code/Mage/Customer/etc/config.xml

<entities>
     <customer_token>
        <table>customer_token</table>
    </customer_token>
</entities>

In my_project/app/core/code/Mage/Customer/Resource/token.php

class Mage_Customer_Model_Resource_Token extends Mage_Eav_Model_Entity_Abstract
{


}

And in my_project/wrappers/customer_register.php

  $token = getToken(20);
        $data = array('customer_id' => 1, 'token' => $token);
        $model = Mage::getModel('customer/token')->setData($data);
        try {
            $insertId = $model->save()->getId();
            echo "Data successfully inserted. Insert ID: " . $insertId;
        } catch (Exception $e) {
            echo $e->getMessage();
        }

But it throws me a Resource is not set error . Any idea ??

UPDATE

I followed the blog specified in the answer and created a module as

customer_token . am sharing the main files below ,

 `my_project\app\code\community\Customer\Token\etc\config.xml`

1.0.0

Customer_Token_Model
customertoken_resource

Customer_Token_Model_Resource

customer_token

Customer_Token

core_setup

core_read

core_write

Customer_Token_Block

<!-- start of routers 
-->
<frontend>
    <routers>
        <customertoken>
            <use>standard</use>
            <args>
                <module>Customer_Token</module>
                <frontName>customertoken</frontName>
            </args>
        </customertoken>
    </routers>
    <layout>
        <updates>
            <customertoken>
                <file>customertoken.xml</file>
            </customertoken>
        </updates>
    </layout>
</frontend>

IN my_project\app\code\community\Customer\Token\Model\Customertoken.php

   class Cusotmer_Token_Model_Customertoken extends Mage_Core_Model_Abstract
{
    public function _construct()
    {
        $this->_init('customertoken/customertoken');
    }

}

And in my_project\app\etc\modules\Customer_Token.xml

    <config>
     <modules>
        <Customer_Token>
            <active>true</active>
            <codePool>community</codePool>
        </Customer_Token>
    </modules>
   </config>

And in my_project\app\code\community\Customer\Token\Resource\Collection.php

class Cusotmer_Token_Model_Resource_Customertoken_Collection extends Mage_Core_Model_Resource_Db_Collection_Abstract {

    protected function _constuct() {
        $this->_init('customertoken/customertoken');
    }

}

And in my_project\app\code\community\Customer\Token\Resource\Customertoken.php

class Customer_Token_Model_Resource_Customertoken extends Mage_Core_Model_Resource_Db_Abstract
{
    /**
     * Initialize resource model
     *
     * @return void
     */
    public function _construct()
    {
        $this->_init('customertoken/customertoken', 'id');
    }
}

And in my_project\app\code\community\Customer\Token\sql\customertoken_setup\install-1.6.0.0.php

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

$installer->run("
-- DROP TABLE IF EXISTS `{$this->getTable('customer_token')}`;
CREATE TABLE `{$this->getTable('customer_token')}` (
  `id` int(11) NOT NULL auto_increment,
  `customer_id` smallint(8) unsigned  default '0',
  `token` varchar(255)   default '0',
  `created_at` datetime NOT NULL default '0000-00-00 00:00:00',
  `expire_at` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`),
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

    ");
$installer->endSetup();

And am calling it like this ,

$data = array('customer_id' => $customerId, 'token' => $token);
    $model = Mage::getModel('customer_token/custmertoken')->addData($data);
    try {
        $insertId = $model->save()->getId();
        echo "Data successfully inserted. Insert ID: " . $insertId;
    } catch (Exception $e) {
        echo $e->getMessage();
    }

I appreciate your help , thanks .

Best Answer

There are lot of issue in your module.

Don't create any custom table on Core_Module

It is too bad idea to create a model at Core Module(Mage_Customer) and it break magento standard.

I suggest you need to define model at a new custom module.

Please the blog how create Model of table.

Model and resource model class was not write properly

If you are using custom Module and using flat table format for that Model then

Model class inherit from Mage_Core_Model_Abstract.

Resource Model class inherit from Mage_Core_Model_Resource_Db_Abstract.

Collection Model class inherit from Mage_Core_Model_Resource_Db_Collection_Abstract.

Insert data;

As you have set multiple fields ,so you need to use addData() function.

Also you can $id value after model save data. Basically give the table primary key.

If you define custom module then it config.xml look like:

<?xml version="1.0" ?>
<config>
    <modules>
        <Amit_Custommodule>
            <version>1.0.0</version>
        </Amit_Custommodule>
    </modules>
    <global>
        <models>
    <!-- Model is define at here -->
            <custommodule> <!-- Model Prefix -->
                <class>Amit_Custommodule_Model</class>
                <resourceModel>custommodule_resource</resourceModel>
            </custommodule>
    <!--  Resource Model is define at here -->

            <custommodule_resource>
                <class>Amit_Custommodule_Model_Resource</class>
                <entities>
                    <token> <!-- define an new  entities for module -->
                        <table>customer_token</table> <!-- define table -->
                    </token>
                </entities>
            </custommodule_resource>
        </models>
        <resources>
            <custommodule_setup>
                <setup>
                    <module>Amit_Custommodule</module>
                </setup>
                <connection>
                    <use>core_setup</use>
                </connection>
            </custommodule_setup>
            <custommodule_read>
                <connection>
                    <use>core_read</use>
                </connection>
            </custommodule_read>
            <custommodule_write>
                <connection>
                    <use>core_write</use>
                </connection>
            </custommodule_write>
        </resources>
    </global>
</config>

Model class is like : Model file Token.php path is app/code/community/Amit/Custommodule/Model

<?php
class Amit_Custommodule_Model_Token extends Mage_Core_Model_Abstract
{
    public function _construct()
    {
        $this->_init('custommodule/token');
    }

}

ResourceModel:

Resource class Token.php

app/code/community/Amit/Custommodule/Model/Resource/

<?php
class Amit_Custommodule_Model_Resource_Token extends Mage_Core_Model_Resource_Db_Abstract
{
    /**
     * Initialize resource model
     *
     * @return void
     */
    public function _construct()
    {
        $this->_init('custommodule/token', 'id');
    }
}

Data save Like :

$token = getToken(20);
$data = array('customer_id' => 1, 'token' => $token);
$model = Mage::getModel('custommodule/token')->addData($data);
try {
$model->save(); //save data 
    $insertId = $model->getId();
    echo "Data successfully inserted. Insert ID: " . $insertId;
} catch (Exception $e) {
    echo $e->getMessage();
}

Related Solutions

Magento 1.9 – How to Add Custom Page with Cross-Sell Products

Install below extension that will help you to create extra page after cart

https://github.com/tmhub/suggestpage

above extension add extra page after cart and that page you will add these code and you will get cross-sell product data

change your indexController indexAction as below

public function indexAction()
{
    $this->loadLayout()
        ->_initLayoutMessages('checkout/session')
        ->_initLayoutMessages('catalog/session');

    $_product = Mage::getModel('catalog/product')->load(1); //here 1 is product Id
    $block =  $this->getLayout()->createBlock('checkout/cart_crosssell')->setProduct($_product)->setTemplate('checkout/cart/crosssell.phtml');
    $this->getLayout()->getBlock('content')->append($block);

    $this->renderLayout();
}

and for your 4 product issue please check in your app/design/frontend/YourPackge/YourTheme/checkout/cart/crosssell.phtml file any condition who breaks for loop after four product then change it.

to increase limit for cross-sell product follow this quick step

1) copy app/code/core/Mage/Checkout/Block/Cart/Crosssell.php file to app/code/local/Mage/Checkout/Block/Cart/Crosssell.php

2) find this line and increase limit as per your need protected $_maxItemCount = 4;

Magento 1.9 PayPal – Fix PayPal NVP Gateway Errors in M1 CE

We've faced this a number of times at Something Digital. Sometimes the Nvp exceptions aren't the root cause. They're likely raised with exceptions happening elsewhere and the payments objects using Exceptions as routing behavior.

Here are the most likely causes:

Observers listening to sales_order_place_after are failing
Observers listening to sales_order_payment_place_end
Issues with IPN deadlocking the order place
Model load in loop causing deadlocking on sales order tables

Any of these could be caused by an extension or custom code. A bit of an audit would have to be conducted to find out the root cause for sure.

To that end Magento 1.9+ did a great job of solving some of the common deadlock issues. Seeing as you're on 1.9.2 this is not the likely cause. Again, I know this isn't a concrete answer but without further investigation hopefully this sets you off in a good path.