";
echo "This means that " . ($rowcount1 * $percentSurvived1) . " will survive";
echo "";
$rowsurvived1 = ($rowcount1 * $percentSurvived1);
echo "The Integer is: " . (int)$rowsurvived1;
echo "";
echo "This means that we need to mark survived as 1 for " . (int)$rowsurvived1 . " passengers";
echo "";
echo "";
$rowcounter1 = 0;
while ($row1 = mysqli_fetch_array($result1, MYSQLI_ASSOC)) {
if ($rowcounter1 == (int)$rowsurvived1) {
break;
}
$id1 = $row1['PassengerId'];
mysqli_query($dbcon,"UPDATE test SET Survived='1' WHERE PassengerId=".$id1."");
$rowcounter1 = $rowcounter1 + 1;
}
echo $query1;
echo "";
$query1A = "select * from test where Pclass = '1' and Sex = 'male' and Age <= '18' ";
$result1A = mysqli_query($dbcon, $query1A) or die('error getting data');
$rowcount1A=mysqli_num_rows($result1A);
$passengerCount1A = $rowcount1A;
echo "There are: " . $rowcount1A . " Passengers";
echo "";
$query1B = "select * from test where Pclass = '1' and Survived = '1' and Sex = 'male' and Age <= '18' ";
$result1B = mysqli_query($dbcon, $query1B) or die('error getting data');
$rowcount1B=mysqli_num_rows($result1B);
$survivedCount1B = $rowcount1B;
echo $rowcount1B . "Survived";
echo "";
echo "This is a percentage of: " . ($survivedCount1B / $passengerCount1A);
echo "
";
// First Class Male > 18 <= 65
$query1 = "select * from test where Pclass = '1' and Sex = 'male' and Age > '18' and Age <= '65' ";
$percentSurvived1 = 0.380435;
$result1 = mysqli_query($dbcon, $query1) or die('error getting data');
$rowcount1=mysqli_num_rows($result1);
echo "There are: " . $rowcount1 . " Passengers";
echo "";
echo "This means that " . ($rowcount1 * $percentSurvived1) . " will survive";
echo "";
$rowsurvived1 = ($rowcount1 * $percentSurvived1);
echo "The Integer is: " . (int)$rowsurvived1;
echo "";
echo "This means that we need to mark survived as 1 for " . (int)$rowsurvived1 . " passengers";
echo "";
echo "";
$rowcounter1 = 0;
while ($row1 = mysqli_fetch_array($result1, MYSQLI_ASSOC)) {
if ($rowcounter1 == (int)$rowsurvived1) {
break;
}
$id1 = $row1['PassengerId'];
mysqli_query($dbcon,"UPDATE test SET Survived='1' WHERE PassengerId=".$id1."");
$rowcounter1 = $rowcounter1 + 1;
}
echo $query1;
echo "";
$query1A = "select * from test where Pclass = '1' and Sex = 'male' and Age > '18' and Age <= '65' ";
$result1A = mysqli_query($dbcon, $query1A) or die('error getting data');
$rowcount1A=mysqli_num_rows($result1A);
$passengerCount1A = $rowcount1A;
echo "There are: " . $rowcount1A . " Passengers";
echo "";
$query1B = "select * from test where Pclass = '1' and Survived = '1' and Sex = 'male' and Age > '18' and Age <= '65' ";
$result1B = mysqli_query($dbcon, $query1B) or die('error getting data');
$rowcount1B=mysqli_num_rows($result1B);
$survivedCount1B = $rowcount1B;
echo $rowcount1B . "Survived";
echo "";
echo "This is a percentage of: " . ($survivedCount1B / $passengerCount1A);
echo "
";
// First Class Male > 65
$query1 = "select * from test where Pclass = '1' and Sex = 'male' and Age > '65' ";
$percentSurvived1 = 0.25;
$result1 = mysqli_query($dbcon, $query1) or die('error getting data');
$rowcount1=mysqli_num_rows($result1);
echo "There are: " . $rowcount1 . " Passengers";
echo "";
echo "This means that " . ($rowcount1 * $percentSurvived1) . " will survive";
echo "";
$rowsurvived1 = ($rowcount1 * $percentSurvived1);
echo "The Integer is: " . (int)$rowsurvived1;
echo "";
echo "This means that we need to mark survived as 1 for " . (int)$rowsurvived1 . " passengers";
echo "";
echo "";
$rowcounter1 = 0;
while ($row1 = mysqli_fetch_array($result1, MYSQLI_ASSOC)) {
if ($rowcounter1 == (int)$rowsurvived1) {
break;
}
$id1 = $row1['PassengerId'];
mysqli_query($dbcon,"UPDATE test SET Survived='1' WHERE PassengerId=".$id1."");
$rowcounter1 = $rowcounter1 + 1;
}
echo $query1;
echo "";
$query1A = "select * from test where Pclass = '1' and Sex = 'male' and Age > '65' ";
$result1A = mysqli_query($dbcon, $query1A) or die('error getting data');
$rowcount1A=mysqli_num_rows($result1A);
$passengerCount1A = $rowcount1A;
echo "There are: " . $rowcount1A . " Passengers";
echo "";
$query1B = "select * from test where Pclass = '1' and Survived = '1' and Sex = 'male' and Age > '65' ";
$result1B = mysqli_query($dbcon, $query1B) or die('error getting data');
$rowcount1B=mysqli_num_rows($result1B);
$survivedCount1B = $rowcount1B;
echo $rowcount1B . "Survived";
echo "";
echo "This is a percentage of: " . ($survivedCount1B / $passengerCount1A);
echo "
";
//Second Class Male < = 18
$query1 = "select * from test where Pclass = '2' and Sex = 'male' and Age <= '18' ";
$percentSurvived1 = 0.6;
$result1 = mysqli_query($dbcon, $query1) or die('error getting data');
$rowcount1=mysqli_num_rows($result1);
echo "There are: " . $rowcount1 . " Passengers";
echo "";
echo "This means that " . ($rowcount1 * $percentSurvived1) . " will survive";
echo "";
$rowsurvived1 = ($rowcount1 * $percentSurvived1);
echo "The Integer is: " . (int)$rowsurvived1;
echo "";
echo "This means that we need to mark survived as 1 for " . (int)$rowsurvived1 . " passengers";
echo "";
echo "";
$rowcounter1 = 0;
while ($row1 = mysqli_fetch_array($result1, MYSQLI_ASSOC)) {
if ($rowcounter1 == (int)$rowsurvived1) {
break;
}
$id1 = $row1['PassengerId'];
mysqli_query($dbcon,"UPDATE test SET Survived='1' WHERE PassengerId=".$id1."");
$rowcounter1 = $rowcounter1 + 1;
}
echo $query1;
echo "";
$query1A = "select * from test where Pclass = '2' and Sex = 'male' and Age <= '18' ";
$result1A = mysqli_query($dbcon, $query1A) or die('error getting data');
$rowcount1A=mysqli_num_rows($result1A);
$passengerCount1A = $rowcount1A;
echo "There are: " . $rowcount1A . " Passengers";
echo "";
$query1B = "select * from test where Pclass = '2' and Survived = '1' and Sex = 'male' and Age <= '18' ";
$result1B = mysqli_query($dbcon, $query1B) or die('error getting data');
$rowcount1B=mysqli_num_rows($result1B);
$survivedCount1B = $rowcount1B;
echo $rowcount1B . "Survived";
echo "";
echo "This is a percentage of: " . ($survivedCount1B / $passengerCount1A);
echo "
";
// Second Class Male > 18 <= 65
$query1 = "select * from test where Pclass = '2' and Sex = 'male' and Age > '18' and Age <= '65' ";
$percentSurvived1 = 0.073171;
$result1 = mysqli_query($dbcon, $query1) or die('error getting data');
$rowcount1=mysqli_num_rows($result1);
echo "There are: " . $rowcount1 . " Passengers";
echo "";
echo "This means that " . ($rowcount1 * $percentSurvived1) . " will survive";
echo "";
$rowsurvived1 = ($rowcount1 * $percentSurvived1);
echo "The Integer is: " . (int)$rowsurvived1;
echo "";
echo "This means that we need to mark survived as 1 for " . (int)$rowsurvived1 . " passengers";
echo "";
echo "";
$rowcounter1 = 0;
while ($row1 = mysqli_fetch_array($result1, MYSQLI_ASSOC)) {
if ($rowcounter1 == (int)$rowsurvived1) {
break;
}
$id1 = $row1['PassengerId'];
mysqli_query($dbcon,"UPDATE test SET Survived='1' WHERE PassengerId=".$id1."");
$rowcounter1 = $rowcounter1 + 1;
}
echo $query1;
echo "";
$query1A = "select * from test where Pclass = '2' and Sex = 'male' and Age > '18' and Age <= '65' ";
$result1A = mysqli_query($dbcon, $query1A) or die('error getting data');
$rowcount1A=mysqli_num_rows($result1A);
$passengerCount1A = $rowcount1A;
echo "There are: " . $rowcount1A . " Passengers";
echo "";
$query1B = "select * from test where Pclass = '2' and Survived = '1' and Sex = 'male' and Age > '18' and Age <= '65' ";
$result1B = mysqli_query($dbcon, $query1B) or die('error getting data');
$rowcount1B=mysqli_num_rows($result1B);
$survivedCount1B = $rowcount1B;
echo $rowcount1B . "Survived";
echo "";
echo "This is a percentage of: " . ($survivedCount1B / $passengerCount1A);
echo "
";
// Second Class Male > 65
$query1 = "select * from test where Pclass = '2' and Sex = 'male' and Age > '65' ";
$percentSurvived1 = 0.0;
$result1 = mysqli_query($dbcon, $query1) or die('error getting data');
$rowcount1=mysqli_num_rows($result1);
echo "There are: " . $rowcount1 . " Passengers";
echo "";
echo "This means that " . ($rowcount1 * $percentSurvived1) . " will survive";
echo "";
$rowsurvived1 = ($rowcount1 * $percentSurvived1);
echo "The Integer is: " . (int)$rowsurvived1;
echo "";
echo "This means that we need to mark survived as 1 for " . (int)$rowsurvived1 . " passengers";
echo "";
echo "";
$rowcounter1 = 0;
while ($row1 = mysqli_fetch_array($result1, MYSQLI_ASSOC)) {
if ($rowcounter1 == (int)$rowsurvived1) {
break;
}
$id1 = $row1['PassengerId'];
mysqli_query($dbcon,"UPDATE test SET Survived='1' WHERE PassengerId=".$id1."");
$rowcounter1 = $rowcounter1 + 1;
}
echo $query1;
echo "";
$query1A = "select * from test where Pclass = '2' and Sex = 'male' and Age > '65' ";
$result1A = mysqli_query($dbcon, $query1A) or die('error getting data');
$rowcount1A=mysqli_num_rows($result1A);
$passengerCount1A = $rowcount1A;
echo "There are: " . $rowcount1A . " Passengers";
echo "";
$query1B = "select * from test where Pclass = '2' and Survived = '1' and Sex = 'male' and Age > '65' ";
$result1B = mysqli_query($dbcon, $query1B) or die('error getting data');
$rowcount1B=mysqli_num_rows($result1B);
$survivedCount1B = $rowcount1B;
echo $rowcount1B . "Survived";
echo "";
echo "This is a percentage of: " . ($survivedCount1B / $passengerCount1A);
echo "
";
//Third Class Male < = 18
$query1 = "select * from test where Pclass = '3' and Sex = 'male' and Age <= '18' ";
$percentSurvived1 = 0.215686;
$result1 = mysqli_query($dbcon, $query1) or die('error getting data');
$rowcount1=mysqli_num_rows($result1);
echo "There are: " . $rowcount1 . " Passengers";
echo "";
echo "This means that " . ($rowcount1 * $percentSurvived1) . " will survive";
echo "";
$rowsurvived1 = ($rowcount1 * $percentSurvived1);
echo "The Integer is: " . (int)$rowsurvived1;
echo "";
echo "This means that we need to mark survived as 1 for " . (int)$rowsurvived1 . " passengers";
echo "";
echo "";
$rowcounter1 = 0;
while ($row1 = mysqli_fetch_array($result1, MYSQLI_ASSOC)) {
if ($rowcounter1 == (int)$rowsurvived1) {
break;
}
$id1 = $row1['PassengerId'];
mysqli_query($dbcon,"UPDATE test SET Survived='1' WHERE PassengerId=".$id1."");
$rowcounter1 = $rowcounter1 + 1;
}
echo $query1;
echo "";
$query1A = "select * from test where Pclass = '3' and Sex = 'male' and Age <= '18' ";
$result1A = mysqli_query($dbcon, $query1A) or die('error getting data');
$rowcount1A=mysqli_num_rows($result1A);
$passengerCount1A = $rowcount1A;
echo "There are: " . $rowcount1A . " Passengers";
echo "";
$query1B = "select * from test where Pclass = '3' and Survived = '1' and Sex = 'male' and Age <= '18' ";
$result1B = mysqli_query($dbcon, $query1B) or die('error getting data');
$rowcount1B=mysqli_num_rows($result1B);
$survivedCount1B = $rowcount1B;
echo $rowcount1B . "Survived";
echo "";
echo "This is a percentage of: " . ($survivedCount1B / $passengerCount1A);
echo "
";
// Third Class Male > 18 <= 65
$query1 = "select * from test where Pclass = '3' and Sex = 'male' and Age > '18' and Age <= '65' ";
$percentSurvived1 = 0.135;
$result1 = mysqli_query($dbcon, $query1) or die('error getting data');
$rowcount1=mysqli_num_rows($result1);
echo "There are: " . $rowcount1 . " Passengers";
echo "";
echo "This means that " . ($rowcount1 * $percentSurvived1) . " will survive";
echo "";
$rowsurvived1 = ($rowcount1 * $percentSurvived1);
echo "The Integer is: " . (int)$rowsurvived1;
echo "";
echo "This means that we need to mark survived as 1 for " . (int)$rowsurvived1 . " passengers";
echo "";
echo "";
$rowcounter1 = 0;
while ($row1 = mysqli_fetch_array($result1, MYSQLI_ASSOC)) {
if ($rowcounter1 == (int)$rowsurvived1) {
break;
}
$id1 = $row1['PassengerId'];
mysqli_query($dbcon,"UPDATE test SET Survived='1' WHERE PassengerId=".$id1."");
$rowcounter1 = $rowcounter1 + 1;
}
echo $query1;
echo "";
$query1A = "select * from test where Pclass = '3' and Sex = 'male' and Age > '18' and Age <= '65' ";
$result1A = mysqli_query($dbcon, $query1A) or die('error getting data');
$rowcount1A=mysqli_num_rows($result1A);
$passengerCount1A = $rowcount1A;
echo "There are: " . $rowcount1A . " Passengers";
echo "";
$query1B = "select * from test where Pclass = '3' and Survived = '1' and Sex = 'male' and Age > '18' and Age <= '65' ";
$result1B = mysqli_query($dbcon, $query1B) or die('error getting data');
$rowcount1B=mysqli_num_rows($result1B);
$survivedCount1B = $rowcount1B;
echo $rowcount1B . "Survived";
echo "";
echo "This is a percentage of: " . ($survivedCount1B / $passengerCount1A);
echo "
";
// Third Class Male > 65
$query1 = "select * from test where Pclass = '3' and Sex = 'male' and Age > '65' ";
$percentSurvived1 = 0.0;
$result1 = mysqli_query($dbcon, $query1) or die('error getting data');
$rowcount1=mysqli_num_rows($result1);
echo "There are: " . $rowcount1 . " Passengers";
echo "";
echo "This means that " . ($rowcount1 * $percentSurvived1) . " will survive";
echo "";
$rowsurvived1 = ($rowcount1 * $percentSurvived1);
echo "The Integer is: " . (int)$rowsurvived1;
echo "";
echo "This means that we need to mark survived as 1 for " . (int)$rowsurvived1 . " passengers";
echo "";
echo "";
$rowcounter1 = 0;
while ($row1 = mysqli_fetch_array($result1, MYSQLI_ASSOC)) {
if ($rowcounter1 == (int)$rowsurvived1) {
break;
}
$id1 = $row1['PassengerId'];
mysqli_query($dbcon,"UPDATE test SET Survived='1' WHERE PassengerId=".$id1."");
$rowcounter1 = $rowcounter1 + 1;
}
echo $query1;
echo "";
$query1A = "select * from test where Pclass = '3' and Sex = 'male' and Age > '65' ";
$result1A = mysqli_query($dbcon, $query1A) or die('error getting data');
$rowcount1A=mysqli_num_rows($result1A);
$passengerCount1A = $rowcount1A;
echo "There are: " . $rowcount1A . " Passengers";
echo "";
$query1B = "select * from test where Pclass = '3' and Survived = '1' and Sex = 'male' and Age > '65' ";
$result1B = mysqli_query($dbcon, $query1B) or die('error getting data');
$rowcount1B=mysqli_num_rows($result1B);
$survivedCount1B = $rowcount1B;
echo $rowcount1B . "Survived";
echo "";
echo "This is a percentage of: " . ($survivedCount1B / $passengerCount1A);
echo "
";
// First Class FeMale < = 18
$query1 = "select * from test where Pclass = '1' and Sex = 'female' and Age <= '18' ";
$percentSurvived1 = 0.909091;
$result1 = mysqli_query($dbcon, $query1) or die('error getting data');
$rowcount1=mysqli_num_rows($result1);
echo "There are: " . $rowcount1 . " Passengers";
echo "";
echo "This means that " . ($rowcount1 * $percentSurvived1) . " will survive";
echo "";
$rowsurvived1 = ($rowcount1 * $percentSurvived1);
echo "The Integer is: " . (int)$rowsurvived1;
echo "";
echo "This means that we need to mark survived as 1 for " . (int)$rowsurvived1 . " passengers";
echo "";
echo "";
$rowcounter1 = 0;
while ($row1 = mysqli_fetch_array($result1, MYSQLI_ASSOC)) {
if ($rowcounter1 == (int)$rowsurvived1) {
break;
}
$id1 = $row1['PassengerId'];
mysqli_query($dbcon,"UPDATE test SET Survived='1' WHERE PassengerId=".$id1."");
$rowcounter1 = $rowcounter1 + 1;
}
echo $query1;
echo "";
$query1A = "select * from test where Pclass = '1' and Sex = 'female' and Age <= '18' ";
$result1A = mysqli_query($dbcon, $query1A) or die('error getting data');
$rowcount1A=mysqli_num_rows($result1A);
$passengerCount1A = $rowcount1A;
echo "There are: " . $rowcount1A . " Passengers";
echo "";
$query1B = "select * from test where Pclass = '1' and Survived = '1' and Sex = 'female' and Age <= '18' ";
$result1B = mysqli_query($dbcon, $query1B) or die('error getting data');
$rowcount1B=mysqli_num_rows($result1B);
$survivedCount1B = $rowcount1B;
echo $rowcount1B . "Survived";
echo "";
echo "This is a percentage of: " . ($survivedCount1B / $passengerCount1A);
echo "
";
// First Class FeMale > 18 <= 65
$query1 = "select * from test where Pclass = '1' and Sex = 'female' and Age > '18' and Age <= '65' ";
$percentSurvived1 = 0.972973;
$result1 = mysqli_query($dbcon, $query1) or die('error getting data');
$rowcount1=mysqli_num_rows($result1);
echo "There are: " . $rowcount1 . " Passengers";
echo "";
echo "This means that " . ($rowcount1 * $percentSurvived1) . " will survive";
echo "";
$rowsurvived1 = ($rowcount1 * $percentSurvived1);
echo "The Integer is: " . (int)$rowsurvived1;
echo "";
echo "This means that we need to mark survived as 1 for " . (int)$rowsurvived1 . " passengers";
echo "";
echo "";
$rowcounter1 = 0;
while ($row1 = mysqli_fetch_array($result1, MYSQLI_ASSOC)) {
if ($rowcounter1 == (int)$rowsurvived1) {
break;
}
$id1 = $row1['PassengerId'];
mysqli_query($dbcon,"UPDATE test SET Survived='1' WHERE PassengerId=".$id1."");
$rowcounter1 = $rowcounter1 + 1;
}
echo $query1;
echo "";
$query1A = "select * from test where Pclass = '1' and Sex = 'female' and Age > '18' and Age <= '65' ";
$result1A = mysqli_query($dbcon, $query1A) or die('error getting data');
$rowcount1A=mysqli_num_rows($result1A);
$passengerCount1A = $rowcount1A;
echo "There are: " . $rowcount1A . " Passengers";
echo "";
$query1B = "select * from test where Pclass = '1' and Survived = '1' and Sex = 'female' and Age > '18' and Age <= '65' ";
$result1B = mysqli_query($dbcon, $query1B) or die('error getting data');
$rowcount1B=mysqli_num_rows($result1B);
$survivedCount1B = $rowcount1B;
echo $rowcount1B . "Survived";
echo "";
echo "This is a percentage of: " . ($survivedCount1B / $passengerCount1A);
echo "
";
// First Class FeMale > 65
$query1 = "select * from test where Pclass = '1' and Sex = 'female' and Age > '65' ";
$percentSurvived1 = 0.0;
$result1 = mysqli_query($dbcon, $query1) or die('error getting data');
$rowcount1=mysqli_num_rows($result1);
echo "There are: " . $rowcount1 . " Passengers";
echo "";
echo "This means that " . ($rowcount1 * $percentSurvived1) . " will survive";
echo "";
$rowsurvived1 = ($rowcount1 * $percentSurvived1);
echo "The Integer is: " . (int)$rowsurvived1;
echo "";
echo "This means that we need to mark survived as 1 for " . (int)$rowsurvived1 . " passengers";
echo "";
echo "";
$rowcounter1 = 0;
while ($row1 = mysqli_fetch_array($result1, MYSQLI_ASSOC)) {
if ($rowcounter1 == (int)$rowsurvived1) {
break;
}
$id1 = $row1['PassengerId'];
mysqli_query($dbcon,"UPDATE test SET Survived='1' WHERE PassengerId=".$id1."");
$rowcounter1 = $rowcounter1 + 1;
}
echo $query1;
echo "";
$query1A = "select * from test where Pclass = '1' and Sex = 'female' and Age > '65' ";
$result1A = mysqli_query($dbcon, $query1A) or die('error getting data');
$rowcount1A=mysqli_num_rows($result1A);
$passengerCount1A = $rowcount1A;
echo "There are: " . $rowcount1A . " Passengers";
echo "";
$query1B = "select * from test where Pclass = '1' and Survived = '1' and Sex = 'female' and Age > '65' ";
$result1B = mysqli_query($dbcon, $query1B) or die('error getting data');
$rowcount1B=mysqli_num_rows($result1B);
$survivedCount1B = $rowcount1B;
echo $rowcount1B . "Survived";
echo "";
echo "This is a percentage of: " . ($survivedCount1B / $passengerCount1A);
echo "
";
//Second Class FeMale < = 18
$query1 = "select * from test where Pclass = '2' and Sex = 'female' and Age <= '18' ";
$percentSurvived1 = 1.0;
$result1 = mysqli_query($dbcon, $query1) or die('error getting data');
$rowcount1=mysqli_num_rows($result1);
echo "There are: " . $rowcount1 . " Passengers";
echo "";
echo "This means that " . ($rowcount1 * $percentSurvived1) . " will survive";
echo "";
$rowsurvived1 = ($rowcount1 * $percentSurvived1);
echo "The Integer is: " . (int)$rowsurvived1;
echo "";
echo "This means that we need to mark survived as 1 for " . (int)$rowsurvived1 . " passengers";
echo "";
echo "";
$rowcounter1 = 0;
while ($row1 = mysqli_fetch_array($result1, MYSQLI_ASSOC)) {
if ($rowcounter1 == (int)$rowsurvived1) {
break;
}
$id1 = $row1['PassengerId'];
mysqli_query($dbcon,"UPDATE test SET Survived='1' WHERE PassengerId=".$id1."");
$rowcounter1 = $rowcounter1 + 1;
}
echo $query1;
echo "";
$query1A = "select * from test where Pclass = '2' and Sex = 'female' and Age <= '18' ";
$result1A = mysqli_query($dbcon, $query1A) or die('error getting data');
$rowcount1A=mysqli_num_rows($result1A);
$passengerCount1A = $rowcount1A;
echo "There are: " . $rowcount1A . " Passengers";
echo "";
$query1B = "select * from test where Pclass = '2' and Survived = '1' and Sex = 'female' and Age <= '18' ";
$result1B = mysqli_query($dbcon, $query1B) or die('error getting data');
$rowcount1B=mysqli_num_rows($result1B);
$survivedCount1B = $rowcount1B;
echo $rowcount1B . "Survived";
echo "";
echo "This is a percentage of: " . ($survivedCount1B / $passengerCount1A);
echo "
";
// Second Class FeMale > 18 <= 65
$query1 = "select * from test where Pclass = '2' and Sex = 'female' and Age > '18' and Age <= '65' ";
$percentSurvived1 = 0.9;
$result1 = mysqli_query($dbcon, $query1) or die('error getting data');
$rowcount1=mysqli_num_rows($result1);
echo "There are: " . $rowcount1 . " Passengers";
echo "";
echo "This means that " . ($rowcount1 * $percentSurvived1) . " will survive";
echo "";
$rowsurvived1 = ($rowcount1 * $percentSurvived1);
echo "The Integer is: " . (int)$rowsurvived1;
echo "";
echo "This means that we need to mark survived as 1 for " . (int)$rowsurvived1 . " passengers";
echo "";
echo "";
$rowcounter1 = 0;
while ($row1 = mysqli_fetch_array($result1, MYSQLI_ASSOC)) {
if ($rowcounter1 == (int)$rowsurvived1) {
break;
}
$id1 = $row1['PassengerId'];
mysqli_query($dbcon,"UPDATE test SET Survived='1' WHERE PassengerId=".$id1."");
$rowcounter1 = $rowcounter1 + 1;
}
echo $query1;
echo "";
$query1A = "select * from test where Pclass = '2' and Sex = 'female' and Age > '18' and Age <= '65' ";
$result1A = mysqli_query($dbcon, $query1A) or die('error getting data');
$rowcount1A=mysqli_num_rows($result1A);
$passengerCount1A = $rowcount1A;
echo "There are: " . $rowcount1A . " Passengers";
echo "";
$query1B = "select * from test where Pclass = '2' and Survived = '1' and Sex = 'female' and Age > '18' and Age <= '65' ";
$result1B = mysqli_query($dbcon, $query1B) or die('error getting data');
$rowcount1B=mysqli_num_rows($result1B);
$survivedCount1B = $rowcount1B;
echo $rowcount1B . "Survived";
echo "";
echo "This is a percentage of: " . ($survivedCount1B / $passengerCount1A);
echo "
";
// Second Class FeMale > 65
$query1 = "select * from test where Pclass = '2' and Sex = 'female' and Age > '65' ";
$percentSurvived1 = 0.0;
$result1 = mysqli_query($dbcon, $query1) or die('error getting data');
$rowcount1=mysqli_num_rows($result1);
echo "There are: " . $rowcount1 . " Passengers";
echo "";
echo "This means that " . ($rowcount1 * $percentSurvived1) . " will survive";
echo "";
$rowsurvived1 = ($rowcount1 * $percentSurvived1);
echo "The Integer is: " . (int)$rowsurvived1;
echo "";
echo "This means that we need to mark survived as 1 for " . (int)$rowsurvived1 . " passengers";
echo "";
echo "";
$rowcounter1 = 0;
while ($row1 = mysqli_fetch_array($result1, MYSQLI_ASSOC)) {
if ($rowcounter1 == (int)$rowsurvived1) {
break;
}
$id1 = $row1['PassengerId'];
mysqli_query($dbcon,"UPDATE test SET Survived='1' WHERE PassengerId=".$id1."");
$rowcounter1 = $rowcounter1 + 1;
}
echo $query1;
echo "";
$query1A = "select * from test where Pclass = '2' and Sex = 'female' and Age > '65' ";
$result1A = mysqli_query($dbcon, $query1A) or die('error getting data');
$rowcount1A=mysqli_num_rows($result1A);
$passengerCount1A = $rowcount1A;
echo "There are: " . $rowcount1A . " Passengers";
echo "";
$query1B = "select * from test where Pclass = '2' and Survived = '1' and Sex = 'female' and Age > '65' ";
$result1B = mysqli_query($dbcon, $query1B) or die('error getting data');
$rowcount1B=mysqli_num_rows($result1B);
$survivedCount1B = $rowcount1B;
echo $rowcount1B . "Survived";
echo "";
echo "This is a percentage of: " . ($survivedCount1B / $passengerCount1A);
echo "
";
//Third Class FeMale < = 18
$query1 = "select * from test where Pclass = '3' and Sex = 'female' and Age <= '18' ";
$percentSurvived1 = 0.511628;
$result1 = mysqli_query($dbcon, $query1) or die('error getting data');
$rowcount1=mysqli_num_rows($result1);
echo "There are: " . $rowcount1 . " Passengers";
echo "";
echo "This means that " . ($rowcount1 * $percentSurvived1) . " will survive";
echo "";
$rowsurvived1 = ($rowcount1 * $percentSurvived1);
echo "The Integer is: " . (int)$rowsurvived1;
echo "";
echo "This means that we need to mark survived as 1 for " . (int)$rowsurvived1 . " passengers";
echo "";
echo "";
$rowcounter1 = 0;
while ($row1 = mysqli_fetch_array($result1, MYSQLI_ASSOC)) {
if ($rowcounter1 == (int)$rowsurvived1) {
break;
}
$id1 = $row1['PassengerId'];
mysqli_query($dbcon,"UPDATE test SET Survived='1' WHERE PassengerId=".$id1."");
$rowcounter1 = $rowcounter1 + 1;
}
echo $query1;
echo "";
$query1A = "select * from test where Pclass = '3' and Sex = 'female' and Age <= '18' ";
$result1A = mysqli_query($dbcon, $query1A) or die('error getting data');
$rowcount1A=mysqli_num_rows($result1A);
$passengerCount1A = $rowcount1A;
echo "There are: " . $rowcount1A . " Passengers";
echo "";
$query1B = "select * from test where Pclass = '3' and Survived = '1' and Sex = 'female' and Age <= '18' ";
$result1B = mysqli_query($dbcon, $query1B) or die('error getting data');
$rowcount1B=mysqli_num_rows($result1B);
$survivedCount1B = $rowcount1B;
echo $rowcount1B . "Survived";
echo "";
echo "This is a percentage of: " . ($survivedCount1B / $passengerCount1A);
echo "
";
// Third Class FeMale > 18 <= 65
$query1 = "select * from test where Pclass = '3' and Sex = 'female' and Age > '18' and Age <= '65' ";
$percentSurvived1 = 0.423729;
$result1 = mysqli_query($dbcon, $query1) or die('error getting data');
$rowcount1=mysqli_num_rows($result1);
echo "There are: " . $rowcount1 . " Passengers";
echo "";
echo "This means that " . ($rowcount1 * $percentSurvived1) . " will survive";
echo "";
$rowsurvived1 = ($rowcount1 * $percentSurvived1);
echo "The Integer is: " . (int)$rowsurvived1;
echo "";
echo "This means that we need to mark survived as 1 for " . (int)$rowsurvived1 . " passengers";
echo "";
echo "";
$rowcounter1 = 0;
while ($row1 = mysqli_fetch_array($result1, MYSQLI_ASSOC)) {
if ($rowcounter1 == (int)$rowsurvived1) {
break;
}
$id1 = $row1['PassengerId'];
mysqli_query($dbcon,"UPDATE test SET Survived='1' WHERE PassengerId=".$id1."");
$rowcounter1 = $rowcounter1 + 1;
}
echo $query1;
echo "";
$query1A = "select * from test where Pclass = '3' and Sex = 'female' and Age > '18' and Age <= '65' ";
$result1A = mysqli_query($dbcon, $query1A) or die('error getting data');
$rowcount1A=mysqli_num_rows($result1A);
$passengerCount1A = $rowcount1A;
echo "There are: " . $rowcount1A . " Passengers";
echo "";
$query1B = "select * from test where Pclass = '3' and Survived = '1' and Sex = 'female' and Age > '18' and Age <= '65' ";
$result1B = mysqli_query($dbcon, $query1B) or die('error getting data');
$rowcount1B=mysqli_num_rows($result1B);
$survivedCount1B = $rowcount1B;
echo $rowcount1B . "Survived";
echo "";
echo "This is a percentage of: " . ($survivedCount1B / $passengerCount1A);
echo "
";
// Third Class FeMale > 65
$query1 = "select * from test where Pclass = '3' and Sex = 'female' and Age > '65' ";
$percentSurvived1 = 0.0;
$result1 = mysqli_query($dbcon, $query1) or die('error getting data');
$rowcount1=mysqli_num_rows($result1);
echo "There are: " . $rowcount1 . " Passengers";
echo "";
echo "This means that " . ($rowcount1 * $percentSurvived1) . " will survive";
echo "";
$rowsurvived1 = ($rowcount1 * $percentSurvived1);
echo "The Integer is: " . (int)$rowsurvived1;
echo "";
echo "This means that we need to mark survived as 1 for " . (int)$rowsurvived1 . " passengers";
echo "";
echo "";
$rowcounter1 = 0;
while ($row1 = mysqli_fetch_array($result1, MYSQLI_ASSOC)) {
if ($rowcounter1 == (int)$rowsurvived1) {
break;
}
$id1 = $row1['PassengerId'];
mysqli_query($dbcon,"UPDATE test SET Survived='1' WHERE PassengerId=".$id1."");
$rowcounter1 = $rowcounter1 + 1;
}
echo $query1;
echo "";
$query1A = "select * from test where Pclass = '3' and Sex = 'female' and Age > '65' ";
$result1A = mysqli_query($dbcon, $query1A) or die('error getting data');
$rowcount1A=mysqli_num_rows($result1A);
$passengerCount1A = $rowcount1A;
echo "There are: " . $rowcount1A . " Passengers";
echo "";
$query1B = "select * from test where Pclass = '3' and Survived = '1' and Sex = 'female' and Age > '65' ";
$result1B = mysqli_query($dbcon, $query1B) or die('error getting data');
$rowcount1B=mysqli_num_rows($result1B);
$survivedCount1B = $rowcount1B;
echo $rowcount1B . "Survived";
echo "";
echo "This is a percentage of: " . ($survivedCount1B / $passengerCount1A);
echo "
";
?>