<?php

$con=mysqli_connect("localhost","root","","test");
// Check connection
if (mysqli_connect_errno())
  {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  }


$sql="SELECT Time FROM time_moment";

if ($result=mysqli_query($con,$sql))
  {
  // Return the number of rows in result set
  $rowcount=mysqli_num_rows($result);
  printf("<br>Összesen %d sorom van.\n<br>",$rowcount);




$i = 0;
    while(mysqli_num_rows($result) > $i)    //ciklussal addig megyek, amíg minden sor sorra nem kerül
  {
    $sor = $result->fetch_assoc(); //lépek az adatbázis következő sorára
//echo $sor['Time'].'<br>';

    $i++;
}
$j=0;


$time=7;


$serachTime = filter_input(INPUT_GET, 'Time', FILTER_SANITIZE_SPECIAL_CHARS);
$inport='INSERT INTO time_moment (Time) VALUES('.$serachTime.')';




    if ($con->query($inport) === TRUE) {
    echo "New record created successfully";
} else {
    echo "Error: ".$inport."<br>".$con->error;
}


// Free result set

  mysqli_free_result($result);
  }

mysqli_close($con);<?php

$con=mysqli_connect("localhost","root","","test");
// Check connection
if (mysqli_connect_errno())
  {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  }


$sql="SELECT Time FROM time_moment";

if ($result=mysqli_query($con,$sql))
  {
  // Return the number of rows in result set
  $rowcount=mysqli_num_rows($result);
  printf("<br>Összesen %d sorom van.\n<br>",$rowcount);




$i = 0;
    while(mysqli_num_rows($result) > $i)    //ciklussal addig megyek, amíg minden sor sorra nem kerül
  {
    $sor = $result->fetch_assoc(); //lépek az adatbázis következő sorára
//echo $sor['Time'].'<br>';

    $i++;
}
$j=0;


$time=7;


$serachTime = filter_input(INPUT_GET, 'Time', FILTER_SANITIZE_SPECIAL_CHARS);
$inport='INSERT INTO time_moment (Time) VALUES('.$serachTime.')';




    if ($con->query($inport) === TRUE) {
    echo "New record created successfully";
} else {
    echo "Error: ".$inport."<br>".$con->error;
}


// Free result set

  mysqli_free_result($result);
  }

mysqli_close($con);