Can't display SQL database table to PHP page

Question

I am trying to display a certain row of one of the tables in my database.

Here is my code for it:
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
} 
else printf("Connection Successful");

mysql_select_db('magento');
$query = "SELECT * FROM poll_answer"; 
$result = mysqli_query($query);


while($poll=mysqli_fetch_assoc($result)){
    echo "<tr>" .$poll['answer_title']. "</td>";
}

And here is my table:

+--------------+------------------+------+-----+---------+----------------+
| Field        | Type             | Null | Key | Default | Extra          |
+--------------+------------------+------+-----+---------+----------------+
| answer_id    | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| poll_id      | int(10) unsigned | NO   | MUL | 0       |                |
| answer_title | varchar(255)     | YES  |     | NULL    |                |
| votes_count  | int(10) unsigned | NO   |     | 0       |                |
| answer_order | smallint(6)      | NO   |     | 0       |                |
+--------------+------------------+------+-----+---------+----------------+

I cannot get to print anything but "Connection Successful"!

Can anyone tell me what is possibly wrong?

EDITED SQL to SQLI, still same problem

Sadikhasan · Accepted Answer · 2015-03-08 05:47:41Z

2

You are mixing mysql and mysqli

Change

$result = mysql_query($query);
while($poll=mysql_fetch_assoc($result)){

To

$result = mysqli_query($conn , $query);
while($poll=mysqli_fetch_assoc($result)){

Check Manual

edited Mar 8, 2015 at 5:47

answered Mar 8, 2015 at 5:30

Sadikhasan

18.6k23 gold badges84 silver badges126 bronze badges

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

2 Comments

shehzad_ucdavis Over a year ago

Did that, still nothing being displayed but connection successful!

Sadikhasan Over a year ago

Change $result = mysqli_query($query); to $result = mysqli_query($conn , $query);

shehzad_ucdavis · Accepted Answer · 2015-03-08 05:46:01Z

2

You have to $conn that is connection class object to mysqli_query.

$result = mysqli_query($conn,$query);

edited Mar 8, 2015 at 5:46

shehzad_ucdavis

1351 silver badge10 bronze badges

answered Mar 8, 2015 at 5:40

Kedar B

7845 gold badges19 silver badges47 bronze badges

1 Comment

shehzad_ucdavis Over a year ago

Yes! it was conn first and then query, as Sadikhasan stated

zacbrac · Accepted Answer · 2015-03-08 05:32:49Z

0

It could be because you're using both mysql and mysqli functions. Also, mysql is being deprecated soon, you might want to switch to PDO statements, it's fairly easy to setup, here's a tutorial that you could apply fairly quickly Link

answered Mar 8, 2015 at 5:32

zacbrac

355 bronze badges

Collectives™ on Stack Overflow

Can't display SQL database table to PHP page

3 Answers 3

2 Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related