Insert into a Magento Database Table

Question

Magento Enterprise 1.14.0.1

I have a plugin that I am altering the IndexController file for so that it will insert data collected from a user into a database table I created.

So basically I altered the Magento database to have new table which I am calling sample_requests. My issue is that when the IndexController is fired nothing is being inserted into the database. All database columns are Varchar(255) with the exception of the request_date column which is a datetime column type.

below is my code which I have in the IndexController.php file

    $personal_name = 'test';
    $customer_email = 'boo';
    //Open Database Conenction
      $resource = Mage::getSingleton('core/resource');
      $writeConnection = $resource->getConnection('core_write');

      //The Query
        $query = "insert into magento.sample_requests
                       (first_name, last_name, email_addr, address, city, state, zip, country, customeri_id, request_date) 
                  values($personal_name, NULL, $customer_email, sdf, sdf, sdf, sdf, sdf, 0, NOW())";


        $writeConnection->query($query);

You should really think about using magento models. Beside this, your code looks ok, are you sure it is called? — Fabian Blechschmidt
– Fabian Blechschmidt, Commented Jun 11, 2015 at 18:31
All that SQL!!! So much easier to use: Mage::getModel('my/model')->load($id)->setMyProperty()->save() — pspahn
– pspahn, Commented Jun 11, 2015 at 19:05

Qaisar Satti · Accepted Answer · 2018-07-24 09:39:41Z

4

value must be in ''

 $query = "insert into magento.sample_requests
                       (first_name, last_name, email_addr, address, city, state, zip, country, customeri_id, `request_date`) 
                  values($personal_name,' NULL',$customer_email,'sdf', 'sdf', 'sdf', 'sdf', 'sdf', '0', NOW())";

edited Jul 24, 2018 at 9:39

answered Jun 11, 2015 at 18:41

Qaisar Satti

32.6k18 gold badges88 silver badges138 bronze badges

Thank you apparently the issue was I didnt have a ' arround each of my values because when I change my query to match Qaisar Satti 's answer it works now.

Jayreis
– Jayreis

2015-06-11 19:07:36 +00:00
Commented Jun 11, 2015 at 19:07

Add a comment |

Stack Exchange Network

Insert into a Magento Database Table

1 Answer 1

Your Answer

Hot Network Questions

Insert into a Magento Database Table

1 Answer 1

Your Answer

Sign up or log in

Post as a guest

Related

Hot Network Questions