Run a while loop inside a function?

Question

I made a function and passed values in it but it does not give any output. Instead of writing the same code for fetching data from different tables, I want to make a function so that just by passing string values of table name code could be executed. Here is my code.

        function productTableQuery($selectTable) {

          $query = "SELECT * FROM $selectTable";
          $result = mysqli_query($connection, $query);

          while ($row = mysqli_fetch_assoc($result)) {

            $serialNumber = $row['serial_number']; 
            $particulars = $row['particulars']; 

            echo "<option value='$serialNumber'>$particulars</option>";

          }

        }

        switch($product_table) {
            case 'insert':
                productTableQuery("product_insert");

            break;

            default:
              header("Location: index.php");
              break;
          }

Where is `$connection` defined? It's not in scope in the function. — iainn, Oct 31 '18 at 13:09
first of all, check if function `productTableQuery` is been called or not ? — Krishna Joshi, Oct 31 '18 at 13:19

CaffeinatedCod3r · Answer 1 · 2018-10-31T13:52:04.170

Try this. I have edited condition in while loop. And also you forgot to include 'select'
tag.

function productTableQuery($selectTable) {

          $query = "SELECT * FROM $selectTable";
          $result = mysqli_query($connection, $query);
          echo "<select name='dropDown'>";
          while ($row = mysqli_fetch_array($result)) {

            $serialNumber = $row['serial_number']; 
            $particulars = $row['particulars']; 

            echo "<option value='$serialNumber'>$particulars</option>";

          }
        echo "</select>";
        }

        switch($product_table) {
            case 'insert':
                productTableQuery("product_insert");

            break;

            default:
              header("Location: index.php");
              break;
          }

Run a while loop inside a function?

1 Answers1