Help with prepared statements in PHP?

Trying to limit the number of rows/results but I dont know how to do it in a prepared statement. How do I fix this code? I think I need to put something in the bindparam thing.
The extra variables are for pagination, which complicates the code a bit.