Hjdcti

What is a 'Key' in computer science?

"Whatever a Russian does, they end up making the Kalashnikov gun"? Are there any similar proverbs in English?

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

std::is_constructible on incomplete types

A Paper Record is What I Hamper

Prove the alternating sum of a decreasing sequence converging to 0 is Cauchy.

What is the best way to deal with NPC-NPC combat?

What's parked in Mil Moscow helicopter plant?

What is the ongoing value of the Kanban board to the developers as opposed to management

Why did C use the -> operator instead of reusing the . operator?

Is Electric Central Heating worth it if using Solar Panels?

What is /etc/mtab in Linux?

Is a 5 watt UHF/VHF handheld considered QRP?

"My boss was furious with me and I have been fired" vs. "My boss was furious with me and I was fired"

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

Will I lose my paid in full property

PIC mathematical operations weird problem

How would this chord from "Rocket Man" be analyzed?

Why did Israel vote against lifting the American embargo on Cuba?

How to open locks without disable device?

How would I use different systems of magic when they are capable of the same effects?

Is there any hidden 'W' sound after 'comment' in : Comment est-elle?

How to translate "red flag" into Spanish?

Is Diceware more secure than a long passphrase?

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

asked 2 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

asked 2 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

asked 2 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

asked 2 mins ago

Mansi RajaMansi Raja

638

share

asked 2 mins ago

Mansi RajaMansi Raja

638

asked 2 mins ago

Mansi RajaMansi Raja

638

asked 2 mins ago

Mansi RajaMansi Raja

638

1 Answer
1

active

oldest

votes

0

try as below

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

share

answered 1 min 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

answered 1 min ago

PiyushPiyush

4,84872054

add a comment | 

0

try as below

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

share

answered 1 min ago

PiyushPiyush

4,84872054

add a comment | 

try as below

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

share

answered 1 min ago

PiyushPiyush

4,84872054

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

share

answered 1 min ago

PiyushPiyush

4,84872054

answered 1 min ago

PiyushPiyush

4,84872054

answered 1 min ago

PiyushPiyush

4,84872054