localstorage存mysql_使用PHP将JS嵌套数组从localstorage保存到mysql表中

我正在将数组推送到localstorage,单击按钮后,我想将其存储在mysql表中。

var coords = JSON.parse(localStorage.getItem('coords'));

var coords为我提供了以下输出:

["STAR_SPORTS_2-20170924-200043-210917-00142.jpg", "PerimeterBoard", "Jupiter", 236, 353, 292, 319, 312, 362, "STAR_SPORTS_2-20170924-200043-210917-00142.jpg", "TShirt", "Redshift", 268, 410, 381, 398, 381, 469, "STAR_SPORTS_2-20170924-200043-210917-00142.jpg", "Mic", "Airtel", 317, 327, 425, 329, 421, 371, "STAR_SPORTS_2-20170924-200043-210917-00142.jpg", "Mic", "Airtel", 575, 300, 575, 300, 626, 282]

我使用以下函数将此数组推送到一个PHP文件:

function dbSave(e) {

e.preventDefault();

var coords = JSON.parse(localStorage.getItem('coords'));

$.post("saveAnnotations.php", {'data' : coords }, function(output){

alert(output);

});

}

保存注释.php

$connect = mysqli_connect($hostname, $username, $password,$database);

$lsData = isset($_POST['data'])?$_POST['data']:'';

$annArray = json_decode($lsData, true);

$image = $annArray[0];

$location = $annArray[1];

$brand = $annArray[2];

$firstX = $annArray[3];

$firstY = $annArray[4];

$secondX = $annArray[5];

$secondY = $annArray[6];

$thirdX = $annArray[7];

$thirdY = $annArray[8];

$sql = "INSERT into `annotations` (`matchName`, `imagename`, `locationName`, `brandname`, `firstx`, `firsty`, `secondx`,`secondy`, `thirdx`,`thirdy`) values

('$matdir','$image', '$location','$brand','$firstX','$firstY','$secondX','$secondY','$thirdX','$thirdY');";

$result = mysqli_query($connect, $sql) or die(mysqli_error($connect));

if ($result) {

echo "Data uploaded Successfully";

}

$connect->close();

?>

到mysql db和table的连接是完美的。当我硬编码每个字段的值时,数据会更新到表中。我认为问题在于将数组从localstorage发布到php,并在php端对其进行解码。

$annArray = json_decode(json_encode($lsData, true), true);

$countArray = count($annArray);

$interval = $countArray/9;

function fill_chunck($array, $parts) {

$t = 0;

$result = array_fill(0, $parts - 1, array());

$max = ceil(count($array) / $parts);

foreach($array as $v) {

count($result[$t]) >= $max and $t ++;

$result[$t][] = $v;

}

return $result;

}

//echo print_r(fill_chunck($annArray, $interval));

$inputArray = [];

$inputArray = fill_chunck($annArray, $interval);

foreach($inputArray as $value=>$data) {

$image = $data[0];

$location = $data[1];

$brand = $data[2];

$firstX = $data[3];

$firstY = $data[4];

$secondX = $data[5];

$secondY = $data[6];

$thirdX = $data[7];

$thirdY = $data[8];

$sql = "INSERT into `annotations` (`imagename`, `locationName`, `brandname`, `firstx`, `firsty`, `secondx`,`secondy`, `thirdx`,`thirdy`) values

('$image', '$location','$brand','$firstX','$firstY','$secondX','$secondY','$thirdX','$thirdY');";

$result = mysqli_query($connect, $sql) or die(mysqli_error($connect));

if ($result) {

echo "Data uploaded Successfully";

}

$connect->close();

}