0

I have a value like this 

$id='11';   
$value1= 'tb1,tb2,tb3,tb4';    
$value2= 'th1,th2,th3,th4';

and all I want to do is insert it into MySql (via PHP) like this:

+---------+-------------+-------------+
|      id |         tb |      th      |
+---------+-------------+-------------+
|      11 |        tb1 |      th1     |
|      11 |        tb2 |      th2     |
|      11 |        tb3 |      th3     |
|      11 |        tb4 |      th4     |
+---------+------------+--------------+

I will appreciate any help I get.

Improve this question
5

3 Answers 3

Reset to default
1

I think you have string type values so first explode it then insert see below code

$id='11';   
$value1= 'tb1,tb2,tb3,tb4';    
$value2= 'th1,th2,th3,th4';
$vals1= explode(',',$value1);
$vals2= explode(',',$value2);
$i=0;
foreach($vals1 as $val1)
{
  $ins="INSERT INTO my_table (id, tb, th)values ( ".$id." ,  '".$val1."' ,'".$vals2[$i]."' )";
  $i++;
}
Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

1

You could use batch insert 

  Insert into my_table (id, tb,th)
  values ( 11 ,  'tb1' , 'th1' ),
         ( 11 ,  'tb2' , 'th2' ),
         ( 11 ,  'tb3' , 'th3' ),
         ( 11 ,  'tb4' , 'th4' )
Improve this answer

2 Comments

$value1= 'tb1,tb2,tb3,tb4'; $value2= 'th1,th2,th3,th4'; I will get values like this.
@AnithaS .. if you have an array then you should iterate over the array for build and assigning the proper values to the code ..
0

Assuming you are using PDO for database communication and the amount of values in $value1 and $value2 will be equal:

<?php

$id = 11;
$value1 = 'tb1,tb2,tb3,tb4';
$value2 = 'th1,th2,th3,th4';
$values1 = explode(',', $value1);
$values2 = explode(',', $value2);
$sql = "INSERT INTO table (id, tb, th) VALUES (:id, :value1, :value2 )";
$stmt = $pdo->prepare($sql);
for ($i = 0; $i < count($values1) $i++)
{
    $stmt->bindParam('id', $id);
    $stmt->bindParam('value1', $values1[$i]);
    $stmt->bindParam('value2', $values2[$i]);
    if($stmt->execute()){
        echo "QUERY EXECUTED";
    }
}

?>

Edited for more efficient use of prepare

Improve this answer

1 Comment

To get the most from prepared statements, the prepare should be done outside the loop and executed for each set of values.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.