Arcadia Posted March 14, 2015 Share Posted March 14, 2015 Hello everyone, I have a problem and really hope someone can help me out here I'm trying to insert data from a form in my MYSQL database and it connect to the database but when i try to submit the form i keep getting these two error messages: Notice: Undefined index: Naam in /Applications/XAMPP/xamppfiles/htdocs/Oefentoets1/Vraag4_Invoer.php on line 18Notice: Undefined index: Score in /Applications/XAMPP/xamppfiles/htdocs/Oefentoets1/Vraag4_Invoer.php on line 19 I have the form and php code in one page I hope this is not a problem. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> <title>Vraag4_Invoer</title> <?php // Connect to the database $con = mysqli_connect("localhost","root","","Oefentoets1"); $naam = $_POST['Naam']; $score = $_POST['Score']; // Check connection if (mysqli_connect_errno()) { echo "Failed to connect to MySQL: " . mysqli_connect_error(); } $sql = "INSERT INTO Scores (Naam, Score) VALUES ('$naam', '$score')"; if ($con->query($sql) === TRUE) { echo "Thanks for signing up!"; } else { echo "Error: " . $sql . "<br>" . $con->error; } mysqli_close($con); ?> </head> <body> <form action="Vraag4_Invoer.php" method="post"> <label>Naam: </label><input name="Naam" type="text" /> <p> <label>Score: </label><input name="Score" type="text" /> <p> <input name="Submit" type="submit" /> </form> </body> </html> Quote Link to comment https://forums.phpfreaks.com/topic/295228-problem-inserting-data-from-form-to-database/ Share on other sites More sharing options...
Solution fastsol Posted March 14, 2015 Solution Share Posted March 14, 2015 In your particular case with this code, it would be best to wrap the entire mysql connection (open to close) in an if() that checks if the form has been submitted yet. At this time the page is trying to run the insert query as soon as the page loads, but the post vars don't exist yet cause you haven't submitted the form. if(isset($_POST['Submit'])) { // Connect to the database $con = mysqli_connect("localhost","root","","Oefentoets1"); $naam = $_POST['Naam']; $score = $_POST['Score']; // Check connection if (mysqli_connect_errno()) { echo "Failed to connect to MySQL: " . mysqli_connect_error(); } $sql = "INSERT INTO Scores (Naam, Score) VALUES ('$naam', '$score')"; if ($con->query($sql) === TRUE) { echo "Thanks for signing up!"; } else { echo "Error: " . $sql . "<br>" . $con->error; } mysqli_close($con); } Quote Link to comment https://forums.phpfreaks.com/topic/295228-problem-inserting-data-from-form-to-database/#findComment-1508074 Share on other sites More sharing options...
Arcadia Posted March 17, 2015 Author Share Posted March 17, 2015 Works like a charm! Thank you my friend. Quote Link to comment https://forums.phpfreaks.com/topic/295228-problem-inserting-data-from-form-to-database/#findComment-1508275 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.