Passing array object from PHP to Python

Update: A Completely different approach

There is a difficulty with the PHP script JSON-encoding a structure to produce a JSON string and then passing it as a command line argument since the string needs to be placed in double quotes because there can be embedded spaces in the encoded string. But the string itself can contain double quotes as start of string characters and within such a string. Confused? Who wouldn’t be?

There is no problem however with writing such a string to a file and having the Python program read it in and decode it. But we don’t want to have to deal with temporary files. So the solution is to pipe the data to the Python program where it can then be read in as stdin

Let’s assume your array looks like:

$arr =
[
    [
        "FileName" => ""\  nRon's20221227_202035.jpg",
        "Model" => "27_202035.jpg",
        "Longitude" => 106.90425,
        "Latitude" => 106.90425
    ],
    [
        "FileName" => "20221227_202157.jpg",
        "Model" => "SM-A528B",
        "Longitude" => 106.9042428,
        "Latitude" => -6.1676580997222
    ]
];

Note that I have modified your example slightly so that the first FileName field contains a " character, a ' character, an escape sequence n representing the newline character and finally some spaces. Although your example does not contain these characters or some other escape sequence, I would like to be able to handle such a condition should it arise. This solution should work with such input.

PHP File

<?php
$arr =
[
    [
        "FileName" => ""\  nRon's20221227_202035.jpg",
        "Model" => "27_202035.jpg",
        "Longitude" => 106.90425,
        "Latitude" => 106.90425
    ],
    [
        "FileName" => "20221227_202157.jpg",
        "Model" => "SM-A528B",
        "Longitude" => 106.9042428,
        "Latitude" => -6.1676580997222
    ]
];

// Encode string as JSON:
$json = json_encode($arr);

// Pipe the JSON string to the Python process's stdin and
// read the result from its stdout:
$descriptorspec = array(
   0 => array("pipe", "r"),  // stdin is a pipe that the child will read from
   1 => array("pipe", "w")   // stdout is a pipe that the child will write to
);
$options = array('bypass_shell' => True); // Only has effect on Windows
//$process = proc_open("python3 test.py", $descriptorspec, $pipes, null, null, $options);
// For your actual environment:
$process = proc_open("D:/Anaconda/python.exe D:/xampp/htdocs/Klasifikasi_KNN/admin/test.py", $descriptorspec, $pipes, null, null, $options);

// Pipe the input for the Python program and close the pipe:
fwrite($pipes[0], $json);
fclose($pipes[0]);

// Read the result from the Python program and close its pipe
$result = stream_get_contents($pipes[1]);
fclose($pipes[1]);

# Now that we have closed the pipes, we can close the process:
$return_code = proc_close($process);

echo "Result from stdin:n$resultn";

test.py

import json
import sys

DEBUG = True # for debugging purposes

if DEBUG:
    import os

    for k, v in sorted(os.environ.items()):
        print(k, '->', v, file=sys.stderr)
else:
    import numpy as np
    import pandas as pd

# Load from stdin:
arr = json.load(sys.stdin)
# print each dictionary of the array:
for d in arr:
    print(d)

Prints:

{'FileName': '"\  nRon's20221227_202035.jpg', 'Model': '27_202035.jpg', 'Longitude': 106.90425, 'Latitude': 106.90425}
{'FileName': '20221227_202157.jpg', 'Model': 'SM-A528B', 'Longitude': 106.9042428, 'Latitude': -6.1676580997222}