CODEWITHSUNDEEP
phpmysql
darwinboy
darwinboy

Reputation: 53

hyperlink on every row of mysql data

<?php

require 'database.php'; 
$query = "SELECT id, date, ponumber FROM so";

$result = $mysqli->query($query) or die(mysqli_error($mysqli));

if ($result) {
  echo "<form method='post' action='delete.php'>"; 

  echo "<table cellspacing='0' cellpadding='15' border='1'>
  <th >DELETE</th>
  <th >VIEW</th>
  <th >ID</th>
  <th >DATE</th>
  <th >PO NUMBER</th>";

  while ($row = $result->fetch_object()) {

$date      = $row->date ;
$ponumber  = $row->ponumber;
$id        = $row->id;
//put each record into a new table row with a checkbox
echo "<tr>
    <td>
        <input type='checkbox' name='checkbox[]' id='checkbox[]'  value=$id />
    </td>
     <td>
        $id
     </td>
     <td>
        <a href="view.php">view</a>
     </td>
    <td>
         $date
    </td>
<td>
       $ponumber
     </td>
  </tr>"; 
    }

   echo "</table><p><input id='delete' type='submit' class='button' name='delete' 

       value='Delete Selected Items'/></p></form>";}
?>

i have a sort of an online order form which enable the sales rep to input sales order, i have done the insert and delete using the code above now i want every row to be a hyperlink so that when they click view it will display only row that has been clicked, in my code above if you click :view" all the detail will display, how can i display only the row that i will click will display the detail of the record!

Upvotes: 1

Views: 976

Answers (1)

AD7six
AD7six

Reputation: 66178

you need to pass the id in the url and you need to read it if it's there.

e.g.

<?php
require 'database.php'; 
$query = "SELECT id, date, ponumber FROM so";
/* Edit 1 */
if (!empty($_GET['id'])) { 
    $query .= " WHERE id = " . mysql_real_escape_string($_GET['id']);
}
/* Edit 1 end */
$result = $mysqli->query($query) or die(mysqli_error($mysqli));
if($result) {
    echo "<form method='post' action='delete.php'>"; 
    echo "<table cellspacing='0' cellpadding='15' border='1'>
            <th >DELETE</th><th >VIEW</th><th >ID</th><th >DATE</th><th >PO NUMBER</th>";
    while ($row = $result->fetch_object()) {
        $date = $row->date ;
        $ponumber = $row->ponumber;
        $id = $row->id;
        //put each record into a new table row with a checkbox
        echo "<tr>
                  <td><input type='checkbox' name='checkbox[]' id='checkbox[]'  value=$id /></td>
                  <td>$id</td>
                  <td>";
            /* Edit 2 */
            echo "<a href='view.php?id=$id'>view</a>";
            /* Edit 2 End */
            echo "</td>
                  <td>$date</td>
                  <td>$ponumber</td></tr>"; 
    }
    echo "</table><p><input id='delete' type='submit' class='button' name='delete' value='Delete Selected Items'/></p></form>";}
?>

A style suggestion:

Don't do/stop doing this:

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

Where what you are echoing is a static string. Instead, do:

?>
<form method='post' action='delete.php'>
...
<?php
while

it's simply easier to read and maintain.

Upvotes: 1

Related Questions