How to add Hyperlink on php/html table that displays information from mysql database [closed]

by

You’ll have to use css/javascript to do this.

There are 3 ways: The more easy way is to print all data, but just not displaying it yet until someone clicks the link. For the hyperlink part. In this example I used a ‘span’ element which is styled like a hyperlink.

//place inside your head tag
<style>
.hyperlink-lookalike
{
    text-decoration:underline;
    color:blue;
    cursor:pointer;
}
</style>
<script>
//javascript function to toggle extra animal info
function show_extra_info(id)
{
   var tr = document.getElementById('extra_info_'+id);
   if(tr.style.display=='none')
   {
      tr.style.display='table-row';
   }
   else{
      tr.style.display='none';
   }
}
</script>

//inside the loop
echo '<tr>';
echo '<td colspan='2'><span class="hyperlink-lookalike" onclick="show_extra_info(' . $row['id'] . ')">' . $row['name'] . '</span></td>';
echo '</tr>';
echo '<tr id="extra_info_' . $row['id'] . '" style="display:none;">';
echo '<td>' . $row['cost'] . '</td>';
echo '<td>' . $row['life'] . '</td>';
echo '</tr>';

The second way is, and this one uses a hyperlink, go to a detail view:

echo '<td><a href="http://www.example.com/animaldetailedinfo.php?id=' . $row['id'] . '">' . $row['name'] . '</a></td>';

The third (more advanced) way is to do an AJAX request to get the information and display that in a ‘div’ tag. For that you might want to use a javascript library like jquery. Again if you want it to show up in a popup a hyperlink is not necessary. A span element with an onclick event that fires a javascript function that does the request to the server for more information is easier. 

$.get("http://www.example.com/animaldetailedinfo.php", function( data ) {
  $( "#popupcontainer" ).html( data );
});

More Related Contents:

  1. Query database then email posts from where user is subbed to
  2. Laravel – only a zero is saved to the database
  3. storing user_id in session variable
  4. I am seeing this error on submitting form Error: query was empty [closed]
  5. Is “mysqli_real_escape_string” enough to avoid SQL injection or other SQL attacks?
  6. MySQL Great Circle Distance (Haversine formula)
  7. How to insert multiple rows from array using CodeIgniter framework?
  8. MySQL and NoSQL: Help me to choose the right one
  9. Slowness found when base 64 image select and encode from database
  10. Why is mysqli giving a “Commands out of sync” error?
  11. JSON encode MySQL results
  12. PHP mysql insert date format
  13. How to store file name in database, with other info while uploading image to server using PHP?
  14. How to best store user information and user login and password
  15. Laravel: connect to databases dynamically
  16. Concatenating a string and primary key Id while inserting
  17. Php : Convert a blob into an image file
  18. PHP: Calling MySQL Stored Procedure with Both INPUT AND OUTPUT Parameters (NOT “INOUT”)
  19. Detect mysql update/insertion failure due to violated unique constraint
  20. PHP + MySql + Stored Procedures, how do I get access an “out” value?
  21. How do I construct a cross database query in PHP?
  22. How to bind SQL variables in PHP?
  23. Having issue with matching rows in the database
  24. PHP – Secure member-only pages with a login system
  25. MySQL ORDER BY IN()
  26. mysql – INSERT date range into date columns IF dates don’t overlap with existing ones
  27. php password_verify() hash and pass won’t match
  28. PHP mySQL – Insert new record into table with auto-increment on primary key
  29. How to check if a value already exists to avoid duplicates?
  30. MYSQL select a piece of a string and order by that piece

Leave a Comment