C# 服务器（不是 Web 服务器）和 PHP 之间的数据交换

C# 服务器与 PHP 之间的数据交换

csharp
// C# 服务器端代码
using System;
using System.Net;
using System.Net.Http;
using System.Web.Http;
public class ProductController : ApiController
{
    [HttpGet]
    public IHttpActionResult GetProduct(int id)
    {
        // 根据产品 ID 获取产品信息的逻辑
        Product product = GetProductById(id);
        if (product != null)
        {
            return Ok(product);
        }
        else
        {
            return NotFound();
        }
    }
    private Product GetProductById(int id)
    {
        // 实际获取产品信息的逻辑
        // ...
    }
}

php
// PHP 客户端代码
$productId = 123; // 产品 ID
$url = "http://example.com/api/product/" . $productId;
$ch = curl_init($url);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
$response = curl_exec($ch);
if ($response === false) {
    echo "Error: " . curl_error($ch);
} else {
    $product = json_decode($response);
    // 处理获取到的产品信息
    // ...
}
curl_close($ch);
?>

csharp
// C# 服务器端代码
using System;
using System.Data.SqlClient;
public class ProductRepository
{
    private string connectionString = "Data Source=server;Initial Catalog=mydatabase;User ID=username;Password=password";
    public Product GetProductById(int id)
    {
        using (SqlConnection connection = new SqlConnection(connectionString))
        {
            connection.Open();
            SqlCommand command = new SqlCommand("SELECT * FROM Products WHERE Id = @Id", connection);
            command.Parameters.AddWithValue("@Id", id);
            SqlDataReader reader = command.ExecuteReader();
            if (reader.Read())
            {
                Product product = new Product
                {
                    Id = (int)reader["Id"],
                    Name = (string)reader["Name"],
                    Price = (decimal)reader["Price"]
                };
                return product;
            }
            else
            {
                return null;
            }
        }
    }
}

php
// PHP 客户端代码
$productId = 123; // 产品 ID
$servername = "server";
$username = "username";
$password = "password";
$dbname = "mydatabase";
$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}
$sql = "SELECT * FROM Products WHERE Id = " . $productId;
$result = $conn->query($sql);
if ($result->num_rows > 0) {
    $row = $result->fetch_assoc();
    // 处理获取到的产品信息
    // ...
} else {
    echo "Product not found";
}
$conn->close();
?>