title: How to add a "href" link in a td of data table to open a PHP page
body: <p>I have this server side table that works fine, except it has modals, but I need to open another PHP edit page(not as modal), linked to the row-id selected.</p>
  
  <pre><code> &lt;/div&gt;
     &lt;div class="table-responsive"&gt;
      &lt;table id="users_data" class="table table-bordered table-striped"&gt;
       &lt;thead&gt;
        &lt;tr&gt;
         &lt;th data-column-id="id" data-type="numeric"&gt;No&lt;/th&gt;
          &lt;th data-column-id="idno"&gt;Id No&lt;/th&gt;
          &lt;th data-column-id="surname"&gt;Surname&lt;/th&gt;
          &lt;th data-column-id="firstname"&gt;Firstname&lt;/th&gt;
         &lt;th data-column-id="category_name"&gt;Category&lt;/th&gt;
         &lt;th data-column-id="age"&gt;Age&lt;/th&gt;
         &lt;th data-column-id="commands" data-formatter="commands" data-sortable="false"&gt;Commands&lt;/th&gt;
        &lt;/tr&gt;
       &lt;/thead&gt;
      &lt;/table&gt;
  
      &lt;script type="text/javascript" language="javascript" &gt;
  $(document).ready(function(){
   $('#add_button').click(function(){
    $('#users_form')[0].reset();
    $('.modal-title').text("Add New Users");
    $('#action').val("Add");
    $('#operation').val("Add");
   });
  
   var usersTable = $('#users_data').bootgrid({
    ajax: true,
    rowSelect: true,
    post: function()
    {
     return{
      id: "b0df282a-0d67-40e5-8558-c9e93b7befed"
     };
    },
    url: "fetch.php",
    formatters: {
     "commands": function(column, row)
     {
  return "&lt;button type='button'  class='btn btn-warning btn-xs update' data-row-id='"+row.id+"'&gt;Edit&lt;/button&gt;" + 
  "&amp;nbsp; &lt;button type='button'  class='btn btn-danger btn-xs delete' data-row-id='"+row.id+"'&gt;Delete&lt;/button&gt;";
  
     }
    }
   });
  </code></pre>
  
  <p>Where the buttons are, I need something like this:</p>
  
  <pre><code>  &lt;td&gt;&lt;a href="update2.php?u=&lt;?php echo $row['id'] ?&gt;"&gt;&lt;span class="glyphicon glyphicon-pencil" aria-hidden="true" &lt;/span&gt;&lt;b&gt;&lt;font size="3" color="red"&lt;/font&gt; Edit&lt;b&gt;&lt;/a&gt;&lt;/td&gt;
  </code></pre>
  
  <p>Currently it uses this modal info:</p>
  
  <pre><code> $(document).on("loaded.rs.jquery.bootgrid", function()
   {
    usersTable.find(".update").on("click", function(event)
    {
     var id = $(this).data("row-id");
      $.ajax({
      //url:"update2.php",    
      url:"fetch_single_entries.php",
      method:"POST",
      data:{id:id},
      dataType:"json",
      success:function(data)
      {
       $('#usersModal').modal('show');
  
  
  
        $('#categories').val(data.categories);
       $('#idno').val(data.idno);
       $('#surname').val(data.surname);
       $('#firstname').val(data.firstname);
       $('#age').val(data.age);
       $('.modal-title').text("Edit User");
       $('#id').val(id);
       $('#action').val("Edit");
       $('#operation').val("Edit");
      }
     });
    });
   });
  </code></pre>
  
  <p>The fetch.php for the table data looks like this:</p>
  
  <pre><code>&lt;?php
  //fetch.php
  include("connection.php");
  $query = '';
  $data = array();
  $records_per_page = 10;
  $start_from = 0;
  $current_page_number = 0;
  if(isset($_POST["rowCount"]))
  {
   $records_per_page = $_POST["rowCount"];
  }
  else
  {
   $records_per_page = 10;
  }
  if(isset($_POST["current"]))
  {
   $current_page_number = $_POST["current"];
  }
  else
  {
   $current_page_number = 1;
  }
  $start_from = ($current_page_number - 1) * $records_per_page;
  $query .= "
   SELECT 
    users.id, 
    tblcategories.category_name, 
    users.idno,users.surname,users.firstname,    
    users.age FROM users 
    INNER JOIN tblcategories 
   ON tblcategories.category_id = users.category_id ";
  if(!empty($_POST["searchPhrase"]))
  {
   $query .= 'WHERE (users.id LIKE "%'.$_POST["searchPhrase"].'%" ';
   $query .= 'OR tblcategories.category_name LIKE "%'.$_POST["searchPhrase"].'%" ';
   $query .= 'OR users.idno LIKE "%'.$_POST["searchPhrase"].'%" ';
   $query .= 'OR users.surname LIKE "%'.$_POST["searchPhrase"].'%" ';
    $query .= 'OR users.firstname LIKE "%'.$_POST["searchPhrase"].'%" ';
   $query .= 'OR users.age LIKE "%'.$_POST["searchPhrase"].'%" ) ';
  }
  $order_by = '';
  if(isset($_POST["sort"]) &amp;&amp; is_array($_POST["sort"]))
  {
   foreach($_POST["sort"] as $key =&gt; $value)
   {
    $order_by .= " $key $value, ";
   }
  }
  else
  {
   $query .= 'ORDER BY users.id DESC ';
  }
  if($order_by != '')
  {
   $query .= ' ORDER BY ' . substr($order_by, 0, -2);
  }
  
  if($records_per_page != -1)
  {
   $query .= " LIMIT " . $start_from . ", " . $records_per_page;
  }
  //echo $query;
  $result = mysqli_query($connection, $query);
  while($row = mysqli_fetch_assoc($result))
  {
   $data[] = $row;
  }
  
  $query1 = "SELECT * FROM users";
  $result1 = mysqli_query($connection, $query1);
  $total_records = mysqli_num_rows($result1);
  
  $output = array(
   'current'  =&gt; intval($_POST["current"]),
   'rowCount'  =&gt; 10,
   'total'   =&gt; intval($total_records),
   'rows'   =&gt; $data
  );
  
  echo json_encode($output);
  
  ?&gt;
  </code></pre>
  
  <p>Please assist this novice programmer about how to adjust the code.</p>