Doe ik dit als code:
<?php
// set database server access variables:
$host = "localhost";
$user = "";
$pass = "";
$db = "voetbal";
// open connection
$con=mysqli_connect($host, $user, $pass) or die ("Unable to connect!");
// select database
mysqli_select_db($con, 'voetbal') or die ("Unable to select database!");
// create query
$ClubCheck = mysqli_query($con, "SELECT club from users WHERE id = '$id'");
$ClubCheck2 = mysqli_query($con, "SELECT leeftijd from users WHERE id = '$id'");
$ClubCheck3 = mysqli_query($con, "SELECT positie from clubs WHERE user_id = '$id'");
$ClubCheck4 = mysqli_query($con, "SELECT clubthuisgoals, clubuitgoals from wedstrijden WHERE user_id = '$id'");
if ($ClubCheck2 > "1") {
echo "<div class='progress'>
<div class='progress-bar' role='progressbar' aria-valuenow='60' aria-valuemin='0' aria-valuemax='100' style='width:3%';>
3%</div></div>";
}
elseif ($ClubCheck2 > "1" && $ClubCheck3 > "1") {
echo "<div class='progress'>
<div class='progress-bar' role='progressbar' aria-valuenow='60' aria-valuemin='0' aria-valuemax='100' style='width:6%';>
6%</div></div>";
};?>
dan weergeeft hij alleen "3%".
Doe ik dit:
<?php
// set database server access variables:
$host = "localhost";
$user = "";
$pass = "";
$db = "voetbal";
// open connection
$con=mysqli_connect($host, $user, $pass) or die ("Unable to connect!");
// select database
mysqli_select_db($con, 'voetbal') or die ("Unable to select database!");
// create query
$ClubCheck = mysqli_query($con, "SELECT club from users WHERE id = '$id'");
$ClubCheck2 = mysqli_query($con, "SELECT leeftijd from users WHERE id = '$id'");
$ClubCheck3 = mysqli_query($con, "SELECT positie from clubs WHERE user_id = '$id'");
$ClubCheck4 = mysqli_query($con, "SELECT clubthuisgoals, clubuitgoals from wedstrijden WHERE user_id = '$id'");
if ($ClubCheck2 > "1") {
echo "<div class='progress'>
<div class='progress-bar' role='progressbar' aria-valuenow='60' aria-valuemin='0' aria-valuemax='100' style='width:3%';>
3%</div></div>";
}
if ($ClubCheck2 > "1" && $ClubCheck3 > "1") {
echo "<div class='progress'>
<div class='progress-bar' role='progressbar' aria-valuenow='60' aria-valuemin='0' aria-valuemax='100' style='width:6%';>
6%</div></div>";
};?>
Dan weergeeft hij 3% en 6% onder elkaar.
Waarom werkt bij mij in de eerste code de elseif niet?