PHP MySQL搜索结果表格添加自增序号列技术求助

Hey Robin, I see where you're stuck—let's get that sequential numbering working for your table's first column. The main issue in your current code is that you're assigning the entire $results array to $field1name, which won't give you the 1,2,3... sequence you need. Here's how to fix it step by step:

Step 1: Initialize a Counter Variable #

Right before your foreach loop, declare a counter starting at 1. This will track the number for each row:

if (count($results) > 0) {
  $counter = 1; // Add this line to start the counter
  foreach ($results as $r) {

Step 2: Use the Counter for the "No" Column #

Replace the line $field1name = $results; with using the $counter variable directly, then increment the counter at the end of each loop iteration:

// Replace $field1name = $results; with this:
$field1name = $counter;

// ... keep all your existing code for other fields ...

// At the end of the foreach loop, add this to increment the counter
$counter++;

Modified Full Code Snippet #

Here's how the relevant part of your code will look after the changes (key edits are highlighted):

if (count($results) > 0) {
  $counter = 1; // Initialize counter
  foreach ($results as $r) {
    $field1name = $counter; // Use counter for the "No" column
    $field2name = $r["pre_code"];
    $field3name = $r["post_code"];
    $field4name = $r["f_code"];
    $field5name = $r["device"];
    $field6name = $r["Name"];
    $field7name = $r["class"];
    $field8name = $r["AM"];
    $field9name = $r["AT"];
    $field10name = $r["shopfront_signage"];
    $field11name = $r["p1"];
    $field12name = $r["p2"];
    $field13name = $r["p3"];
    $field14name = $r["p4"];
    $field15name = $r["p5"];

    // ... your existing image fallback logic stays the same ...

    echo '<tr style="width: 259px; vertical-align:top"> <td>' . $field1name . '</td> <td>' . $field2name . '</td> <td >' . $field3name . '</td> <td >' . $field4name . '</td> <td>' . $field5name . '</td> <td>' . $field6name . '</td> <td >' . $field7name . '</td> <td >' . $field8name . '</td> <td>' . $field9name . '</td> <td>' . $field10name . '</td> <td><a href="/dealer/search/images/' . $img . '" target = "_blank"><img src="/dealer/search/images/' . $img . '" height="100" width="120"></td> <td><a href="/dealer/search/images/' . $img2 . '" target = "_blank"><img src="/dealer/search/images/' . $img2 . '" height="100" width="120"></td> <td><a href="/dealer/search/images/' . $img3 . '" target = "_blank"><img src="/dealer/search/images/' . $img3 . '" height="100" width="120"></td> <td><a href="/dealer/search/images/' . $img4 . '" target = "_blank"><img src="/dealer/search/images/' . $img4 . '" height="100" width="120"></td> <td><a href="/dealer/search/images/' . $img5 . '" target = "_blank"><img src="/dealer/search/images/' . $img5 . '" height="100" width="120"></td> </tr>';

    $counter++; // Increment counter for next row
  }
  $result->free();
} else {
  echo '<FONT COLOR="RED" SIZE="5"> &nbsp;&nbsp;&nbsp; >> &nbsp;&nbsp;&nbsp; NO RESULTS FOUND </FONT>';
}

Why This Works #

• The $counter variable starts at 1 for the first result row.
• Each time we loop through a result, we use the current counter value for the "No" column.
• After processing the row, we increment the counter so the next row gets the next number in sequence.

This will give you the 1,2,3... numbering you want for the first column of your results table.

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