如何在PHP中获取JSON数组并打印其值？

Question

Actually I have created an array that contains table rows value and I want to pass the array to PHP file using jQuery and I want to store it in MySql database.

I have done as:

var myTableArray = [];

$("table#tbl-nitem tr").each(function() {
    var arrayOfThisRow = [];
    var tableData = $(this).find('td');
    if (tableData.length > 0) {
        tableData.each(function() {
            arrayOfThisRow.push($(this).text());
        });

        alert(arrayOfThisRow);
        arrayOfThisRow.shift();
        myTableArray.push(arrayOfThisRow);
    }
});
//myTableArray.shift();
alert(myTableArray);

var jsonString = JSON.stringify(myTableArray);
$.ajax({
    type: "GET",
    url: "script_expenses.php",
    data: {
        data: jsonString
    },
    cache: false,

    success: function(response) {
        if (response == "ok") {
            alert("OK");
        } else {
            alert(response);
        }
    }
});

The above code that will create, store and pass the array to .php file

$conn = require_once 'db_connection.php';
//echo $conn;
session_start();
$data = $_GET['data'];
json_encode($data);

//  $sql = "INSERT INTO my_table ( fname, lname ) VALUES ( ?,? )"; 
//$ins = 

$sql = "INSERT INTO expenses_list VALUES (?, ?, ?, ?, ?, ?)";
$stmt = mysqli_prepare($conn, $sql);

foreach($data as $row) {
    mysqli_stmt_bind_param('ss', 'TEA');
    mysqli_stmt_bind_param('ss', $row['Purpose']);
    mysqli_stmt_bind_param('ss', $row['UnitPrice']);
    mysqli_stmt_bind_param('ss', $row['Qty']);
    mysqli_stmt_bind_param('ss', $row['DTime']);
    mysqli_stmt_bind_param('ss', $row['Description']);
    $result = mysqli_stmt_execute($stmt);
}

flush();

The above code will receive the array and try to store in databse. But I am getting an error in foreach statement as: Invalid argument supplied foreach

I searched and come to know that the receiving value is not an array. How to solve the issue???

Answer 1

just do

$data = $_GET['data'];

$data = json_decode($data,true);

now you can use $data in foreach loop Update 1

$conn =  require_once'db_connection.php';
session_start();
$data = $_GET['data'];
$data = json_decode($data,true);

$sql    = "INSERT INTO expenses_list VALUES (?, ?, ?, ?, ?, ?)";
$stmt   = mysqli_prepare($conn,$sql);

foreach($data as $row){
    mysqli_stmt_bind_param('s', 'TEA');
    mysqli_stmt_bind_param('s', $row['Purpose']);

    //mysqli_stmt_bind_param('s', $row['UnitPrice']);
    //if UnitPrice is double values then use
    mysqli_stmt_bind_param('d', $row['UnitPrice']);

    //mysqli_stmt_bind_param('s', $row['Qty']);
    //if Qty is integer then use
    mysqli_stmt_bind_param('i', $row['Qty']);
    mysqli_stmt_bind_param('s', $row['DTime']);
    mysqli_stmt_bind_param('s', $row['Description']);
    $result = mysqli_stmt_execute($stmt);
}

In mysqli_stmt_bind_param please use following types

i corresponding variable has type integer

d corresponding variable has type double

s corresponding variable has type string

b corresponding variable is a blob and will be sent in packets

for more refernce check this http://php.net/manual/en/mysqli-stmt.bind-param.php