I can not select a Database using PHP

Asked Dec 31 '16 at 14:36

Active Aug 04 '17 at 19:47

Viewed 30 times

I am trying to insert form data into a table which was created in phpMyAdmin.

<?php
    $DisplayForm = True;
    if(isset($_POST['submit'])){
        $con = mysqli_connect('127.0.0.1','user','password');
        if(!$con) {
            die('Nicht mit dem Server verbunden' . mysql_error());
        }
        mysqli_select_db($con,"ergebnisse");
        if(!mysqli_select_db($con,'ergebnisse')) {
            echo 'Datenbase nicht ausgewählt. <br/>';
        }
        $sql = "INSERT * INTO 'ergebnisse' ('Ergebnis') VALUES ('$_POST[eingabe]')";
        if(!mysqli_query($con, $sql)){
            echo 'Nicht eingefügt. <br/>';
        }
        $DisplayForm = False;
        echo 'Danke für deine Teilnahme!';
    }
    if ($DisplayForm) {
?>
    <form action="Umfrage.php" method="post">
        <input type="text" name="eingabe">
        <input type="submit" name="submit" value="Absenden">
    </form>
<?php
    }
?>

The code does connect to the server but the following code doesn't work so it doesn't select the database and it doesn't insert the form data.

edited Aug 04 '17 at 19:47

Francisco

10,918
6
34
45

asked Dec 31 '16 at 14:36

DustinZ3

First you are using `mysqli` to connect, then you write `mysql_error()`. Change that and see what's gonna happen. Also the user and pass are the right ones? – Dan Costinel Dec 31 '16 at 14:38
that ^ isn't the only thing failing. Incorrect identifier qualifiers used. – Funk Forty Niner Dec 31 '16 at 14:39
Also remove the `*` from the `INSERT` query. – Dan Costinel Dec 31 '16 at 14:44
Please sanitize your database input to avoid sql injection attacks. Parametrized queries are typically the preferred way of doing it. – erik258 Dec 31 '16 at 14:46
I have changed it but still nothing happens. – DustinZ3 Dec 31 '16 at 14:54

I can not select a Database using PHP

0 Answers0