How to get the specific row with View button

$database = new Connection();                          $db = $database->open();                          try{                                  $sql = 'SELECT * FROM payroll_payment';                              foreach ($db->query($sql) as $row) { }    <br> Name: <b>  <?php echo $row['fullname'] ; ?> </b> </br>                                          <br> Item Name: <b> <?php echo $row['item']; ?> </b> </br>                                          <br> Item Price: <b> ₱<?php echo number_format($row['price'],2) ?>  </b></br>                                          <br> quantity: <b> <?php echo $row['quantity']; ?> </b> </br>                                          <br> Commission: <b> ₱<?php echo $row['commission']; ?>  </b> </br>                                          <br> Date: <b>  <?php echo $row['date']; ?> </b>  </br>                                          <br> Total Sale: <b>₱<?php echo number_format($row['totalsale'],2) ?> </b> </br>                                          <br> Total Commission: <b> ₱<?php echo number_format($row['totalcommission'],2) ?> </b> </br>                                          <br> Grand Total: <b> ₱<?php echo number_format($row['grandtotal'],2) ?> <b> </br>   

within this code im getting the first row. i want to get the specific row for each user data. When clicking the view button i want to show each user data.

https://stackoverflow.com/questions/66916659/how-to-get-the-specific-row-with-view-button April 02, 2021 at 04:40PM