Magento as you might know or not! has really a very PIA (Pain in the A**) type of methods to create SQL, execute and fetch! There are two ways of getting SQL from the collection of Magento. Here are the two ways.
1. Only Echoing Query String.
For just echoing the query string you [...]
Posts Tagged ‘query’
How to get Query as a String in Magento?
Posted by Bagesh Singh on April 7th, 2010
Posted in Magento, PHP Third Party Tools, php, tips and technique 
Tags: Magento, query, String 
Comments Off
Using Custom Query in Magento
Posted by Bagesh Singh on April 7th, 2010
Magento has given us very good features to manage Models and Collection for interacting with Database tables. Nowonder, they are very helpful in most of the cases. Yet, we may need to write custom query in some cases (if you need it quick or if you are new to Models & [...]
Using Custom Query in Magento
Posted by Bagesh Singh on April 7th, 2010
Magento has given us very good features to manage Models and Collection for interacting with Database tables. Nowonder, they are very helpful in most of the cases. Yet, we may need to write custom query in some cases (if you need it quick or if you are new to Models & [...]
Redirect to some other location from Model or Observer in Magento
Posted by Bagesh Singh on April 6th, 2010
Redirection in Magento’s controller is simple. You just need to call a _redirect() or _forward() function and provide appropriate router/controller/action parameter. But if you want to redirect to some other page from Model or from Observer, then this can be tricky. Lets take an example, for explaining what I am [...]
Posted in Magento, how-to, php, tips and technique Tags: Controllers, how-to, Magento, php, query, tricks Comments Off
Creating Product Links in Magento Using Custom Query
Posted by Bagesh Singh on April 6th, 2010
I’ve already made a post in this blog about Adding Related Product and other links to Product in Magento . But when I used the method to creating links among product’s, while importing very large number of products and creating large number of product links, it took a lot of time [...]
Creating Collection of Objects in Magento using a “Magical Class”:Varien_Data_Collection
Posted by Bagesh Singh on April 6th, 2010
Have you ever wondered how Collection in Magento are built, containing array of individual Entity Objects of Magento? Collections are one of the most important data structure (if I am right) used in Magento. Most of the queries in Magento will result into collection, and then you will apply a foreach [...]
Getting Ordered Items and their Detail from Order ID in Magento
Posted by Bagesh Singh on April 6th, 2010
Here is a small snippet of code, yet useful, to get ordered items and its details. I’ve deviced this code a lot before and posted in Magento Commerce’s Forum as well. But felt like writting it again, so that I can have a quick refrence to it as well. Next thing, I’ve [...]
Getting Customer’s Info Using Single Query Including Billing and Shipping Addresses in magento
Posted by Bagesh Singh on April 6th, 2010
Query in Magento can be quite troublesome, if you are a starter..or non-starter. So I’ve tried to share some of the difficult queries using collection in Magento, so that it will be helpful to my blog readers and also a place where I can later refer to. Here is one of them, [...]
How did I reduce CPU overhead problem caused by MySql?
Posted by Bagesh Singh on March 16th, 2010
From last day, We were having problem with a project which was shut down in the middle due to heavy traffic. As a technical manager, I was the person who to take charge over the project bring it down to the track. After doing few benchmark test, I came to know that [...]
How did I reduce CPU overhead problem caused by MySql?
Posted by Bagesh Singh on March 3rd, 2010
From last day, We were having problem with a project which was shut down in the middle due to heavy traffic. As a technical manager, I was the person who to take charge over the project bring it down to the track. After doing few benchmark test, I came to know that the MySql access [...]
