Create hyperlink from html table row to open record on a new page

by

Assuming that you’re creating the table doing something like this,

$results = some_mysql_query;
foreach ($results as $index => $array) {
    echo "<tr>";
        echo "<td>";
            echo $array['RecordNumber'];
        echo "</td>";
        echo "<td>";
            echo $array['CallerName'];
        echo "</td>";
        echo "<td>";
            echo $array['Time'];
        echo "</td>";
        echo "<td>";
            echo $array['Duration'];
        echo "</td>";
    echo "</tr>";
}

Then you can add in a link by doing something like this:

$results = some_mysql_query;
foreach ($results as $index => $array) {
    echo "<tr>";
        echo "<td>";
            echo "<a href="https://stackoverflow.com/questions/34799831/recordInfo.php?record="" . $array['RecordNumber'] . "'>" . $array['RecordNumber'] . "</a>";
        echo "</td>";
        echo "<td>";
            echo "$array['CallerName'];
        echo "</td>";
        echo "<td>";
            echo $array['Time'];
        echo "</td>";
        echo "<td>";
            echo $array['Duration'];
        echo "</td>";
    echo "</tr>";
}

NOTE the use of single-quotes, ‘, inside the double-quotes – and the ‘”https://stackoverflow.com/”‘ surrounding the variable.

Alternatively, your echo with the link could look like this:

            echo "<a href="https://stackoverflow.com/questions/34799831/recordInfo.php?record="{$array['RecordNumber']}'>{$array['RecordNumber']}</a>";

These accomplish the same thing.

This principle is the same, BTW, if your code looks like this:

$results = some_mysql_query;
while ($row = mysql_fetch_array($result)) {
    ...
        echo $row['RecordNumber'];

Also, in case you’re not already aware of how this will work, your recordInfo.php will receive its information in the $_GET array; specifically, it will refer to the RecordNumber as $_GET['RecordNumber'].

More Related Contents:

  1. Getting links from db and displaying them in another div [closed]
  2. HTML Form/PHP connected but MySQL is empty
  3. Parse error: syntax error, unexpected T_STRING in C:\wamp\www\b_php\project\login_save.php on line 14 [closed]
  4. Save the data into a database and return another value from database using PHP
  5. Thank you for helping [closed]
  6. Is the following code valid? [closed]
  7. How to retrieve images from MySQL database and display in an html tag
  8. Preserve Line Breaks From TextArea
  9. How to upload images into MySQL database using PHP code
  10. Fetching data from MySQL database to HTML dropdown list
  11. HTML – Change\Update page contents without refreshing\reloading the page
  12. Delete multiple rows by selecting checkboxes using PHP
  13. “slash before every quote” problem [duplicate]
  14. How to add a delete button to a PHP form that will delete a row from a MySQL table
  15. Dynamic table in HTML using MySQL and php
  16. mysqli_query() expects at least 2 parameters, 1 given in? [duplicate]
  17. display data from SQL database into php/ html table [closed]
  18. Echo menu tree with recursive function
  19. How to display an BLOB image stored in MySql database?
  20. Javascript function post and call php script
  21. PHP – Secure member-only pages with a login system
  22. PHP: Inserting Values from the Form into MySQL
  23. onbeforeprint() and onafterprint() equivalent for non IE browsers
  24. Creating dynamic tables in HTML using MySQL and PHP
  25. Create table with PHP and populate from MySQL
  26. Turkish characters are not displayed correctly [duplicate]
  27. mysql_fetch_array skipping first row
  28. Displaying BLOB image from Mysql database into dynamic div in html
  29. Using PHP to upload file and add the path to MySQL database
  30. MySQL PHP – SELECT WHERE id = array()? [duplicate]

Leave a Comment