CodeIgniter from Scratch: Displaying & Sorting Tabular Data

Just for your note. Using file name like Film_model.php does not work in Ubuntu/Linux. It is better to use all lower case like film_model.php. I think it is better to use lowercase for all the file names.

Was this the end of CI from scratch?

I wish you guys would edit the earlier articles in the series with the full list of tuts, so when I’m at day 6, I can click on day 7 right from it. Or day 13 if I feel like it. At least that way I can see how far it goes.

thanks!

Excellent! Just what I needed! Cheers!!
Looking forward to more in these series.

Hi,
With Firefox 4.0 the down arrow icon at sorting has strange characters before. I have five small squares, 0081 number inside them. Somebody saw that? Who knows why?

thank you so much.. you really help me to learn codeigniter.. thanks a lot

Hi!! Thanks for yours tutorials! I watched almost in a week! I’m learning a lot! I’m from Argentina but your english is very well so I can understand! :)

I have a doubt… Why don’t you use “table” library? like in day 6: Pagination? These advance functions don’t work on that library so you have to make the table manually??

Thanks again!

JP Cook

Hey Burak!

I’m using Aptana Studio (ver. 3) too, and how did you do that, when you typed “html:5″, it converted a blank HTML5 template?

Great tutorials Burak! Thank you!

I’ve been using notepad++ for all of these tuts when on my win7 and gedit on Ubuntu laptop. Something I haven’t seen since I used it once a few years ago was character map and it was in MS Word. I figured out I can use all the online utf-8 characters if I switch notepad++/gedit to use utf-8 encoding and it works since it is a web standard. So I learned something new.

I’m not sure about the comments on uppercase names because I haven’t had a problem on win with IIS or on Ubuntu with Apache. Both are running php5.

I notice in CI (at least in the recent version) all the library files and class names are capitalized like you have been doing.

Also this is more in line with naming conventions like Zend (Zend_Controller_PluginAbstract) except that they change the prefix to “Zend” instead of “ZEND”

I think it’s a good idea to put restrictive naming conventions like all class names start with a prefix or all class names start with a capital letter. This ensures that if someone has to make a change in the core it won’t break everything. It makes things more specific and certain. IMHO

Hi Barak!

Thank for your fabulous tutorials…

I have a problem with the pagination links but I can’t figure out why. Here is the code:

Hello!

i’m too new to CI to prentend having ancounter a bug. There’s must be a mistake in my code! I’ve read documentation and browsed forums but i can’t find where!

Any help is welcome:

I want to a simple pagination with sorting features. Here is the code:

load->model(‘project_model’);

$results = $this->project_model->search($limits,$offset,$sort_by, $sort_order);
$data['projects'] = $results['rows'];
$data['num_results'] = $results['num_rows'];

//pagination
$this->load->library(‘pagination’);
$config = array();
$config['base_url']=site_url(“projects/display/$sort_by/$sort_order/$offset”);
$config['total_rows'] = $data['num_results'];
$config['per_page'] = $limits;
$config['uri_segment'] = 5;

$this->pagination->initialize($config);
$data['pagination']= $this->pagination->create_links();

$this->load->view(‘projects’,$data);

}

}
?>

The search function works great, i can type url such like:

http://10.153.9.6/dev/index.php/projects/display/id/desc
http://10.153.9.6/dev/index.php/projects/display/id/desc/10
http://10.153.9.6/dev/index.php/projects/display/counrty/asc/400
http://10.153.9.6/dev/index.php/projects/display/name/asc/11

But the pagination links are wrong, I obtain:

http://10.153.9.6/dev/index.php/projects/display/id/desc/0/240

instead of:

http://10.153.9.6/dev/index.php/projects/display/id/desc/240

I thought the problem was in the “uri_segment’, but I think 5 is the correct value:

I’ve missed something. Any idea?

thanks!

fanch

Hello,

it is really good working in CodeIgniter 1.7 version. And now i am using CodeIgniter 2.1 version or latest version. it is not working and i got error message. it says:

A PHP Error was encountered
Severity: Notice
Message: Undefined property: Films::$pagination
Filename: controllers/films.php
Line Number: 30

Fatal error: Call to a member function initialize() on a non-object in C:\XAMPP\HTDOCS\Ci_test\application\controllers\films.php on line 30

Can you solve this problem?
Thanks

One of the best Codeigniter tutorials. Great job man. Now I know how to sort search results with a link. However, how can I get the same results using select’s onchange() event and reload the page with sorted results. I really need to find out how to make it for my new project. But I couldnt find anything like that on internet. The problem is that I dont know how to make javascript (jQuery) to work PHP in this situation (I know how to make it with AJAX, but I dont want to use it here because I want the page reload after select’s onchange event fires). Please help me guys. I would really appreciate your help. Thanks.

I’d like this series to be updated for codeigniter 2.0+ and the HMVC addon. Thanks for the work you do.