How to get entire column from database and store it in an array using php? [duplicate]

Question

My table's name is userdetails, it has four attributes named name, username, mobile and password. I want to get all the mobile numbers and store it in an array using php. I have used the following php code

if($_SERVER['REQUEST_METHOD']=='GET'){
require_once('dbConnect.php');
$mobile  = $_GET['mobile'];
$sql = "SELECT MOBILE FROM USERDETAILS";

 $r = mysqli_query($con,$sql);

 $res = mysqli_fetch_array($r);

 $result = array();

 array_push($result,array(
 "MOBILE"=>$res['MOBILE']
 )
);

echo json_encode(array("result"=>$result));

mysqli_close($con);

  }

but all I am getting is the first entry of the database. Please help.

Osama Sayed · Accepted Answer · 2016-06-22 05:18:03Z

1

You should loop through the records by doing the following:

$result = [];
while ($array = mysqli_fetch_array($r)) {
    $result[] = $array['MOBILE'];
}
echo json_encode($result);

answered Jun 22, 2016 at 5:18

Osama Sayed

2,03316 silver badges16 bronze badges

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

Comments

Saty · Accepted Answer · 2016-06-22 05:16:03Z

0

For getting all number of column use while loop as

 $jsonData = array();// initialized you array
    while ($array = mysqli_fetch_array($r,MYSQLI_ASSOC)) {// add MYSQLI_ASSOC to get associative array
        $jsonData[] = $res['MOBILE'];// store data into array
    }
    echo json_encode($jsonData);// convert in into json

answered Jun 22, 2016 at 5:16

Saty

22.5k7 gold badges35 silver badges52 bronze badges

Comments

Ani Menon · Accepted Answer · 2016-06-22 05:17:35Z

0

Try this:

$result = mysqli_query($con,$sql);
$mob = Array();
while ($row = mysqli_fetch_array($result,MYSQLI_ASSOC)) {
    $mob[] =  $row['MOBILE'];  
}

answered Jun 22, 2016 at 5:17

Ani Menon

28.4k17 gold badges111 silver badges128 bronze badges

Collectives™ on Stack Overflow

How to get entire column from database and store it in an array using php? [duplicate]

3 Answers 3

Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Linked

Related