Only single row is getting fetched from phpmyadmin table using php

Question

I' m using the following code to get the desired details,that is, all the books that have the highest total count in order to show the most trending/popular books present in a website. The total column depicts the no. of times a particular book had been viewed by an user of the website. Here is the code`

<?php    
include("connection.php");
global $con;
$sql1= "SELECT book FROM vi_views ORDER BY total DESC LIMIT 3";
$query1= mysqli_query($con,$sql1);
if (!$query1)
{
  printf("Error: %s\n", mysqli_error($con));
  exit();
}
$obj1=mysqli_fetch_array($query1,MYSQLI_BOTH);
$row1=mysqli_num_rows($query1);
if ($row1>0)
{
  echo var_dump($obj1);
}
?>

Here is a look of how my table looks

Table:vi_views

id  book  course  date  total

1   book1  null  dd//mm/yy 3   
2   null   course1 dd/mm/yy 1    
3  book2   null dd/mm/yy 8

and so on....

The problem is that the query is working but only the first record according to the query is shown, that is, book2 in this case and no more books are showing. where I'm lacking in my code please tell...

people are trying to help you with answers but you not active — Masivuye Cokile, Feb 27 '17 at 10:06
Possible duplicate of [PHP MYSQLI num rows returning 0](http://stackoverflow.com/questions/5016253/php-mysqli-num-rows-returning-0) — Masivuye Cokile, Feb 27 '17 at 10:08

score 1 · Answer 1 · answered Feb 27 '17 at 09:18

You need to loop though the rows returned after execution of query.

$rowCount=mysqli_num_rows($query1);
if ($rowCount > 0)
{
  while ($row = mysql_fetch_array($result)) {
    echo var_dump($row);  // Can do something what you want to with data
  }
} else {
  echo 'No records';
}

score 0 · Answer 2 · answered Feb 27 '17 at 09:18

0

Change $obj1=mysqli_fetch_array($query1,MYSQLI_BOTH); to while($row = mysqli_fetch_array($query1)){ //do stuff } With fetch array you get only one row at the time

answered Feb 27 '17 at 09:18

Bojan Radaković

430
3
12

NID · Accepted Answer · 2017-02-27T13:27:54.200

0

Try this:

$sql1= "SELECT book FROM vi_views ORDER BY total DESC LIMIT 3";
$query1= mysqli_query($con,$sql1);

while ($row = mysqli_fetch_assoc($query1)) {
    print_r($row);
}

or

   while ($row = mysqli_fetch_assoc($query1)) {
    //print_r($row);
    $book=$row['book'];echo "<br/>";
    echo $book;
}

output:

book1

book2

book3

edited Feb 27 '17 at 13:27

answered Feb 27 '17 at 09:20

NID

3,238
1
17
28

Sorry but it's showing Fatal error: Uncaught Error: Call to undefined function mysql_fetch_assoc() – Swapnil Chaudhuri Feb 27 '17 at 11:41
use mysqli_fetch_assoc. – NID Feb 27 '17 at 11:43
mysql_* functions have been removed in PHP7 – NID Feb 27 '17 at 11:44
code running but is there any other way out rather than using print_r function as i need to show individual results of the array in different
tags out in my website
– Swapnil Chaudhuri Feb 27 '17 at 12:13
i used list($book1, $book2)=$row['book']; echo $book1."
".$book2; but the page is blank..not showing any errors or results – Swapnil Chaudhuri Feb 27 '17 at 12:19
your updated answer is printing all values of that particular column at a time, however, i want that the result get store in some kind of array variable or list() such that i can print only individual result i want to...is it possible? plzz help me out – Swapnil Chaudhuri Feb 27 '17 at 12:59

score 0 · Answer 4 · edited Feb 27 '17 at 09:33

0

Please try this:

$obj1 = mysqli_fetch_array($query1,MYSQLI_BOTH);
while($row = mysqli_fetch_assoc($query1)){
  $book=$row['book'];
  echo var_dump($book);
}

edited Feb 27 '17 at 09:33

jww

97,681
90
411
885

answered Feb 27 '17 at 09:24

Jimm

1
1

score 0 · Answer 5 · answered Feb 27 '17 at 10:03

0

You should loop the result.

$rowCount=mysqli_num_rows($query1);
if ($rowCount > 0)
{
  while ($row = mysql_fetch_assoc($result)) {
  echo "<pre>";
  print_r($row);
  echo "</pre>";
}

answered Feb 27 '17 at 10:03

Salehin Rafi

351
2
6
16

Only single row is getting fetched from phpmyadmin table using php

5 Answers5