There is only maximum 300 lines in the csv, four bits of data (start time end time date and details), the csv is maximum 6kb, it loads just like any other light php page for me so I'm happy as it is. If it was loads of data I'd be doing it a little differently, however I cba to spend years on the school calendar lol

quote:

---

Originally posted by ed
fseek() works using bytes and not lines; you'd need to know how many bytes each line contained to use it.

---

fseek() works using bytes and not lines; you'd need to know how many bytes each line contained to use it. There's some OO stuff built which lets you seek to a line number, but it works still works recursively to find the line in the file you want.

That's why databases can be useful :)

[Edited on 19-04-2015 by ed]

quote:

---

Originally posted by ed
Yah, but PHP's IO is a bit sucky. You're stuck going through the file recursively no matter what as you can't set the file pointer manually, like you can do in other languages. Once you open the file up, the whole thing will be there in an array so you may as well slice it.

---

Yah, but PHP's IO is a bit sucky. You're stuck going through the file recursively no matter what as you can't set the file pointer manually, like you can do in other languages. Once you open the file up, the whole thing will be there in an array so you may as well slice it.

quote:

---

Originally posted by ed
Load the entire CSV into an array....

---

I've done it :cool:

Thanks for you help everyone - Ed that array slice thing was the one :D

Actually I'm managing to do it using a variable in the address as Steve suggested which is working nicely. You all may laugh but we gotta start somewhere!

[Edited on 17-04-2015 by pow]

Dave help me :cry:

This one's better :0

https://github.com/edcs/jquery-bootgrid

e.g. http://www.jtable.org/Demo/PagingAndSorting

You'd be better off getting PHP to serve up the Data as JSON then use a JQuery UI paged table plug-in to display it.

Load the entire CSV into an array, then use array_slice() to get the parts of it you'd like.

i.e.

$paginated = array_slice($myCsvArray, 0, 20);

Will get you the first twenty rows of it and,

$paginated = array_slice($myCsvArray, 20, 20);

Will get you the next twenty. PHP's array handling is super quick; from first hand experience you'd need to be dealing with tens of thousands of rows before you notice a slowdown.

It's not a DB backend though, it's a CSV - does that make a difference? I fucking hate websites!

so the link for the next button may look like

http://www.domain.com/cal.php?start=20&end=40

etc

Easy, put the DB query limit in a variable that is set by a HTTP post and get variable containing a number that relates to the start/end you are interested in, then just dynamically generate the link for the button to contain the correct numbers.


[Edited on 17-04-2015 by Steve]

I am useless with php, I mostly steal code from helpful people on the internet :lol:

I have a list of data from a CSV document into a table: (Link Removed for now)

But I want to split that up so it shows 20 results per page with a next/previous button - how would I do this?

Thanks for any help in advance :wave:

[Edited on 17-04-2015 by pow]

[Edited on 18-04-2015 by pow]