add key=>value pair to associative array in php While loop

Question

I create a simple associative array in a WHILE loop. The key is the field name and the value is a Unix timestamp. I would like to add to this array a new key=>value pair 'Date"=>format the Unix timestamp, json_encode the array and return it to a JQ script in an Ajax call. The array looks like this:

Array 
  ( [0] => Array 
    ( [Post_timestamp] => 1370876787 ) [Date] => 2013 06 10 )

However, shouldn't it look like this:

Array 
  ( [0] => Array ( [Post_timestamp] => 1370876787 [Date] => 2013 06 10))

I guess my question is "how do I create the array so that the formatted timestamp and the raw timestamp are a single record"? Right now, it appears as if they are two records.

PHP

$query = "SELECT Post_timestamp FROM Comments LIMIT 1";
$result = mysqli_query($dbc, $query);

while ($rows = mysqli_fetch_assoc($result)) {
    $array[] = $rows;
    $array['Date'] = date("Y m d", $rows['Post_timestamp']);
}

Orangepill · Accepted Answer · 2013-07-29 21:21:49Z

4

The problem is you have two different values into the array, what you need to do is push an array that contains both values. This should get you what you want.

$query = "SELECT Post_timestamp FROM Comments LIMIT 1";
$result=mysqli_query($dbc,$query);
while ($rows = mysqli_fetch_assoc($result)) {

    $rows["Date"] = date("Y m d",$rows['Post_timestamp']);
    $array[] = $rows;   
}

answered Jul 29, 2013 at 21:21

Orangepill

24.7k3 gold badges44 silver badges64 bronze badges

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

3 Comments

user2232681 Over a year ago

That seems to just change the order of the resultArray ( [Date] => 2013 06 10 [0] => Array ( [Post_timestamp] => 1370876787 ) )

Orangepill Over a year ago

are you sure you didn't miscopy $rows["Date"] = date(... as $array["Date"] = date(...

user2232681 Over a year ago

yes I did! when I saw your answer I thought right away, that's the answer, and when it didn't work I didn't understand. So simple. Big help.

Collectives™ on Stack Overflow

add key=>value pair to associative array in php While loop

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related