Data not inserting into database (SQL)

Asked Mar 28 '18 at 21:42

Active Mar 28 '18 at 21:48

Viewed 26 times

I have a form that gives the data to this File. I checked that the data comes in correctly and it does. I have connection to my database but the code isn't sending it to the database. Why isn't it working?

<?php 
        session_start();
        include_once("includes/db.php");


        if(isset($_POST['produkt']) && isset($_POST['größe']) && isset($_POST['name']) && isset($_POST['telefonnummer']) && isset($_POST['straße']) && isset($_POST['postleitzahl']) && isset($_POST['ort'])) {

            $produkt = $_POST['produkt'];
            $größe = $_POST['größe'];
            $name = $_POST['name'];
            $telefonnummer = $_POST['telefonnummer'];
            $straße = $_POST['straße'];
            $postleitzahl = $_POST['postleitzahl'];
            $ort = $_POST['ort'];

            $sql_store = "INSERT into bestellungen (id, produkt, größe, name, telefonnummer, straße, postleitzahl, ort) VALUES (NULL, '$produkt', '$größe', '$name', '$telefonnummer', '$straße', '$postleitzahl', '$ort')";
            $sql = mysqli_query($db, $sql_store); 

        }

?>

asked Mar 28 '18 at 21:42

Noah Adler

without knowing your db.php and the bestellungen table, can't help you. – Forbs Mar 28 '18 at 21:44
you have too many unclosed questions, IMHO. – Funk Forty Niner Mar 28 '18 at 21:46
You can check mysqli_error to see if something went wrong – Pain67 Mar 28 '18 at 21:47
1

what are meaning "größe" or "straße" ? this words has utf-8 chars, maybe the issue came from this! don't use utf-8 chars for variables or tables name. – aidinMC Mar 28 '18 at 21:51
@aidinMC You are right! It works now! Thank you! – Noah Adler Mar 28 '18 at 22:02

Data not inserting into database (SQL)

0 Answers0