ved opstart indsættes null værdier i Databasen?
Kode: Vælg alt
<?php
error_reporting(1);
$dato = $_POST['dato'];
$vejer = $_POST['weight'];
$bmi = $_POST['bmi'];
$fedt= $_POST['fedt'];
$muskel= $_POST['muskel'];
$vand= $_POST['vand'];
$klik = $_POST['Gem'];
$mysqli = new mysqli('localhost','root', '', 'weightdatadb');
if($mysqli->connect_errno){
echo $mysqli->connect_error,"<br>";
die('Sorry, we having some problems.');
}
else {
echo "Tilsluttet:";
$query = "INSERT INTO `weight_data` (`Dato`, `Weight`, `BMI`, `Fedt`, `Muskel`, `Vand`)"
. " VALUES('$dato', '$vejer', '$bmi', '$fedt', '$muskel', '$vand')";
$statement = $mysqli->prepare($query);
$statement->bind_param('sddddd', $dato, $vejer, $bmi, $fedt, $muskel, $vand);
if($statement->execute()){
print 'Success! ID of last inserted record is : ' .$statement->insert_id .'<br />';
}else{
die('Error : ('. $mysqli->errno .') '. $mysqli->error);
}
$statement->close();
}
?>
<html>
<head>
<meta charset="UTF-8">
<title> Weight Data</title>
</head>
<style>
body{
background: #242424;
font-family: Arial;
color: #eee;
}
fieldset{
position: absolute;
top: 10%;
left: 50%;
margin-left: -150px;
background: #494949;
width: 300px;
border-radius: 5px;
box-shadow: 2px 1px 5px #080808;
}
legend{
color: #969696;
}
label{
float: left;
width: 120px;
}
input{
border-radius: 2px;
}
input[type="submit"]{
float: right;
}
</style>
<body>
<form action="index.php" method="post">
<fieldset>
<legend>Input</legend>
<div>
<label for="date">Dato</label>
<input type="date" name="dato">
<label for="weight">Vægt</label>
<input type="text" name="weight">
<label for="bmi">Bmi</label>
<input type="text" name="bmi">
<label for="fedt">Fedt %</label>
<input type="text" name="fedt">
<label for="muskel">Muskelmasse</label>
<input type="text"name="muskel">
<label for="vand">vand %</label>
<input type="text"name="vand">
<input type="submit" value="Gem">
</div>
</fieldset>
</form>
</body>
</html>
