Checkbox in Method Post form, converting from array into string, in PHP

Question

I have a form to upload items to my database. In this form I have a selection of checkboxes to give tags to the items. preferably I want to save these tags as one single string in my database, separated by a comma. However, no matter what I try, I only seem to get an error or just the final result of my checkboxes.

<form action="storeupdate.php" enctype="multipart/form-data" method="post">
<input type='checkbox' name='Tags' value='Milk' >Milk<br/>
<input type='checkbox' name='Tags' value='Sugar' >Sugar<br/>
<input type='checkbox' name='Tags' value='Cream' >Cream<br/>
<input type='checkbox' name='Tags' value='Chocolate' >Chocolate<br/>
<input type="reset"> <input type="submit" name="Submit" value="Submit"><br/>
</form>

storeupdate.php:

$Tags = mysqli_real_escape_string($conn, $_REQUEST['Tags']);

I have tried foreach loops, but they dont seem to give me any results back. When I echo the $Tags, I only get the 'highest' result that has been submitted.

If I can't even figure out how to grab the individual values, I can't even begin to work on a script to string them together before placing them in my database.

Update

Now that we have established I did wrong in the form, I am still confused in how to catch and convert this array.

$Tags[] = mysqli_real_escape_string($conn, $_POST['Tags[]']);
$tagstring = implode(",",$Tags);
echo "<br/> $_REQUEST = ";
var_dump($_POST['Tags']);
echo "<br/> $Tags = ";
var_dump($Tags);
echo "<br/> $tagstring = ";
var_dump($tagstring);
echo "<br/>";
echo "Tags= " . $tagstring . "<br/>";

returns the following: Array = array(6) { [0]=> string(1) "1" [1]=> string(1) "2" [2]=> string(1) "3" [3]=> string(1) "4" [4]=> string(1) "5" [5]=> string(1) "6" } Array = array(1) { [0]=> string(0) "" } = string(0) "" Tags=

I need this array as a string separated by the comma in order to make the rest of my build code work, but im doing something wrong in the handling after I catch the data.

Answer 1

You should write such HTML:

<form action="storeupdate.php" enctype="multipart/form-data" method="post">
<input type='checkbox' name='Tags[]' value='Milk' >Milk<br/>
<input type='checkbox' name='Tags[]' value='Sugar' >Sugar<br/>
<input type='checkbox' name='Tags[]' value='Cream' >Cream<br/>
<input type='checkbox' name='Tags[]' value='Chocolate' >Chocolate<br/>
<input type="reset"> <input type="submit" name="Submit" value="Submit"><br/>
</form>

And take $_POST['Tags'] from $_POST request where $_POST['Tags'] is array of your tags.

Answer 2

If you want to have an array of Tags you need to declare this parameter as an array in HTML:

<input type='checkbox' name='tags[]' value='Milk' >Milk<br/>
<input type='checkbox' name='tags[]' value='Sugar' >Sugar<br/>
<input type='checkbox' name='tags[]' value='Cream' >Cream<br/>
<input type='checkbox' name='tags[]' value='Chocolate' >Chocolate<br/>

Now $_REQUEST['tags'] will contain an array.

Answer 3

<form action="storeupdate.php" method="post">             //enctype="multipart/form-data" The "multipart/form-data" is not required unless you are uploading a file. otherwise no need to set it. It has a default value of "application/x-www-form-urlencoded"
    <input type='checkbox' name='tags[]' value='Milk' >Milk<br/>             //Try to use small letters, hyphen and underscore when setting the name attribute of your form.
    <input type='checkbox' name='tags[]' value='Sugar' >Sugar<br/>
    <input type='checkbox' name='tags[]' value='Cream' >Cream<br/>
    <input type='checkbox' name='tags[]' value='Chocolate' >Chocolate<br/>
    <input type="reset"> <input type="submit" name="submit" value="Submit"><br/>
</form>

Now your data will be in $_POST['tags'].