PHP SQL request does nothing

Asked Apr 23 '20 at 18:28

Active Apr 23 '20 at 18:32

Viewed 23 times

I'm trying to query an SQL database, but I cannot get a simple "select" query to work. I don't get an error message but I don't get the values in the database either.

$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}
$sql = "SELECT id FROM 'visitor' WHERE visitorNumber=0";
$order = $conn->query($sql);
echo $order;


$conn->close();

edited Apr 23 '20 at 18:31

Jay Blanchard

33,530
16
73
113

asked Apr 23 '20 at 18:28

user9244901

Table names should be back ticked, not quoted. – Jay Blanchard Apr 23 '20 at 18:30
You are getting error messages, they are in the server's error logs. You're not doing anything in your code to add to error checking. – Jay Blanchard Apr 23 '20 at 18:31
You can't `echo $order` here because `$order` is a results object. You need to use whatever the mysqli version of `fetch()` is to get the first row from the result set, then display that. – droopsnoot Apr 23 '20 at 18:34
Thank you very much. All your comments were very useful. – user9244901 Apr 24 '20 at 16:20

PHP SQL request does nothing

0 Answers0