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

Originally Posted by PavaniMadan

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..

Hi,

Mysql version 5.0.X supports stored procedures. PHPmyadmin does not support executing the procedures : 'Call <procedure>'. I hope they will fix this in the next version of phpmyadmin.

So as an work around would be to use an mysql client tool to create & execute the stored procedures.

hmmm, sorry you thought my post was off topic. Since phpMyIDE is an adjunct to phpMyAdmin and handles this problem quite squarely, I think it's on the dot.

So to answer the just-previous post, there IS a tool for doing this, phpmyide which can be found at phpmyide dot com (it is an open source freeware app, utterly un-monetized). It also allows you to wrap phpMyAdmin into one of the working tabs, so that you can have the formidable benefits of phpMyAdmin in a MySQL stored procedure development IDE.

Yes. You can create Stored Procedure in PhpMyAdmin.
Here is one example that how you can write it. For that we have to first change the delimiter sign so that we can execute the query.
delimiter //
CREATE PROCEDURE Sample(IN userID INT, OUT userName VARCHAR(20))
BEGIN
SELECT UserName INTO userName FROM TblUsers WHERE UserID=userID;
END

Here is the PHP code. MYSQL: calling sp with out variables.

$rs = mysql_query( "CALL getCountry(1, @userName)" );
$rs = mysql_query( "SELECT @userName" );
while($row = mysql_fetch_assoc($rs))
{
echo $row['@userName'];
}

That's it. Be happy. What ever problem just tell me.
You can contact for more details on joshisumitnet@yahoo.com
You can also find some more PHP code snippest on my blog
http://phpwithsumitjoshi.blogspot.com/