News Feed
Jobs Feed
Sections




News Archive
Looking for more information on how to do PHP the right way? Check out PHP: The Right Way

php|architect:
Stored Procedure Programming for MySQL5 (Part 2)
August 08, 2006 @ 12:11:54

The A/R/T article repository (from php|architect) has posted the second part of their series covering stored procedure programming in MySQL by Ligaya Turmelle.

Now that we become familiar with the fundamentals of stored procedures it is time to start playing with the "Big Boy Toys". This article will go over stored procedures's built in error handling, the security features available, various "extras" available, what isn't allowed in a stored procedure, and some basic administration of the stored procedures. So lets stop talking and bust open the toy box and start playing!

Since they've already gotten the groundwork laid in the previous article, they jump right into the transactions in this part. In this example, they create a "mass insert", show hoe to create some error handling, add in a dash of security, and toss in a few extras. There's also a few small gotchas included to watch out for.

0 comments voice your opinion now!
mysql stored procedure programming part2 mass insert error security mysql stored procedure programming part2 mass insert error security


blog comments powered by Disqus

Similar Posts

ThinkPHP Blog: Commoditizing PHP security (Chorizo! Launched)

Zend Developer Zone: Streamline Working with XML in PHP Using Service Data Objects (Part 1 & 2)

WebDevRadio: Episode 108: New Ruby, Regex and my Framework Security Rant(tm)

MSBWare.com: Integrating FCKeditor With Your MySQL Database

Michi Kono's Blog: The Best PHP Book Out There


Community Events











Don't see your event here?
Let us know!


composer introduction performance package unittest component podcast language framework hack install release opinion facebook application symfony2 database security hhvm series

All content copyright, 2014 PHPDeveloper.org :: info@phpdeveloper.org - Powered by the Solar PHP Framework