News Feed
Sections




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

Dev-Explorer.com:
Using MySQL Stored Procedures and Extending MySQLi in PHP
June 19, 2009 @ 12:57:28

On the Dev-Explorer blog there's a post made recently about using stored procedures in your MySQL database via the mysqli interface in PHP.

On a new project I am working on I decided to take a look at the MySQLi (MySQL Improved) library. Most of the functions remain the same but it can now be used in object orientated programming which seemed to me as big advantage. Below I look at implementing MySQLi and extending it with your own custom code, along with using it to execute stored procedures.

He shows how to create both pieces of the puzzle - the class extending the mysqli functionality and a simple stored procedure on the database side (to insert users into a table). They're tied together with a PHP class with a "storedProcedure" method that runs a query() with a "CALL" to the procedure name.

0 comments voice your opinion now!
tutorial storedprocedure mysqli


blog comments powered by Disqus

Similar Posts

Tomas Petricek's Blog: Writing Silverlight applications in PHP

Chris Hartjes' Blog: Metatesting: Understanding Mock Objects

Abhinav Singh's Blog: How to use locks for assuring atomic operation in Memcached?

Zend Developer Zone: Installing PHP4 and PHP5 Concurrently on One WinXP Computer

Blond R's Blog: Set up IIS 7 w/ MySQL and PHP 5


Community Events





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


opinion developer list unittest framework install laravel code refactor community interview threedevsandamaybe wordpress introduction podcast testing release language configure series

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