WordPress自定义用户系统搭建：如何用PHP/SQL存储导师自定义数据？

Great question! Building a tutor-specific user system in WordPress is totally doable without straying too far from core functionality. Let's walk through the best approaches—starting with the simplest, most WordPress-friendly method, then moving to more advanced options if you need them.

WordPress already has a built-in system for storing extra user data called user metadata. This is way better than jumping straight to custom SQL tables because it plays nicely with core updates, plugins, and existing user management tools.

Add Custom Fields to the Admin Profile #

First, let's add your tutor-specific fields (subjects taught, hourly rate) to the user's profile page in the WordPress admin. Drop this code into your theme's functions.php file or a custom plugin (plugins are better for long-term stability):

// Render custom tutor fields on user profile pages
add_action('show_user_profile', 'render_tutor_profile_fields');
add_action('edit_user_profile', 'render_tutor_profile_fields');

function render_tutor_profile_fields($user) {
    ?>
    <h3>Tutor Professional Details</h3>
    <table class="form-table">
        <tr>
            <th><label for="subjects_taught">Subjects Taught</label></th>
            <td>
                <input 
                    type="text" 
                    name="subjects_taught" 
                    id="subjects_taught" 
                    value="<?php echo esc_attr(get_user_meta($user->ID, 'subjects_taught', true)); ?>" 
                    class="regular-text" 
                />
                <p class="description">List subjects (e.g., "Algebra, AP Literature, Spanish")</p>
            </td>
        </tr>
        <tr>
            <th><label for="hourly_rate">Hourly Rate</label></th>
            <td>
                <input 
                    type="number" 
                    step="0.01"
                    name="hourly_rate" 
                    id="hourly_rate" 
                    value="<?php echo esc_attr(get_user_meta($user->ID, 'hourly_rate', true)); ?>" 
                    class="regular-text" 
                />
                <p class="description">Enter your hourly rate (e.g., 75.00)</p>
            </td>
        </tr>
    </table>
    <?php
}

Save the Custom Data #

Next, we need to make sure the data gets saved when the user updates their profile. Add this right after the previous function:

// Save custom tutor fields when profile is updated
add_action('personal_options_update', 'save_tutor_profile_fields');
add_action('edit_user_profile_update', 'save_tutor_profile_fields');

function save_tutor_profile_fields($user_id) {
    // Only let users edit their own profile or admins edit others
    if (!current_user_can('edit_user', $user_id)) return;

    // Sanitize and save subjects
    if (isset($_POST['subjects_taught'])) {
        update_user_meta(
            $user_id, 
            'subjects_taught', 
            sanitize_text_field($_POST['subjects_taught'])
        );
    }

    // Sanitize and save hourly rate
    if (isset($_POST['hourly_rate'])) {
        update_user_meta(
            $user_id, 
            'hourly_rate', 
            sanitize_text_field($_POST['hourly_rate'])
        );
    }
}

Retrieve and Display the Data #

When you need to show a tutor's info (like on a public profile page), use get_user_meta() to pull the data:

// Get the tutor's user ID (replace with a specific ID if needed)
$tutor_id = get_current_user_id();

// Fetch custom meta data
$subjects = get_user_meta($tutor_id, 'subjects_taught', true);
$hourly_rate = get_user_meta($tutor_id, 'hourly_rate', true);

// Display the data safely
if (!empty($subjects)) {
    echo '<p><strong>Subjects I Teach:</strong> ' . esc_html($subjects) . '</p>';
}
if (!empty($hourly_rate)) {
    echo '<p><strong>Hourly Rate:</strong> $' . esc_html($hourly_rate) . '</p>';
}

If you need a more structured setup—like allowing tutors to add multiple subjects with different rates per subject—you can create a custom database table. Note: This requires more maintenance, so only use this if the user meta approach isn't enough.

Create the Custom Table #

Add this code to a custom plugin's activation hook (don't run this directly—use the activation hook to avoid duplicate tables):

// Create custom table on plugin activation
function create_tutor_subjects_table() {
    global $wpdb;
    $table_name = $wpdb->prefix . 'tutor_subjects'; // Prefix ensures compatibility with multisite

    $charset_collate = $wpdb->get_charset_collate();

    $sql = "CREATE TABLE $table_name (
        id mediumint(9) NOT NULL AUTO_INCREMENT,
        user_id mediumint(9) NOT NULL,
        subject varchar(255) NOT NULL,
        hourly_rate decimal(10,2) NOT NULL,
        PRIMARY KEY  (id),
        KEY user_id (user_id)
    ) $charset_collate;";

    require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
    dbDelta($sql);
}
// Hook to plugin activation
register_activation_hook(__FILE__, 'create_tutor_subjects_table');

Insert Data into the Custom Table #

To add a subject and rate for a tutor:

global $wpdb;
$table_name = $wpdb->prefix . 'tutor_subjects';

$wpdb->insert(
    $table_name,
    array(
        'user_id' => get_current_user_id(),
        'subject' => 'Calculus BC',
        'hourly_rate' => 85.00
    ),
    array(
        '%d', // Integer for user ID
        '%s', // String for subject
        '%f'  // Float for rate
    )
);

Retrieve Data from the Custom Table #

To get all subjects and rates for a specific tutor:

global $wpdb;
$table_name = $wpdb->prefix . 'tutor_subjects';
$tutor_id = get_current_user_id();

// Use prepare() to prevent SQL injection
$subjects = $wpdb->get_results(
    $wpdb->prepare("SELECT subject, hourly_rate FROM $table_name WHERE user_id = %d", $tutor_id)
);

if ($subjects) {
    echo '<ul class="tutor-subjects">';
    foreach ($subjects as $item) {
        echo '<li>' . esc_html($item->subject) . ' - $' . esc_html($item->hourly_rate) . '/hour</li>';
    }
    echo '</ul>';
}

• Always sanitize/escape data: Use sanitize_text_field(), esc_html(), and $wpdb->prepare() to protect against SQL injection and XSS attacks.
• Use custom plugins: Avoid putting this code in your theme's functions.php—if you switch themes later, your custom functionality will break. A simple plugin takes 2 minutes to set up.
• Permissions: The current_user_can() check in the save function ensures only authorized users can edit tutor data.

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