var dumping mysqli query gives false boolean [duplicate]











up vote
-1
down vote

favorite













This question already has an answer here:




  • When to use single quotes, double quotes, and back ticks in MySQL

    12 answers



  • How to display errors for my MySQLi query? [duplicate]

    3 answers




im trying to output data from my database but my mysqli query gives me an error. This is my code: 



<?php

$mysqli = new mysqli('db','root','mysql');

var_dump(mysqli_query($mysqli,"SELECT * FROM  'posts' "));

?>


this is what my browser shows: bool(false) . Idk how can i fix this problem because im sure that the db is connected.






php mysql database mysqli







share|improve this question









New contributor




senthuu27 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.











marked as duplicate by Funk Forty Niner mysql
Users with the  mysql badge can single-handedly close mysql questions as duplicates and reopen them as needed.

StackExchange.ready(function() {
if (StackExchange.options.isMobile) return;

$('.dupe-hammer-message-hover:not(.hover-bound)').each(function() {
var $hover = $(this).addClass('hover-bound'),
$msg = $hover.siblings('.dupe-hammer-message');

$hover.hover(
function() {
$hover.showInfoMessage('', {
messageElement: $msg.clone().show(),
transient: false,
position: { my: 'bottom left', at: 'top center', offsetTop: -7 },
dismissable: false,
relativeToBody: true
});
},
function() {
StackExchange.helpers.removeMessages();
}
);
});
});
 2 days ago


This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.















  • Look at parameter 4 of new mysqli('db','root','mysql'); which you dont have OR look at mysqli_select_db() but parameter 4 is a better solution. Basically you have not told MySQL what database you want to be looking at. Remember MySQL can manage many databases
    – RiggsFolly
    2 days ago












  • Also, incorrect Identifier Qualifiers.
    – Funk Forty Niner
    2 days ago










  • I've added a dbname but it still isnt working
    – senthuu27
    2 days ago










  • ^ that was meant for you I think @RiggsFolly
    – Funk Forty Niner
    2 days ago










  • Did you also fix the SELECT error?
    – RiggsFolly
    2 days ago















up vote
-1
down vote

favorite













This question already has an answer here:




  • When to use single quotes, double quotes, and back ticks in MySQL

    12 answers



  • How to display errors for my MySQLi query? [duplicate]

    3 answers




im trying to output data from my database but my mysqli query gives me an error. This is my code: 



<?php

$mysqli = new mysqli('db','root','mysql');

var_dump(mysqli_query($mysqli,"SELECT * FROM  'posts' "));

?>


this is what my browser shows: bool(false) . Idk how can i fix this problem because im sure that the db is connected.






php mysql database mysqli







share|improve this question









New contributor




senthuu27 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.











marked as duplicate by Funk Forty Niner mysql
Users with the  mysql badge can single-handedly close mysql questions as duplicates and reopen them as needed.

StackExchange.ready(function() {
if (StackExchange.options.isMobile) return;

$('.dupe-hammer-message-hover:not(.hover-bound)').each(function() {
var $hover = $(this).addClass('hover-bound'),
$msg = $hover.siblings('.dupe-hammer-message');

$hover.hover(
function() {
$hover.showInfoMessage('', {
messageElement: $msg.clone().show(),
transient: false,
position: { my: 'bottom left', at: 'top center', offsetTop: -7 },
dismissable: false,
relativeToBody: true
});
},
function() {
StackExchange.helpers.removeMessages();
}
);
});
});
 2 days ago


This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.















  • Look at parameter 4 of new mysqli('db','root','mysql'); which you dont have OR look at mysqli_select_db() but parameter 4 is a better solution. Basically you have not told MySQL what database you want to be looking at. Remember MySQL can manage many databases
    – RiggsFolly
    2 days ago












  • Also, incorrect Identifier Qualifiers.
    – Funk Forty Niner
    2 days ago










  • I've added a dbname but it still isnt working
    – senthuu27
    2 days ago










  • ^ that was meant for you I think @RiggsFolly
    – Funk Forty Niner
    2 days ago










  • Did you also fix the SELECT error?
    – RiggsFolly
    2 days ago













up vote
-1
down vote

favorite









up vote
-1
down vote

favorite












This question already has an answer here:




  • When to use single quotes, double quotes, and back ticks in MySQL

    12 answers



  • How to display errors for my MySQLi query? [duplicate]

    3 answers




im trying to output data from my database but my mysqli query gives me an error. This is my code: 



<?php

$mysqli = new mysqli('db','root','mysql');

var_dump(mysqli_query($mysqli,"SELECT * FROM  'posts' "));

?>


this is what my browser shows: bool(false) . Idk how can i fix this problem because im sure that the db is connected.






php mysql database mysqli







share|improve this question









New contributor




senthuu27 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.












This question already has an answer here:




  • When to use single quotes, double quotes, and back ticks in MySQL

    12 answers



  • How to display errors for my MySQLi query? [duplicate]

    3 answers




im trying to output data from my database but my mysqli query gives me an error. This is my code: 



<?php

$mysqli = new mysqli('db','root','mysql');

var_dump(mysqli_query($mysqli,"SELECT * FROM  'posts' "));

?>


this is what my browser shows: bool(false) . Idk how can i fix this problem because im sure that the db is connected.





This question already has an answer here:




  • When to use single quotes, double quotes, and back ticks in MySQL

    12 answers



  • How to display errors for my MySQLi query? [duplicate]

    3 answers







php mysql database mysqli




php mysql database mysqli






share|improve this question









New contributor




senthuu27 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.











share|improve this question









New contributor




senthuu27 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.









share|improve this question




share|improve this question








edited 2 days ago









Madhur Bhaiya

15k52136




15k52136






New contributor




senthuu27 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.









asked 2 days ago









senthuu27

1




1




New contributor




senthuu27 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.





New contributor





senthuu27 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.






senthuu27 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.




marked as duplicate by Funk Forty Niner mysql
Users with the  mysql badge can single-handedly close mysql questions as duplicates and reopen them as needed.

StackExchange.ready(function() {
if (StackExchange.options.isMobile) return;

$('.dupe-hammer-message-hover:not(.hover-bound)').each(function() {
var $hover = $(this).addClass('hover-bound'),
$msg = $hover.siblings('.dupe-hammer-message');

$hover.hover(
function() {
$hover.showInfoMessage('', {
messageElement: $msg.clone().show(),
transient: false,
position: { my: 'bottom left', at: 'top center', offsetTop: -7 },
dismissable: false,
relativeToBody: true
});
},
function() {
StackExchange.helpers.removeMessages();
}
);
});
});
 2 days ago


This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.






marked as duplicate by Funk Forty Niner mysql
Users with the  mysql badge can single-handedly close mysql questions as duplicates and reopen them as needed.

StackExchange.ready(function() {
if (StackExchange.options.isMobile) return;

$('.dupe-hammer-message-hover:not(.hover-bound)').each(function() {
var $hover = $(this).addClass('hover-bound'),
$msg = $hover.siblings('.dupe-hammer-message');

$hover.hover(
function() {
$hover.showInfoMessage('', {
messageElement: $msg.clone().show(),
transient: false,
position: { my: 'bottom left', at: 'top center', offsetTop: -7 },
dismissable: false,
relativeToBody: true
});
},
function() {
StackExchange.helpers.removeMessages();
}
);
});
});
 2 days ago


This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.














  • Look at parameter 4 of new mysqli('db','root','mysql'); which you dont have OR look at mysqli_select_db() but parameter 4 is a better solution. Basically you have not told MySQL what database you want to be looking at. Remember MySQL can manage many databases
    – RiggsFolly
    2 days ago












  • Also, incorrect Identifier Qualifiers.
    – Funk Forty Niner
    2 days ago










  • I've added a dbname but it still isnt working
    – senthuu27
    2 days ago










  • ^ that was meant for you I think @RiggsFolly
    – Funk Forty Niner
    2 days ago










  • Did you also fix the SELECT error?
    – RiggsFolly
    2 days ago


















  • Look at parameter 4 of new mysqli('db','root','mysql'); which you dont have OR look at mysqli_select_db() but parameter 4 is a better solution. Basically you have not told MySQL what database you want to be looking at. Remember MySQL can manage many databases
    – RiggsFolly
    2 days ago












  • Also, incorrect Identifier Qualifiers.
    – Funk Forty Niner
    2 days ago










  • I've added a dbname but it still isnt working
    – senthuu27
    2 days ago










  • ^ that was meant for you I think @RiggsFolly
    – Funk Forty Niner
    2 days ago










  • Did you also fix the SELECT error?
    – RiggsFolly
    2 days ago
















Look at parameter 4 of new mysqli('db','root','mysql'); which you dont have OR look at mysqli_select_db() but parameter 4 is a better solution. Basically you have not told MySQL what database you want to be looking at. Remember MySQL can manage many databases
– RiggsFolly
2 days ago






Look at parameter 4 of new mysqli('db','root','mysql'); which you dont have OR look at mysqli_select_db() but parameter 4 is a better solution. Basically you have not told MySQL what database you want to be looking at. Remember MySQL can manage many databases
– RiggsFolly
2 days ago














Also, incorrect Identifier Qualifiers.
– Funk Forty Niner
2 days ago




Also, incorrect Identifier Qualifiers.
– Funk Forty Niner
2 days ago












I've added a dbname but it still isnt working
– senthuu27
2 days ago




I've added a dbname but it still isnt working
– senthuu27
2 days ago












^ that was meant for you I think @RiggsFolly
– Funk Forty Niner
2 days ago




^ that was meant for you I think @RiggsFolly
– Funk Forty Niner
2 days ago












Did you also fix the SELECT error?
– RiggsFolly
2 days ago




Did you also fix the SELECT error?
– RiggsFolly
2 days ago

















active

oldest

votes






















active

oldest

votes













active

oldest

votes









active

oldest

votes






active

oldest

votes

-

Popular posts from this blog

How to change which sound is reproduced for terminal bell?

Image
3 Recently upgrade to 18.10 from 18.04, and using the terminal is becoming annoying: the new alert sound is a drip ( /usr/share/sounds/gnome/default/alerts/drip.ogg ), and the previous one is still located at ( /usr/share/sounds/ubuntu/stereo/bell.ogg ). My issue is that at the gnome-terminal, when autocompleting or pressing left BOTH sounds are reproduced, at the same time. I want to just have ubuntu/stereo/bell.ogg active, not both . At the moment I have been only able to reduce the volume of the alerts (but still both are played), or turn the alerts down (but I dislike both "solutions"). gnome-terminal 18.10 teminal-bell share | improve this question
Read more

Title Spacing in Bjornstrup Chapter, Removing Chapter Number From Contents

Image
up vote 5 down vote favorite 2 I would like to make it so that the vertical space below the title of each chapter is the same when using the Bjornstrup package (i.e. so that the descenders do not affect the spacing - as shown by the red arrow in the picture below). I think I'm fairly happy with the spacing around "A chapter", so I'd really like titles without descenders (e.g. "Contents") to have the same vertical spacing as "A chapter" below the title. I would also like to remove the large "0" in the contents title. Any help appreciated, as always. documentclass[11pt,a4paper]{book} % Packages[![enter image description here][1]][1] usepackage[left=3.5cm, right=3.5cm, top=4.3cm, bottom=4.25cm]{geometry} usepackage[utf8]{inputenc} usepackage{libertine} usepackage[libertine]{newtx
Read more

Can I use Tabulator js library in my java Spring + Thymeleaf project?

Image
0 I want to add Tabulator js to my java project. I added tabulator.min.js, tabulator.min.css to resources folder. After that added to my html page these dependencies as recommending in readme.md. <link rel="stylesheet" th:href="@{/css/tabulator.min.css}"> <script type="text/javascript" th:src="@{/js/tabulator.min.js}"></script> Now my tables view all elements, that I have in the html page, but not correct. In the documentation of Tabulator is example how to create header and table, var table = new Tabulator("#example-table", { columns:[ {title:"Name", field:"name", sorter:"string", width:200, editor:true}, {title:"Age", field:"age", sorter:"
Read more