使用HTML表中的值填充PHP数组

Question

I need to insert specific rows of an HTML table into a PHP array using a checkbox. For some reason only the first column is going into the array. the code i wrote is:

if(isset($_GET["key"])) {
    $user_key = $_GET["key"];
    if ($stmt = $mysqli->prepare("SELECT sandwich.sname, description, size, price FROM sandwich     JOIN menu on sandwich.sname = menu.sname WHERE description like ?")) {
        $stmt->bind_param("s", $search_string);
        $search_string= "%".$user_key."%";
        $stmt->execute();
        $stmt->bind_result($sname, $description, $size, $price);

        // Printing results in HTML
        echo "The menu for the given key word is.<br>";
        echo "<table border = '1'>
";
        while ($stmt->fetch()) {
            echo "<tr>";
            echo "<td>$sname</td><td>$description</td><td>$size</td><td>$price</td><td><input type='checkbox' name='order[]' value='$sname'|'$size'|'$price'></td>";
            echo "</tr>
";
        }
        echo "</table>
";
        $stmt->close();
    $mysqli->close();
    }

I nede all the sname, size and price values in the array order[] but only sname isgoing into it. Someone please suggest what is wrong with the code. I am totally new to PHP.

Answer 1

It looks like you have a couple of lines the wrong way round:

$stmt->bind_param("s", $search_string);
$search_string= "%".$user_key."%";

should be:

$search_string= "%".$user_key."%";
$stmt->bind_param("s", $search_string);

Also, are any of the field names common between both your sandwich and your menu tables? I would recommend modifying your query to state which tables you are referring to:

if ($stmt = $mysqli->prepare("SELECT sandwich.sname, <tablename>.description, <tablename>.size, <tablename>.price FROM sandwich JOIN menu on sandwich.sname = menu.sname WHERE <tablename>.description like ?")) {