PHP & MYSQL no database selected

Question

i get an "no database selected" error and i can't figure out why. Would be nice if someone could help me out. Code below. There are no typos in there and im using XAMPP/Apache as server so localhost should be right i guess?

 <!--Insert in database-->
    <?php
    $servername = "localhost";
    $dbname = "databank";

    $conn = mysqli_connect($servername, $dbname);

    if(!$conn)
    {
    die("Connection failed: " . mysqli_connect_error());    
    }

    $Kundennummer = $_POST["id"];
    $Vorname = $_POST["vorname"];
    $Nachname = $_POST["nachname"];
    $plz = $_POST["plz"];
    $strasse = $_POST["strasse"];
    $hausnummer = $_POST["hausnummer"];

    $sql = "INSERT INTO kundendaten (Kundennummer, ProduktID, Vorname,Nachname, Hausnummer, Strasse, PLZ)
    Values ('$Kundennummer', '0', '$Vorname', '$Nachname', '$hausnummer', '$strasse', '$plz')";

    if(mysqli_query($conn, $sql))
    {
        echo "DONE";
    }
    else
    {
        echo "ERROR: " . $sql . "<br>" . mysqli_error($conn);
    }
    mysqli_close($conn);
    ?>

TarangP · Accepted Answer · 2018-03-16 09:18:32Z

2

Learn mysqli_connect() in php

The valid syntex is

mysqli_connect(host,username,password,dbname,port,socket);

answered Mar 16, 2018 at 9:18

TarangP

2,7385 gold badges24 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Darshan Jain · Accepted Answer · 2018-03-16 09:23:49Z

0

You have forgot to add username and password into the mysqli_connect.

Please check below sample.

<?php
$con = mysqli_connect("localhost","mysqli-user","mysqli-password","databank");

// Check connection
if (mysqli_connect_errno())
  {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  }
?>

I hope this might be helpful for you to resolve your issue.

answered Mar 16, 2018 at 9:23

Darshan Jain

4972 silver badges10 bronze badges

1 Comment

iNex Over a year ago

Thanks, thought username and password wouldn't be necessary.

Collectives™ on Stack Overflow

PHP & MYSQL no database selected

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related