setup project code ci3

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 //LARAV...

 config.php <?php $servername = "localhost"; $username = "pakpoultrypk_website"; $password = "qhofB132"; $db = "pakpoultrypk_website"; // Create connection $con = mysqli_connect($servername, $username, $password,$db); // Check connection if (!$con) {   die("Connection failed: " . mysqli_connect_error()); } echo "Connected successfully"; ?> mainfile.php #!/usr/bin/php  Or use this #!/usr/bin/env php <?php    require_once('config.php');   $date = date('Y-m-d');   mysqli_query($con,"DELETE FROM broiler WHERE expDate<='$date'");   mysqli_query($con,"DELETE FROM chicksBroiler WHERE expDate<='$date'");   mysqli_query($con,"DELETE FROM chicksDomestic WHERE expDate<='$date'");   mysqli_query($con,"DELETE FROM domesticFarming WHERE expDate<='$date'");   mysqli_query($con,"DELETE FROM eggDomestic WHERE expDate<='$date...