MySQL - Stored Procedures && Functions

A stored procedure is basically like a function jo apny andr different queries store kr skta h aur run be krta h on server side(PHPMyAdmin).

it can have both parameters and no parameters.

//CREATE PROCEDURE.

 Go to Routes

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

END

DELIMITER //
 CREATE PROCEDURE sp_select_suborders(IN `p_subId`)

    IF EXISTS (SELECT * FROM suborders WHERE subId = p_subId ) 

THEN
    BEGIN
       SELECT * FROM suborders WHERE subId = p_subId
    END

ELSE
    BEGIN
        SELECT id FROM orders WHERE id = p_subId LIMIT 1
    END 

DELIMITER ;

CALL STORED PROCEDURES IN CODE(the result will be in the array)

    $stmt = $db->prepare('CALL sp_select_suborders(?)');

  $this->db->query('EXEC procedureName $param1 $param2 $param3,...')

//LINKS TO USE

https://medium.com/mobiosolutions/create-stored-procedures-in-php-myadmin-ccf02c323a7e

//LARAVEL

https://medium.com/coding17/how-to-execute-stored-procedure-using-laravel-8d067c306154