<?php
  $con = mysqli_connect("localhost", "root", "", "bazaphp");
?>

<?php
  function makeOption($val) {
    echo "<option>" . $val . "</option>";
  }
?>

<?php
  function makeForm($conf) {
    $sql = "SELECT DISTINCT age FROM users ORDER BY age";
    $result = mysqli_query($conf, $sql);

    echo "choose age";
    echo "<form method='post' action='form.php'>";
      echo "<select name='opcja'>";
        while ( $row = mysqli_fetch_assoc($result) ) {
          makeOption($row['age']);
        }
      echo "</select>";
      echo "<input type='submit' name='showAge'>";
    echo "</form>";

  }
?>

<?php
  function makeFormGender($conf) {
    $sql = "SELECT DISTINCT gender FROM users";
    $result = mysqli_query($conf, $sql);

    echo "choose gender";
    echo "<form method='post' action='form.php'>";
      echo "<select name='opcja'>";
        while ( $row = mysqli_fetch_assoc($result) ) {
          makeOption($row['gender']);
        }
      echo "</select>";
      echo "<input type='submit' name='showGen'>";
    echo "</form>";

  }
?>

<?php
  makeForm($con);
  makeFormGender($con);
?>

<?php

  function orderById() {
    $sql = "SELECT * FROM users ORDER BY id";
    return $sql;
  }

  function orderByFirstname() {
    $sql = "SELECT * FROM users ORDER BY firstname";
    return $sql;
  }

  function orderByLastname() {
    $sql = "SELECT * FROM users ORDER BY lastname";
    return $sql;
  }

  function orderByAge() {
    $sql = "SELECT * FROM users ORDER BY age";
    return $sql;
  }

  function orderByGender() {
    $sql = "SELECT * FROM users ORDER BY gender";
    return $sql;
  }

?>

<table>

  <tr>
    <th><a href="form.php?temp=<?php echo 1 ?>">id</a></th>
    <th><a href="form.php?temp=<?php echo 2 ?>">firstname</a></th>
    <th><a href="form.php?temp=<?php echo 3 ?>">lastname</a></th>
    <th><a href="form.php?temp=<?php echo 4 ?>">age</a></th>
    <th><a href="form.php?temp=<?php echo 5 ?>">gender</a></th>
  </tr>

  <?php
    if ( $_GET['temp'] == 1 ) {
      $sql = orderById();
    }
    if ( $_GET['temp'] == 2 ) {
      $sql = orderByFirstname();
    }
    if ( $_GET['temp'] == 3 ) {
      $sql = orderByLastname();
    }
    if ( $_GET['temp'] == 4 ) {
      $sql = orderByAge();
    }
    if ( $_GET['temp'] == 5 ) {
      $sql = orderByGender();
    }
    if ( $_GET['temp'] == NULL ) {
      $sql = "SELECT * FROM users";
    }

    if ( isset($_GET['edit']) ) {
      $sql = "SELECT * FROM users WHERE id='{$_GET['edit']}'";

      $result = mysqli_query($con, $sql);
      while ( $row = mysqli_fetch_assoc($result) ) : ?>

      <form action="" method="post">
        firstname <input type="text" name="fname">
        firstname <input type="text" name="fname">
        firstname <input type="text" name="fname">
        firstname <input type="text" name="fname">
        firstname <input type="text" name="fname">
      </form>

</table>

<?php

/*
 *
 *
 *
 *
 * if(isset($_GET['edit'])) {
 * $sql="SELECT * from user_sch where id='{$_GET['edit']}'";

  $result=mysqli_query($con,$sql);
  while($row = mysqli_fetch_assoc($result))
  {


 ?>

<form action="" method="post">

imie<input type="text" name="first_na" placeholder="<?php echo $row['firstname'] ?>">
nazwisko<input type="text" name="last_na" placeholder="<?php echo $row['lastname'] ?>">
wiek <input type="text" name="age" placeholder="<?php echo $row['age'] ?>">
<select name="gender">
    <option value="M">M</option>
    <option value="F">F</option>
    </select>
<input type="submit" name="send"/>
</form>

<?php
}
}
if($_POST['wys_age'])
{
    $temp=$_POST['opcja'];

    $sql="SELECT * from user_sch WHERE age = $temp";


}
if($_POST['wys_gen'])
{
    $temp=$_POST['opcja'];


    $sql="SELECT * from user_sch WHERE gender = '$temp'";
    //echo $sql;

}
if($_POST['send'])
{

    $name=$_POST['first_na'];
    $lastn=$_POST['last_na'];
    $age=$_POST['age'];
    $gender=$_POST['gender'];
    $id=$_GET['edit'];
        $sql="UPDATE user_sch SET firstname='$name',lastname='$lastn',gender='$gender',age='$age' WHERE id='$id'";
    //echo $sql;


    mysqli_query($con,$sql);
    header("Refresh:0; url=table_edit.php");

}


//$sql="SELECT * from user_sch";
if(isset($_GET['edit'])) {
    $sql="SELECT * FROM user_sch";

}

$result=mysqli_query($con,$sql);

  while($row = mysqli_fetch_assoc($result))
  {
   echo '<tr>';
    echo '<td>'.$row['ID'].'</td>';
        echo '<td>'.$row['firstname'].'</td>';
             echo "<td>{$row['lastname']}</td>";
                 echo "<td>{$row['age']}</td>";
                echo "<td>{$row['gender']}</td>";
                echo '<td> <a href="table_edit.php?del='.$row['ID'].'">del</td>';
                echo '<td> <a href="table_edit.php?edit='.$row['ID'].'">edit</td>';


        echo "</tr>";

  }

?>
 *
 *
 *
 */