请求修改posts1.php模板，实现特定分类帖子按姓氏+名字排序

Got it, let's walk through modifying your posts1.php template to support both Last Name and First Name sorting. Since you already have the Last Name sorting working, this is just a matter of adding a way to toggle between the two and updating the query logic. Here's my step-by-step approach:

1. Locate the Existing Sorting Logic in posts1.php #

First, find where the post query is defined. It’s probably using WP_Query with a meta key for Last Name, or maybe a custom SQL query. For example, your current code might look something like this:

// Original Last Name-only query
$args = array(
    'category_name' => 'your-target-category', // Replace with your category slug
    'orderby' => 'meta_value',
    'meta_key' => 'last_name', // Your existing Last Name meta key
    'order' => 'ASC'
);
$post_query = new WP_Query($args);

2. Add a Toggle for Sorting Parameter #

We’ll use a URL query parameter (like ?sort=first_name) to let users switch between sorting options. Update the query logic to check for this parameter and adjust the meta key accordingly:

// Get sort choice from URL (default to Last Name if no parameter is set)
$sort_option = isset($_GET['sort']) ? sanitize_text_field($_GET['sort']) : 'last_name';

// Map the sort option to the correct meta key
$sort_meta_key = ($sort_option === 'first_name') ? 'first_name' : 'last_name';

// Updated query with dynamic sorting
$args = array(
    'category_name' => 'your-target-category',
    'orderby' => 'meta_value',
    'meta_key' => $sort_meta_key,
    'order' => 'ASC'
);
$post_query = new WP_Query($args);

Note: Replace first_name with the actual meta key you use for First Names if it’s different (e.g., fname).

3. Add Frontend Sorting Links #

To let users switch between sorting options, add these links somewhere above your post list in posts1.php (like a header or filter bar):

<div class="sort-controls">
    <strong>Sort by:</strong>
    <a href="<?php echo add_query_arg('sort', 'last_name', get_permalink()); ?>">Last Name</a>
    |
    <a href="<?php echo add_query_arg('sort', 'first_name', get_permalink()); ?>">First Name</a>
</div>

This will generate links that keep the current page’s URL but add/update the sort parameter.

4. If You’re Using Custom SQL (Instead of WP_Query) #

If your original code uses a direct SQL query instead of WP_Query, adjust the ORDER BY clause dynamically. Here’s an example:

global $wpdb;

$sort_option = isset($_GET['sort']) ? sanitize_text_field($_GET['sort']) : 'last_name';
$sort_meta_key = ($sort_option === 'first_name') ? 'first_name' : 'last_name';

// Escape the meta key to prevent SQL injection
$safe_meta_key = $wpdb->escape($sort_meta_key);

$sql = "
    SELECT p.*, pm.meta_value AS sort_value
    FROM {$wpdb->posts} p
    JOIN {$wpdb->postmeta} pm ON p.ID = pm.post_id
    WHERE pm.meta_key = '$safe_meta_key'
    AND p.post_category = 'your-category-id' // Replace with your category ID
    AND p.post_status = 'publish'
    ORDER BY pm.meta_value ASC
";
$posts = $wpdb->get_results($sql);

Quick Checks Before Testing #

• Make sure all posts in your target category have both last_name and first_name meta fields populated (otherwise, posts missing a field might not show up in the sorted list).
• Test the sorting links to ensure they switch between Last Name and First Name correctly.
• Double-check that you’ve replaced placeholder values (like category slug/ID) with your actual site’s details.

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