Why does not the stored procedure run?

Question

The code brings the corresponding parameters and does not show any error or exception, I have no idea why it does not perform what is programmed in the stored procedure, help!

This is the stored procedure in MySQL:

DELIMITER //
DROP PROCEDURE IF EXISTS prueba.CAMBIA_A_ACTIVO //
CREATE PROCEDURE CAMBIA_A_ACTIVO
( 
    IN  _email VARCHAR(45),
    IN _nombre_grupo VARCHAR(80)
) 
BEGIN
 UPDATE INTEGRATES_GRUPOS SET activo = 1
 WHERE nombre_grupo = _nombre_grupo 
 AND email = _email;
END; //

And this is the php code:

<?php

require_once('connection.php');

class CAMBIA_A_ACTIVO
{
    public function __construct($email, $nombre_grupo)
    { 
        try
            { 
                $mysql = new connection();
                $conexion = $mysql -> get_connection(); 
                $datos = array("email" => "$email", "nombre_grupo" => "$nombre_grupo"); 
                $statement = $conexion->prepare("CALL CAMBIA_A_ACTIVO(?,?)"); 
                $statement -> bind_param("ss", $datos["email"], $datos["nombre_grupo"]); 
                $statement -> execute(); 
                $statement -> close();
                $conexion -> close();   
            } catch (Exception $e)
                  {echo $e->getMessage();}
    }
}
?>

Check for errors, add `or die($conexion->error);` after the `prepare` and `execute` calls. — Barmar, Jul 31 '17 at 07:18
I don't understand what you're saying. If it's running successfully, why do you think the stored procedure isn't working? — Barmar, Jul 31 '17 at 07:42
If I execute the stored procedure update in the MySQL, runs succesfully but if I execute the update from php doesn't works — Alejandro Montanari, Jul 31 '17 at 07:45
That's why I said to make sure that the PHP variables contain values that have matching rows. — Barmar, Jul 31 '17 at 07:46
Is there a reason why you're putting the variables into an array? Why not just `bind_param('ss', $email, $nombre_groupo)` — Barmar, Jul 31 '17 at 07:48
How are you connecting to the MySql database? I don't recognise the class `connection()` as being part of the MySQLi (object-oriented), MySQLi (procedural) or the PDO interface. — Carsten Massmann, Jul 31 '17 at 08:00
The class connection() is: conn = new mysqli("localhost", "root", "", "prueba"); } public function get_connection(){ return $this->conn; } } ?> but I put the line: bind_param('ss', $email, $nombre_grupo) and the update doesn't run and don't show errors with or without the command "or die" — Alejandro Montanari, Jul 31 '17 at 18:52

score 0 · Answer 1 · answered Jul 31 '17 at 07:23

There are certain points within the exection flow where you can test for success or failure - as the code is set to catch Exceptions you could use such logic tests to raise new exceptions if there is a problem.

Presumably the actual stored procedure works when called from either the commandline or gui?

<?php
    require_once('connection.php');
    class CAMBIA_A_ACTIVO {
        public function __construct($email, $nombre_grupo){ 
            try { 
                $mysql = new connection();
                $conexion = $mysql->get_connection(); 

                if( $conexion ){
                    $datos = array("email" => "$email", "nombre_grupo" => "$nombre_grupo"); 
                    $statement = $conexion->prepare("CALL CAMBIA_A_ACTIVO(?,?)");

                    if( !$statement )throw new Exception('Failed to prepare SQL statement');
                    else {

                        $statement->bind_param("ss", $datos["email"], $datos["nombre_grupo"]); 
                        $result=$statement->execute();
                        $statement->close();
                        $conexion->close();

                        if( !$result )throw new Exception('Query failed');
                    }
                } else {
                    throw new Exception('Connection to db failed');
                }
            } catch (Exception $e){
                echo $e->getMessage();
            }
        }
    }
?>

I execute the code but not present errors or exceptions and the code don't execute the stored procedure... — Alejandro Montanari, Jul 31 '17 at 07:28
Have you checked MySql's own error messages with `mysqli_error()` ( https://stackoverflow.com/a/17053501/2610061 ) ? — Carsten Massmann, Jul 31 '17 at 07:56

Why does not the stored procedure run?

1 Answers1