メモ
データベースを接続して、データをアップロードする．
cmd：
cd /Applications/MAMP/Library/bin/
./mysql -u root -proot
コード：
すでにデータベースとテーブルを作成してから、データをアップロードするだけ
<!DOCTYPE html>
<head>
<title>Count Fat</title>
<h1> Count Fat</h1>
</head>
<hr />
<body>
<?php
$id = $gender = $height = $weight = $bmi = "";
function text_input($data){
$data = trim($data);
$data = stripslashes($data);
$data = htmlspecialchars($data);
return $data;
}
function getSimpleValue($post_name, &$value){
if(!empty($_POST[$post_name])){
$value = text_input($_POST[$post_name]);
}
else{
$value = "Null!";
}
}
getSimpleValue("ID", $id);
getSimpleValue("Height", $height);
getSimpleValue("Weight", $weight);
getSimpleValue("Gender", $gender);
?>
<form action = "<?php echo htmlspecialchars($_SERVER["PHP_SELF"])?>" method = "POST">
ID: <input type = "text" name = "ID"><br>
Height: <input type = "text" name = "Height">CM<br>
Weight: <input type = "text" name = "Weight">KG<br>
Gender:
Female<input type = "radio" name = "Gender" value = "Female">
Male<input type = "radio" name = "Gender" value = "Male"><br>
<input type = "submit" value = "Submit"><br>
</form>
<hr />
<?php
$bmif = function($w, $h){
$h /= 100;
return $w / ($h * $h);
};
$server = "localhost";
$user = "root";
$pw = "root";
$dbname = "myDBPDO";
$bmi = $bmif($weight, $height);
try {
$conn = new PDO("mysql:host = $server;dbname=$dbname", $user, $pw);
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$gender = "\"".$gender."\"";
$sql =<<<EOL
INSERT INTO Diet
(id, gender, height, weight, bmi)
VALUES
($id, $gender, $height, $weight, $bmi)
EOL;
$conn->exec($sql);
echo "</ hr>". "Your data uploaded.";
}
catch(PDOException $e){
echo $sql . "<br>" . $e->getMessage();
}
$conn = null;
echo "ID:" . $id . "<br>";
echo "Height:" . $height . "<br>";
echo "Weight:" . $weight . "<br>";
echo "Gender:" . $gender . "<br>";
echo "BMI" . $bmi . "<br>";
?>
</body>
</html>