Do not save data with Mysql

Question

Good people, I have the following complication, each patient has a so-called "PII" and this same "PII" has several data. The problem is when filling the PII by clicking write it simply wipes me all data instead of storing in the database.

The initial snippet of php connecting to Mysql:

    <?php
session_start();
error_reporting(0);
include('includes/config.php');
if(strlen($_SESSION['alogin'])==0)
    {   
header('location:index.php');
}
else{
if(isset($_POST['add']))
{
$avinicial=$_POST['AvInicial'];
$meta=$_POST['Meta'];
$avintercalar=$_POST['AvIntercalar'];
$avfinal=$_POST['AvFinal'];
$datainicio=$_POST['DataInicio'];
$datafim=$_POST['DataFim'];
$resultadouni=$_POST['ResultadoUni'];
$avalexp=$_POST['AvalExpec'];
$concretizaobj=$_POST['ConcretizaObj'];
$objdefinidos=$_POST['ObjDefinidos'];
$objatingidos=$_POST['ObjAtingidos'];
$totalalcancados=$_POST['TotalAlcancados'];
$sql = "INSERT INTO tblobjetivos(AvInicial, Meta, AvIntercalar, AvFinal, DataInicio, DataFim, ResultadoUni, AvalExpec, ConcretizaObj, ObjDefinidos, ObjAtingidos, TotalAlcancados) VALUES(:avinicial, :meta, :avintercalar, :avfinal, :datainicio, :datafim, :resultadouni, :avalexp, :concretizaobj, :objdefinidos, :objatingidos, :totalalcancados)";
$query = $dbh->prepare($sql);
$query->bindParam(':avinicial', $avinicial, PDO::PARAM_STR);
$query->bindParam(':meta', $meta, PDO::PARAM_STR);
$query->bindParam(':avintercalar', $avintercalar, PDO::PARAM_STR);
$query->bindParam(':avfinal', $avfinal, PDO::PARAM_STR);
$query->bindParam(':datainicio', $datainicio, PDO::PARAM_STR);
$query->bindParam(':datafim', $datafim, PDO::PARAM_STR);
$query->bindParam(':resultadouni', $resultadouni, PDO::PARAM_STR);
$query->bindParam(':avalexp', $avalexp, PDO::PARAM_STR);
$query->bindParam(':concretizaobj', $concretizaobj, PDO::PARAM_STR);
$query->bindParam(':objdefinidos', $objdefinidos, PDO::PARAM_STR);
$query->bindParam(':objatingidos', $objatingidos, PDO::PARAM_STR);
$query->bindParam(':totalalcancados', $totalalcancados, PDO::PARAM_STR);
$lastInsertId = $dbh->lastInsertId();
$query->execute();

    if ($lastInsertId) {
        $msg = "PII Adicionado com Sucesso";
    } else {
        $error = "Confirme se preencheu tudo corretamente!";
    }
}?>

Answer 1

Not a solution but a hint: in the connection file (probably /include/config.php), set the PDO to trigger exceptions. These exceptions will include important information, such as why the data is not being persisted in the database. For example, if in the database a column is NOT NULL and you are trying to add a null value, it will trigger an exception with the message.

http://php.net/manual/en/pdo.error-handling.php

<?php
$dsn = 'mysql:dbname=testdb;host=127.0.0.1';
$user = 'dbuser';
$password = 'dbpass';

try {
    $dbh = new PDO($dsn, $user, $password);
    $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch (PDOException $e) {
    echo 'Connection failed: ' . $e->getMessage();
}

?>

I hope I’ve helped.