Deleting a record with stored procedure

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

I actually got this working with the following:

[php]// if confirm deletion button has been clicked, delete record
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->bind_param(“ii”, $fileID, $rmaID);
$stmt->execute();
if ($stmt->affected_rows > 0) {
$deleted = true;
} else {
$error = ‘There was a problem deleting the record.’;
}
}[/php]

Sponsor our Newsletter | Privacy Policy | Terms of Service