使用js或jquery将POST发送到mysql

Question

I want to send an array of strings on my JavaScript to a MySQL table. What is the best way and how can I do it?

Answer 1

You can use AJAX POST like so:

function sendArray()
{
var myArray = ["one","two","three"];
$.ajax({
url     : 'YOUR_URL',
method    : 'POST',
data :{
 arrayData:myArray
},
success   : function(response)
{
alert("data sent response is "+response);
},
error : function(e)
{
alert("data not sent")
}
});
}
</script>
<button onclick="sendArray();">Send Array</button>

here myArray is the string array you want.

on the PHP backend you can get this data as:

<?php
$arrayData = $_REQUEST['arrayData'];
foreach($arrayData as $data)
{
    echo $data;
}