How to Debug Queries with CodeIgniter

Posted by teejay on October 31, 2009

If you are like me - browsing through the forums almost everyday - you'll probably notice the large number of questions regarding SQL debugging. I try to answer a few depending on the time I have.

Eventually, you get tired. That's the reason I posted this. There are two ways in CodeIgniter to extract the query and debug it using a GUI SQL Manager.

Using the CodeIgniter Profiler

CodeIgniter has a built-in profiler that tries to extract information for each page load. It also lists all the queries that were done to generate the page. From there you can identify if the certain query was generated correctly.

Using the Active Records Last Query Function

I use this a lot. Whenever I suspect that the query generated was incorrect, I put echo $this->db->last_query(); below the script to see the query generated. I check it out. If I can't figure out the problem, I copy and paste this in my GUI SQL Manager and check if it generates the correct information I need.

$this->select('students.name, students.age, schools.name');
$this->db->join('students_schools', 'students_schools.student_id = students.id', 'LEFT');
$this->db->join('schools', 'students_schools.school_id = schools.id', 'LEFT');
$this->db->get_where('students', array('students.id' => 17));

echo $this->db->last_query();

Debugging CodeIgniter generated queries are so much easier if you use these techniques. I sure hope this post could help anyone who is using CodeIgniter and have problems debugging his queries.

Categories: How To, Web Development

Tags: codeigniter, php

20 Comments

rodrigo

Thnxs a lot, I’m sure i’ll make use of this function a lot !

December 6th 2009

ihsan

fuck is that?
stupid answer

April 29th 2010

cosplay

Cosplay Costumes Cosplay Wigs Movie TV Cosplay School Uniform Uniform Cosplay Cosplay Accessories .
cosplay costumes
cosplay
sexy lingerie
The Lingerie Store,The lingerie and nightwear SALE at Style Lingerie. All lingerie sale garments marked 30% to 70% off.
Sexy lingerie, ladies underwear and designer nightwear
lingerie store
lingerie sale
sexy lingerie
Sexy Clubwear
Lingerie, sleepwear and intimate apparel is our specialty, ranging from sexy lingerie to bridal lingerie,
including corset, bras, thongs and stockings.
Sexy Costumes
sexy nurses costume
sexy Sports costume
Vinyl Lingerie
lingerie sale

August 2nd 2010

laojiu

Ed Hardy
cheap Ed Hardy
EdHardy
Ed Hardy sale
Provide high quality silver Tiffany jewellery including necklaces,rings and other style jewelry at wholesale prices.Pick your dreaming
Tiffany jewellery
Best Discounted UK Tiffany Jewellery Sale Outlet provides designer Tiffany Ring, necklaces and other jewelry in wholesale price.
UK Tiffany specializes in
Tiffany Rings
Tiffany & Co Earrings
Tiffany
Tiffany jewellery

August 7th 2010

sdgsg

The time during which people think it is ugly to wear a pair of glasses on their faces has gone away from today’s fashion trends. Because everyone has a different opinion and style?many different eyeglasses or sunglasses need to be designed in order to supply the market with affordable and appealing spectacles. Firmoo.com is such a online store to provide you the most satisfying inexpensive glasses, like, online eyeglasses, prescription sports eyeglasses, discount perscription eyeglasses, titanium eyeglass frames, polarized sunglasses, $8 eyeglassesetc. they are with super quality, attractive exterior and low price. They can enhance your reading and your charm at low cost. Shopping eyeglasses and sunglasses here, you can enjoy the warmest customer services as well. More info: http://daianna.bloge.fr/.Houston eye doctor|Los Angeles eye care center

August 12th 2010

gucci

linda
It’s the most important part of our marketing Tiffany & Co,” he said. “I absolutely cannot imagine a retailer or designer operating today without a website.We have a social media prada store who has helped us integrate our Facebook page with our blog, the website and Twitter, and it has definitely brought in clients,” Gucci Shoes Sale said. “Our big thing right now is video, though. We can take our clients to market with us via the clips we bring back and share on our video Nike Air Jordan. We’ve also found great success with Flowtown, a pay-for tool that lets you import your email list and see who’s on Twitter, chanel bags, LinkedIn - then aggregate them based on how they describe themselves.

August 13th 2010

replicahandbags

Corum replica watches are not simple Breitling replica , the replica Watch accessories are high qualityOris watches with excellent accuracy of time and resemblance with their original models. Thesereplica Tag Heuer makes a style statement irrespective of the user is paying a game or in a party.

August 14th 2010

quentina

Women in summer would like to become beautiful. Everything can grab other’s eyes is their best friends.Products make them beauty and confident is their favourite. Look in the street,you can see many different types of make up to show women’s personality.

Welcome to the shop, the following is our products, free shipping.

Soccer Shoes Cheap Soccer Shoes Nike Soccer Shoes Adidas Soccer Shoes Nike Soccer Shoes sale Adidas Soccer Shoes sale UGG UGGs UGG Boot UGG Boots UGG Boots Sale Cheap UGG Boots UGG Boots Cheap Women UGG boots ugg boots cardy ugg cardy boots Nike Air Nike Air Max Nike Air Max Shoes Nike SB Nike Dunk Nike Dunk SB Nike Dunk SB Shoes Nike Shox Nike Shox Shoes Timberland Timberland sale Timberland boots Timberland boots online Timberland on sale New timberland boots Women Bags Women Bags Sale Women Handbags Women Handbags Sale Women New Bags Cheap Bags Cheap Bags On Sale UGG UGG boots UGG boots sale UGG boots short Short ugg Short ugg boots Ugg boots tall New women bags New women bags sale New women bags sale online Louis Vuitton Handbags Gucci bags Nike Nike Shoes Nike Shoes Sale Nike running Nike running shoes Nike trainers Nike trainers shoes Timberland Timberland boots Timberland boots sale Timberland boot Timberland boot sale Timberland boots cheap Men timberlands MBT MBT Shoes MBT Chapa GTX MBT Men Shoes MBT Women Shoes Discount MBT Shoes LV Handbags Gucci Handbags Chanel Handbags Chloe Handbags D&G Handbags Dior Handbags Fendi Handbags Hermes Handbags Jimmy Choo Bags Marc Jacobs Bags Miu Miu Handbags Mulberry Bags Prada Handbags Versace Handbags Yves Saint Laurent Balenciaga Bags Burberry Handbags LV Handbags Gucci Handbags Chanel Handbags Chloe Handbags D&G Handbags Dior Handbags Fendi Handbags Hermes Handbags Jimmy Choo Bags Marc Jacobs Bags Miu Miu Handbags Mulberry Bags Prada Handbags Versace Handbags Yves Saint Laurent Balenciaga Bags Burberry Handbags

Those who want to become most beautiful in the world should try them. Just ones can make you different. Girls who want to grab your boyfriends’s heart is necessary to use them.

August 17th 2010

QQQ

Elana and I had never had any sort of romantic involvement despite acting like this very often free porn. We had talked about it a long while ago and decided that it would be ebst to remain under the best friends tag, we didn’t want hairy bush to risk losing each other. I had wanted to fuck her a lot of times, she wasn’t a knockout but she was incredibly cute, but at the same time, there was a bit of a brother-sister relationship in our friendship empflix.com.
ABB728019391 ?????

August 18th 2010

eastnike

well,the following i will do a introduce about the popular shoes:
air jordan force 9
nike air jordan force 9
air jordan force IX LS
nike air max skyline
air max skyline
cheap air max skyline
airmax skyline
nike air max lebron 7
air max lebron 7
air max lebron VII
nike air max+2009
nike air max+2010
nike air max 90 shoes
nike air max 90 kids
nike air max 93 shoes
nike air max 95 shoes
nike air max 87 shoes
nike Air Max 1 premium
nike air max run lite
nike air max 89 shoes
nike air max 97 shoes
air max 97 shoes

nike womens
nike women’s shoes
nike women’s running shoes
nike kids shoes
nike kids
nike kids running shoes

puma cat shoes
puma ferrari
puma men shoes
puma ferrari shoes
puma ferrari cat
air max ltd
air max skyline
nike free running
cheap puma shoes
Nike Air Jordan
Nike Air Force 1
Nike Air Max
Nike Shox
Nike Free
Nike Dunk
Nike Basketball
Nike Shoes
Nike Women Shoes
Puma Shoes

We are a professional and reliable supplier of series of innovative, authentic and inexpensive Nike shoes with original box and retro card.
air max 2009
air max 2009 shoes
air max shoes sale
air max shoes
nike air max 2009
cheap air max 2009
buy air max 2009
air max 2009 review
airmax 2009
nike air max+2009
airmax shoes
air maxs
air maxes
air max
nike air max

warmly welcome and sincerely thank you for visiting our NikeShoes123 website.
the following is the hot sale on our website:
Nike air force 1 shoes
air force 1 shoes
air force 1 shoes sale
air forces
air force shoes
nike air force
nike air force shoes
1 shoes
af1 shoes
air force 1
air force 1 shoe
air force 1 high
air force 1 low
air force 1 mid
air force 1 sneaker
air force 1’s
air force one
air force one low
air force one shoes
air force one shoe
air force one sneaker
air force one high
air force one mid
air force one for sale
air forces shoes

August 18th 2010

etwet

Here at shanghai massage company provides out-call , beijing massageservice in beijing escortand the shengzhen massage Company guangzhou massagehas strong supply ability. beijing escort Living in Puxi is to live with jollification and prosperity, either downtown and Hongqiao area, or external ring, shanghai apartment rental .This is the best site I have found for building cnc plasma of any type.East meets West, Culture meets Excitement, Tradition meets Inspiration? We find it for you right here in.

August 22nd 2010

igor

A few minutes later they all came in with their mature tube cloths on. I told them amateur porn to all get naked and they did. Dayana had a great homemade porn body dark with firm tits. Tits had a free porn movies slight sage and a great ass. amateur video Evan sported a 6 inch dick and a home video tube muscular body. I told them free sex videos that I had pictures and maturesex would give them to their mom if they didn’t take care of me. free zoo video It was their disicion. They both started animal porn sucking on my dick. Evan stood there free porn QQX903752A11

August 23rd 2010

phoebe

Our website offers replica Patek Philippe watches that are chosen from the best suppliers. These watches are guaranteed to work, as each one is tested before it is shipped out. They look just like the original, however only cost a few hundred dollars, rather than three thousand or more. If you are looking for replica Patek Philippe Celestial Watches, you will surely be able to find them on our website. So, if you always dreamed about getting one of those Patek Philippee replica watches? your dreams can come true. You will now be able to buy a look a like watch, and a small fraction of the original price.
Franck Muller Casablanca Replica
Audemars Piguet Royal Oak Offshore Replica Watches
IWC Portuguese Replica Watches
Rolex Daytona Replica Watches
Audemars Piguet Royal Oak Offshore Replica Watches

August 24th 2010

william

we have extensively revised and expanded this MCITP Certification and Security+ Study Guide with much new material, to match the revisions of the CompTIA Network+ and Security+ exams N10-004 and 220-702.CompTIA’s Network+ exam has a unique position in the IT industry in that it is one of those certifications that act as a stepping-stone to so many other certifications. Most techs get their Network+ Certification after becoming 220-701. Network+ opens the way to several certification paths for those interested in continuing their certifictions

August 25th 2010

air max 90

Specializing in jerseys, b2ctradekey.com offers a wide selection of shirts, jerseys cheap cheap including the NFL, MLB jerseys cheap, cheap NHL jerseys, NBA jerseys cheap, cheap NCAA Jerseys. Ect .. b2ctradekey.com has enjoyed fame since it was established on the basis of high quality, competitive price, fast delivery and the best customer service. designer handbags on sale designer handbags cheap designer handbags marc jacobs handbags louis vuitton handbags prada handbags chanel handbags burberry handbags gucci handbags coach handbags fendi handbags gucci handbags gucci handbags The combination of the best quality with various styles, NFL jerseys and shirts for sale on MLB on sale are popular, both are always hot sale on our site. Many people worry about the cost of the shirts, why not take a look at our offer NHL Jerseys, must be worthy of purchase. women shox shoes nike Air Force nike dunk black nike dunk white vibram five shoes five finger shoes discount mbt shoes gucci belt Chanel Handbags paul smith paul smith sale paul smith bag paul smith clothing paul smith wallet paul smith shirt paul smith shoes PAUL SMITH BELTS The use of a favorite shirt will keep you in a good mood one day, so enjoy shopping here. In b2ctradekey. com, you need to fill in your name, phone, email, some personal information when you register on our site, we need the order status of your order by email instead of spam. b2ctradekey.com promises 100% security when purchasing online. No one will know your personal information without your permission. air max 90 air max shoes nike max shoes Visvim shoes nfl jerseys nfl jerseys on sale cheap nfl jerseys football nfl jerseys mbt shoes sale nike air max nike dunk shoes nike Air Force 1 nike air max black The company has always adhered to “quality first, reputation first, customers above the” to the end, and attract more new customers and regular. ugg boots ugg boots sale Ugg Classic Tall classic ugg boots ugg classic boots ugg classic short ugg on sale UGG cardy UGG Classic Mini UGG Slipper ugg boots classic tall UGG Ultra Short UGG Ultra Tall cheap ugg boots b2ctradekey.com also established a team of customer service from the establishment that will cater to the demand of all.

August 25th 2010

abercrombie london

abercrombie london
abercrombie
abercrombie and fitch
abercrombie uk
abercrombie and fitchmall
tiffany uk
abercrombie
Abercrombie outlet
Abercrombie clothing
ed hardy uk
love kills slowly
abercrombie outlet
abercrombie clothing
abercrombie and fitch uk
abercrombie fitch uk
Abercrombie & fitch uk
abercrombie and fitchmall
abercrombie and fitchmall
abercrombie uk
abercrombie and fitch uk
Abercrombie & Fitch UK
abercrombie fitch uk

August 25th 2010

timberland boots

my website is special designed for you Cheap timberland shoes
Timberland Waterproof Boots
Cheap timberland boot On Sale
Mens Timberland Boots
Womens Timberland Boots
Cheap Timberland Boots
Timberland Winter Boots
Timberland Work Boots
Timberland Waterrproof Shoes
Timberland UK Boots

August 27th 2010

ugg boots UK

It’s a interesting news,i like it.Additionally,wellcome to my website oboots.There are so many UGG Boots UK such as:
ugg uk uggs on sale cheap ugg boots ugg classic boots ugg bailey button boots|ugg argyle knit boots|ugg classic cardy boots|ugg crochet boots|ugg flower boots|ugg leopard boots|UGG Classic Tall Leopard boots|ugg classic mini boots|ugg paisley boots|UGG Classic Short Paisley boots|UGG Short Paisley boots|ugg classic short boots|ugg classic tall boots|ugg elsey wedge boots|ugg infants erin boots|ugg langley boots|ugg lo pro boots|ugg locarno boots|ugg mayfaire boots|ugg nightfall boots|ugg rainier eskimo boots||UGG Sundance II boots|ugg ultimate bind boots|ugg ultra short boots|ugg ultra tall boots|ugg suede boots|ugg upside boots ugg roxy boots|ugg seline boots|ugg corinth wedge boots|ugg liberty boots|ugg highkoo boots|ugg knightsbridge boots|ugg bomber jacket boots|ugg adirondack boots|ugg suburb crochet boots|U UGG Roseberry Suede Boots|UGG Smithfield Tall Boots|UGG Gaviota Boots|UGG Brookfield Tall Boots|UGG Ashur Boots|UGG Cove Boots|UGG Desoto|UGG Desoto Boots|UGG Shoreline Boots|UGG Tess Boots|UGG High Heel Tall Boots|UGG Caroline Boots|UGG Stella Boots|UGG Swell Tall Boots|UGG Men’s Brookfield|UGG Men’s Brookfield Boots|UGG Stripe Cable Knit Boots|UGG Broome Boots|UGG Felicity Boots|Ugg Gissella Boots|UGG Adirondack Boots II||UGG Chrystie Boots|UGG Kensington Boots|UGG Sandra Boots|UGG Bailey Button Fancy Boots|UGG Classic Short Boots II|UGG Classic Tall Boots II|UGG Classic Tall Boots 5885|UGG Payton Boots|UGG Kid’s Boots 5281|UGG Kid’s Classic Short|UGG Kid’s Classic Short 5251|UGG Kids Classic Tall Boots 5229|UGG Bailey Button Triplet Boots|UGG Kid’s Bailey Button Boots|UGG Men’s Classic Short Boots|mbt shoes|ugg boots sale|
tiffany|ugg boots|uggs on sale|cheap ugg boots|ugg size guide|
There are so much style of cheap ugg boots,so once you go to my website you will be very surprise.

August 31st 2010

uggs on sale

August 31st 2010

uggs on sale in uk

Not even as I shook womens ugg boots and trembled uncontrollably in the trenches, did I forget your ugg boots face. I would sit huddled into the wet mud, terrified, as the ugg australia hails of bullets and mortars crashed down around me. I would clutch my uggs bailey button rifle tightly to my heart, and think again of that very first day we met. I would cry out in bailey button boots fear, as the noise of war beat down around me. But, as I thought ugg boots in uk of you and saw you smiling back at me, everything ugg boots usa around me would be become silent, and I would be with you again for a few precious official ugg boots moments, far from the death and destruction. It would not be ugg classic cardy until I opened my eyes once again, that I would see and hear the carnage of the war around me.I cannot tell you ugg classic cardy boots how strong my love for you was back then, when I returned to you on leave in the September, feeling uggs classic cardy battered, bruised and fragile. We held each other so tight I thought ugg uk we would burst. YQ

September 1st 2010

PinoyTech.org