Laravel新手求助：如何用下拉选择框实现多表数据筛选？

Hey there! Let's walk through fixing your multi-table filtering and Ajax dropdown issue step by step. I'll break down the problems in your code and show you the corrected versions.

First, let's tackle the issues in your controller:

• You're trying to fetch request()->sel_stand, but your Ajax sends a parameter named standard—these don't match!
• Directly concatenating SQL puts you at risk of SQL injection—always use parameter binding or Laravel's query builder to avoid this.
• It looks like you might have mixed up your tables: if subjects are linked to standards (via standard_id), you should query the subjects table instead of topics to get subject options.

Here's the corrected controller code:

public function getsubjects()
{
    // Grab the standard ID from the Ajax request
    $standardId = request()->input('standard');
    
    // Safely query the subjects table using Laravel's query builder
    $subjects = DB::table('subjects')
        ->where('standard_id', $standardId)
        ->get();
    
    // Build the dropdown options HTML
    $options = '<option value="">Select Subject</option>';
    foreach ($subjects as $subject) {
        $options .= '<option value="'.$subject->id.'">'.$subject->subject_name.'</option>';
    }
    
    return response()->json(['success' => 'Subjects loaded successfully.', 'users' => $options]);
}

If you do need to pull data from the topics table (e.g., if subject names are stored there), use parameter binding for safe SQL:

$topics = DB::select('SELECT * FROM `topics` WHERE standard_id = ?', [$standardId]);

Your script has a few small issues that are breaking functionality:

• You're listening for change events on both dropdowns, but only the sel_stand change should trigger a subject load.
• Using alert() for debugging is clunky—use console.log() instead to inspect data in your browser's dev tools.
• Make sure your page includes the CSRF meta tag (otherwise Laravel will block the request).

Corrected script:

<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.3/jquery.min.js"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.5/js/bootstrap.min.js"></script>
<script type="text/javascript">
jQuery(document).ready(function(){
    jQuery.ajaxSetup({
        headers: {
            'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')
        }
    });

    // Only listen for changes on the standard dropdown
    jQuery("#sel_stand").change(function(e){
        e.preventDefault();
        var standard = jQuery("#sel_stand").val();
        
        // Clear the subject dropdown if no standard is selected
        if(!standard) {
            jQuery("#sel_sub").html('<option value="">Select Subject</option>');
            return;
        }

        jQuery.ajax({
            type:'POST',
            url:'/getsubjects',
            data:{ standard: standard },
            success:function(data){
                console.log(data); // Check the response in your browser's console
                jQuery("#sel_sub").html(data.users);
            },
            error:function(xhr, status, error){
                console.error(xhr.responseText); // Print errors to debug issues
            }
        });
    });

    // Add this if you want to load topics when the subject dropdown changes
    jQuery("#sel_sub").change(function(e){
        e.preventDefault();
        var subjectId = jQuery("#sel_sub").val();
        // Add your Ajax logic here to fetch topics based on subject ID
    });
});
</script>

Make sure you've registered the POST route in routes/web.php:

Route::post('/getsubjects', [YourControllerName::class, 'getsubjects']);

Replace YourControllerName::class with the actual name of your controller.

Open your browser's developer tools (F12), go to the Network tab, and watch the Ajax request when you change the dropdown. This will show you if the request fails, what data is being sent, and what the server responds with—this is the fastest way to diagnose Ajax issues!

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