... | ... | @@ -37,3 +37,13 @@ triggered by appropriate links in your search table, like |
|
|
$content .= "<thead><tr><th><a href='?page=search&usersearch=$user_search&sort=1'>Title</a></th>";
|
|
|
```
|
|
|
|
|
|
### pagination
|
|
|
|
|
|
as discussed in the lecture, this makes us of the mysql LIMIT clause e.g.
|
|
|
|
|
|
```
|
|
|
$sql = "SELECT * FROM Orders LIMIT 10 OFFSET 15";
|
|
|
```
|
|
|
|
|
|
This needs a bit of planning, as you will probably need to run one sql query to get the total number of pages, then a second one to pull out the results for the specific page of results you need. The code on last week's lecture slides will help
|
|
|
|