API数据无法使用及PHP调用Node.js并处理数据问题咨询

Hey there! Let's work through your problem step by step—you've got a few connected tasks here, so we'll tackle them one by one.

First, you need to make sure your Node.js script outputs the data in a format PHP can read. Since your target data is an array of objects, we'll use JSON.stringify() to turn it into a string that PHP can parse later.

Example Node.js script (e.g., data-fetcher.js) #

This includes your static get Sth1() function and outputs the data correctly:

class YourDataClass {
  static get Sth1() {
    // Replace this with your actual API fetch logic
    // Make sure it returns the [{ id: 'ID', displayName: 'Name' }] format
    return [
      { id: 'user_1', displayName: 'John Doe' },
      { id: 'user_2', displayName: 'Jane Smith' }
    ];
  }
}

// Output the data as a JSON string (critical for PHP to capture it)
console.log(JSON.stringify(YourDataClass.Sth1));

PHP code to run the Node script and capture $result #

Use shell_exec() to run the Node command, then parse the output into a PHP array with json_decode():

<?php
// Replace with the full path to your Node.js script
$nodeScriptPath = '/var/www/html/data-fetcher.js';

// Run the Node script and capture its output
$nodeOutput = shell_exec("node {$nodeScriptPath}");

// Parse the JSON string into a PHP associative array
$result = json_decode($nodeOutput, true);

// Verify the result (remove this in production)
var_dump($result);
?>

Note: Make sure your server has Node.js installed, and the PHP process has permission to run the node command. If you get empty output, try using the absolute path to Node (e.g., /usr/bin/node instead of just node).

Once you have $result as a PHP array, saving it to a JSON file is straightforward with json_encode() and file_put_contents():

<?php
// Convert the PHP array to a formatted JSON string
$jsonContent = json_encode($result, JSON_PRETTY_PRINT);

// Replace with your desired file path
$jsonFilePath = '/var/www/html/output-data.json';

// Write the JSON content to the file
$writeSuccess = file_put_contents($jsonFilePath, $jsonContent);

if ($writeSuccess !== false) {
  echo "JSON file saved successfully at {$jsonFilePath}!";
} else {
  echo "Failed to save JSON file—check directory permissions.";
}
?>

Pro tip: JSON_PRETTY_PRINT makes the JSON file human-readable; omit it if you want a minified version.

Since $result is a standard PHP array, you can manipulate it just like any other array. Here are common use cases:

1. Loop through all items and display data #

<?php
foreach ($result as $item) {
  $id = $item['id'];
  $name = $item['displayName'];
  echo "User ID: {$id} | Display Name: {$name}<br>";
}
?>

2. Extract all display names into a separate array #

Use array_column() to grab a single field from all items:

<?php
$allDisplayNames = array_column($result, 'displayName');
print_r($allDisplayNames);
// Output: Array ( [0] => John Doe [1] => Jane Smith )
?>

3. Find an item by ID #

<?php
$targetId = 'user_2';
$foundItem = null;

foreach ($result as $item) {
  if ($item['id'] === $targetId) {
    $foundItem = $item;
    break;
  }
}

if ($foundItem) {
  echo "Found user: {$foundItem['displayName']}";
} else {
  echo "No user found with ID {$targetId}";
}
?>

Make sure this function returns data that can be serialized to JSON. If your API returns complex objects (e.g., with circular references or non-serializable values), map the data to a simple object first in your Node script:

static get Sth1() {
  // Fetch raw API data
  const rawApiData = await fetchYourApi();
  
  // Map to your desired format
  return rawApiData.map(rawItem => ({
    id: rawItem.user_id, // Adjust to match your API's field names
    displayName: rawItem.full_name
  }));
}

内容的提问来源于stack exchange，提问作者Boba