Gsyfuy

Putting Ant-Man on house arrest

c++ diamond problem - How to call base method only once

Does Feeblemind produce an ongoing magical effect that can be dispelled?

What do you call the part of a novel that is not dialog?

How to avoid introduction cliches

Has a Nobel Peace laureate ever been accused of war crimes?

What is it called when you ride around on your front wheel?

Check if a string is entirely made of the same substring

What is the least dense liquid under normal conditions?

Can you stand up from being prone using Skirmisher outside of your turn?

"Rubric" as meaning "signature" or "personal mark" -- is this accepted usage?

Is Diceware more secure than a long passphrase?

I preordered a game on my Xbox while on the home screen of my friend's account. Which of us owns the game?

With indentation set to `0em`, when using a line break, there is still an indentation of a size of a space

Rolling Stones Sway guitar solo chord function

Do I need to protect SFP ports and optics from dust/contaminants? If so, how?

Multiple options vs single option UI

Seek and ye shall find

Reattaching fallen shelf to wall?

How to not starve gigantic beasts

Trumpet valves, lengths, and pitch

Multiple fireplaces in an apartment building?

How to keep bees out of canned beverages?

Mistake in years of experience in resume?

echo my sql query in magento

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}

0

here is some minor question but it always bother me while doing the code with magento.

$resource = Mage::getSingleton('core/resource');

$write = $resource->getConnection('core_write');

$table = $resource->getTableName('your/model');

$write->delete(

    $table,

    ['entity_id IN (?)' => [123, 456]]

);

$write->update(

    $table,

    ['column_1' => 3, 'column_2' => 4],

    ['entity_id = ?' => 123]

);

If I use above code to write into DB and I am not sure which query will be formed actually. How would I print the formed SQL through above write object.

I just know this one:

echo $collection->getSelect() 

In which I can get the select query printed on the screen.

Can you please suggest me so that I can get the query which is going to execute or which is executed in last.

Thank you :)

magento-1.9 database delete

share|improve this question

asked 39 mins ago

Mansi RajaMansi Raja

638

add a comment | 

0

here is some minor question but it always bother me while doing the code with magento.

$resource = Mage::getSingleton('core/resource');

$write = $resource->getConnection('core_write');

$table = $resource->getTableName('your/model');

$write->delete(

    $table,

    ['entity_id IN (?)' => [123, 456]]

);

$write->update(

    $table,

    ['column_1' => 3, 'column_2' => 4],

    ['entity_id = ?' => 123]

);

If I use above code to write into DB and I am not sure which query will be formed actually. How would I print the formed SQL through above write object.

I just know this one:

echo $collection->getSelect() 

In which I can get the select query printed on the screen.

Can you please suggest me so that I can get the query which is going to execute or which is executed in last.

Thank you :)

magento-1.9 database delete

share|improve this question

asked 39 mins ago

Mansi RajaMansi Raja

638

add a comment | 

here is some minor question but it always bother me while doing the code with magento.

$resource = Mage::getSingleton('core/resource');

$write = $resource->getConnection('core_write');

$table = $resource->getTableName('your/model');

$write->delete(

    $table,

    ['entity_id IN (?)' => [123, 456]]

);

$write->update(

    $table,

    ['column_1' => 3, 'column_2' => 4],

    ['entity_id = ?' => 123]

);

If I use above code to write into DB and I am not sure which query will be formed actually. How would I print the formed SQL through above write object.

I just know this one:

echo $collection->getSelect() 

In which I can get the select query printed on the screen.

Can you please suggest me so that I can get the query which is going to execute or which is executed in last.

Thank you :)

magento-1.9 database delete

share|improve this question

asked 39 mins ago

Mansi RajaMansi Raja

638

$resource = Mage::getSingleton('core/resource');

$write = $resource->getConnection('core_write');

$table = $resource->getTableName('your/model');

$write->delete(

    $table,

    ['entity_id IN (?)' => [123, 456]]

);

$write->update(

    $table,

    ['column_1' => 3, 'column_2' => 4],

    ['entity_id = ?' => 123]

);

echo $collection->getSelect() 

share|improve this question

asked 39 mins ago

Mansi RajaMansi Raja

638

share|improve this question

asked 39 mins ago

Mansi RajaMansi Raja

638

asked 39 mins ago

Mansi RajaMansi Raja

638

asked 39 mins ago

Mansi RajaMansi Raja

638

1 Answer
1

active

oldest

votes

0

try as below

echo $collection->getSelect()->__toString();

share|improve this answer

answered 37 mins ago

PiyushPiyush

4,84872054

add a comment | 

Your Answer

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "479"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});


}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f272360%2fecho-my-sql-query-in-magento%23new-answer', 'question_page');
}
);

Post as a guest

Name

Email

Required, but never shown

0

try as below

echo $collection->getSelect()->__toString();

share|improve this answer

answered 37 mins ago

PiyushPiyush

4,84872054

add a comment | 

0

try as below

echo $collection->getSelect()->__toString();

share|improve this answer

answered 37 mins ago

PiyushPiyush

4,84872054

add a comment | 

try as below

echo $collection->getSelect()->__toString();

share|improve this answer

answered 37 mins ago

PiyushPiyush

4,84872054

echo $collection->getSelect()->__toString();

share|improve this answer

answered 37 mins ago

PiyushPiyush

4,84872054

answered 37 mins ago

PiyushPiyush

4,84872054

answered 37 mins ago

PiyushPiyush

4,84872054