Unable to insert a string into array

Question

I have this accepted answer working well, where column 1 and column 2 are setup as varchar. When I insert a string into the form however it doesn't insert data into my database. I know that this is because I don't have quotation marks eg "value" around my string but I don't know how to handle this in php? Does anyone have any ideas here?

Niet the Dark Absol · Accepted Answer · 2012-07-14 00:47:42Z

3

Erm... just type " around the values?

 $sql2 .= '("' .$_POST['column1'][$i] . '", "' . $_POST['column2'][$i] . '")';

answered Jul 14, 2012 at 0:47

Niet the Dark Absol

326k86 gold badges480 silver badges604 bronze badges

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

1 Comment

ak85 Over a year ago

Yes that works thanks. I knew it would be something like that, I tried putting "" in other places around the $_POST['column1'][$i] but I couldn't quite get the syntax right. thanks!

Collectives™ on Stack Overflow

Unable to insert a string into array

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related