Print Mysql Insert query in magento

Question

I just want to print and check the insert query in magento. I have searched in google and tried alot but not able to print the insert query in magento.

My code:

  $insert = Mage::getModel('instagram/instagram');
        $insert->setData('username',$data->user->username);
        $insert->setData('name',$data->user->full_name);
        $insert->setData('Bio',$data->user->bio);
        $insert->setData('Website',$data->user->website);
        $insert->setData('user_id',$data->user->id);
        $insert->setData('instagram_access_token',$data->access_token);
        $insert->save();

Can anyone tell me to do???

Do you have a Magento collection code for this?

Mukesh
– Mukesh

2015-09-09 13:15:09 +00:00
Commented Sep 9, 2015 at 13:15 — Mukesh
– Mukesh, Commented Sep 9, 2015 at 13:15
I have updated, pls check it.

tttt
– tttt

2015-09-09 13:35:14 +00:00
Commented Sep 9, 2015 at 13:35 — tttt
– tttt, Commented Sep 9, 2015 at 13:35
Should be migrated to magento.stackexchange.com (?)

BenBarnes
– BenBarnes

2015-09-11 07:46:27 +00:00
Commented Sep 11, 2015 at 7:46 — BenBarnes
– BenBarnes, Commented Sep 11, 2015 at 7:46

santiago glez · Accepted Answer · 2015-09-09 17:09:02Z

2

Go to Varien_Db_Adapter_Pdo_Mysql under lib/Varien/Db/Adapter/Pdo/Mysql.php and change global variables :

protected $_debug               = false;
protected $_logAllQueries       = false;

to

protected $_debug               = true;
protected $_logAllQueries       = true;

then run your script and you should see the query under var/debug/pdo_mysql.log or whatever file specified in

protected $_debugFile           = 'var/debug/pdo_mysql.log';

Don't forget to restore all modified values when you finish logging the query, if the file do not exists after running the script, make sure that magento has permissions under that directory

edited Sep 9, 2015 at 17:09

answered Sep 9, 2015 at 16:56

santiago glez

213 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

tttt Over a year ago

I had done the steps that you have mentioned, but i did not get the query in log file.

santiago glez Over a year ago

Do you have enable logging?, check in admin panel System > Configuration > Developer > Log Settings, also make sure that folder var/log has 777 permissions

Mukesh · Accepted Answer · 2015-09-09 13:51:14Z

0

Try following

$insert = Mage::getModel('instagram/instagram');
echo $insert->getSelect()->__toString();

answered Sep 9, 2015 at 13:51

Mukesh

7,84623 gold badges111 silver badges167 bronze badges

1 Comment

tttt Over a year ago

I think this will print only select query, I asked for printing insert query.

Collectives™ on Stack Overflow

Print Mysql Insert query in magento

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related