Failed to delete record in database

Question

Failed to delete record in database

Navigation

#1 by (1 votes)

0

I'm trying to delete a record from my bank after deleting a physical file from a particular folder, the deletion of the physical file occurs as expected but the one from the bank fails, what I did was:

if ($_POST["Operacao"] == 'ExcluirUpload') {

$sql = "SELECT * FROM gerDoctoContrato WHERE IdDocumento = ? AND IdContrato = ?";

if($stmt = $conn->prepare($sql) ){
    $stmt->bind_param(
        "ii",
        $_POST["IdDocumento"],
        $_POST["IdContrato"]            
    ); 


    if ($stmt->execute()) {
        $data = array();    
        $result = $stmt->get_result();
        while ($row = $result->fetch_assoc()) {

            $CaminhoAnexo = $row['CaminhoAnexo'];
            $NomeArquivo = $row['NomeArquivo'];     

            unlink($CaminhoAnexo.$NomeArquivo);

        }

        $sqlUp = "DELETE FROM gerDoctoContrato WHERE IdDocumento = ? AND IdContrato = ?";
        if($stmts = $conn->prepare($sqlUp) ){           
            $stmst->bind_param(
                "ii",
                $_POST["IdDocumento"],
                $_POST["IdContrato"]            
            );  
        }

        $aretorno["msg"] = "Registro exclu&iacute;do com sucesso.";
        $aretorno["par"] = $_POST["IdContrato"];

    } else {
        $aretorno["msg"] = "Ocorreu um erro na exclus&atilde;o dos dados: " . $stmt->error . ". Verifique.";
        $aretorno["status"] = "ERRO";
    }

} else {
    $aretorno["msg"] = "Ocorreu um erro na prepara&ccedil;&atilde;o dos dados: "  . $stmt->error . ". Verifique.";
    $aretorno["status"] = "ERRO";
}

}

My console looks like this:

Uncaught TypeError: e.unbind is not a function

php

asked by anonymous 21.08.2015 / 18:44

1 answer

How to validate drop-down with jquery-validation How do I define the push_back function for a c ++ structure?

score 1 · Accepted Answer

I was able to solve, I changed the deletion script to one that I have working in another script and now it is deleting, in the end, after attaching the variables with bind_param () the commands $stmts->execute(); and $stmts->close(); were executed, thus :

if ($_POST["Operacao"] == 'ExcluirUpload') {

$sql = "SELECT * FROM gerDoctoContrato WHERE IdDocumento = ? AND IdContrato = ?";

if($stmt = $conn->prepare($sql) ){
    $stmt->bind_param(
        "ii",
        $_POST["IdDocumento"],
        $_POST["IdContrato"]            
    ); 


    if ($stmt->execute()) {
        $data = array();    
        $result = $stmt->get_result();
        while ($row = $result->fetch_assoc()) {

            $CaminhoAnexo = $row['CaminhoAnexo'];
            $NomeArquivo = $row['NomeArquivo'];     

            unlink($CaminhoAnexo.$NomeArquivo);

        }

        $sqls = "DELETE FROM gerDoctoContrato WHERE IdDocumento = ? AND IdContrato = ?";
        $stmts = $conn->prepare($sqls);
        $stmts->bind_param(
        'ii', 
        $_POST['IdDocumento'],
        $_POST['IdContrato']);
        $stmts->execute(); 
        $stmts->close();

        $aretorno["msg"] = "Registro exclu&iacute;do com sucesso.";
        $aretorno["par"] = $_POST["IdContrato"];

    } else {
        $aretorno["msg"] = "Ocorreu um erro na exclus&atilde;o dos dados: " . $stmt->error . ". Verifique.";
        $aretorno["status"] = "ERRO";
    }

} else {
    $aretorno["msg"] = "Ocorreu um erro na prepara&ccedil;&atilde;o dos dados: "  . $stmt->error . ". Verifique.";
    $aretorno["status"] = "ERRO";
}

}