mysqli_fetch_array is not returning anything

Question

I have checked my Sql statement in the phpMyAdmin and it returns multiple results but when i run it as a php script it doesn't return anything. Can anyone please tell me what mistake i'm making?

<?php 
require "conn.php";
/*$sqlQry = $_POST["sqlQry"];*/

$sqlQry = "SELECT bad.id, Name, Address, Latitude, Longitude, AvAge FROM baraddresses bad inner join barlivedata bld on bad.id = bld.id inner join bar_data bdt on bdt.id = bad.id";

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

$json = array();
while ($row = mysqli_fetch_array($result , MYSQL_NUM)){
$json[] = array('id' => $row[0], 
        'Name' => $row[1],
        'Address' => $row[2],
        'Latitude'=> $row[3],
        'Longitude' => $row[4],         
        'AvAge' => $row[5]          
            );
}

$jsonstring = json_encode($json);
    echo $jsonstring; 

?>

Conn.php

<?php

/* This file allows you to connect to a database */


$db_name = "bdata";
$mysql_username = "root";
$mysql_password = "" ;
$server_name = "localhost";
$conn = mysqli_connect($server_name , $mysql_username , $mysql_password , $db_name  );

/*
if($conn){
echo "true";
} 
*/

?>

@Gurchani can you please add this if (mysqli_num_rows($result) > 0) { then your while loop}else{echo "No results} — Masivuye Cokile
– Masivuye Cokile, Commented May 8, 2017 at 9:04

Death-is-the-real-truth · Accepted Answer · 2017-05-08 09:34:51Z

2

Change you code like below and check once:-

conn.php (check file name and correct yourself):-

<?php
    //comment these two lines when everything started working fine
    error_reporting(E_ALL);
    ini_set('display_errors',1);

    $db_name = "bdata";
    $mysql_username = "root";
    $mysql_password = "" ;
    $server_name = "localhost";
    $conn = mysqli_connect($server_name , $mysql_username , $mysql_password , $db_name  );

    if(!$conn){
      echo "connection error:-".mysqli_connect_error();
    }
?>

And other page:-

<?php
    //comment these two lines when everything started working fine
    error_reporting(E_ALL);
    ini_set('display_errors',1);
    require "conn.php";

    $sqlQry = "SELECT bad.id, bad.Name, bad.Address, bad.Latitude, bad.Longitude, bad.AvAge FROM baraddresses bad JOIN barlivedata bld on bad.id = bld.id JOIN bar_data bdt on bdt.id = bad.id";

    $result = mysqli_query($conn ,$sqlQry) or die(mysqli_error($conn));

    $json = array();
    if(mysqli_num_rows($result)>0){
       /* Either use this */
        while ($row = mysqli_fetch_assoc($result)){
            $json[] = array('id'=>$row['id'],'Name'=>$row['Name'],'Address'=>$row['Address'],'Latitude'=>$row['Latitude'],'Longitude'=>$row['Longitude'],'AvAge'=>$row['AvAge']);
        }
        /* Or use this

        $json = mysqli_fetch_all($result,MYSQLI_ASSOC);

        mysqli_free_result($result); */

        mysqli_close($conn);

        echo "<pre/>";print_r($json);

        $jsonstring = json_encode($json);

        echo $jsonstring; 
    }else{
      die('No record exist');
    }
?>

edited May 8, 2017 at 9:34

answered May 8, 2017 at 9:15

Death-is-the-real-truth

72.3k10 gold badges59 silver badges105 bronze badges

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

3 Comments

hassan Over a year ago

why not to use simply mysqli_fetch_all, as long as the OP is filling a new array with the same database columns names?

Death-is-the-real-truth Over a year ago

@hassan added that

Death-is-the-real-truth Over a year ago

@Gurchani glad to help you :):)

Death-is-the-real-truth · Accepted Answer · 2017-05-08 09:39:44Z

2

Change MYSQL_NUM to MYSQLI_NUM;-

while ($row = mysqli_fetch_array($result , MYSQLI_NUM)){


}

edited May 8, 2017 at 9:39

Death-is-the-real-truth

72.3k10 gold badges59 silver badges105 bronze badges

answered May 8, 2017 at 8:51

Arun Kumaresh

6,2966 gold badges36 silver badges50 bronze badges

8 Comments

Death-is-the-real-truth Over a year ago

you have enough reputation to put it as a comment

Death-is-the-real-truth Over a year ago

@Gurchani do echo $sqlQry;die(); and copy and paste that query directly to phpmyadmin and check anything returned or not?

Gurchani Over a year ago

I have pasted it directed in phpmy admin and it does return results there but when i run it in this code it doesnt return anything.

Death-is-the-real-truth Over a year ago

@Gurchani can you please add conn.php code too in your question

Masivuye Cokile Over a year ago

@ArunKumaresh what makes u think its him?

|

Collectives™ on Stack Overflow

mysqli_fetch_array is not returning anything

2 Answers 2

3 Comments

8 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

8 Comments

Your Answer

Sign up or log in

Post as a guest

Related