Using mysql insert with implode in PDO

Question

I have been using the following query to upload my data into mysql database:

$sql = array(); 
foreach( $data as $row ) {
    $sql[] = '("'.mysql_real_escape_string($row['text']).'", '.$row['category_id'].')';
}
mysql_query('INSERT INTO table (text, category) VALUES '.implode(',', $sql));

Since a bit I have started using PDO and my query looks like this:

$query="INSERT INTO mytable (name, use) VALUES(:sname, :usee)";     
$res = $db_conn->prepare($query);
$res->bindValue(':sname',$value);
$res->bindValue(':usee',$_SESSION['usee']);
$res->execute();

Now the above code block is fine, but now when I am going through my CSV upload thing, I again looking backward and using the first code. Want to use the same PDO now for CSV upload also.

Is there a trick to upload multiple values in database using PDO at once?

sergio · Accepted Answer · 2014-01-25 11:08:58Z

1

Yes, you can use some loop in which you will execute, something like this:

$query = $db->prepare(
    'INSERT INTO mytable (name, use) VALUES(:sname, :usee)'
  );
      foreach($mainArrayOfveluus AS $arrayOfValue){
            $query->execute(array(
          ':sname' => $arrayOfValue['sname'],
          ':usee' =>$arrayOfValue['usee']
        ));
      }

      $query->commit();

answered Jan 25, 2014 at 11:08

sergio

5,2607 gold badges27 silver badges47 bronze badges

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

Collectives™ on Stack Overflow

Using mysql insert with implode in 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