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

Biblatex bibliography style without URLs when DOI exists (in Overleaf with Zotero bibliography)

Image
2 2 I have a Zotero bibliography in Overleaf. I use biblatex . usepackage[backend=biber,citestyle=authoryear]{biblatex} addbibresource{zoteroALH.bib} Bibliography entries look like: @book{de_saint-gervais_uniformization_2016, title = {Uniformization of {Riemann} {Surfaces}}, isbn = {978-3-03719-145-3}, url = {https://www.ems-ph.org/books/book.php?proj_nr=198&srch=series%7Chem}, urldate = {2019-02-03}, author = {de Saint-Gervais, Paul Henri}, year = {2016}, doi = {10.4171/145} } In the bibliography down the paper the reference shows like this: There is the DOI, great, but also the URL which is unnecessary when the DOI is there. How can I remove the URL when the DOI is present? biblatex bibliographies overleaf zote
Read more

ComboBox Display Member on multiple fields

Image
2 I'm trying to set the .DisplayMember property of a ComboBox in C#, but I want to bind it to multiple columns in the .DataSouce . My SQL looks like this: SELECT PersNbr, PersFirstName, PersMiddleName, PersLastName FROM Pers WHERE PersNbr = :persNbr; I'm saving this query in a DataTable so each column selected has it's own column in the Datatable . I want to make the .DisplayMember a combination of PersFirstName + PersMiddleName + PersLastName so their full name appears like this: comboBox.DisplayMemeber = "PersFirstName" + "PersMiddleName" + "PersLastName" I know I can just to this on the query: SELECT PersNbr, (PersFirstName || PersMiddleName || PersLastName) PersName and then just do this: comboBox.DisplayMember = "PersName"; but I
Read more

Is it possible to collect Nectar points via Trainline?

Image
2 Since I am not eligible for any Railcard, the only available discount/bonus scheme is Nectar Card for me. GWR, SWR, LNER and Virgin Trains allow to collect Nectar points and I have already linked a card to my GWR account. A friend suggested me to use Trainline App, because it can search for bus tickets either. I had a look at the application, but could not see any option for Nectar. Is there a way to collect Nectar points when I buy tickets via Trainline? uk trains loyalty-programs trainline share | improve this question asked Dec 2 '18 at 15:50 ahmedus 3,224 5 19 49
Read more