Tips for Adjusting to Screen Size Automatically

Proceed to "miscellaneous" section inside PHPRunner and limit the number
of records to be displayed under "Records per page". Further, you can change
the range options under "Records per page selection" according to your needs.

Greetings HJB, thank you very much for your answer.
It's not exactly what I need, maybe I explained myself wrong.

What I want to do, if possible, is that when entering, for example, the list page, the display is adjusted to the size of the pc monitor. and that automatically determines the number of records to display based on the size of the monitor. Always keeping the page number section down at the edge of the monitor.
(Google translator)

Page layout and Grid type

Search for "body width" (as seen within the screenshot of the above URL content) and
change it from "standard" to "full" = using full PC monitor width to display e.g. a list page.

Thank you very much for your answers, but it is not exactly what I need. The alternatives they mention fit the monitor width perfectly, but what I need is to adjust the height (on PC) so that no scrolling occurs.

Do NOT compare "apples with oranges" here ...

PHPRunner is a code generator for so called DYNAMIC WEB PAGES in junction with e.g. MySQL
or lots of other databases. In other words, it provides web applications where database content by
tables of whatsoever number of database records are displayed at a large. So, depending on the
numbers of users, some hundreds or even thousands of database records need to be displayed
over time, dynamically managed by an interactive web appliance created by PHPRunner.

If you have just 10 or 20 products to show on a single page with NO scroll bars at all, I recommend
to look around for a web page making tool which enables you to create STATIC WEB PAGES.

In shortage, for STATIC web pages you can define the page size that way to not see any scroll bar at all.

if avoiding scrolling is important, such as in kiosk app, maybe you can detect the screen resolution after login at JS events, and make a ajax call to php script to update the resolution into user profile table, and subsequently PHP can retrieve at before SQL event and limit the rows to be displayed.

JavaScript to detect screen size: read this

Thanks acpan for your answer. I will continue investigating the side that you indicate to me. I have managed to solve problems that were impossible for me with your help.

I think HJB didn't understand what I want to do. Nor have I compared anything. I am working with PHP, MySQL and SQL Server and the tables do not have 10 or twenty records, they have thousands. But queries can be optimized so that the system responds quickly.

Thanks a lot.

Google translator

As registered PHPRunner user since v1.0 in 2001 I'm seeing NO
scroll bar at my end on a dummy project under PHP 8.09 once I
limit the records to 4 per page (as I tried to explain on how to
do it as above).

I do NOT have any objections if others want to ride the PHPRunner
horse from for example "underneath the animal" riding position by trying
to clamp hands and feet into the horse's skin, hairs and flesh by means
of experimental manual coding yet as far as I'm concerned, I only want
to ride that very horse from the top position, firmly saddled by what the
developers had been implementing before 2 decades experience gained.

Just my two little cents on the issue ...

Each one has its needs and requirements and each project is different. And not because a certain project requires something is wrong. If a query seems wrong to you, just do not answer and we avoid all problems. For what I'm doing PHPrunner is perfect.

Maybe this can give you some idea.

I had implemented below with good result to dynamically "do_something", based on detected user's screen height:

Part 1 : Detect User Screen with JS

Javascript On Load event at login page, insert this:

Part 2: PHP part to display rows per page based on screen height

PHPRunner event - AfterTableInit - allows you to set rows per page (pageSize) for the specific table conditionally:

AfterTableInit event:

Note: $_SESSION["screen_height"] is the session variable you would assign from user profile table at login successful event.

More info on AfterTableInit event and setting Page Size

Detecting screen width can also be done too, it's a reliable and good way to tell if user is a mobile device, by obtaining its screen size via JS, and hence possible to save the value into user profile table for PHP to use.

Go to this link, then open the chrome console and set the viewing device to mobile, click try it and see the width value changes.

Thank you very much Acpan for your time and patience. With the information you provide me, I should already achieve the results I need. I'm going to do the corresponding tests.
Thank you very much again ...

(Google translator)