Tukukkk

In track.php Page once we click on "Submit" button [1st row], I want to Update "ecomexpress_awb table -> orderid column" with value 123456789....

Track.php page [ Based on Orders Table ]:

Below is Table Orders :

Below is Table ecomexpress_awb

Track.php

<?php



$con = mysqli_connect("localhost","root","","do_management4");



$result = mysqli_query($con,"SELECT * FROM orders");



echo "<table border='1'>

<tr>

<th>order</th>

<th>payment</th>

<th>generate</th>

<th>tracking id</th>

</tr>";



while($row = mysqli_fetch_array($result))

{

$id = $row['id'];

echo "<tr>";

echo "<td>" . $row['order_id'] . "</td>";

    echo "<td>" . $row['payment_type'] . "</td>";



    echo "<td>";

    if (empty($row['awb'])) {

        echo "<form method='post' action='call.php'>";

        echo "<input type ='hidden' name='id' value='$id'>

          <input type='submit'>

          </form>";

    }

    echo "</td>";

echo "<td>" . $row['awb'] . "</td>";



echo "</tr>";

}

echo "</table>";



mysqli_close($con);



?>

Call.php

<?php



$con = mysqli_connect("localhost","root","","do_management4");



$result = mysqli_query($con,"SELECT * FROM ecomexpress_awb");



$awb_id='';

$awb_id = $_POST['awb_id'];



$sql = $con->query("update ecomexpress_awb set orderid = '' WHERE awb_id ='$awb_id'");



mysqli_close($con);



?>

Check this code, This may help you
You should insert awb when insert record in orders table if you have awb then you can update like this

Track.php

<?php



$con = mysqli_connect("localhost","root","","do_management4");



$result = mysqli_query($con,"SELECT * FROM orders");



echo "<table border='1'>

<tr>

<th>order</th>

<th>payment</th>

<th>generate</th>

<th>tracking id</th>

</tr>";



while($row = mysqli_fetch_array($result))

{

$id = $row['id'];

echo "<tr>";

echo "<td>" . $row['order_id'] . "</td>";

    echo "<td>" . $row['payment_type'] . "</td>";



    echo "<td>";

    if (empty($row['awb'])) {

        echo "<form method='post' action='call.php'>";

        echo "<input type ='hidden' name='id' value='$id'>

            <input type ='hidden' name='order_id' value='".$row['order_id']."'>

            <input type ='hidden' name='awb' value='".$row['awb']."'>

          <input type='submit'>

          </form>";

    }

    echo "</td>";

echo "<td>" . $row['awb'] . "</td>";



echo "</tr>";

}

echo "</table>";



mysqli_close($con);



?>

Call.php

<?php



$con = mysqli_connect("localhost","root","","do_management4");



$result = mysqli_query($con,"SELECT * FROM ecomexpress_awb");



$awb_id='';

$awb_id = $_POST['awb_id'];



$sql = $con->query("update ecomexpress_awb set orderid = '".$order_id."' WHERE awb_id ='$awb_id'");



mysqli_close($con);





//Added code

$order_id='';

if(isset($_POST['order_id']) && $_POST['order_id']!=''){

    $order_id = $_POST['order_id'];

    $awb= $_POST['awb'];

    $sql = $con->query("update ecomexpress_awb set orderid = '".$order_id."' WHERE awb ='".$awb."'");

    mysqli_close($con);

}

//End added code



?>

Add one more field in your your button form in Track.php :

echo "<form method='post' action='call.php'>";

        echo "<input type ='hidden' name='id' value='$id'>

            <input type ='hidden' name='order_id' value='".$row['order_id']."'>

            <input type ='hidden' name='awb' value='".$row['awb']."'>

          <input type='submit'>

          </form>";

and then update your update query in call.php :

if(isset($_POST['order_id'], $_POST['awb'])

 && !empty($_POST['order_id'])

 && !empty($_POST['awb'])){

    $con = mysqli_connect("localhost","root","","do_management4");

    $awb = $_POST['awb'];

    $order_id = $_POST['order_id'];

    $sql = $con->query("update ecomexpress_awb set orderid = '".$order_id."' WHERE awb ='".$awb."'");

    mysqli_close($con);

}