php not displaying results on database

Question

I have a database with 4 tables. (products,purchase,customer,user). When I tried to display all rows in products, no results. But in the user table, it displays. What should be the problem? Is it on my database?tables?php code?

Here's my code:

<?php

$db = mysqli_connect("localhost","root","", "prodpurchase");
if (!$db) {
die('Could not connect: ' . mysqli_error());
}

$sql = mysqli_query($db, "select * from user");
if( $sql === FALSE ) {
  die('Query failed returning error: '. mysqli_error());
} else {
   while($row=mysqli_fetch_array($sql))
   {
    echo $row['username']. "<br>";
   }
}
?>

Hope you could help me.

I think you are mixing up some words here. You say you have a database with 4 columns when a database doesn't have columns. A table has columns. — judda
– judda, Commented Mar 25, 2013 at 4:19

Handy Manny · Accepted Answer · 2013-03-25 04:34:20Z

1

Did you check the letters uppercase and lowercase in table columns?

answered Mar 25, 2013 at 4:34

Handy Manny

3881 gold badge5 silver badges20 bronze badges

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

Comments

Helto · Accepted Answer · 2013-03-25 04:19:25Z

1

You have inventory in your code, but in your question you named the table products, Is it this simple?

answered Mar 25, 2013 at 4:19

Helto

6251 gold badge6 silver badges17 bronze badges

Comments

Ryan Knopp · Accepted Answer · 2013-03-25 04:19:08Z

0

echo $row['item']. "<br>";

What is 'item'? Shouldn't you be selecting them by $row[0] or $row['products'].. or one of your other columns.

answered Mar 25, 2013 at 4:19

Ryan Knopp

6121 gold badge5 silver badges12 bronze badges

Comments

syrkull · Accepted Answer · 2013-03-25 04:28:05Z

0

check your variables, for your example, try renaming your vairable $sql to something else, because you might have a similar variable somewhere in your code that you did not show.

try this :

<?php

$db = mysqli_connect("localhost","root","", "prodpurchase");
if (!$db) {
die('Could not connect: ' . mysqli_error());
}

$sqlstackoverflow = mysqli_query($db, "select * from user");
if($sqlstackoverflow === FALSE ) {
  die('Query failed returning error: '. mysqli_error());
} else {
   while($row=mysqli_fetch_array($sqlstackoverflow))
   {
    echo $row['username']. "<br>";
   }
}
?>

edited Mar 25, 2013 at 4:28

answered Mar 25, 2013 at 4:21

syrkull

2,3846 gold badges37 silver badges68 bronze badges

1 Comment

syrkull Over a year ago

@scarface23 Thank you for the reply, but I will leave my answer as it is because sometimes this could be the solution.

judda · Accepted Answer · 2013-03-25 04:28:09Z

0

Your code references an inventory table but you said your database has a products table (and no inventory table). Because of this, the query is failing.

answered Mar 25, 2013 at 4:28

judda

3,9721 gold badge27 silver badges27 bronze badges

1 Comment

judda Over a year ago

What is your query that is wrong? Is there any errors that are being emitted?

John Peter · Accepted Answer · 2013-03-25 04:38:04Z

0

Just Try With The Following :

<?php
$db = mysqli_connect("localhost","root","","prodpurchase");
if (!$db) {
die('Could not connect: ' . mysqli_error());
}
$sql = mysqli_query($db,"select * from user");
if( $sql === FALSE ) {
  die('Query failed returning error: '. mysqli_error());
} else {
   while($row=mysqli_fetch_array($sql,MYSQLI_ASSOC))
   {    
    echo $row['username']."<br>";    
   }
}
?>

I think this may help you to resolve your problem.

answered Mar 25, 2013 at 4:38

John Peter

2,9283 gold badges29 silver badges47 bronze badges

Collectives™ on Stack Overflow

php not displaying results on database

6 Answers 6

Comments

Comments

Comments

1 Comment

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

Comments

Comments

Comments

1 Comment

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest