Untitled

<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "radio";

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

if($conn->connect_error)
{
  die("Nem lehet kapcsolodni az adatbázishoz : " . $conn->connect_error);

}

$sql = "SELECT
  sz_id,
  sz_nev,
  sz_kerdes,
  sz_datum,
  sz_pontszam_a,
  sz_pontszam_b,
  sz_pontszam_c,
  sz_pontszam_d FROM  kerdesek";
$result = $conn->query($sql);
$adat = "";
if ($result->num_rows > 0)
{
  echo "<table><tr><th>ID</th><th>Name</th></tr>";
  while($row = $result->fetch_assoc())
  {
      $adat .= $row['sz_id'] . "," . $row['sz_nev'] . "," . $row['sz_kerdes'] . "," . $row['sz_datum'] . "," . $row['sz_pontszam_a'] . "," . $row['sz_pontszam_b'] . "," . $row['sz_pontszam_c'] . "," . $row['sz_pontszam_d']. ";" . "\n";

        echo"<tr><td>".$row["sz_id"] . "</td><td>". $row["sz_nev"] . "</td><td>" . $row["sz_kerdes"] ."</td><td>" . $row["sz_datum"] . "</td><td>" . $row['sz_pontszam_a'] . "</td><td>" .$row['sz_pontszam_b'] . "</td><td>" .$row['sz_pontszam_c'] .
        $row['sz_pontszam_d']. "</td></tr>";
  }
  echo "</table>";
  if(isset($_POST['mentes']))
  {
    $now = new DateTime();
    $now->format('Y-m-d H:i:s');
    $now->getTimestamp();
    $sql = "INSERT INTO kerdesek (sz_nev,sz_kerdes,sz_datum,sz_pontszam_a,sz_pontszam_b,sz_pontszam_c,sz_pontszam_d) VALUES (?,?,?,?,?,?,?)";
    $stmt = mysqli_prepare($sql);
    $stmt->bind_param($_POST['kerdesnev'],$_POST['kerdes_torzs'],$_POST['sz_datum'],0,0,0,0);
    $stmt->execute();

  }
}
else
{
  echo "Nincs találat!";
}
if(isset($_POST['csvmentes']))
{
       // Creates a new csv file and store it in tmp directory
  $new_csv = fopen('/tmp/report.csv', 'w');
  fputcsv($new_csv, $row);
  fclose($new_csv);

  // output headers so that the file is downloaded rather than displayed
  header("Content-type: text/csv");
  header("Content-disposition: attachment; filename = report.csv");
  readfile("/tmp/report.csv");
  echo "lefutott";

}
elseif (isset($_POSt['pdfmentes']))
{
 //  $pdf_filename = "KerdesekTabla.pdf"
  //header("Content-Type: application/pdf");
  //header("Content-disposition: attachment; filename=".$pdf_filename);
  echo "NINCS IMPLEMENTÁLVA A FUNKCIÓ";

}
?>
<head>
  <title>NYEREMÉNYJÁTÉK</title>
</head>

<body>

  <form>

    <label id="kerdes_nev_lbl"> Kérdés neve : </label><br/>
    <input type="text" name="kerdesnev"></br>

    <label id="kerdes_torzs_lbl"> Kérdés : </label><br/>
    <input type="text" name="kerdes_torzs"><br/>

    <button type="submit" name="mentes">Mentés</button><br/>
    <button type="submit" name="csvmentes">CSV Mentés</button><br/>
    <button type="submit" name="pdfmentes">PDF Mentés</button><br/>

  </form>

</body>

<?php

$conn->close();

?>