PHP MySQL Multiple Insertion

Question

I'm not quite sure where I'm going wrong :(

if(isset($_POST['finish'])){
$objectives=addslashes(strip_tags($_POST['item']));

    foreach ($objectives AS $objective) {
        echo "$objective <br />";
    }

}

It's not showing anything.. what have I missed out? I'm trying to get data from multiple input entries..

<input class="item" id="objectives" name="item[]" />

Any ideas?

well, the first thing you missed is the type of your input... — Laurent S.
– Laurent S., Commented May 24, 2013 at 16:17
addslashes and strip_tags work on string literals, not arrays. error_reporting(E_ALL) would have told you that immediately. — Sébastien Renauld
– Sébastien Renauld, Commented May 24, 2013 at 16:17
what is the value of $_POST['finish'] ? Is the block even getting run — exussum
– exussum, Commented May 24, 2013 at 16:18
@Bartdude Note: The default type is: text. see: w3schools.com/tags/att_input_type.asp — user645280
– user645280, Commented May 24, 2013 at 16:27

grossvogel · Accepted Answer · 2013-05-24 16:48:00Z

5

Well if you have multiple <input class="item" id="objectives" name="item[]" /> then $_POST['item'] will be an array and not a string. So you have to iterate over it or apply an array_map function.

$items = array_map('strip_tags',$items);
$items = array_map('addslashes',$items);

Your code would then be

if(isset($_POST['finish'])){
    $_POST['item'] = array_map('strip_tags',$_POST['item']);
    $_POST['item'] = array_map('addslashes',$_POST['item']);

    foreach ($_POST['item'] AS $objective) {
        echo "$objective <br />";
    }

}

edited May 24, 2013 at 16:48

grossvogel

6,7921 gold badge28 silver badges37 bronze badges

answered May 24, 2013 at 16:17

km6zla

4,9272 gold badges32 silver badges53 bronze badges

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

10 Comments

Jake Duncan Over a year ago

Ok, how do i go about doing that properly?

Jake Duncan Over a year ago

Haha, def need to keep practicing this... This most likely won't work.. well... it doesn't haha but I'm not getting any errors in my log... if(isset($_POST['finish'])){ $items=addslashes(strip_tags($_POST['item'])); $items = array_map('strip_tags',$items); $items = array_map('addslashes',$items); echo $items; }

km6zla Over a year ago

You need to remove $items=addslashes(strip_tags($_POST['item'])); Also $items is intended to represent $_POST['item'].

Jake Duncan Over a year ago

Ok, starting to make sense, could you possible struture it to actually work for me... because i removed it.. it doesn't even echo anything out.. feel like a dumb ass at the moment, but yeah, it happens.. thanks nick!

km6zla Over a year ago

"INSERT INTO objectives (objective) VALUES ('$objective')" Need quotes around a string you are inserting.

|

bgrohs · Accepted Answer · 2014-07-20 07:25:29Z

The direct answer is that any tag that has brackets([]) is put in the superglobal array as an array. You will need to loop over your this or use array_map to perform functions on this array.

My extended answer is that if you are using php 5.2 or later you can use the filter_var_array to perform this operation without iterating over your array in php. As well as do type checking. filter_var and filter_var_array have to many filter options for me to cover. Please see the docs http://php.net/manual/en/function.filter-var-array.php

if(isset($_POST['finish'])) {
    $objectives = filter_var_array($_POST['item'], FILTER_SANITIZE_STRING);

foreach ($objectives AS $objective) {
    echo "$objective <br />";
}

}

Collectives™ on Stack Overflow

PHP MySQL Multiple Insertion

2 Answers 2

10 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

10 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related