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

by

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.

More Related Contents:

  1. Store procedures in phpMyAdmin
  2. How to write a stored procedure in phpMyAdmin?
  3. Can I store query result of one field into different variables? if not then what should I do for that?
  4. The requested URL was not found on this server.
  5. Warning: mysqli_connect(): (HY000/1045): Access denied for user ‘username’@’localhost’ (using password: YES)
  6. How to call a MySQL stored procedure from within PHP code?
  7. Import file size limit in PHPMyAdmin
  8. Fix Access denied for user ‘root’@’localhost’ for phpMyAdmin
  9. Mysql event error using php
  10. Access denied for user ‘root’@’localhost’ with PHPMyAdmin
  11. Calling stored procedure with Out parameter using PDO
  12. How to solve time out in phpmyadmin?
  13. WAMP/MySQL errors not in correct language
  14. PHP: Calling MySQL Stored Procedure with Both INPUT AND OUTPUT Parameters (NOT “INOUT”)
  15. PHP + MySql + Stored Procedures, how do I get access an “out” value?
  16. phpmyadmin automatic logout time
  17. #1193 – Unknown system variable ‘lc_messages’ when trying to login to phpmyadmin
  18. Unknown database error in PHP but it exists in PHPMyAdmin
  19. Extension mysqli is missing, phpmyadmin doesn’t work
  20. How to SELECT DEFAULT value of a field
  21. Stored Procedures, MySQL and PHP
  22. How to log in to phpMyAdmin with WAMP, what is the username and password?
  23. Auto Increment skipping numbers?
  24. Installing PDO driver on MySQL Linux server
  25. phpmysql error – #1273 – #1273 – Unknown collation: ‘utf8mb4_general_ci’
  26. Can I store images in MySQL [duplicate]
  27. Outputting all PHP errors to database not error_log
  28. php sample script for pagination [closed]
  29. How can I do a migration in laravel 5.5?
  30. How can I list data in sections by an ID, with a while loop in PHP? [closed]

Leave a Comment