Store Session Array in Database

Question

I have the array-ed session....

$_SESSION['Names'] = array (11,15,26);
$_SESSION['Location'] = array (35,42,10);

and I want to store them in my database...

$que = "Insert into tblpeople (DateTimePosted, first, second, third) VALUES(now(),'$_SESSION['Names'][0], $_SESSION['Location'][0])','$_SESSION['Names'][1], $_SESSION['Location'][1])','$_SESSION['Names'][2], $_SESSION['Location'][2])')";
$exec = mysql_query($que);

After Saving, my database (tblpeople) shows the following values:

DateTimePosted: 2014-01-03 16:23:02

first: Array[0],Array[0]

second: Array[1],Array[1]

third: Array[2],Array[2]

Instead, I want my output to be...

DateTimePosted: 2014-01-03 16:23:02

first: 11,35

second: 15,42

third: 26,10

What's wrong?

Answer 1

To expand multidimensional arrays in a string, you need to wrap them in curly braces:

$que = "Insert into tblpeople (DateTimePosted, first, second, third)
        VALUES(now(),
               '{$_SESSION['Names'][0]}, {$_SESSION['Location'][0]}',
               '{$_SESSION['Names'][1]}, {$_SESSION['Location'][1]}',
               '{$_SESSION['Names'][2]}, {$_SESSION['Location'][2]}')";

You also had some extra parentheses in the values.

However, this seems like a pretty strange way to store data into a database. Why do you have two values separated by commas in each column, rather than splitting each into separate columns? And why are you storing array elements into different columns, rather than using separate tables with each value in a row?

Answer 2

use this function

$x=serialize($_SESSION['Names']);

it return a string that you can save any where

and this function reverse it

$_SESSION['Names']=unserialize($x);

Answer 3

Try this

<?php
session_start();
$_SESSION['Names'] = array (11,15,26);
$_SESSION['Location'] = array (35,42,10);


$refNumbers = $_SESSION['Names'];
$partIds = $_SESSION['Location'];



$combined = array();

foreach($refNumbers as $index => $refNumber) {
    if(!array_key_exists($index, $partIds)) {
        throw OutOfBoundsException();
    }

    $combined[] = array(
        'Names'  => $refNumber,
        'Location' => $partIds[$index]
    );
}

print_r($combined);

$combine1 = implode(",",$combined[0]);
$combine2 = implode(",",$combined[1]);
$combine3 = implode(",",$combined[2]);



$que = "insert into tblpeople (DateTimePosted, first, second, third) VALUES(now(),'$combine1','$combine2','$combine3')";
//$exec = mysql_query($que);

?>