• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Generating Links Within a HTML Table Using Query Results.

#1
[eluser]Unknown[/eluser]
I'm trying to display two columns in my table view, one being a title of the document, the next being a description of the document. I have a column in the particular table which I am selecting named "filename" that stores the name of the uploaded document which is associated with it's title and description.

I'm curious as to how I would manage to display only the title and description, while setting the data contained in the "filename" column as the hyperlink value of the title? (Basically, I'm wanting them to be able to download a document once they click on it's name)

I'm fairly certain that I can pull this off by manually by skipping the table generator and doing a "foreach" in the view to print out all the data from the resultset, but I'm open to suggestions, as this would make for sloppy code. Here's a snippet of my controller below.

Code:
<?php
class blah extends CI_Controller {

public function troubleshooting() {
$this->load->library('pagination');
$this->load->library('table');

$config['base_url'] = 'http://somewebsite.com/troubleshooting';
$config['total_rows'] = $this->db->get('document')->num_rows();
$config['per_page'] = 10;
$config['num_links'] = 10;
$this->pagination->initialize($config);
$data['records'] = $this->db->get('document', $config['per_page'],$this->uri->segment(3));
$this->db->select('doc_title, filename, description, category_id, product_id');
$this->db->where('category_id = 1');
$this->db->where('product_id = 1');
$this->db->order_by('doc_title', 'asc');
$this->load->view('someproduct/troubleshooting.php', $data);
}
}


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2021 MyBB Group.