CODEWITHSUNDEEP
phpmysqlsql
Ryan Napp
Ryan Napp

Reputation: 11

Selecting data from sql database doesn't work. how do I fix it?

I am trying to select data from a database. I do have a successful connection, but it seems like the query doesn't work even though I know for sure that the query is right. What am I doing wrong?

If I execute the code below, the result I get is: "Connected successfullyBad query". The 'Bad query' should mean that the query is wrong, but I checked it and it isn't wrong...

<?php
$servername = "localhost";
$username = "root";
$password = "usbw";
// Create connection
$conn = new mysqli($servername, $username, $password);

// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
} 
echo "Connected successfully";
$sql ="SELECT * FROM  `producten`";
$result = mysqli_query($conn, $sql) or die("Bad query");

$conn->close();

?>

I expect to only see "connected successfully"

Upvotes: 0

Views: 132

Answers (3)

nilsmahajan
nilsmahajan

Reputation: 1

Please give database name also, check below code.

<?php
$servername = "localhost";
$username = "root";
$password = "usbw";
$dbname = "";      //Enter database name
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);

// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
} 
echo "Connected successfully";
$sql ="SELECT * FROM  `producten`";
$result = mysqli_query($conn, $sql) or die("Bad query");

$conn->close();

?>

Upvotes: 0

Pooja Kumari
Pooja Kumari

Reputation: 1

Your query is right just write your database name in mysqli constructor.

$conn = new mysqli(DB_HOST, DB_USER, DB_PASS, DB_NAME);

Visit: https://www.php.net/manual/en/mysqli.construct.php

Upvotes: 0

nacho
nacho

Reputation: 5396

You are missing your database name. You can do it two ways, or in the connect statement:

$conn = new mysqli($servername, $username, $password,$database);

Or you can do it in your select statement:

$sql ="SELECT * FROM  `yourdatabase`.`producten`";

If you don´t set your database your query is wrong

Upvotes: 2

Related Questions