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:/