Add mysql row to existing array

Question

I have an existing array, and I want to add some items in it from a mysql row

        $extendedadmindetails = full_query("SELECT * FROM `tbladmins` WHERE `id`='{$_SESSION['adminid']}'");
        $extendedadmindetailsrow = mysql_fetch_assoc ($extendedadmindetails);

        array_push($apiresults, $extendedadmindetailsrow);

This returns an array in an array:

 Array
(
    [result] => success
    [adminid] => 1
    [name] => My Name
    [notes] => 
    [signature] => 
    [allowedpermissions] => My Name
    [departments] => 1
    [requesttime] => 2017-02-26 12:44:06
    [0] => Array
        (
            [id] => 1
            [uuid] => sqdqsdqsdqsdq454
            [roleid] => 1
            [username] => Myname
            [password] => $dfsdfsdfsdfsdfsdfsdfsdfsdfsdfsdfsdf
            [passwordhash] => $jghjghjghjghjghjghjghjghjg                
            [updated_at] => 0000-00-00 00:00:00
        )

)

while I need:

 Array
(
    [result] => success
    [adminid] => 1
    [name] => My Name
    [notes] => 
    [signature] => 
    [allowedpermissions] => My Name
    [departments] => 1
    [requesttime] => 2017-02-26 12:44:06
    [id] => 1
    [uuid] => sqdqsdqsdqsdq454
    [roleid] => 1
    [username] => Myname
    [password] => $dfsdfsdfsdfsdfsdfsdfsdfsdfsdfsdfsdf
    [passwordhash] => $jghjghjghjghjghjghjghjghjg        
    [updated_at] => 0000-00-00 00:00:00


)

I believe I should use array_push to add to an existing array, but I'm not sure how to proceed from there. Do I need to loop trough the extendedadmindetailsrow array and add items 1 by 1? Any one can help me out with this?

Thanks!!

Naincy · Accepted Answer · 2017-02-26 12:03:07Z

2

use of array_merge is better in case

// Considering your mysql is returning only 1 row
foreach ($extendedadmindetailsrow as $key => $row) {
  $arr = $row;
}

// after this if you will try array_push also that will work
$result = array_merge($apiresults, $arr);
print_r($result);

answered Feb 26, 2017 at 12:03

Naincy

2,9431 gold badge15 silver badges21 bronze badges

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

Comments

Daniel Phillips · Accepted Answer · 2017-02-26 12:01:41Z

2

Take a look at array_merge

array_merge($apiresults, $extendedadmindetailsrow);

answered Feb 26, 2017 at 12:01

Daniel Phillips

213 bronze badges

Comments

Qirel · Accepted Answer · 2017-02-26 12:48:34Z

2

You can:

$result = $apiresults + $extendedadmindetailsrow;

edited Feb 26, 2017 at 12:48

Qirel

26.6k7 gold badges54 silver badges71 bronze badges

answered Feb 26, 2017 at 12:08

Shaun

4907 silver badges18 bronze badges

Comments

Qirel · Accepted Answer · 2017-02-26 12:50:02Z

1

Use array_merge()

$a1=array("red","green");
$a2=array("blue","yellow");
print_r(array_merge($a1,$a2));

Output will be

Array ( 
    [0] => red 
    [1] => green
    [2] => blue
    [3] => yellow
)

edited Feb 26, 2017 at 12:50

Qirel

26.6k7 gold badges54 silver badges71 bronze badges

answered Feb 26, 2017 at 12:00

ANIK ISLAM SHOJIB

3,3383 gold badges31 silver badges48 bronze badges

Collectives™ on Stack Overflow

Add mysql row to existing array

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related