Mam problem ponieważ gdy chciałbym dodać przez formularz dane to niestety się nie dodają do tabeli w bazie danych, php nie wybija żadnego błędu i nie mogę znaleźć przyczyny
<?php
error_reporting(E_ALL & ~E_NOTICE);
session_start();
if(isset($_SESSION['nick']) && ($_SESSION['nick']=='skaut1' || $_SESSION['nick']=='skaut2'|| $_SESSION['nick']=='skaut3')){ //musi zalogowac sie skaut
$nick = ucfirst($_SESSION['nick']);
if($_POST['submit']){
$idpilkarza = $_POST['idpilk'];
$minuty = $_POST['min'];
$bramki = $_POST['bramki'];
$ck = $_POST['czyste'];
$ocena = $_POST['ocena'];
include_once("connection.php");
$sql = "INSERT INTO meczeskaut1 (idpil, minuty, bramki, asysty, ck, ocena) VALUE ('$idpilkarza', '$minuty' , '$bramki' ,'$ck', '$ocena')";
mysqli_query($dbCon, $sql);
}
}else {
header('Location: login2.php');
die();
}
?>
<!DOCTYPE html>
<html lang="pl">
<head>
<!-- Required meta tags always come first -->
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
<meta http-equiv="x-ua-compatible" content="ie=edge">
<title>Panel skauta</title>
<link rel="stylesheet" href="css/style.css" type="text/css"/>
<!-- Bootstrap CSS -->
<link href="css/bootstrap.min.css" rel="stylesheet">
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0-alpha.5/css/bootstrap.min.css" integrity="sha384-AysaV+vQoT3kOAXZkl02PThvDr8HYKPZhNT5h/CXfBThSRXQ6jW5DO2ekP5ViFdi" crossorigin="anonymous">
<script type="text/javascript">
function alercik(){
document.getElementById('alercik').style.display = 'block';
}
</script>
</head>
<body>
<!-- MENU BOOTSTRAPOWE -->
<nav class="navbar navbar-inverse navbar-fixed-top">
<div class="container">
<!-- mobilne -->
<div class="navbar-header">
<button type="button" class="navbar-toggle" data-toggle="collapse" data-target="#bs-example-navbar-collapse-1">
<span class="sr-only">Nawigacja mobilna</span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
</button>
<a class="navbar-brand" href="index.html">Home</a>
</div>
<!-- -->
<div class="collapse navbar-collapse" id="bs-example-navbar-collapse-1">
<ul class="nav navbar-nav">
<li>
<a href="admin.php">Zarząd</a>
</li>
<li>
<a href="skaut.php">Skaut</a>
</li>
<li>
<a href="kadra.php">Kadra</a>
</li>
</ul>
</div>
<!-- /.navbar-collapse -->
</div>
<!-- /.container -->
</nav>
<!-- baner i jego wypozycjonowanie bootstrapem -->
<header class="image-bg-fluid-height">
<div class="row">
<div class="col-sm-12">
<br>
</div>
</div>
</header>
<!-- GŁÓWNY KONTENER -->
<div class="container">
<hr id="hrblog"><h2>Panel Skauta: </h2> <hr>
<h4> Witaj, <?php echo $nick; ?>!</h4> <h4><a href="logout.php"> Wyloguj </a></h4><br>
<form id="e" method="post" action="skaut.php" >
<p>Dodaj raport meczu obserwowanego zawodnika:<p>
Wybierz piłkarza:
<select name="idpilk">
<?php
include_once("connection.php");
$znaki = 'SET NAMES utf8';
mysqli_query($dbCon,$znaki);
$sqlee = "select * from pilkarze where idk<>1";
$rezult = $dbCon->query($sqlee);
if ($rezult->num_rows > 0) {
// output data of each row
while($roww = $rezult->fetch_array()) {
echo '<option value="'.$roww["idpil"].'">'.$roww[imie]." ".$roww[nazwisko].'</option>'."<br>";
}
} else {
echo "0 results";
}?>
</select>
<br><br>
Minuty: <input type="number" min="0" max="90" name = "min" class="form-control" placeholder="Wpisz ilość rozegranych minut" autofocus /> <br>
Bramki: <input type="number" min="0" max="50" name = "bramki" class="form-control" placeholder="Wpisz ilość bramek w meczu" /> <br>
Asysty: <input type="number" min="0" max="50" name = "asysty" class="form-control" placeholder="Wpisz ilość asyst w meczu" /> <br>
Czyste konto: <input type="czyste" min="0" max="1" name = "idpozycja" class="form-control" placeholder="1 - czyste konto, 0 - brak" /> <br>
Ocena: <input type="number" min="0" max="10" name = "ocena" class="form-control" placeholder="Wpisz ocenę" /> <br>
<input type = "submit" name="submit" value ="Dodaj" class="btn btn-primary" onclick="alercik()" />
<input type="reset" value="Reset" class="btn btn-primary"/>
</form>
<hr>
<br><br>
<hr class="hrblog">
<div class="alert alert-success" role="alert" id="alercik">
<strong>Pomyślnie dodano raport!</strong>
</div>
<div class="row">
<div class="col-sm-12">
<h2> Obserwowani gracze: </h2>
e
<br>
</div>
</div>
<div class="row">
<div class="col-sm-12">
<br>
</div>
</div>
<div class="row">
<div class="col-sm-12">
<br>
</div>
</div>
<hr>
</div>
<!-- Footer -->
<footer>
<div class="container">
<div class="row">
<div class="col-lg-12">
<p>© Dominik Nalepa 2018</p>
</div>
</div>
</div>
</footer>
<!-- jQuery first, then Tether, then Bootstrap JS. -->
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.1.1/jquery.min.js" integrity="sha384-3ceskX3iaEnIogmQchP8opvBy3Mi7Ce34nWjpBIwVTHfGYWQS9jwHDVRnpKKHJg7" crossorigin="anonymous"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/tether/1.3.7/js/tether.min.js" integrity="sha384-XTs3FgkjiBgo8qjEjBk0tGmf3wPrWtA6coPfQDfFEY8AnYJwjalXCiosYRBIBZX8" crossorigin="anonymous"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0-alpha.5/js/bootstrap.min.js" integrity="sha384-BLiI7JTZm+JWlgKa0M0kGRpJbF2J8q+qreVrKBC47e3K6BW78kGLrCkeRX6I9RoK" crossorigin="anonymous"></script>
</body>
</html>