Using Stored Procedures with mySQL and PHP

Hello guys,

we have new project...medium size - hotel managment WEB software

Writing external scripts to perform complex data handling is a tedious affair. The best way to automate tasks straightaway into the server is by using Stored Procedures. It is very useful to make them as flexible as possible, as it facilitates easy identification of any errors and can be used for executing a variety of tasks as well.

what you thing?

That’s cool.
I’d use the same way.

With Revo?

Quote from: goldsky at Dec 08, 2010, 02:00 PM

That’s cool.
I’d use the same way.

With Revo?

i thing double-edged sword...
some links:
http://www.macronimous.com/resources/using_stored_procedure_with_mySQL_and_PHP.asp
http://en.wikipedia.org/wiki/Stored_procedure

Disadvantages

Stored procedure languages are quite often vendor-specific. If you want to switch to using another vendor’s database, then you have to rewrite your stored procedures. Stored procedure languages from different vendors have different levels of sophistication; for example, Oracle’s PL/SQL has more languages features and built-in features (via packages such as DBMS_ and UTL_ and others) than Microsoft’s T-SQL. Tool support for writing and debugging stored procedures are often not as good as for other programming languages; but again, this differs between vendors and languages (for example, both PL/SQL and T-SQL have dedicated IDEs and debuggers).

==================
huh, somthing other what you thing about mysqli and PDO? Who is best choice?
here some benchmarks:
http://blogs.vinuthomas.com/2006/08/07/benchmark-mysql-mysqli-pdo-in-php/
http://jonathanrobson.me/2010/06/mysqli-vs-pdo-benchmarks