json encode 2 dimensional array

Question

I have this PHP code :

$sql = read_sql( 'SELECT * FROM ges_messagerie_mess WHERE id_channel = ' . $_POST["idconv"] . ' AND id_private = ' . $_POST["idprive"] . ' AND iduser != ' . $_SESSION['compte'] . ' AND statut = 1 ORDER BY datecreation ASC' );

if ( $sql ) {
    foreach ( $sql as $message ) {
        $datemessage         = utf8_encode( strftime( "%d %b %Y", strtotime( $message["datecreation"] ) ) );
        $data['datemessage'] = $datemessage;

        $heureTicket          = utf8_encode( strftime( "%H:%M", strtotime( $message["datecreation"] ) ) );
        $data['heuremessage'] = $heureTicket;

        $data['success'] = nl2br( $message["message_user"] );

        $data['logo'] = getLogo( $message["idbase"] );

    }
}

 echo json_encode( $my2dimensionalArrayHere );

but i'm looking how to create an array with 2 dimensions to send to my AJAX call ! And then in the Ajax part, how do i get to the data with my 2 dimensional array ?

Thanks a lot for your help :)

Syscall · Accepted Answer · 2018-05-09 21:14:05Z

1

You could use the [] operator to push your $data array into the $my2dimensionalArray:

$my2dimensionalArray[] = $data;

The code could be:

$my2dimensionalArray = [];
if ( $sql ) {
    foreach ( $sql as $message ) {
        $datemessage         = utf8_encode( strftime( "%d %b %Y", strtotime( $message["datecreation"] ) ) );
        $data['datemessage'] = $datemessage;

        $heureTicket          = utf8_encode( strftime( "%H:%M", strtotime( $message["datecreation"] ) ) );
        $data['heuremessage'] = $heureTicket;

        $data['success'] = nl2br( $message["message_user"] );

        $data['logo'] = getLogo( $message["idbase"] );

        $my2dimensionalArray[] = $data;
    }
}
echo json_encode( $my2dimensionalArray );

output will look like:

[
 {"datemessage":"01 Jan 2018","heuremessage":"00:00","success":"success","logo":"logo"},
 {"datemessage":"01 Jan 2018","heuremessage":"00:00","success":"success","logo":"logo"},
 {"datemessage":"01 Jan 2018","heuremessage":"00:00","success":"success","logo":"logo"}
]

edited May 9, 2018 at 21:14

answered May 9, 2018 at 20:58

Syscall

19.8k10 gold badges44 silver badges60 bronze badges

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

1 Comment

Syscall Over a year ago

You're welcome @MatthieuRigaux :) Don't forget to close your question if an answer solves your problem. Thanks :) meta.stackexchange.com/questions/5234/…

Collectives™ on Stack Overflow

json encode 2 dimensional array

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related