Welcome Guest, Not a member yet? Register   Sign In
Building pagination into code / using MySQL in views - help needed [newbie question]

I'm building a TV guide for my site which uses the framework; the views work great, haven't quite figured out how to use MySQL with it yet though.

I'm planning to paginate sort of like this:
http: library.digiguide.tv/lib/programmenextshowing/12578

This is part of the code in my view file:

That's all manually entered in for now; but how could I get it to be rendered from the database and convert times from displaying as 10:00:00, 16:30:00 etc. to 10:00am, 4:30pm
etc. and paginate the MySQL results so they render like in library.digiguide.tv/lib/programmenextshowing/12578 with their style of pagination?

Note that my site is inspired by, but not a copy of theirs.

I've got the basics of CodeIgniter working well, but need it to create a login system etc. so I can update this TV guide platform without having to manually update the data via PhpMyAdmin every time etc. Note that I'm .htaccess - protecting the login to just localhost, so deny from all should be used [I think].

This newbie needs some help; had a look on Google but not quite sure how to implement this!


*can't post links though, so you'll have to manually cut-and-paste them.

This is the code (plain HTML at the moment, but needs to be in a database with JOIN etc.):
http: pastebin.com/UCGpCK2S

Theme © iAndrew 2016 - Forum software by © MyBB