cześć, mam problem z insertem do bazy danych.
Potrzebuje z dwóch inputów przesłać do bazy danychwartośći.
Kod:
<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "clicker";
// Create connection
$conn = mysqli_connect($servername, $username, $password, $dbname);
// Check connection
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Calm breeze login screen</title>
<link rel="stylesheet" href="./style.css">
</head>
<body>
<!-- partial:index.partial.html -->
<div class="wrapper">
<div class="container">
<h1>You Voted!</h1>
<form class="form" method="post">
<input type="text" placeholder="Username" name="username">
<input type="number" placeholder="Number" name="number">
<button type="submit" id="login-button">Vote</button>
</form>
</div>
<?php
$nick = $_POST['username'];
$number = $_POST['number'];
$sql = "INSERT INTO voted (user, number)
VALUES ('$nick', $number)";
mysqli_close($conn);
?>
</div>
<!-- partial -->
<script src='https://cdnjs.cloudflare.com/ajax/libs/jquery/2.1.3/jquery.min.js'></script>
<script src="./script.js"></script>
</body>
</html>
Dostaję dwa błędy
Notice: Undefined index: username in D:\Programy\xampp\htdocs\clicker\final\index.php on line 41
Notice: Undefined index: number in D:\Programy\xampp\htdocs\clicker\final\index.php on line 42
Wartości nie dodają sie do bazy danych.
czy ktoś wie czym to jest spowodowane?
Kiedy testowo zrobiłem Inserta, wszystko działało
$sql = "INSERT INTO voted (user, number)
VALUES ('Test', 4)";