Insert into sql, insert values within loop

Question

enter image description here

What is the right syntax for code above?

$_POST[firstname{$i}],  $_POST[firstname+$i], $_POST[firstname.$i]

I searched over and over again but I couldn't find any answer yet : /

How am I suppose to put the $i after those names?

you can use concat to put $i after those names. – Ronak K Jan 22 '14 at 10:42 — Ronak K, Jan 22 '14 at 10:42

score 1 · Answer 1 · answered Jan 22 '14 at 11:04

1

The correct syntax:

"... values ( ".$_POST['firstname'.$i]." ) ..."

answered Jan 22 '14 at 11:04

Alireza Fallah

4,609
3
31
57

score 0 · Answer 2 · answered Jan 22 '14 at 10:45

0

try this

 $firstname =  $_POST['firstname'.$i];

and user $firstname variable in your query

answered Jan 22 '14 at 10:45

Satish Sharma

9,547
6
29
51

score 0 · Answer 3 · edited May 23 '17 at 12:13

0

You cannot use array subscripts in a string like that. You'd have to write "{$_POST['firstname'.$i]}" (you were also missing the quotes around the first part of the array subscript, such as 'firstname').

If you plan on doing that though, you will open your application to hackers (read here on how to prevent sql injections in php).

edited May 23 '17 at 12:13

Community

1
1

answered Jan 22 '14 at 10:48

knittl

246,190
53
318
364

score 0 · Answer 4 · answered Jan 22 '14 at 11:16

0

"hi dear mistysnake u can use 'Peter''".$i."' peter is the static value and u can insert value and your problem is the u can put the $_GET"

answered Jan 22 '14 at 11:16

jignesh

11
6

Insert into sql, insert values within loop

4 Answers4