Untitled

ADMIN

<html>
<head>
</head>

<body>
  <div class="refresh">
  <div class="ui two item menu">
    <a class="item" href="Harjoitus.php">Pääsivu</a>
    <a class="active item" href="admin.php">Admin</a>
  </div>
  <?php
  include("header.php");
  $servername = "localhost";
  $username = "root";
  $password = "";
  $dbname = "tietokanta";

  $conn = new mysqli($servername, $username, $password, $dbname);

  // $query = "DELETE FROM lomake WHERE id={$_POST['id']}";
  function poista_user($id, $conn){
    mysqli_query($con,"DELETE FROM lomake WHERE id='".$id."'");

  }

  if ($conn->connect_error) {
      die("Connection failed: ". "<br>" . $conn->connect_error);
    } else {
      echo "<script>console.log('Connected successfully');</script>";
    }
  $sql = "SELECT * FROM lomake";
  $id = $_POST['id'];
  $result = $conn->query($sql);
  echo "<table class='ui table'>";
  echo "<thead>";
    echo "<tr>";
    echo "<th>". "ID"."</th>" ;
    echo "<th>". "Sähköposti"."</th>" ;
    echo "<th>". "Etunimi"."</th>" ;
    echo "<th>". "Sukunimi"."</th>" ;
    echo "<th>". "Ikä"."</th>";
    echo "<th>". "Säännöt"."</th>" ;
    echo "<th>". "Sukupuoli"."</th>" ;
    echo "<th>". "Toiminnot"."</th>" ;
    echo "</tr>";
    if ($result->num_rows > 0) {
      // output data of each row
      while($row = $result->fetch_assoc()) {
        echo "<tr>";
          echo "<td>" . $row["id"] ."</td>";
          echo "<td>" . $row["sahkoposti"] ."</td>";
          echo "<td>" . $row["etunimi"] ."</td>";
          echo "<td>" . $row["sukunimi"] ."</td>";
          echo "<td>" . $row["ika"] ."</td>";
          echo "<td>" . $row["saannot"] ."</td>";
          echo "<td>" . $row["sukupuoli"] ."</td>";
          echo "<td> <a href=admin.php?delete_id=". $row['id'] ."><i class='times circle icon'></i></a>";
        echo "<tr>";
        }

    } else {
      echo "<div class='item'>0 results</div>";
    }
  if (isset($_POST['clear'])){
    echo "<br>";
    $poista = "DELETE FROM lomake";
    if($conn->query($poista)=== TRUE){
      echo "TAULU POISTETTU!";

    } else {
      echo "TAULUN POISTAMINEN EPÄONNISUI! " . $conn->error;
    }
  }

  $conn->close();
  echo "</table>";
 ?>
  <form method= 'POST' action=''>
    <input class="ui button" type="submit" name="submit" value="Hae käyttäjät">
    <button class="ui button" type="submit" name="clear" value="TYHJENNÄ TAULU">
Tyhjennä taulu
    </button><br>
    </a>
  </form>
  <?php
 ?>
</div>
</body>
</html>


HEADER
<html>
<head>
<style>
.refresh{
  margin-left: 2%;
  margin-top: 2%;
  margin-right: 2%;
}
</style>
<link rel="stylesheet" href="design\semantic\semantic.css">
<script src="design\semantic\semantic.js"></script>
</head>
</html>

HARJOITUS

<html>
<header>
  <title>Rekisteröinti</title>
</header>
<head>
<link rel="stylesheet" type="text/css" href="\design\semantic\semantic.css">
<script src="\design\semantic\semantic.js"></script>


</head>
<?php

error_reporting(0);
ini_set('display_errors', 0);

$enimiErr = $snimiErr = $spostiErr = $ikaErr = $sukuErr = $saannotErr = $spostiErr2 = "";
$enimi = $snimi = $sposti = $ika = $suku = $saannot = "";
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "tietokanta";

$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}
if (isset($_POST['register'])){
  if (empty($_POST["enimi"])){
    $enimiErr = "Nimi on pakollinen.";
  }else{
    $enimi = ($_POST["enimi"]);
  }
  if (empty($_POST["sposti"])){
    $spostiErr = "Sähköposti on pakollinen.";
  } elseif (filter_var(($_POST["sposti"]), FILTER_VALIDATE_EMAIL)) {
      $sposti = ($_POST["sposti"]);
    } else {
      $spostiErr = "Väärän muotoinen sähköposti.";
    }


  if (empty($_POST["snimi"])){
    $snimiErr = "Sukunimi on pakollinen.";
  }else{
    $snimi = ($_POST["snimi"]);
  }
  if (empty($_POST["ika"])){
    $ikaErr = "Ikä on pakollinen.";
  }else{
    $ika = ($_POST["ika"]);
  }
  if (empty($_POST["suku"])){
    $sukuErr = "Valitse sukupuoli.";
  }else{
    $suku = ($_POST["suku"]);
  }
  if (empty($_POST["saannot"])){
    $saannotErr = "Sinun on hyväksyttävä säännöt.";
  } else{
    $saannot = "Hyväksytty";
  }
}
/*
function test_input($data) {
  return $data;
}*/
?>
<style>
.theform {
  margin-top: 10px;
  margin-left: 2%;
  margin-right: 10%;
  margin-bottom: 10px;
}
</style>

<body>
  <div class="ui two item menu">
    <a class="active item">Pääsivu</a>
    <a class="item" href="admin.php">Admin</a>
  </div>
  <div class="theform">
    <form  class="ui equal width form" action="<?php echo ($_SERVER["PHP_SELF"]);?>" method="POST">
      <div class="fields">
        <div class="field">
          Sähköposti: <span class="error">*</span> <input type="text" name="sposti" placeholder="Sähköposti">
          <span class="error"> <?php echo $spostiErr; ?><br></span>
        </div>
      </div>
      <div class="fields">
        <div class="field">
          Etunimi: <span class="error">*</span> <input type="text" name="enimi" placeholder="Etunimi">
          <span class="error"> <?php echo $enimiErr; ?><br></span>
        </div>
        <div class="field">
          Sukunimi: <span class="error">*</span> <input type="text" name="snimi" placeholder="Sukunimi">
          <span class="error"> <?php echo $snimiErr; ?><br></span>
        </div>
      </div>

      <div class="fields">
        <div class="field" >
          Ikä: <span class="error">*</span>
          <input type="number" name="ika" placeholder="Ikä" width="20px">
          <span class="error"> <?php echo $ikaErr; ?><br></span>
        </div>
      </div>

      <div class="fields">
        <div class="field">
          <label>Hyväksyn palvelun säännöt:</label><input class="ui checkbox" type="checkbox" name="saannot"><span class="error">* <?php echo $saannotErr; ?><br></span>

        </div>
      </div>
      <label>Sukupuoli: <span class="error">* </span> </label>

      <div class="fields">
        <div class="field">
          <div class="ui radio checkbox">
          <input type="radio" name="suku" value="Mies" > <label>Mies</label>
        </div>
          <div class="ui radio checkbox">
          <input type="radio" name="suku" value="Nainen" ><label>Nainen</label>
        </div>
          <span class="error"> <?php echo $sukuErr; ?><br></span>
        </div>
      </div>

    <input class="ui button" type="submit" name="register" value="Rekisteröi">
  </form>

  <?php
    include("header.php");

    function sahkotesti($sahkari) {
      if (filter_var($sahkari, FILTER_VALIDATE_EMAIL)) {
        return "hyväksytty";
      } else {
        return "väärin";
      }
    }

  $sql = "INSERT INTO lomake (sahkoposti, etunimi, sukunimi, ika, saannot, sukupuoli)
  VALUES ('$sposti', '$enimi', '$snimi', '$ika', '$saannot', '$suku')";

  if($_POST["snimi"]==""||$_POST["sposti"]==""||$_POST["enimi"]==""||$_POST["ika"]==""||$_POST["saannot"]==""||$_POST["suku"]==""||sahkotesti($_POST["sposti"])=="vaarin"){
    ?><span class="error2"><?php
    echo "Jokin kentistä on tyhjä!" . "<br>";
    echo "<br>";
    } elseif ($conn->query($sql) === TRUE) {
      echo "<h4>New record created successfully</h4>";
      echo "";
      } else {
        echo "Error: " . $sql . "<br>" . $conn->error;
    }
    ?></span><?php
  $conn->close();
  ?>
</div>
</body>
</html>