How to do Multiple SQL Inserts

Posted by teejay on November 2, 2009

Using multiple insert queries almost always slip my mind when developing applications. If you are like me, we all need some reminder in some way or another.

Inserting multiple rows using multiple inserts:

$this->db->insert('students', array('first_name' => 'teejay', 'last_name' => 'obazee'));
$this->db->insert('students', array('first_name' => 'maev', 'last_name' => 'shadowsong'));
$this->db->insert('students', array('first_name' => 'jaina', 'last_name' => 'proudmore'));

Inserting multiple rows using a single query:

$this->db->query('INSERT INTO students (first_name, last_name) VALUES
                     ('teejay', 'obazee')'
                     ('maev', 'shadowsong')'
                     ('jaina', 'proudmore')', FALSE)

Unfortunately, CodeIgniter’s Active Record cannot do multiple inserts as of this writing. This will be the solution for now.

Categories: How To, Web Development

Tags: codeigniter, sql, php, mysql

17 Comments

laojiu

nice 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

juicy couture

Shop the latest styles juicy couture handbags, juicy couture tracksuit.
Juicy Couture
An online shop specializing in Herve Leger, Herve Leger Dress, Herve Leger Skirt,
Herve Leger
FashionStyleOnsale offer high quality Moncler Jackets at low price.
Moncler Jackets on sale, shop more discount Moncler Vest, Moncler Coats at FashionStyleOnsale
Moncler

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

Many of them quench their thirst for a replica Panerai watches by opting for great replica Rolex Air-King watches available in an affordable way.
The illustrious tradition of replica Rado is matched by replica Rolex GMT ’s inimitable performance. she is a much replica Montblanc woman in the media. There is no wonder that more and more admire the great union between designer watches and Rolex Sea Dweller replica 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

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

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

Customer service is available 24/7 and will respond to email in record time, three hours or less. Our knowledgeable staff will answer questions and tell you about the reliability and precision of our replica Chopard watches, Order your a Frank Muller Conquistador Replica Watches today and feel pride when you put it on your wrist. We are certain that you will come back for buying more replica Chopard watches.
Breitling Airwolf Replica
Breitling Aerospace Replica Watches
Cartier Pasha Replica Watches
Cartier Ballon Bleu Replica Watches
Cartier 21 Must De Replica

August 24th 2010

william

What could be better than passing your 220-601 Exam certificate tests, than passing them at your own pace? You’ll find that the professional 220-602 braindump free products we sell are of the highest quality - which explains why we’ve never had anyone accept the guarantee. If you use our MCTS Exam certification exam, you WILL pass, without the required months or years in a MCSE 2003 class or using other MCITP CBT methods.

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.