How to store while loop result to array using php

Question

I have a mysql query which is return matching data from db. I need to store matching results data to $autocompletiondata like that :

$autocompletiondata =  array(
        1 => "shibbir",
        2 => "ahmed",
        3 => "babu",
        4 => "rahim",
        5 => "shakil",
);

Sql query :

$sql = mysqli_query($link, "SELECT cdid, family_name FROM contact_details WHERE     
family_name LIKE '%$term' ");

while($res = mysqli_fetch_array($sql)){
    $cdid = $res['cdid'];
    $fname = $res['family_name'];    
    $autocompletiondata =  array(
        $cdid => "$fname");
}

How can I store all matching data to associative array ? Plz help.

have a look at array_push php.net/manual/en/function.array-push.php — haxxxton
– haxxxton, Commented Jan 13, 2015 at 7:42

Minh Quy · Accepted Answer · 2015-01-13 07:42:13Z

3

Can you try this?

$autocompletiondata = array();

while($res = mysqli_fetch_array($sql)){
    $cdid = $res['cdid'];
    $fname = $res['family_name'];    
    $autocompletiondata[$cdid] =  $fname;
}

answered Jan 13, 2015 at 7:42

Minh Quy

6655 silver badges21 bronze badges

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

Comments

Lepanto · Accepted Answer · 2015-01-13 07:42:44Z

0

while($res = mysqli_fetch_array($sql)){
  $cdid = $res['cdid'];
  $fname = $res['family_name'];    
  $autocompletiondata[$cdid] = $fname; // <== make this change to your code
}

answered Jan 13, 2015 at 7:42

Lepanto

1,3981 gold badge8 silver badges15 bronze badges

Comments

rasso · Accepted Answer · 2015-01-13 07:43:01Z

0

Try this

$sql = mysqli_query($link, "SELECT cdid, family_name FROM contact_details WHERE     
family_name LIKE '%$term' ");

while($res = mysqli_fetch_array($sql)){
    $cdid = $res['cdid'];
    $fname = $res['family_name'];    
    $autocompletiondata[$cdid] = $fname;
}

And print the array with

print_r($autocompletiondata);

answered Jan 13, 2015 at 7:43

rasso

2,2213 gold badges23 silver badges27 bronze badges

Comments

Utkarsh Dixit · Accepted Answer · 2015-01-13 07:43:46Z

0

Its simple just use the code below

$autocompletiondata =  array();
$sql = mysqli_query($link, "SELECT cdid, family_name FROM contact_details WHERE     
family_name LIKE '%$term' ");

while($res = mysqli_fetch_array($sql)){
    $cdid = $res['cdid'];
    $fname = $res['family_name'];    
    $autocompletiondata[$cdid] = $fname;
}

Hope this helps you

answered Jan 13, 2015 at 7:43

Utkarsh Dixit

4,2853 gold badges18 silver badges42 bronze badges

Comments

AuZu · Accepted Answer · 2015-01-13 07:44:52Z

0

Just set data to $autocompletiondata:

$autocompletiondata = array();
while($res = mysqli_fetch_array($sql)){
    $cdid = $res['cdid'];
    $fname = $res['family_name'];    
    $autocompletiondata [$cdid] = $fname;
}

answered Jan 13, 2015 at 7:44

AuZu

9012 bronze badges

Collectives™ on Stack Overflow

How to store while loop result to array using php

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related