WordPress中如何将SQL查询结果表格左列替换为Daily/Monthly/Yearly？

Got it, let's sort out that repeating left column issue in your WordPress table. Here are two reliable solutions depending on your setup:

Solution 1: Hardcode Labels (If No Corresponding Database Field) #

If your myTable doesn't have a field that stores the period labels (Daily/Monthly/Yearly), you can define a matching array and map it to your query results:

global $wpdb;
// Fetch 3 dynamic data entries from myTable
$results = $wpdb->get_results("SELECT dynamic_data FROM myTable LIMIT 3");

// Define your desired left-column labels in order (matches the 3 rows)
$periodLabels = ['Daily', 'Monthly', 'Yearly'];

echo '<table>';
// Loop through results with index to match our label array
foreach ($results as $index => $row) {
    // Fallback to 'Unknown' if we have more results than labels (prevents errors)
    $currentLabel = isset($periodLabels[$index]) ? $periodLabels[$index] : 'Unknown';
    
    echo '<tr>';
    // Use esc_html() for security (prevents XSS attacks)
    echo '<td>' . esc_html($currentLabel) . '</td>';
    echo '<td>' . esc_html($row->dynamic_data) . '</td>';
    echo '</tr>';
}
echo '</table>';

Key Notes: #

• The $periodLabels array order must exactly match the order of rows returned by your SQL query.
• esc_html() is critical here—it sanitizes output to protect your site from cross-site scripting (XSS) vulnerabilities, which is a WordPress best practice.

Solution 2: Pull Labels Directly From Database (Better for Scalability) #

If your myTable already has a field (e.g., period_type) that stores the Daily/Monthly/Yearly values, modify your query to fetch that field directly. This keeps your data and display logic aligned:

global $wpdb;
// Fetch both the period label and dynamic data from myTable
$results = $wpdb->get_results("SELECT period_type, dynamic_data FROM myTable LIMIT 3");

echo '<table>';
foreach ($results as $row) {
    // Fallback to 'Unknown' if the period_type field is empty
    $currentLabel = !empty($row->period_type) ? $row->period_type : 'Unknown';
    
    echo '<tr>';
    echo '<td>' . esc_html($currentLabel) . '</td>';
    echo '<td>' . esc_html($row->dynamic_data) . '</td>';
    echo '</tr>';
}
echo '</table>';

Why This Is Better: #

• No hardcoded labels to update if your data changes later.
• Maintains a single source of truth for your period labels in the database.

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