php - 将多个数组值作为整数插入 - PHP MYSQL

Question

这可能很容易完成，但我似乎无法理解。我有一个数组 $this->shippingLocations 返回以下内容:

var_dump($this->shippingLocations);
array(3) { [0]=> string(2) "14" [1]=> string(1) "5" [2]=> string(1) "1" } 

我想将上述值插入到 mysql 表中。每个在其自己的行上使用 mysqli 准备好的语句，但作为整数。所以我将这些值转换为整数。

foreach($this->shippingLocation as $key => $val) {
  $shipArray[$key] = (int)$val;
}

给出以下结果:

var_dump($shipArray);
array(3) { [0]=> int(14) [1]=> int(5) [2]=> int(1) }

然后获取数组中的项目数

$addCountry = count($shipArray);

并对它们中的每一个运行查询。

for ($i = 0; $i < $addCountry; $i++) {

      $data = array (
      "item_id" => $lastItemID,
      "country_id" => $shipArray[$i]
  );
 // types for bind_param, table name and array(keys are table columns and values are data for columns) which are passed to a working insert function
  $db->insert('ii', 'countries_ship', $data);

  }

我收到的通知是 Undefined offset: 1 .. .2 ... 3 取决于数组中有多少项。

Answer 1

发布工作代码。我唯一的问题是 for 语句中的重复名称。

//$this->shippingLocations is an array with string values

//changing string to array for all values
foreach($this->shippingLocation as $key => $val) {
  $shipArray[$key] = (int)$val;
}

//counting items in new array
$addCountry = count($shipArray);

//add each item in `countries_ship` table
for ($i = 0; $i < $addCountry; $i++) {

  //creating array for mysql query
  $data = array (
  "item_id" => $lastItemID,
  "country_id" => $shipArray[$i]
);

//insert into table
$db->insert('ii', 'countries_ship', $data);

}