Search the Community
Showing results for tags 'while loop'.
-
I'm trying to build an online tool checkout application, so I'm working with script 10.5 to pull (tool names) from a database to populate a table. I need to be able to select multiple tools (using checkboxes), and then submit that form to a shopping cart. I've been able to add a checkbox to each result, but is this the correct way to give each checkbox the name associated with it? // Fetch and print all the records.... $bg = '#eeeeee'; while ($row = mysqli_fetch_array($r, MYSQLI_ASSOC)) { $bg = ($bg=='#eeeeee' ? '#ffffff' : '#eeeeee'); echo '<tr bgcolor="' . $bg . '"> <td align="left">' . $row['category'] . '</td> <td align="left">' . $row['name'] . '</td> <td align="left"> <form action="view_cart.php" method="post"> <input type="checkbox" name="checked" value="$row['name']" /> </td> '; } // End of WHILE loop. And then to display the results? if ($_SERVER['REQUEST_METHOD'] == 'POST') { while ($row = mysqli_fetch_array ($r, MYSQLI_ASSOC)) { echo "\t<tr> <td align=\"left\">{$row['name']}</td> </tr>\n"; } // End of the WHILE loop. It just feels like a shot in the dark, and so I wanted to ask.
- 2 replies
-
- checkbox
- while loop
-
(and 1 more)
Tagged with:
-
Hi Larry, great book, finding it really clear and useful. Thought I'd just ask about the style of coding you've used to display the products in the list_products.html file. You include the header div for that page within the while loop, only echoing it on the first iteration. It uses the g_description and g_image columns from the first row. My problem is that, g_description and g_image are still in every other row of the mysql result. They are identical to those in the first row and are never used. I can't help but feel it's a shame to have called for them in the first place. Have you done it this way to minimize calls to the database? The way I might be tempted to write this page, is to get the category details in a separate database call, then I could take the header completely out of the while loop, and there wouldn't be a need for the if (!$header){ condition. Hope that makes sense to you. Just wondering what your thoughts on this were? Thanks for reading!