Hi
I am new, Pls help me the following issue. When click the update button, ID should be to another page to process the update function. Below is my entire code

index.php

<?php
include_once '../../inc/config.inc.php';

$sql="SELECT * FROM demo  order by id";
    try {
            $result = mysqli_query($con,$sql);  
            include 'view.html.php'; 
         } 
    catch (PDOException $e) 
        {
           echo $e->getMessage() . "\n";
           file_put_contents('PDOErrors.txt', $e->getMessage(), FILE_APPEND);
//           $output = 'Error fetching authors from database!';
//           include '../../notification/errormsg.php';
           exit();
        }

view.html.php

<Script Language="javascript">
function change_action()
    {
        var frm_obj=document.getElementById("frm");
        frm_obj.action="data.php";
    }
</Script>

<h3>User Details</h3>
<form action="" method="POST" id="frm" >
    <table width="100%" align="center" cellpadding="4" cellspacing="1">
        <tr>

            <td>ID</td>
            <td>ID</td>
            <td>NAME</td>
            <td>FIRST NAME</td>
            <td>AGE</td>
            <td></td>

        </tr>
        <?php
            if(isset($result)){
            while($row = mysqli_fetch_array($result)){ ?>
             <tr>

                <td><input type="text" name="vid" value="<?php echo $row['id'];?>"/></td>
                <td><?php echo $row['id'];?></td>
                <td><?php echo $row['name'];?></td>
                <td><?php echo $row['firstname'];?></td>
                <td><?php echo $row['age'] ;?></td>
                <td><input type="submit" value="update" name="update" onclick="change_action()">
                <input type="submit" value="delete" name="delete" onclick="change_action()">
                </td>                
              </tr>  
         <?php
            } 

            }
            mysqli_close($con);
        ?>

    </table>
</FORM>
<?php
include '../../inc/footer.php';

data.php

<?php
include_once '../../inc/config.inc.php';
if (isset($_POST['update']) && $_POST['update']  != "" )
        {
            $id = $_POST['vid'];
            $sql="SELECT * FROM demo where id='$id'";
            $result = mysqli_query($con,$sql);
            include 'edit.php';  
     }

edit.php

<?php
echo 'edit.php';

if(isset($result))
    {
        while($row = mysqli_fetch_array($result))
                { 
                    echo $row['id'];'<br>';
                    echo $row['name'];'<br>';
                    echo $row['firstname'];'<br>';
                    echo $row['age'];'<br>';

                }
    }

Thank you

maideen

You can use $_SESSION

or $_POST

<input type="text" value="<?php echo $row['id'];?>"  readonly>

Hi pzuuveen

how to use session in below code. When I click button.

Basically page shows all data as table format with id. If i click the selected update button, the id of selected row to be posted into next pages to retrive the data of the particular Id. Can you pls explain how to do?

  <?php
            if(isset($result)){
            while($row = mysqli_fetch_array($result)){ ?>
             <tr>

                <td><input type="text" name="vid" value="<?php echo $row['id'];?>"/></td>
                <td><?php echo $row['id'];?></td>
                <td><?php echo $row['name'];?></td>
                <td><?php echo $row['firstname'];?></td>
                <td><?php echo $row['age'] ;?></td>
                <td><input type="submit" value="update" name="update" onclick="change_action()">
                <input type="submit" value="delete" name="delete" onclick="change_action()">
                </td>                
              </tr>  
         <?php
            } 

            }
            mysqli_close($con);
        ?>

hi pzzurveen

I have used in view.html.php

<td><input type="text" name="vid" value="<?php echo $row['id'];?>"/></td>

If I select any row, but edit page shows only last record in database

Pls

I am telling the scnario. I have page with all customer data as grid format. last column is "UPDATE". If I select 5th row and click update, next page open the details of 5th row customer data.
My sql command:

$sql="select id,name,firstname,age from customer where id='$id'"

How can i pass the id for select customer to the next page to retrive data from mysql database and to update if any changes.

Pls help me

ID ID NAME FIRST NAME AGE
1 Hoffman Tatyana 100 Update
2 Atkins Ishmael 44 Update
3 Hamilton Mohammad 73 Update
4 Murray Troy 18 Update
5 Schwartz Carla 79 Update
6 Bond Leno 33 Update
7 Noble Georgia 88 Update
8 Frederick Bradley 80 Update
9 Chambers Aphrodite 63 Update
10 Schultz Allegra 90 Update
11 Garrett Lillith 20 Update
12 Mcdaniel Venus 89 Update
13 Acevedo Iola 26 Update

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.