I got a PHP file that processes a Post form, and sometimes it insert data correctly, and sometimes no data is inserted. I was trying different navigators and devices, and I still don’t understand what could be happening.
I show you my code:
include('procesar_database.php');
$nowDate = str_replace(" ", "", date('m/d/Y h:i:s a', time()));
$nowDate2 = preg_replace('/[^0-9]/', '', $nowDate);
$producto = '';
$origen = '';
$localizacion = '';
$humedad = 0.0;
$calidad = '';
$peso = 0;
$pacas = 0;
$fotomonton = '';
$fotomuestra = '';
$existsMonton = false;
$existsMuestra = false;
if (isset($_POST['producto'])){
$producto = strval($_POST['producto']);
}
if (isset($_POST['origen'])){
$origen = strval($_POST['origen']);
}
if (isset($_POST['localizacion'])){
$localizacion = strval($_POST['localizacion']);
}
if (isset($_POST['humedad'])){
$humedad = floatval($_POST['humedad']);
}
if (isset($_POST['calidad'])){
$calidad = strval($_POST['calidad']);
}
if (isset($_POST['peso'])){
$peso = intval($_POST['peso']);
}
if (isset($_POST['pacas'])){
$pacas = intval($_POST['pacas']);
}
if (ISSET($_FILES)){
if (isset($_FILES['foto_monton'])){
$fotomonton = $_FILES['foto_monton'];
$existsMonton = true;
}
if (isset($_FILES['foto_muestra'])){
$fotomuestra = $_FILES['foto_muestra'];
$existsMuestra = true;
}
}
if (isset($_POST['fotomonton']) && (empty($fotomonton))){
$fotomonton = $_POST['fotomonton'];
$existsMonton = true;
}
if (isset($_POST['fotomuestra']) && (empty($fotomuestra))){
$fotomuestra = $_POST['fotomuestra'];
$existsMuestra = true;
}
$ext_muestra = 'jpeg';
if (ISSET($_POST['extension_muestra'])){
$ext_muestra = strval($_POST['extension_muestra']);
}
$ext_monton = 'jpeg';
if (ISSET($_POST['extension_monton'])){
$ext_monton = strval($_POST['extension_monton']);
}
$uniquecode = uniqid();
if (ISSET($_POST['uniqueid'])){
$uniquecode = strval($_POST['uniqueid']);
}
$pesoTotal = 0;
if ($pacas != null || $pacas > 0){
$pesoTotal = intval($peso) * intval($pacas);
} else {
$pesoTotal = intval($peso);
$pacas = 1;
}
$urlfinal_monton = getURLMonton($fotomonton);
$urlfinal_muestra = getURLMuestra($fotomuestra);
$fecha = date('Y-m-d H:i:s');
$query = "INSERT INTO [dbo].[075_EntradasFabrica] (Producto, Origen, Localizacion, Humedad, PesoTotal, PesoPacas, NumeroPacas, Calidad, FotoMuestra, FotoMonton, IdCierre, createdAt) VALUES ('$producto','$origen', '$localizacion', '$humedad', '$pesoTotal', '$peso', '$pacas', '$calidad', '$urlfinal_muestra', '$urlfinal_monton', NULL, '$fecha')";
echo '<br />'.$query;
if (odbc_exec($connection, $query)){
echo 'Datos incluídos en la base de datos correctamente.<br />';
} else {
echo 'ERROR: Could not able to execute $query';
}
Then, I got this on database:
And I recieve this on test data:
I receive data sometimes, and other time don’t. What could it be?
I have tried bulk data insert, one by one, not parallel tests, on mobile and desktop, on Chrome, Firefox, Brave, Mi Navigator from Android and Edge. Still don’t understand.