我有一个以下格式的值,我想转换这个键和内爆形式的值在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
)我在MYSQL中有两列“键”和“值”,并将上面的值以类似于key:Total_Cubic_Metres,Bedroom_Bassinette,Bedroom_Bedside_Drawers,Bedroom_Bedside_Drawers,Bedroom_Bedside_Table的内爆形式存储在这个字段中。
值:3.46m³,2, 2,2
发布于 2019-03-14 11:37:35
您可以使用bindParam (PHP docs)并像这样编写查询:
$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
)");你可以像这样添加它们:
foreach($arr as $colData){
$my_Insert_Statement->bindParam($colData['key_name'], $colData['value_name']);
}并执行准备好的语句:
if ($my_Insert_Statement->execute()) {
echo "New record created successfully";
} else {
echo "Unable to create record";
}发布于 2019-03-14 12:22:55
尝试下面的代码
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;
}https://stackoverflow.com/questions/55154480
复制相似问题