This is my script code
<script type="text/javascript">
function myFunction() {
var query = '?';
var str = $("form").serialize();
$("#results").text(query += str);
var x = $("#results").text();
return x;
}
$('#myButton').on('click',function(){
var jsonString = JSON.stringify(myFunction());
console.log(jsonString);
$.ajax({
url: 'insert_value.php',
data: jsonString,
contentType: 'application/json; charset=utf-8',
type: 'POST',
}).done(function(resp) {
$('#result').html(resp)
});
});
</script>
<?php
include('db.php');
$json = file_get_contents('php://input');
$data = json_decode($json);
print_r($data);
$result = mysqli_query($link,"SELECT value FROM combo1");
$num_rows = mysqli_num_rows($result);
//echo "$num_rows Rows\n";
if ($result->num_rows > 0) {
// output data of each row
$array = Array();
$array1 = Array();
while($row = $result->fetch_assoc()) {
//echo "<br> value: ". $row['value']. "<br>";
$array[] = $row['value'];
}
print_r($array);
}
$keys = array();
$values = array();
foreach($_GET as $key=>$value){
$keys[] = $key;
$values[] = $value;
}
$arrar1 = array_keys($_GET);
$arrar2 = array_values($_GET);
print_r($arrar1);
print_r($arrar2);
?>
?Gender=Female&id=704136006388169
我的查询字符串是这样的,所以我需要拆分它们并将它们放入如下数组中:
arrar1:性别,id
arrar2:女,70413600638816
那么怎么做呢??Gender=Female&id=704136006388169 我的查询字符串是这样的,所以我需要拆分它们并将它们放入如下数组中:
array1:性别,id array2:女性,70413600638816
拆分此查询后,我想将这些值插入到数据库表中
像 array1 值作为列名和 array2 作为列值所以我该怎么做,请帮助
例如:性别 ID 女 70413600638816
首先使用分离查询字符串=
并将其存储在一个数组中,其中queryString
等于查询字符串。
// Our two arrays
$firstArray = array();
$secondArray = array();
// Considering $queryString = "?Gender=Female&id=704136006388169&h=0"
$queryString = substr($queryString, 1);
// Now $queryString = "Gender=Female&id=704136006388169&h=0"
$array = explode('&',$queryString);
// Value of $array will be now be ["Gender=Female", "id=704136006388169", "h=0"]
for($i = 0; $i < $array[].length; $i++){
$tempArray = explode('=', $array[i]);
// Temp array for the first time will be ["Gender","Female"];
$firstArray[i] = $tempArray[0];
$secondArray[i] = $tempArray[1];
}
如果你想要更多评论请。
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句