updatecode.php

<?php

include('conn.php');

if (isset($_POST['updatedata'])) {
    $var_summons_number= $_POST['update_summons'];

    $var_issuer_code = $_POST['issuer_code'];
    $var_issuing_agency = $_POST['issuing_agency'];
    $var_issuer_precinct = $_POST['issuer_precinct'];
    $var_issuer_command = $_POST['issuer_command'];
    $var_issuer_squad = $_POST['issuer_squad'];

    $query = "UPDATE issuer SET issuer_code = '$var_issuer_code', issuing_agency = '$var_issuing_agency', 
                issuer_precinct = '$var_issuer_precinct', issuer_command = '$var_issuer_command', issuer_squad = '$var_issuer_squad' 
                WHERE summons_number = '$var_summons_number' ";
    try
    {
        $prepared_stmt = $dbo->prepare($query);
        $prepared_stmt->bindValue(':summons_number', $var_summons_number, PDO::PARAM_INT);
        $prepared_stmt->bindValue(':issuer_code', $var_issuer_code, PDO::PARAM_STR);
        $prepared_stmt->bindValue(':issuing_agency', $var_issuing_agency, PDO::PARAM_STR);
        $prepared_stmt->bindValue(':issuer_precinct', $var_issuer_precinct, PDO::PARAM_INT);
        $prepared_stmt->bindValue(':issuer_command', $var_issuer_command, PDO::PARAM_STR);
        $prepared_stmt->bindValue(':issuer_squad', $var_issuer_squad, PDO::PARAM_STR);
        $result = $prepared_stmt->execute();
        echo '<script> alert ("Data Saved"); <script>';
        header('Location: issuer.php');
 
    }
    catch (PDOException $ex)
    { // Error in database processing.
        echo $sql . "<br>" . $error->getMessage(); // HTTP 500 - Internal Server Error
    }
}