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

作者: 林老爷的日常
发布时间: 2025-03-06 09:52:57 (3天前)
转自：

3 条回复

0#
回复此人
烏鴉喝酒 | 2019-08-31 10-32

<div class =“post-text”itemprop =“text”> <P> 试试下面的代码 </p> <pre> <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; } </code> </pre> </DIV>

编辑
1#
回复此人
Hey ou | 2019-08-31 10-32

<div class =“post-text”itemprop =“text”> <P> 你可以用 <a href="https://www.hostinger.com/tutorials/how-to-use-php-to-insert-data-into-mysql-database" rel="nofollow noreferrer"> bindParam </A> （ <a href="http://php.net/manual/en/pdostatement.bindparam.php" rel="nofollow noreferrer"> PHP文档 </A> 并写下你的查询： </p> <pre> <code> $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 )"); </code> </pre> <P> 你可以像下面这样添加它们： </p> <pre> <code> foreach($arr as $colData){ $my_Insert_Statement->bindParam($colData['key_name'], $colData['value_name']); } </code> </pre> <P> 并执行准备好的声明： </p> <pre> <code> if ($my_Insert_Statement->execute()) { echo "New record created successfully"; } else { echo "Unable to create record"; } </code> </pre> </DIV>

编辑

登录后才能参与评论