Storing more than one data in the array variable

Question

I need some help with storing the data in the arrays. I have got a problem with the arrays variable $_SESSION, because it will only allow me to store one data at a time which it have overwritten the data.

When I try this:

$link = mysqli_connect('localhost', 'mydbusername', 'mydbpassword', 'mydbname');
$campaign_db = "SELECT campaign_name FROM campaign WHERE username = 'myusername'";

if($stmt = mysqli_prepare($link, $campaign_db))
{
    // Set parameters
    $param_username = $_SESSION['username'];

    // Attempt to execute the prepared statement
    if(mysqli_stmt_execute($stmt))
    {
        // Bind variables to the prepared statement as parameters
        mysqli_stmt_execute($stmt);

        $results = mysqli_stmt_get_result($stmt);

        while ($rows = mysqli_fetch_array($results, MYSQLI_NUM))
        {
            foreach ($rows as $campaign)
            {
                $_SESSION['campaign'] = $campaign;
            }
        }
    }
    print_r($_SESSION);
    // Close statement
    mysqli_stmt_close($stmt);

}

I will only get this:

Array
(
    [campaign] => facebook
)

It should be:

Array 
( 
    [campaign] => somename [campaign] => youtube [campaign] => google [campaign] => linkedlin [campaign] => bing [campaign] => facebook 
)

I have tried this:

$_SESSION['campaign'][] = $campaign;

It give me an error: Fatal error: Uncaught Error: [] operator not supported for strings. Stack trace: #0 {main} thrown.

Can you please show me an example how I can insert and store more than 1 data in the array for the variable $_SESSION?

EDIT: When I try this:

while ($rows = mysqli_fetch_array($results, MYSQLI_NUM))
{
    $_SESSION['campaign'] = array($rows);
)

And I have also try this:

while ($rows = mysqli_fetch_array($results, MYSQLI_NUM))
{
    foreach ($rows as $campaign)
    {
        $_SESSION['campaign'] = array($campaign);
    }
)

It still give me this:

 [campaign] => Array
    (
        [0] => facebook
    )

your "It should be:" is not a valid array, keys must be unique — user10226920
– user10226920, Commented Dec 4, 2018 at 21:18
I have tried it but it give me this [0] => facebook when i tried this $_SESSION['campaign'] = array($campaign); — Robert Jones
– Robert Jones, Commented Dec 4, 2018 at 21:30
This code is open to sql injection. Using prepare() doesn't constitute as a "prepared statement" per se; you should use one. — Funk Forty Niner
– Funk Forty Niner, Commented Dec 4, 2018 at 21:32

Nick · Accepted Answer · 2018-12-04 21:18:29Z

1

You must have initialised $_SESSION['campaign'] to a string somewhere in your code. Wherever you did that you need to change it to

$_SESSION['campaign'] = array('string value')

or if it's an empty string then just use array() and then you will be able to use

$_SESSION['campaign'][] = $campaign;

in your loop.

answered Dec 4, 2018 at 21:18

Nick

147k23 gold badges67 silver badges106 bronze badges

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

3 Comments

Robert Jones Over a year ago

thank you for this, but when I try this in the loop: $_SESSION['campaign'] = array($campaign);, it give me this [0] => facebook. Any idea?

Nick Over a year ago

@RobertJones you need to use $_SESSION['campaign'] = array(); outside the loop, then inside the loop you would use $_SESSION['campaign'][] = $campaign;

Robert Jones Over a year ago

Oh I didn't realised that I need to use $_SESSION['campaign'] = array(); outside the loop so when I insert the $_SESSION['campaign'][] = $campaign; inside the loop, it works great. Thank you very much for your help so problem are now resolved.

Collectives™ on Stack Overflow

Storing more than one data in the array variable

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