Does CodeIgniter Automatically Prevent SQL Injection?

Posted by teejay on October 29, 2009

So, Does CodeIgniter Automatically Prevent SQL Injection?. The answer is no.

SQL Injection, according to wikipedia, "is a code injection technique that exploits a security vulnerability occurring in the database layer of an application".

CodeIgniter doesn't prevent this but it has the capacity to clean SQL. There are two ways CodeIgniter does this:

One is through Binding:

No Binding:

$this->db->query('INSERT INTO table_name (column1, column2) VALUES (val1, val2)');

With Binding:

$this->db->query('INSERT INTO table_name (column1, column2) VALUES (?, ?)');

Second is through the CodeIgniter Active Record Class:

No Active Record:

$this->db->query('INSERT INTO table_name (column1, column2) VALUES (val1, val2)');

With Active Record:

$this->db->insert('table_name', array('column1' => 'val1', 'column2' => 'val2'));

Almost all frameworks offer some kind of protection from SQL injections. This is how CodeIgniter does it.

Categories: How To, Web Development

Tags: codeigniter, php

29 Comments

Mark

Very nice article indeed. I learned a few things - for example, I didn’t know about binding :P

November 2nd 2009

Manny

This was a great help to me as a CI newbie. Hope to see more articles from you on CodeIgniter.

November 2nd 2009

fiwedding

supply in stock and custom lace front wigs, full lace wigs, lace wigs, human hair wigs,
remy lace front wigs, cheap wigs, cheap, buy, celebrity
full lace wigs
lace wigs
lace wigs sale
lace front wigs
synthetic front lace wigs
A Famous Dresses Shop which sell directly Wedding Dresses, Evening Dress, Bridesmaid Dresses,Prom dresses
cheap wedding dresses
cheap evening dresses
cheap prom dresses
cheap evening dresses
cheap prom dresses
Elegant evening dresses are always associated with the brides and their bridesmaids.Shopping for evening dresses and your wedding dress in stylish bridal ..

August 2nd 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

dsg

As the fast development of eyewear industry, there are different kinds of glasses catering for various needs and flavors. People have their choices when they want to wear glasses as fashion accessories. Online cheap eyeglasses enable customers to save great expense. Firmoo.com is the right place for you to buy eyeglasses and sunglasses, for there is a huge variety for your choice, like, buy glasses online prescription, titanium eyeglass frames, discount eyeglasses, progressive no line bifocal reading glasses, prescription sunglasses online, $12 eyeglasses and so forth. Firmoo.com will satisfy your needs for vision and beauty. The quality of these glasses is guaranteed. Why not take your action right now? More info: http://blog.math.uny.ac.id/daianna/.Detroit eyeglasses|Honolulu eyewear

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

This Alain Silberstein replica watches was well known in Russia and Scandinavia. A change in location was made by the grandson of Hublot replica watches . But it didn’t last long. In 1965 with the arrival of the great business Rolex Daytona watches , replica Omega brand had to make a withdrawal from the scene. He was the one who introduced the inclusion of high quality jewelleries into the portfolio of Panerai watches product. consideration the high precision mechanical replica Burberry movement of the original founder replica Movado watches .

August 14th 2010

bbq grills

Step around burgers, put away chicken; to grills something that could be genuinely rapidly foodstuff, think portable charcoal bbq grill about that fish filet within the filet mignon.

A lot of chefs forget fish whenever they take out their own charcoal barbecue grill, favoring the actual classic beef and pork. Unfortunately grilling fish releases fillets which might extremely kamado grill flaky along with flavorful, a person wouldn’t think twice about barbecue grill not often known the very beer batter or maybe typically the profound baking.

Grilled fish is actually healthful - virtually fat-free outdoor barbecue grill help save a little brushing of vegetable oil to prevent it from inserting—plus making that at real wood cedar planks can kamado grills certainly add full flavour free of improving unhealthy calories.

Karen Adler along with Judith Fertig, the making duo by Kansas referred to as typically the kamado ceramic grill Queens, reported ample at home cooks, particularly landlocked Midwesterners, skip fish relating to grill together with are usually surprised to find out barbecue grills how very easy it is without question.

With every, Adler plus Fertig bbq grills possess created much more when compared with 20 cookbooks, primarily on grilling in barbecue grill accessories addition to barbecuing, this includes the particular recently launched “Techniques with regard to Cooking charcoal bbq grill Fish” and also “Skills intended for Planking”

“I consider the way to grilling fish is to cedar plank this,” Adler kamado ceramic grill stated. Planking, or maybe making on a fabulous cedar planks of savoury solid wood which has been grill bundles soaked in water, helps to continue to keep fish succulent plus reduces the call to turn the actual fish filet over, extremely firmly sticking isn’t a concern. Fish with the latest planks chefs by means of portable outdoor grill roundabout temperature. You need to soak the exact cedar in cold water for not less than one hour before putting this about typically the grill so the plank doesn’t burn during cooking.

Planking occurs in convenient pertaining to extremely thin fillets of water fish, this sort of since perch, which in turn can certainly sink while outdoor bbq grills. Whenever it’s done preparing food, the fish bbq smokers is good straight out of the cedar.Aluminum foil likewise helps out lining the particular bbq grill grates and also generating packets to get fish.

While with regard to the time to barbeque grill fish, Adler charcoal grills as well as Fertig advise a very simple “10 minutes of the inch of thickness” rule, turning over at the particular halfway point. A good salmon fillet that calculates 3/4 -inch-thick will likely barbeque smoker grill need to barbeque grill about 7 to 8 minutes, or simply bbq grill approximately 4 minutes upon each side over high, direct heat.Nearly every type of fish and also shellfish may be
bbq grill smoker cooked upon the exact grilling.

August 16th 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

lisaweng

Looking at Christian Louboutin Sandals,which

appealed many women want to buy it.The Christian Louboutin Slingbacks that you are going to find on display are more graceful,fashionable and sexy.The color will be

colorful for us to choose from the most discerning of customers.There are a large number of new and different colors of the Christian Louboutin Wedges.Customers canChristian Louboutin Pumps at boutinques from all over the world or from online

stores.Women are always crazy for Christian Louboutin.
Louboutin pumps may actually require who

persuits the fashion trend.Christian pumps is so

hot. So what are you waiting for?

August 18th 2010

nike air max 2012

air max
air max shoes
cheap air max
discount air max
mens nike air max 2012
mens nike air max 2010
womens nike air max 2010
mens nike air max 2009
womens nike air max 2009
nike air max 2003
nike air max 97
mens nike air max 95
womens nike air max 95
nike air max 93
mens nike air max 91
womens nike air max 91
nike air max 89
nike air max 88
mens nike air max 87
womens nike air max 87
nike air max 180
nike air max 360
mens air max ltd
womens air max ltd
nike air max bw
nike air max premium
nike air max skyline
air max zenyth
nike air max tn
kids air max 90
nike air max bw

August 19th 2010

ewtwet

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

To boot, we examine our Replica IWC Portuguese Watches before mailing them to you. We need you to have an quality functional watch for many years to come. With us, you will be able to expect quick delivery and the proper boxing and packaging to maintain your Replica IWC Portuguese Watch while it is en route to you! This is not usually available with many online stores. You can feel comfortable about buying your IWC Replica Watches from us.
Cartier Pasha Replica
Hublot Big Bang Replica
Chopard Happy Sport replica
Omega Seamaster Replica Watches
IWC Pilot Replica

August 24th 2010

william

All CompTIA Security+ online tests MCITP Certification somewhere, and that is what the CompTIA Security+ training course will do for you: create a MCSA Certification to build on. Study guides are essentially a detailed CompTIA Security+ tutorial and are great introductions to new 70-299 Exam training courses as you advance. The content is always relevant, and compound again to make you a CompTIA Security+ testking. You will frequently find these MCTS Exam files downloadable and can then archive or print them for extra reading or studying on-the-go.

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

xiaoqiang

wholesale louis vuitton
gucci sneakers desiger
abercrombie fitch clothing
affliction for sale
ed hardy replica
fashion coogi clothing
urban armani watches
dolce gabbana new
prada handbags cheap
vibram five finger discount
http://www.cheapclotheschina.com

August 26th 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

ugg boots sale

September 1st 2010

ugg boots

UGG Ultra Short
Black UGG Ultra Short Boots
Chestnut UGG Ultra Short Boots
Chocolate UGG Ultra Short Boots
Sand UGG Ultra Short Boots

September 2nd 2010

Microsoft Office 2007

Microsoft Office 2007
Office 2007
Microsoft Office
Office 2007 key
Office 2007 download
Office 2007 Professional
Office 2007 home
Office Professional 2007
Office ultimate 2007
Microsoft Office 2010
Office 2010 Professional
Office 2010
Office 2010 key
Office 2010 download
Office 2010 Home.
office professional 2010
Windows 7 Home

September 4th 2010

Cheap UGGs For Sale

We have all cheap UGGs for sale in our website http://www.salesuggs.org! You can meet all your needs for UGGs sale here and will certainly be satisfied with the top quality at low price. All UGGs on sale are made with the 100% genuine sheepskin from Australia and are hand-made in our own factory completely. So you need no to worry about the quality and the cheap UGGs for sale are all to be delivered in free shipping. Enjoy the large discount!
UGG Mayfaire
ugg mayfaire black
ugg mayfaire chestnut
ugg mayfaire chocolate
ugg mayfaire sand
UGG Bailey Button Triplet

September 6th 2010

CYJisZZZ

September 7th 2010

MONCLER

Moncler
Moncler jackets
Moncler coats
Moncler vest
Moncler down jackets
Moncler sale
Moncler jackets
Moncler kids
Moncler women
Moncler men

Moncler
Moncler coats
Moncler men jackets
Doudoune Moncler
Moncler K2
Moncler quincy
Moncler homme
Moncler femme
Moncler sale

Moncler
The north face
Columbia Titanium
Columbia jackets
The north face sale
The north face discount
Piumini Moncler
Moncler prezzi
Moncler abbigliamento
Moncler uomo
Moncler donna
Canada Goose Parka

Christian Louboutin
Christian Louboutin Shoes
Christian Louboutin Ebay
Christian Louboutin Sale
Christian Louboutin Discount
Christian Louboutin pumps
Christian Louboutin Cheap
Louboutin

September 9th 2010

PinoyTech.org

Does CodeIgniter Automatically Prevent SQL Injection?

Comments

Sponsors

Categories

Archives

Recent Posts