How to insert PHP array into SQL database

Question

I'm trying to insert php array into sql database like this:

$i=1    
$sql="INSERT INTO table(itemname) VALUES ('$_SESSION[someVariable][$i]')";

however, the name in the database is always Array[1]. it is not the value contained in $_SESSION[someVariable][$i]

I wonder if there is anyway to declare this? I know I'm messing up with the quotes

What do you mean with i1? That is invalid syntax. You mean 'i1' or $i1 or something else? — trincot
– trincot, Commented Jan 10, 2016 at 22:34
Yes, but you put quotes. I don't see those in the question. That is why I asked. OK, I get it, it is the syntax where the quotes are around the whole expression. My bad. — trincot
– trincot, Commented Jan 10, 2016 at 22:39

Funk Forty Niner · Accepted Answer · 2016-01-10 23:00:20Z

7

If you embed array items in a string, make sure to embrace them in curly braces:

$sql="INSERT INTO table(itemname) VALUES ('{$_SESSION[$somevariable][$i]}')";

Alternatively, use string concatenation:

$sql="INSERT INTO table(itemname) VALUES ('" . $_SESSION[$somevariable][$i] . "')";

or a temporary variable:

$itemname = $_SESSION[$somevariable][$i];
$sql="INSERT INTO table(itemname) VALUES ('$itemname')";

PS, I've replaced i1 with $somevariable. You've changed it to somevariable after the discussion in comments, but being a variable, it needs a $, of course.

edited Jan 10, 2016 at 23:00

Funk Forty Niner

74.2k14 gold badges71 silver badges146 bronze badges

answered Jan 10, 2016 at 22:32

GolezTrol

116k19 gold badges186 silver badges215 bronze badges

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

1 Comment

weeo Over a year ago

Thank you! The curly braces are what I'm missing!

wogsland · Accepted Answer · 2016-01-10 22:32:21Z

3

You need curly brackets to use an array in a string:

$sql="INSERT INTO table(itemname) VALUES ('{$_SESSION[i1][$i]}')";

The reason you were getting Array[1] is because the array was being converted to a string Array and $i was 1.

answered Jan 10, 2016 at 22:32

wogsland

9,53121 gold badges63 silver badges99 bronze badges

Collectives™ on Stack Overflow

How to insert PHP array into SQL database

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related