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

php stored-procedures mysql phpmyadmin
Starx picture Starx · May 17, 2010 · Viewed 134.2k times · Source

I want to be able create stored procedures using phpMyAdmin and later on use it through php.

But I dont know how to?

From what I know, I found out that we cannot manage stored procedures through phpMyAdmin.

What other tool can manage stored procedure?

I am not even sure if it is better option to use stored procedure through PHP. Any suggestion?

Answer

wimvds picture wimvds · May 17, 2010

Since a stored procedure is created, altered and dropped using queries you actually CAN manage them using phpMyAdmin.

To create a stored procedure, you can use the following (change as necessary) :

CREATE PROCEDURE sp_test()
BEGIN
  SELECT 'Number of records: ', count(*) from test;
END//

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

Once you created the stored procedure it will appear in the Routines fieldset below your tables (in the Structure tab), and you can easily change/drop it.

To use the stored procedure from PHP you have to execute a CALL query, just like you would do in plain SQL.

Related questions

How to call a MySQL stored procedure from within PHP code?

I have stored procedure that I created in MySQL and want PHP to call that stored procedure. What is the best way to do this? -MySQL client version: 4.1.11 -MySQL Server version: 5.0.45 Here is my stored procedure: DELIMITER $$ DROP FUNCTION IF …

Read More
Prepared Statement vs. Stored Procedure

If you are using php5 and mysql5, is there a substantial advantage to using stored procs over prepared statements? ( i read somewhere you may not get substantial performance gains from mysql5 stored proc)

Read More
Laravel 5.1 How do you create a MySQL stored procedure with migration

Hello I'm trying to create a stored procedure using Laravel 5.1 migrations. So far I tried with DB::connection()->getPdo()->exec(), DB::raw() and DB::unprepared(), but no luck. Here's how my code looks like: use Illuminate\…

Read More