Pessoal Boa Tarde ,Tudo certo?
Estou com um projeto para aprendizagem (já que só tenho conhecimentos de css e html) e upgrade da firma onde trabalho e não estou conseguindo salvar os valores do formulário no banco de dados,a conexão é feita porem salva todos os valores como null.
<?php
$servername = "192.168.1.109";
$database = "cadastrokm";
$username = "teste";
$password = "123456";
// Create connection
$conn = mysqli_connect($servername, $username, $password, $database);
// Check connection
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}
echo "Connected successfully";
$funcionarioKm = isset( $_POST['funcionarioKm']);
$veiculoKm = isset($_POST['veiculoKm']);
$kmInicial = isset($_POST['kmInicial']);
$kmFinal = isset($_POST['kmFinal']);
$sql = "INSERT INTO km (funcionarioKm,veiculoKm,kmInicial,kmFinal)
VALUES ('$funcionarioKm','$veiculoKm','$kmInicial',
'$kmFinal')";
if (mysqli_query($conn, $sql)) {
echo "New record created successfully";
} else {
echo "Error: " . $sql . "<br>" . mysqli_error($conn);
}
mysqli_close($conn);
?>
<!DOCTYPE html>
<html lang="pt-br">
<head>
<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.1.3/css/bootstrap.min.css" integrity="sha384-MCw98/SFnGE8fJT3GXwEOngsV7Zt27NXFoaoApmYm81iuXoPkFOJwJ8ERdknLPMO" crossorigin="anonymous">
<script src="https://code.jquery.com/jquery-3.3.1.slim.min.js" integrity="sha384-q8i/X+965DzO0rT7abK41JStQIAqVgRVzpbzo5smXKp4YfRvH+8abtTE1Pi6jizo" crossorigin="anonymous"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.14.3/umd/popper.min.js" integrity="sha384-ZMP7rVo3mIykV+2+9J3UJ46jBk0WLaUAdn689aCwoqbBJiSnjAK/l8WvCWPIPm49" crossorigin="anonymous"></script>
<script src="https://stackpath.bootstrapcdn.com/bootstrap/4.1.3/js/bootstrap.min.js" integrity="sha384-ChfqqxuZUCnJSK3+MXmPNIyE6ZbWh2IMqE241rYiqJxyMiZ6OW/JmZQ5stwEULTy" crossorigin="anonymous"></script>
</head>
<body>
<div class=container>
<section>
<!-- Página de Cadastro de KM -->
<h1>Cadastro de Km</h1>
<hr><br><br>
<form method="post" action="conexao.php">
<p class="font-weight-bold">Favor Selecione seu Nome:</p>
<select id="funcionarioKm" name="funcionarioKm"required autofocus>
<option>Motorista</option>
<option>Almir</option>
<option>Maykon</option>
<option>Jorge</option>
</select>
</br></br>
<p class="font-weight-bold">Favor Selecione o Veiculo:</p>
<select id="veiculoKm" value="veiculoKm " name="veiculoKm"required>
<option>Veiculo</option>
<option>L200</option>
<option>Strada 01</option>
<option>Strada 02</option>
<option>Caminhão 01</option>
</select>
</br></br>
<label for="litros"><p class="font-weight-bold">Informe a Quilometragem Inicial:</p></label>
<input type="number" id="kmInicial" name="kmInicial" required/>
</br></br>
<label for="litros"><p class="font-weight-bold">Informe a Quilometragem Final:</p></label>
<input type="number" id="kmFinal" name="kmFinal" required />
</br></br>
<input type="submit" value="Salvar" class="btn btn-primary btn-md">
<input type="reset" value="Limpar"class="btn btn-primary btn-md" >
<br><br>
</form>
</section>
</div>
</body>
</html>