how to pass the selected id to another page

General discussions related to php

Moderators: macek, egami, gesf

maideen
New php-forum User
New php-forum User
Posts: 27
Joined: Mon Mar 07, 2011 11:38 pm

how to pass the selected id to another page

Postby maideen » Wed Apr 02, 2014 3:59 am

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

Code: Select all

<?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

Code: Select all

<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

Code: Select all

<?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

Code: Select all

<?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

maideen
New php-forum User
New php-forum User
Posts: 27
Joined: Mon Mar 07, 2011 11:38 pm

Re: how to pass the selected id to another page

Postby maideen » Thu Apr 03, 2014 3:26 am

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

User avatar
menator01
New php-forum User
New php-forum User
Posts: 6
Joined: Sat May 10, 2014 3:29 pm

Re: how to pass the selected id to another page

Postby menator01 » Sat May 10, 2014 4:16 pm

You could pass it in a link like

Code: Select all

<a href="nextpage.php?id=$id">nextpage</a>

or have a look at sessions.


Return to “PHP General”

Who is online

Users browsing this forum: No registered users and 0 guests