select that particular id when button is pressed in php

Question

I am trying to send the id from one page to other and i have achieved that but how do i make sure that when the show is pressed of a particular column only that id is sent.Here is my code. This is index.php.It displays the rows and a show button against each row.

    <?php session_start(); ?>
    <!DOCTYPE html>
    <html lang="en">
    <head>
    <meta charset="utf-8">
    <link   href="css/bootstrap.min.css" rel="stylesheet">
    <script src="js/bootstrap.min.js"></script>
    </head>

    <body>
    <div class="container">
            <div class="row">
                <h3>Restaurant Categories</h3>
            </div>
            <div class="row">
            <p> <a href="create_categories.php" class="btn btn-success">Create</a> </p>
                <table class="table table-striped table-bordered">
                  <thead>
                    <tr>
                      <th>ID</th>
                      <th>Name</th>
                      <th>Description</th>
                    </tr>
                  </thead>
                  <tbody>
                  <?php
                   include 'database.php';
                   $pdo = Database::connect();
                   $sql = 'SELECT * FROM Categories';
                   $result = $pdo->query($sql);
                   foreach ($pdo->query($sql) as $row) {
                            echo '<tr>';
                            echo '<td>'. $row['C_id'] . '</td>';
                            echo '<td>'. $row['C_name'] . '</td>';
                            echo '<td>'. $row['C_description'] . '</td>';
                            echo '<td><a class="btn" href="show_items.php">Shitems</a>     </td>';

                            $_SESSION["id"] = $row['C_id'];     <-----I am saving the id here.But it only saves the latest id
                            echo $_SESSION["id"];
                            echo '</tr>';
                   }
                   Database::disconnect();
                  ?>
                  </tbody>
            </table>
        </div>
       </div> <!-- /container -->
    </body>
  </html>

I believe this is because sessions can only store 1 thing, so i would recommend you use post or get to send what you need or do as Marc B's answer — Jim Sundqvist, Jan 02 '15 at 16:07

score 2 · Accepted Answer · answered Jan 02 '15 at 16:07

2

Just embed the ID in the url as a query string:

echo '<td><a class="btn" href="show_items.php?id=' . $row['C_id'] . '">Shitems</a>     </td>';
                                             ^^^^^^^^^^^^^^^^^^^^

answered Jan 02 '15 at 16:07

Marc B

356,200
43
426
500

Is it safe that way?Won't it lead to SQL injection? – soldiershin Jan 02 '15 at 16:20
1

only if you write crappy code that allows it: http://stackoverflow.com/questions/60174/how-can-i-prevent-sql-injection-in-php – Marc B Jan 02 '15 at 16:22

score 0 · Answer 2 · answered Jan 02 '15 at 16:08

0

Simple using _GET...

<a class="btn" href="show_items.php">

<a class="btn" href="show_items.php?id=<?=$row['C_id']?>">

Then you can access it via... _GET['id']

answered Jan 02 '15 at 16:08

geggleto

2,605
1
15
18

score 0 · Answer 3 · answered Jan 02 '15 at 16:08

0

First you need from form around button. But you can make this with ajax(if you don't redirect the page) or link

answered Jan 02 '15 at 16:08

Fortran

593
4
14

select that particular id when button is pressed in php

3 Answers3