PHP MYSQL Displaying the same data from table to another page

Question

<div class="card-header py-3">
          <h4 class="m-2 font-weight-bold text-primary">Asset Approval List</h4>
        </div>

        <div class="card-body">
          <div class="table-responsive">
            <table class="table table-bordered" id="dataTable" width="100%" cellspacing="0"> 
           <thead>
               <tr>
                 <th>Asset</th>
                 <th>Serial Number</th>
                 <th>Model Name</th>
                 <th>Owner ID</th>
                 <th>Owner Name</th>
                 <th>Description</th>
               </tr>
           </thead>
      <tbody>
    
    <script>
    function approval(){
      window.location.href = "AddAssetApproval.php";
    }
    </script>

<?php    
            
$query = "SELECT * FROM waiting_approval";
$result = mysqli_query($conn, $query) or die (mysqli_error($conn));

while ($row = mysqli_fetch_assoc($result)) {
                     
    echo '<tr>';
    echo '<td>'. $row['Category'].'</td>';
    echo '<td>'. $row['SerialNumber'].'</td>';
    echo '<td>'. $row['ModelName'].'</td>';
    echo '<td>'. $row['OwnerID'].'</td>';
    echo '<td>'. $row['OwnerName'].'</td>';
    echo '<td>'. $row['Description'].'</td>';
    echo '<td><input type="button" value = "View" onclick="approval()"></td>';
    echo '</tr> ';
}
?> 

<div class="title">
  Add Asset Approval Form
</div>

<div class="form">
   <div class="inputfield">
      <label>Category</label>
      <input type="text" class="input" name="Category">
   </div>  
     
   <div class="inputfield">
      <label>Serial Number</label>
      <input type="text" class="input" name="SN">
   </div>  

  <div class="inputfield">
      <label>Model Name</label>
      <input type="text" class="input" name="Model Name">
   </div> 

   <div class="inputfield">
      <label>Owner ID</label>
      <input type="text" class="input" name="OID">
   </div> 

   <div class="inputfield">
      <label>Owner Name</label>
      <input type="text" class="input" name="OName">
   </div> 

  <div class="inputfield">
      <label>Description</label>
      <input type="text" class="input" name="Desc">
   </div>

Asset Approval List is a table with lots of row of data and a button, after clicking the button, it will link to Asset Approval Form. I would like to fetch the data from the same row in Asset Approval List to my Asset Approval Form. The data in the table of Asset Approval List is fetched from mysql phpmyadmin. Any idea how to link the same data to Asset Approval Form?

This is my Asset Approval List

This is my Asset Approval Form

Is there a unique ID column in the table?

Barmar
– Barmar

2021-01-21 05:13:49 +00:00
Commented Jan 21, 2021 at 5:13 — Barmar
– Barmar, Commented Jan 21, 2021 at 5:13
yeap Serial Number is my unique ID

Kin Wei
– Kin Wei

2021-01-21 05:54:34 +00:00
Commented Jan 21, 2021 at 5:54 — Kin Wei
– Kin Wei, Commented Jan 21, 2021 at 5:54

Barmar · Accepted Answer · 2021-01-26 15:07:37Z

3

Assuming there's a unique ID column in the table, you should include that in the call to approval():

    echo '<td><input type="button" value = "View" onclick="approval(\'' . $row['SerialNumber'] . '\')"></td>';

Then change approval() to include the ID in the URL.

    function approval(serial){
      window.location.href = "AddAssetApproval.php?serial=" + serial;
    }

And AddAssetApproval.php should use $_GET['serial'] to display the appropriate approval form for that serial number.

$stmt = $conn->prepare("SELECT * FROM waiting_approval WHERE SerialNumber = ?");
$stmt->bind_param("i", $_GET['serial']);
$stmt->execute();
$result = $stmt->get_result();
$row = $result->fetch_assoc();

edited Jan 26, 2021 at 15:07

answered Jan 21, 2021 at 5:16

Barmar

789k57 gold badges554 silver badges669 bronze badges

Sign up to request clarification or add additional context in comments.

12 Comments

Kin Wei Over a year ago

may i know where to put $_GET['serial'] at?

Barmar Over a year ago

Use it when you're looking up the record to approve.

Kin Wei Over a year ago

I've added all of those but when i clicked on the button I get this error -> Uncaught ReferenceError: LPA101121104552 is not defined onclick @ C:\xampp\htdocs\hallbar23\hallbar\AssetApprovalList.php:105:191

Barmar Over a year ago

I mistakenly used PHP . instead of JS + for concatenation in the approval() function.

Kin Wei Over a year ago

owhhhhh so what should i do to achieve the solution?

|

Collectives™ on Stack Overflow

PHP MYSQL Displaying the same data from table to another page

1 Answer 1

12 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

12 Comments

Your Answer

Sign up or log in

Post as a guest

Related