下拉框选值后无法自动填充Brand文本框的技术求助

Let's break down what's going wrong here and fix it step by step:

1. Core Mismatch: Passed Value vs. Query Field #

This is the root cause of your issue:

• In your dropdown, you're setting each <option>'s value to productcode:

  <option value="<?php echo $dp['productcode'] ?>"><?php echo $dp['productcode']; ?></option>
  

• But in ff.php, you're querying using productid = '$id':

  $query = mysqli_query($conn,"SELECT productbrand FROM products WHERE productid = '$id' ");
  

Since productcode and productid are almost certainly different fields in your database, no matching records are found—so your script returns nothing, leaving the text box empty.

Fix options (pick one):

• Option 1: Change the dropdown's value to use productid (better practice, since IDs are unique primary keys):

  <option value="<?php echo $dp['productid'] ?>"><?php echo $dp['productcode']; ?></option>
  

• Option 2: Update the query in ff.php to match the passed productcode:

  $query = mysqli_query($conn,"SELECT productbrand FROM products WHERE productcode = '$id' ");
  

2. Add AJAX Error Debugging #

Your current AJAX call only handles successful responses—if something goes wrong (like a server error or invalid response), you won't know. Add an error callback to debug:

function getState(val) {
 $.ajax({
 type: "POST",
 url: "ff.php",
 data:'productid='+val,
 success: function(data){
 $("#brandss").val(data);
 },
 error: function(xhr, status, error) {
   // Log errors to browser console for troubleshooting
   console.error("AJAX Request Failed:", status, error);
   console.log("Server Response:", xhr.responseText);
 }
 });
}

Open your browser's developer tools (F12) and check the Console tab to see any issues with the request.

3. Fix ff.php for Safety & Edge Cases #

Your current ff.php has two problems:

• If no matching record is found, $brand is undefined, which will throw a warning.
• Directly inserting user input into SQL is a SQL injection vulnerability.

Rewrite ff.php using prepared statements (safer) and handle empty results:

<?php
require_once("conn.php");
$brand = ''; // Default empty value

if(isset($_POST['productid'])){
    $id = $_POST['productid'];
    // Use prepared statement to prevent SQL injection
    $stmt = $conn->prepare("SELECT productbrand FROM products WHERE productid = ?");
    // Adjust the type specifier if productid is an integer (use "i" instead of "s")
    $stmt->bind_param("s", $id);
    $stmt->execute();
    $result = $stmt->get_result();
    
    if($rs = $result->fetch_assoc()){
        $brand = $rs['productbrand'];
    }
    
    $stmt->close();
}

echo $brand;
?>

4. Double-Check Frontend Element IDs #

Make sure the text box's ID (brandss) is spelled correctly and matches what's referenced in your AJAX success callback. A typo here would prevent the value from being set.

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