I have written the code to connect the database in the following form
<html>
<body>
<?php
$conn=new mysqli('localhost','root','');
if($conn->connect_error){
die("connection failed" .$conn->connect_error);
}
echo "DB connected successfully";
mysqli_select_db($conn,"namesql_db");
echo "
DB is selected as Test successfully";
$sql="INSERT INTO namesql_table(age,fwaist) VALUES('$_POST[age]','$_POST[fwaist]')";
if($conn->query($sql)===TRUE){
echo "New record created successfully";
} else {
echo "Error:" .$sql."<br>" .$conn->error;
}
mysqli_close($conn);
?>
</body>
</html>
And i have written the code for age and waist like:
</head>
<body bgcolor="lightyellow" text="black" style="font-size:18pt; font-family:Garamond"><center>
<h2>DIABETES RISK SCORE SYSTEM</h2></center>
<form action="insert.php" method="post">
<label for="age">Enter your Age: </label>
<select name="age">
<option value="">--select the age--</option>
<option value="21-34">21-34</option>
<option value="35-49">35-49</option>
<option value="50-80">50-80</option>
</select>
<p></p>
<script>
var select = document.querySelector('select');
var para = document.querySelector('p');
select.onchange = setage;
function setage() {
var choice = select.value;
if(choice === "21-34") {
para.textContent = 'The score is 0';
} else if(choice === "35-49") {
para.textContent = 'The score is 22';
} else if(choice === "50-80") {
para.textContent = 'The score is 34';
} else {
para.textContent = '';
}
}
</script>
<br/><br/><img src="age1.jpg" align="right" width="300" height="300">
<input type="submit"/>
</form>
<a href="Gender.php" class="btn">BACK</a>
<a href="waist.php" class="btn">NEXT</a>
while developing the UI using this code am getting the score.For example if i click the age 21-34 am getting the score as 0.But in database am getting only the category as 21-34 am not getting score..Can anybody tell me ...
Thanks in advance