PHP MySQL is not getting anything from the database

Question

Trying to get all the users from my database, yet when I do so, the query fails.

Attempting to do so with

 $userNames = mysqli_query($con, "SELECT * FROM Login");

Where in PHPMyAdmin the database has a few records in the table login. I checked if the connection is connected, its connected.

Is there any reason this wouldn't work?

Here is a examplepage, you can try logging in with Username and Password.

EDIT: From the example page, here is the code used to test:

if (mysqli_connect_errno($con)) {
    echo "Failed to connect to MySQL: " . mysqli_connect_error() . "<br />";
} else {
    echo "Connected to MySQL!<br />";
}
if(mysqli_query($con, "SELECT * FROM Login")){
    echo "Query good!<br />";
} else {
    echo "Query bad!<br />";
}

EDIT 2: Here is a screenshot of the table existing, and the data existing: Something

Added example code, (and its $con). If you go to the demo page and try it, it will say that it could connect to $con. — PaulBGD
– PaulBGD, Commented Jul 16, 2013 at 21:33
Dave, it is a table. I suppose I could send you a censored screenshot.. — PaulBGD
– PaulBGD, Commented Jul 16, 2013 at 21:34

Adsy2010 · Accepted Answer · 2013-07-19 23:28:16Z

1

I use this

$con = StartDatabase("localhost", "username", "password", "mydatabase");

function StartDatabase($dblocation, $dbuser, $dbpasswd, $dbname){
 $link = mysqli_connect($dblocation, $dbuser, $dbpasswd, $dbname);
  if (!$link) {
    die('Connect Error (' . mysqli_connect_errno() . ') '
        . mysqli_connect_error());
  }
 return $link;
}

if(mysqli_query($con, "SELECT * FROM Login")){
    echo "Query good!<br />";
} else {
    echo "Query bad!<br />";
}

answered Jul 19, 2013 at 23:28

Adsy2010

5456 silver badges25 bronze badges

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

Comments

Cosco Tech · Accepted Answer · 2013-07-16 22:00:28Z

0

Try adding this to the else of the query to get an error output:

echo "Error code ({$con->errno}): {$con->error}";

answered Jul 16, 2013 at 22:00

Cosco Tech

5751 gold badge5 silver badges22 bronze badges

2 Comments

Cosco Tech Over a year ago

Can you post your $con string. Just edit out the info you don't want shown.

PaulBGD Over a year ago

$con = mysqli_connect("pdb1.awardspace.com", "**********", "*******", "*******");

Cosco Tech · Accepted Answer · 2013-07-16 22:54:13Z

0

Try like this:

$con = new mysqli("pdb1.awardspace.com", "*******", "****", "*******");

$query = "SELECT * FROM Login";

if ( !$con->query($query) ) {
    echo "Query bad!<br />";
    echo mysqli_connect_error() . "<br />";
    echo "Error code ({$sql->errno}): {$sql->error}";
} else {
    echo "Query good!<br />";
}
$con->close();

edited Jul 16, 2013 at 22:54

answered Jul 16, 2013 at 22:23

Cosco Tech

5751 gold badge5 silver badges22 bronze badges

5 Comments

Cosco Tech Over a year ago

there was an extra backtick(`) in there after login. I have removed it so have an eye for that.

PaulBGD Over a year ago

What? I also tried this, and I get a 500 from if (!$con -> query($query))

Cosco Tech Over a year ago

What do you mean a 500?

PaulBGD Over a year ago

Ah never mind. I just decided to switch to something else.. And by 500 I mean PHP server error.

Cosco Tech Over a year ago

Did you edit the $con string, it is different than your orig.

Collectives™ on Stack Overflow

PHP MySQL is not getting anything from the database

3 Answers 3

Comments

2 Comments

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

2 Comments

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related