How to write a stored procedure using phpmyadmin and how to use it through php? -


I want to be able to create stored processes using phpMyAdmin and later it will be php I want to use it through

But I do not know how?

Whatever I know, I have found that we can not manage stored procedures through phpMyAdmin .

Can other devices manage stored functions?

I'm also not sure that this is a better option for using stored functionality via PHP. Any suggestions?

Since using a stored procedure, you can actually use them phpMyAdmin Asks.

To create a stored procedure, you can use the following (changes as needed):

  created process sp_test () Number of records: 'From the test ( *) Calculation; END //  

And make sure you set the "Delimiter" field on the SQL tab. //

Once you create a stored procedure, it's the routings field under your tables (in the Structure tab), and you can easily change / drop it.

To use PHP stored procedure, you have to execute the call query, as you would in plain SQL.


Comments