How to POST an array with PHP server side [duplicate]

Question

I'm trying to upload a posted array into a database table. From within the form the user writes the text that should be uploaded into the database. What I've read and understood is that I should create the array like this:

<li> <input type='checkbox' name='R[]'  id='R[]'> <label>"+ userInput + "</label> </li>

and that every element the user creates will become R[0], R[1], R[2]..... etc...

my question is, how do I read this array within server side? How do I know how many elements are in the array from server side?

On server side I'd do an insert like this:

$sql="INSERT INTO $tbl_name (R) VALUES('$R1');";
$sql2="INSERT INTO $tbl_name (R) VALUES('$R2');";

if it wasn't an array I'd simply define R1 and R2 like this:

$R1=$_POST["R1"]; 
$R2=$_POST["R2"];

but I don't get how to manage the array.

Thanks!

define a value attr for <input>. $R1 = implode("', '", $_POST["R1"]); in your case. Remember an SQL injection possibility. — Deadooshka
– Deadooshka, Commented May 14, 2014 at 1:00
A search engine should always be used before asking questions. — Anonymous
– Anonymous, Commented May 14, 2014 at 1:25

John Conde · Accepted Answer · 2014-05-14 01:05:55Z

3

how do I read this array within server side?

Just like you would any array.

echo $_POST['R'][0]; // get first element in that array
echo $_POST['R'][2]; // get third element in that array

How do I know how many elements are in the array from server side?

Just like you would with any array. By using count()

echo count($_POST['R']);

but how do I loop through the elements?? because I want to post all of them

Just like you would any array. Using a loop.

foreach ($_POST['R'] as $r) {
    // do something
    // echo $r;
}

FYI, you don't need array syntax for the ID attribute of your input element. But you do need to make sure it is unique.

edited May 14, 2014 at 1:05

answered May 14, 2014 at 0:56

John Conde

220k100 gold badges464 silver badges504 bronze badges

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

9 Comments

Evana Over a year ago

but how do I loop through the elements?? because I want to post all of them...

John Conde Over a year ago

The whole point of my answer is to show you this is just an ordinary array. There's nothing really special going on here. See my updated answer for how to loop through this array.

Evana Over a year ago

ok I get it... so I'd simply do this foreach ($_POST['R'] as $r) { $sql3="INSERT INTO REG (ID_User, Reg) VALUES('$userid','$r');"; $tab= mysql_query($sql3, $dbh) or die ("error"); } and that way all the elements would be added to the database

John Conde Over a year ago

Sure. You could even do it in one query if you wanted to.

Evana Over a year ago

I'm getting two errors: "Undefined index: R", "Invalid argument supplied for foreach()"

|

Collectives™ on Stack Overflow

How to POST an array with PHP server side [duplicate]

1 Answer 1

9 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

9 Comments

Linked

Related