How to create conditional button in HTML based on MySQL data?

Question

I am trying to create a button that will either say "Follow" or "Unfollow", depending on whether or not the current user follows another user.

If John followed Tim, but not Sarah, the web view would look as follows, according to John's view:

_________________________________
|                |              |
|       Tim      |   (unfollow) |       
|________________|______________|
|                |              |
|       Sarah    |    (follow)  |       
|________________|______________|

Where (" ") denotes a button.

I have a database that indicates who follows whom, but how would I display the correct button based upon validation with said database?

great idea, start writing some code

user557846
– user557846

2012-05-10 21:13:25 +00:00
Commented May 10, 2012 at 21:13 — user557846
– user557846, Commented May 10, 2012 at 21:13

clayjar · Accepted Answer · 2012-05-10 21:46:39Z

Assuming you have three fields "name_id","name" and "followed" where "name_id" is the id of the person, "name" is a string signifying the name of the person, and "followed" is a boolean:

<script type="text/javascript">
function toggleFollowing(name_id) {
  window.location = 'toggleFollowing.php?name_id='+name_id;
}
</script>
...
<?php
  ...
  while ($row = $result->fetch_assoc()) {
    echo '<tr>';
    echo '<td>'.$row['name'].'</td><td><a href=""><button type="button" onclick="toggleFollowing('.$row['name_id'].')">'.($row['followed']==1 ? 'Unfollow':'Follow').'</button></td>';
    echo '</tr>';
  }
  ...
?>

You would have toggleFollowing.php receive the variable $_GET['name_id'] to toggle on the database and come back to this page. I'm assuming you have the current user's ID stored as a session variable or by other means since you would need that as a primary reference to update the record. If you're passing that from page to page by some other means, then you would want to pass that variable as well.

Apparently, this is more truncated code, but a better method would be to use AJAX to perform the toggling on the DB, and DOM manipulation (JQuery?) for a "real-time" update.

Pastor Bones · Accepted Answer · 2012-05-10 21:17:05Z

0

Hard to answer without examples of your code, but something like this?

<?php

  if(follow){
    echo '<input type="button" value="Follow" />';
  } else {
    echo '<input type="button" value="Unfollow" />';
  }

?>

answered May 10, 2012 at 21:17

Pastor Bones

7,3813 gold badges39 silver badges56 bronze badges

Collectives™ on Stack Overflow

How to create conditional button in HTML based on MySQL data?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related