如何在mysql中以Implode形式插入数组值

问题描述：

I have a value in below format and i want to convert this key and value in implode form to insert value in database in mysql.

 Array
(
[users_ids] => 
[key_name] => Total_Cubic_Metres
[value_name] => 3.46m³
)

Array
(
[users_ids] => 
[key_name] => Bedroom_Bassinette
[value_name] => 2
)

Array
(
[users_ids] => 
[key_name] => Bedroom_Bedside_Drawers
[value_name] => 2
)

Array
(
[users_ids] => 
[key_name] => Bedroom_Bedside_Table
[value_name] => 2
)

I have 2 COLUMN in MYSQL "key" and "value" and store the above value in this field in implode form something like this key:Total_Cubic_Metres,Bedroom_Bassinette,Bedroom_Bedside_Drawers,Bedroom_Bedside_Drawers,Bedroom_Bedside_Table

Value:3.46m³, 2, 2,2

我有一个以下格式的值，我希望将此键和值以implode形式转换为在数据库中插入值在mysql中。 p>

  Array 
（
 [users_ids] =＆gt; 
 [key_name] =＆gt; Total_Cubic_Metres 
 [value_name] =＆gt;3.46m³
）
  
Array 
（
 [users_ids] =＆gt; 
 [key_name] =＆gt; Bedroom_Bassinette 
 [value_name] =＆gt; 2 
）
 
Array 
（
 [users_ids] =＆gt; \  n [key_name] =＆gt; Bedroom_Bedside_Drawers 
 [value_name] =＆gt; 2 
）
 
Array 
（
 [users_ids] =＆gt; 
 [key_name] =＆gt; Bedroom_Bedside_Table 
 [value_name] =  ＆gt; 2 
）
  code>  pre> 
 
 我在MYSQL“key”和“value”中有2个COLUMN并将上述值以implode形式存储在此字段中 
key：Total_Cubic_Metres，Bedroom_Bassinette，Bedroom_Bedside_Drawers，Bedroom_Bedside_Drawers，Bedroom_Bedside_Table  p> 
 
 
价值：3.46立方米，2,2,2  p> 
  div>

答

You could use bindParam (PHP docs) and write your queries like so:

$my_Insert_Statement = $my_Db_Connection->prepare("
INSERT INTO TABLE_NAME (
  Total_Cubic_Metres,
  Bedroom_Bassinette,
  Bedroom_Bedside_Drawers,
  Bedroom_Bedside_Drawers,
  Bedroom_Bedside_Table) 
VALUES (
 :Total_Cubic_Metres,  
 :Bedroom_Bassinette,
 :Bedroom_Bedside_Drawers,
 :Bedroom_Bedside_Drawers,
 :Bedroom_Bedside_Table
)");

and you could add them like:

foreach($arr as $colData){
  $my_Insert_Statement->bindParam($colData['key_name'], $colData['value_name']);
}

and execute the prepared statement:

if ($my_Insert_Statement->execute()) {
  echo "New record created successfully";
} else {
  echo "Unable to create record";
}

答

Try below code

 function insertQuery($table, $dataArray, $connection){
    $dataArray = array_map(array($connection, 'real_escape_string'), $dataArray);
    $keys = array_keys($dataArray);
    $colmuns = implode(",",$keys);
    $values =array_values($dataArray);
    $valueData = implode("','",$values);
    $query = "INSERT INTO $table ($colmuns) VALUES ('$valueData')";
    $result = mysqli_query($connection, $query);

    if($result){
      $id = mysqli_insert_id($connection);
      return $id;
    }
    return false;
 }

如何在mysql中以Implode形式插入数组值

相关推荐