Submitting array to database

Question

I am having some issues with submitting an array of inputs to the database.

More specifically I am getting this error "Array to string conversion" on the line where I bind the parameters. How would I submit the array through the foreach loop so that they are all individual of each other.

Here is the form

<form name = "entries" method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">  
<input type="text" class="form-control input-lg" name="myInputs[]">
<input type="text" class="form-control input-lg" name="myInputs[]">
<input type="text" class="form-control input-lg" name="myInputs[]">
<input id = "submit1" name="submit1" type="submit">

and here is the php

    $inputs = (empty($_POST['myInputs'])) ? : $_POST['myInputs'] ;
    foreach ((array)$inputs as $eachInput) {
        $query = $db->prepare("INSERT INTO `entries` (entries) VALUES(:inputs)");
        $query->bindParam(':inputs', $inputs, PDO::PARAM_STR);
        $query->execute();
    }

Jalpa · Accepted Answer · 2016-11-24 07:19:21Z

1

Please try to replace your PHP code with below code.

$inputs = $_POST['myInputs'];
if(count($inputs) > 0) {
    foreach ($inputs as $eachInput) {
        $query = $db->prepare("INSERT INTO `entries` (entries) VALUES(:inputs)");
        $query->bindParam(':inputs', $eachInput, PDO::PARAM_STR);
        $query->execute();
    }
}

If any query then let me know.

answered Nov 24, 2016 at 7:19

Jalpa

7203 silver badges13 bronze badges

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

2 Comments

user3594895 Over a year ago

Thanks man, you're awesome. Why did I have to change it from $inputs = (empty($_POST['myInputs'])) ? : $_POST['myInputs'] ; to $inputs = $_POST['myInputs']; though? thats the only part I don't understand

Jalpa Over a year ago

@user3594895 I just make it in proper way. If you got blank array then doesn't need to run foreach loop. your code is also right :)

Collectives™ on Stack Overflow

Submitting array to database

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related