Insert multiple HTML data from array multiple input to db using PDO

Question

I have multiple FAQ fields (question and answer) and have to insert them into the MySQL database. I am using PDO.

HTML:

<input type="text" name="qns[]/>
   <textarea name="ans[]"></textarea><br>

PHP

    $qns=$_POST['qns'];
    $ans=$_POST['ans'];
    date_default_timezone_set('Asia/Kathmandu');
    $created= date('m/d/Y h:i:s a', time());

    foreach ($qns as $q){
        foreach ($ans as $a){
                $stmt=$pdo->prepare("INSERT INTO tbl_faq 
                            (faq_qn, faq_ans, faq_creator, faq_created, faq_updated)
                            VALUES
                            (?,?,?,?,?)");
                $stmt->bindValue(1, $q);
                $stmt->bindValue(2, $a);
                $stmt->bindValue(3, $_SESSION['id']);
                $stmt->bindValue(4, $created);
                $stmt->bindValue(5, $created);
                $stmt->execute();
        }
  }
  header("location:dashboard.php?page=faq/view.php");

When I insert it into the db, it produce the Cartesian Product. I know there is something going on with the loop. But not sure how to fix it..

What's your specific question about this? What have you tried to resolve the problem? — Nico Haase
– Nico Haase, Commented Jul 7, 2021 at 7:36
How do the answers relate to the questions. You just seem to get 2 arrays from the $_POST array and combine them. — Nigel Ren
– Nigel Ren, Commented Jul 7, 2021 at 7:43
I am trying to insert the question and answer into separate columns of a database tabel. — Dikshant Ghimire
– Dikshant Ghimire, Commented Jul 7, 2021 at 7:48
the size of questions and answers is same right, just use 1 array and same key. You are actually doing Cartesian product as you are using nested loop. — Danyal Sandeelo
– Danyal Sandeelo, Commented Jul 7, 2021 at 7:51

Asim · Accepted Answer · 2021-07-07 07:49:07Z

3

Use only one loop and pass the index of question loop in $ans[]

foreach ($qns as $key => $q)
{
    $stmt = $pdo->prepare("INSERT INTO tbl_faq 
                (faq_qn, faq_ans, faq_creator, faq_created, faq_updated)
                VALUES
                (?,?,?,?,?)");

    $stmt->bindValue(1, $q);
    $stmt->bindValue(2, $ans[$key]);
    $stmt->bindValue(3, $_SESSION['id']);
    $stmt->bindValue(4, $created);
    $stmt->bindValue(5, $created);
    $stmt->execute();
}

answered Jul 7, 2021 at 7:49

Asim

1745 bronze badges

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

Collectives™ on Stack Overflow

Insert multiple HTML data from array multiple input to db using PDO

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related