Best extension to use for stored procedures between PHP 5.0+, MySQL 5.2+

Question

4.00/5 (1 vote)

See more:

Hello all!

So I am relatively new to using PHP (I am much more versed at using C# ASP.NET) and I was wondering what the best php extension was to interact with stored procedures on a MySQL server. So far I have looked at php_mysql.dll, php_mysqli.dll, and am now looking at php_pdo.dll.

When I was working with ASP.NET the SqlCommand object would take in a connection and a stored procedure. Then you could subsequently add SqlParameter objects in which you could specify the direction, the parameter type, the parameter value, etc.

My question, then, is which is the PHP extension that most closely represents this fine-grained level of control over stored procedure interaction?

Much appreciated!

-Moarcodeplz

Posted 7-Jun-11 10:28am

suprcodr

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Kim Togo · Accepted Answer · 2011-06-07T11:50:00

Solution 1

This link Call a stored procedure from PHP[^] is found under MySQL Articles, Tips & Snippets[^]

Posted 7-Jun-11 11:50am

Kim Togo

Comments

suprcodr 8-Jun-11 10:33am

While both responses are good, this response has exactly what I needed. Thank you for the input!

Kim Togo 8-Jun-11 15:11pm

Thanks, and you are welcome. You can accept both solutions if you find good.

suprcodr 8-Jun-11 15:12pm

Had no idea! Done and done.

Peter_in_2780 · Accepted Answer · 2011-06-07T15:12:00

php_sqli is definitely to be preferred over php_sql.

This is from the PHP manual, intro section to php_mysqli:

The mysqli extension allows you to access the functionality provided by MySQL 4.1 and above. More information about the MySQL Database server can be found at » http://www.mysql.com/
An overview of software available for using MySQL from PHP can be found at Overview
Documentation for MySQL can be found at » http://dev.mysql.com/doc/.
Parts of this documentation included from MySQL manual with permissions of MySQL AB.

AFAIK, php_pdo is simply an abstraction layer to provide db-independent access methods, so if you're sticking with mysql, it doesn't buy you much.

For what I think you're trying to do, have a look at the MySQLi_STMT class in the PHP manual.

Cheers,
Peter