Insert php array elements into mysql database [duplicate]

Question

i Want to insert each array element into new row in mysql db

<?php
   if(isset($_SESSION['user'])){
      echo "<body>
            <form method='GET'>
            <input type='text' id='search-box' name='item'>
            <button type='submit' name='add'>add</button>
            <button type='submit' name='place'>place</button>
            </form>
            </body>";
    if(isset($_GET['add'])){
       $item = $_GET["item"];
       array_unshift($_SESSION['menu1'], $item);
    }
   if(isset($_GET['place'])){
       echo implode(",", $_SESSION['menu1']);
    }
   }
   else{
      echo "you are not logged in";
   }
 ?>

The above code outputs an array in which each element is separated by comma, but i want to insert each element into a new row

See implode(). If you don't want the array joined by commas, you may want to remove that part. — showdev
– showdev, Commented Jul 27, 2019 at 9:16
There was no coding attempt to insert, so a generalised duplicate is suitable for closure. You should not be using the GET method to send data bound for the database. — mickmackusa
– mickmackusa ♦, Commented Jul 27, 2019 at 9:55

Dharman · Accepted Answer · 2020-07-26 00:00:36Z

0

If you have a large set of values in the array to be inserted in the database, I suggest you to segment the query.

You can use Prepared Statement

$stmt = $mysqli->prepare("INSERT INTO something ( id , title , description) VALUES ( DEFAULT , ?, ?)");

foreach( $item_array as $item ){
    $stmt->bind_param( $item->title , $item->description);
    $stmt->execute();
}

edited Jul 26, 2020 at 0:00

Dharman♦

33.9k27 gold badges106 silver badges157 bronze badges

answered Jul 27, 2019 at 9:19

Kiran Maniya

9,08911 gold badges63 silver badges87 bronze badges

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

1 Comment

showdev Over a year ago

You might consider using Prepared Statements. Also see why MySQLi prepared statements?.

Collectives™ on Stack Overflow

Insert php array elements into mysql database [duplicate]

1 Answer 1

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Linked

Related