query('SELECT MAX(POS) AS POS FROM VEHICULOS_NOTAS')->fetch_array();
$p = $pos['POS'] + 1;
$Schema->executeQuery('INSERT INTO VEHICULOS_NOTAS(CLAVE, POS, FECHA, USUARIO, NOTA) VALUES(?, ?, ?, ?, ?)', 'iisss', [$_SESSION['CODIGO_COCHE'], $p, date('Y-m-d H:i:s'), $usuarioSession, $nota]);
}
$res = $Schema->executeQuery('SELECT * FROM VEHICULOS_NOTAS WHERE CLAVE = ? AND CODIGO_TAS = ? ORDER BY POS DESC', 'is', [$_SESSION['CODIGO_COCHE'], FALSE]);
if($res->num_rows) {
while($row = $res->fetch_array()) {
$html .= '';
$html .= '| ';
if($usuarioSession == $row['USUARIO']) {
$html .= '';
} else {
$html .= '';
}
$html .= ' | ';
$html .= '' . date('d/m/Y', strtotime($row['FECHA'])) . ' | ';
$html .= '' . $row['USUARIO'] . ' | ';
$notas = str_ireplace($breaks, "
", $row['NOTA']);
$html .= '' . $notas . ' | ';
$html .= '
';
}
} else {
$html .= '| ' . $sin_resultados_lg . ' |
';
}
echo $html;
?>