php - 从 mysql 查询中删除最后一个逗号

Question

在这里，我在 mysql 插入查询中使用了多个数据。我在最后使用逗号 ","。但是如果我想从插入查询中删除最后一个逗号，我们该怎么做呢？我的查询是:

 $sql.= INSERT INTO shipping_boxes(ship_method,order_id,box_id,rate,signature,weight,length,width,height,value,markupPercentage,insured) VALUES("Pickup - Deliver By Messenger: Approximately 1 Business Day, by 5 PM","15566","99999","0","0","21.9","24","24","21","200","","0"),("Pickup - Deliver By Messenger: Approximately 1 Business Day, by 5 PM","15566","88888","0","0","18","20","20","18","140","","0"),("Pickup - Deliver By Messenger: Approximately 1 Business Day, by 5 PM","15566","88888","0","0","18","20","20","18","140","","0"),;

更新:我想要这样，

$sql.= INSERT INTO shipping_boxes(ship_method,order_id,box_id,rate,signature,weight,length,width,height,value,markupPercentage,insured) VALUES("Pickup - Deliver By Messenger: Approximately 1 Business Day, by 5 PM","15566","99999","0","0","21.9","24","24","21","200","","0"),("Pickup - Deliver By Messenger: Approximately 1 Business Day, by 5 PM","15566","88888","0","0","18","20","20","18","140","","0"),("Pickup - Deliver By Messenger: Approximately 1 Business Day, by 5 PM","15566","88888","0","0","18","20","20","18","140","","0");

Answer 1

我认为您正在循环创建 sql 字符串:

$sql = "INSERT INTO mytable (col1, col2, col3) VALUES "

for ($i = 1; $i <= 10; $i++) {
    $sql .= "('val1', 'val2', 'val3'),"
}

然后你可以用 rtim 删除最后一个逗号:

rtrim($sql, ",")

但我建议您改用带有占位符的准备好的语句。如果你使用的是 mysqli，它是这样的:

$conn = new mysqli($servername, $username, $password, $dbname);
$stmt = $conn->prepare("INSERT INTO mytable (col1, col2, col3) VALUES (?, ?, ?)");
$stmt->bind_param("sss", $value1, $value2, $value3);

for (....) {
  $value1 = 'something';
  $value2 = 'something';
  $value3 = 'something';

  $stmt->execute();
}

$stmt->close();
$conn->close();