Simple loop not displaying data

Question

This is puzzling the hell out of me .. Simple fetch & loop isn't displaying any data There is data in the table as displaying the result outside the loop returns data

$dbc = mysqli_connect($dbh, $dbu, $dbp, $dbn);
$query = mysqli_query($dbc,"SELECT * FROM `products`");
$res = mysqli_fetch_assoc($query);
$rows = array();
do {
    $rows[] = $res['product'];

}while($res = mysqli_fetch_assoc($query)) ;
$data = json_encode($rows);
echo $data;
echo mysqli_error($dbc);

ADDED :

returns the data in the array

<pre>Array
(
    [ID] => 1
    [list_name] => Dry Fruits
    [cat] => Dry Fruits and Nuts
    [item_code] => 1049
    [pack_style] => 106
    [packstyle_active] => Y
    [style_desc] => Stabilo250
    [system_wt] => 0.25
    [weight_desc] => 250gm
    [declared_weight] => 0.25
    [declared_weight_desc] => 250gm
    [uom] => gm
    [qty_in_case] => 1
    [case_size] => 1 x 250gm
    [product] => Almond Sliced
    [weight_code] => 126
    [qty_code] => 00
    [product_code] => 1049-106-126-00
    [barcode] => 502185878567
    [barcode13] => 5021858785678
    [sequence_no] => 78567
    [sage_code] => 104978567
    [active] => N
    [allergen] => Y
    [origin] => Various
    [density] => 0
    [processtype] => PT32
    [processed_by] => FGS
    [Industrial] => N
    [Catering] => N
    [RetailEthnic] => Y
    [RetailMainstream] => N
    [Website] => N
    [Special] => N
    [zohoitemcode] => 1540890000001353073
)

So I think its an issue with the json_encode.. maybe

    print_r($rows) 
    Array
   (
    [0] => Almond Sliced
    [1] => Almond Sliced
    [2] => Almond Sliced
    [3] => Almond Sliced
    [4] => Almond Sliced
    [5] => Almond Sliced
    [6] => Almond Sliced
    [7] => Almond Sliced
    [8] => Almond Sliced
    [9] => Almond Sliced
    [10] => Almond Sliced
    [11] => Almond Sliced
    [12] => Almond Sliced
    [13] => Almond Sliced
    [14] => Almond Sliced
    [15] => Almond Sliced
    )

There is over 36000 records of products

`$res` does exist inside loop because it is declared in line 3. — Atal Prateek, Dec 11 '18 at 09:26
Doesn't `$rows[] = $res['product']` create a numerical index? Your `print_r($rows)` output doesn't look like that. How can that `print_r` be the result of your loop? — D.Go, Dec 11 '18 at 09:46
sorry that was the output form something someone requested i just forgot to remove the print_r reference — Chris Yates, Dec 11 '18 at 09:48
Are you getting any error because I tried your code and works perfectly. — Atal Prateek, Dec 11 '18 at 09:50
thats the annoying thing .. no errors whatsoever If i do a print_r($rows) I get every product listed , Thats why I think it might be something wrong with the json_encode — Chris Yates, Dec 11 '18 at 09:52
nope for a script to pass into zoho.. but there is nothing else on this page at all which could be causing it to behave like this — Chris Yates, Dec 11 '18 at 10:00
ive been running this with limit 3000 while ive been doing all the tests — Chris Yates, Dec 11 '18 at 10:05

Joseph_J · Accepted Answer · 2018-12-11T10:21:08.230

2

This appeared to be a strange encoding issue. Added a line in the while loop to force the encoding to UTF-8.

$dbc = mysqli_connect($dbh, $dbu, $dbp, $dbn);
$query = "SELECT * FROM `products`";
$stmt = $dbc->prepare($query);
$stmt->execute();
$results = $stmt->get_result();

while($res = $results->fetch_assoc()){

  $rows[] = mb_convert_encoding($res['product'], 'UTF-8', 'UTF-8');

}

echo '<pre>';
print_r($rows);
echo '</pre>';

$data = json_encode($rows);
echo $data;

echo mysqli_error($dbc);

edited Dec 11 '18 at 10:21

answered Dec 11 '18 at 09:22

Joseph_J

3,654
2
13
22

still the same @Joseph_J – Chris Yates Dec 11 '18 at 09:35
It appears that your query is only returning 1 product. – Joseph_J Dec 11 '18 at 09:37
Yeah which is annoying because there are 36000 records If i do a simple echo $res['product']; inside the do while loop it returns them all – Chris Yates Dec 11 '18 at 09:39
See Updated answer. – Joseph_J Dec 11 '18 at 09:47
just got null returned – Chris Yates Dec 11 '18 at 09:49
`$data = json_encode($res)` is encoding `$res` when it's false. You must have meant to encode `$rows`. – D.Go Dec 11 '18 at 09:53
Yeah I spotted that and changed to $rows in my code – Chris Yates Dec 11 '18 at 09:53
@D.Go Thanks for pointing that out. Updated... Did that fix it for ya? – Joseph_J Dec 11 '18 at 09:54
nope .. I spotted your error and used $rows in my code.. still same issue – Chris Yates Dec 11 '18 at 09:57
So print_r($rows) is displaying the information correctly? – Joseph_J Dec 11 '18 at 10:00
yep as many records as I want it to using LIMIT will post snippet of results above – Chris Yates Dec 11 '18 at 10:01
So what is the problem then? If `$rows` is printing out ok then you have your data. What does the `echo $data;` produce for you. – Joseph_J Dec 11 '18 at 10:03
Let us [continue this discussion in chat](https://chat.stackoverflow.com/rooms/185057/discussion-between-joseph-j-and-chris-yates). – Joseph_J Dec 11 '18 at 10:05
echo $data doesnt seem to be doing anything .. I need the data json encoded – Chris Yates Dec 11 '18 at 10:06
1

cheers :) stupid encoding issue .. – Chris Yates Dec 11 '18 at 10:21

oreopot · Answer 2 · 2018-12-11T09:38:57.210

0

Try change your loop to the following:

foreach($res as $val) {
    $rows[] = $val['product'];
}

Moreover, if it still doesn't work. then:

echo "<pre>";
print_($res);
die();

and please post the output.

Edit: 1

You don't need foreach loop.

you can directly do:

$data = json_encode($res);
echo $data;

edited Dec 11 '18 at 09:38

answered Dec 11 '18 at 09:19

oreopot

3,392
2
19
28

Am getting Warning: Illegal string offset 'product' in line 21 thats the $rows[] = $val['product']; line. Will try your last suggestion now – Chris Yates Dec 11 '18 at 09:23
You are getting it because you don't have a key named `product` in your array. – oreopot Dec 11 '18 at 09:24
have just added the output you requested – Chris Yates Dec 11 '18 at 09:29
did you try the changes I updated in answer? – oreopot Dec 11 '18 at 09:32
yeah the last suggestion you made just outputted 1 product – Chris Yates Dec 11 '18 at 09:33
I have changed foreach loop. Try it. – oreopot Dec 11 '18 at 09:39
still the Illegal string offset 'product' error – Chris Yates Dec 11 '18 at 09:40
`foreach` loop will not work because `$res` contains only one row. – Atal Prateek Dec 11 '18 at 09:42

Simple loop not displaying data

2 Answers2