I’m trying to delete a record and update a table using a stored procedure but I’m currently getting the “white screen of death”. Below is my code:
[php]if (isset($_POST[‘delete’])) {
$fileID = 11720;
$rmaID = 2932;
/$stmt = mysqli_prepare($conn, ‘CALL update_new_sn(?, ?)’);
mysqli_bind_param(‘ii’, $fileID, $rmaID);
mysqli_execute($stmt);/
$stmt = $conn->prepare(‘Call update_new_sn(?, ?)’);
$stmt -> bindParam(1, $fileID, PDO::PARAM_INT);
$stmt -> bindParam(2, $rmaID, PDO::PARAM_INT);
$stmt->execute();
if ($stmt->affected_rows > 0) {
$deleted = true;
} else {
$error = ‘There was a problem deleting the record.’;
}
}
[/php]
Here is my stored procedure:
DROP PROCEDURE update_new_sn
//
CREATE DEFINER=admin
@localhost
PROCEDURE update_new_sn
(in selectedID int, in selectedRMAID int)
begin
delete from dropbox where id = selectedID;
update rma set ref_status_id = 0 where id = selectedRMAID;
end