Mysqli数据转文件：如何调整单行数据库数据的写入格式？

Absolutely! Adjusting the output format is totally straightforward once you break it down into two key steps: retrieving the data correctly and formatting it to match your needs before writing to the file. Let’s walk through this with practical examples.

Step 1: Retrieve the Single Row as an Associative Array #

First, make sure you’re fetching your database row as an associative array (using mysqli_fetch_assoc()). This lets you easily access each field by its column name, which is critical for flexible formatting.

// Database connection (replace with your own credentials)
$conn = mysqli_connect('localhost', 'db_username', 'db_password', 'your_database');

if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}

// Query for your target single row
$query = "SELECT product_name, price, stock_quantity FROM products WHERE id = 10";
$result = mysqli_query($conn, $query);

// Fetch row as an associative array (keys = column names, values = field data)
$row = mysqli_fetch_assoc($result);

mysqli_close($conn);

Step 2: Format the Data to Your Specified Structure #

This is where you define exactly how you want the output to look. Below are common format examples—pick the one that matches your needs, or adapt it to your custom structure.

Example 1: Custom Human-Readable Format #

If you want output like this:

Product Info:
Name: Wireless Headphones
Price: $99.99
In Stock: 42 units

Build the formatted string manually:

$formattedData = "Product Info:\n";
$formattedData .= "Name: " . $row['product_name'] . "\n";
$formattedData .= "Price: $" . number_format($row['price'], 2) . "\n";
$formattedData .= "In Stock: " . $row['stock_quantity'] . " units\n";

Example 2: JSON Format (Machine-Readable) #

If you need clean, structured JSON (great for APIs or later data processing):

// Use JSON_PRETTY_PRINT for human-readable indentation
$formattedData = json_encode($row, JSON_PRETTY_PRINT);

Example 3: CSV Format (For Spreadsheets) #

If you want a CSV row (with optional headers for clarity):

// Add column headers first
$headers = implode(',', array_keys($row)) . "\n";
// Add the actual data row
$dataRow = implode(',', array_values($row)) . "\n";

$formattedData = $headers . $dataRow;

Step 3: Write the Formatted Data to a File #

Use file_put_contents() for a simple, one-line write (or fopen()/fwrite() if you need more control over file handling):

$filePath = 'product_details.txt'; // Replace with your target file path

// Write to file (use FILE_APPEND to add to existing content instead of overwriting)
if (file_put_contents($filePath, $formattedData)) {
    echo "Data written successfully in your desired format!";
} else {
    echo "Error: Could not write to file. Double-check file permissions.";
}

Quick Pro Tips #

• Double-check that the column names in $row['column_name'] match exactly what’s in your database query—typos here will break formatting.
• For custom formats, use htmlspecialchars() or addslashes() if your data contains special characters (like quotes) to avoid formatting glitches.
• Ensure the file path you’re writing to has proper write permissions (chmod 644 works for most use cases).

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