Is possible to use store procedures in phpMyAdmin? I dont find this possibility.
Thanks.

The answer is yes and no. Phpmyadmin has no tools for creating stored procedures but you can enter in SQL using it and in that way create them.

(Note I don't believe versions prior to MySQL 5 supported stored procedures.)

I´ve enter the script to create the procedure in the phpMyAdmin´s SQL editor, but have an error. I have all permissions (is a local database). It did´t work
I continue work on it. thanks

I forget: I use MySQL 5.0.51 and PHP 5.2.5.

What was the error?

CREATE PROCEDURE test.`get_count_users` ( IN param1 VARCHAR( 50 )

(X) -> ) BEGIN SET @SQL = CONCAT( "SELECT * FROM ", param1, ";" ) ;

MySQL:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3

I put the same script in a SQL edit in Toad For MySQL and works good over the same database!! But phpMyAdmin don´t want to work with any procedure script
I test several scripts and the problem are the same. I think that phpMyAdmin not work with procedures. I search Web, but i didn´t found nothing about that

check your MySQL version....

Several years later, i post about this, sorry
Finally, i can use procedures with PHPMyAdmin, but i dont view as an DB Object. Simply i put the create sentence in SQL Editor and send. The procedure exists, i call from php, but the procedures i not listed in phpMyAdmin.
There is a chance to view procedures in phpMyAdmin?

I really don't think so. PhpMyadmin doesn't support stored procedures. Since it allows you to query the db you can create them but it doesn'thave any tools in place to support them.

In the PhpMyAdmin list of databases should be information_schema. In it is a table name ROUTINES. You query it by issuing a

select ROUTINE_NAME from ROUTINES;

This will output a list of Stored Procedure names. To see a procedure, run the query

show create procdure [procedure name from above select]

Hi

i am able to create procedures at phpmyadmin
can u plz let me know how to use those stored procedures in php
should i use call / execute statement in order to get those results of created stored procedure

thanks..

If you are using mysqli or PDO stuff then it will work pretty much automatically. If you are using the older mysql_ functions, then you must add a flag to the connect directive:

mysql_connect($host, $user, $password, true, 65536);

the 65536 is a magic number flag to allow for multiple responses on the connection. It is not currently documented, but can be found in the php header file.

phpMyAdmin does a crummy job of working with stored procedures, functions and triggers - and executing them from the SQL window is also hit & miss.

I'm looking for anyone that would like to assist me with alpha and beta testing my new open source project, phpMyIDE which is a PHP/JS/Ajax application for managing database-embedded code for MySQL. It can be found here:
<edit>Link removed - Please don't throw original post off topic with your own requests and links</edit>

... many of the questions about working with stored procedures are answered with this app, making working with them a whole lot easier.

Thanks in advance to anyone willing to assist,
/p