ppm - PHP Page Manager

Server side library of simple functions in plain PHP for managing the pagination of dynamic data tables (datagrid) generated by a Postgresql database. It also allows you to sort the result by columns. You can choose the number of lines per page. You can export the result in an excel table, csv or text with a Jquery module.

Requirements

• PHP 7.2.9 or higher;
• pdo_pgsql PHP extension enabled in php.ini;
• Postgresql standalone OR Docker-compose

Installation

Verify that you have installed, depending on your environment, docker-compose OR postgresql, npm, yarn, nodejs and git.

Verify that you have PHP installed : sudo apt-get install php on linux or, for windows, use php already included in xampp. If you have Windows, do not forget to indicate in the environment variable PATH, the path to access php.exe (for example, C:\xampp\php).

run these linux commands (password : test):

sudo su postgres
psql
CREATE DATABASE test
    WITH 
    OWNER = postgres
    ENCODING = 'UTF8'
    CONNECTION LIMIT = -1;
CREATE USER test WITH
  LOGIN
  NOSUPERUSER
  INHERIT
  NOCREATEDB
  NOCREATEROLE
  NOREPLICATION;
ALTER ROLE test with password 'test';
ALTER USER test with password 'test';
REVOKE ALL ON DATABASE test FROM public;
GRANT ALL ON DATABASE test TO test;        
exit
cd /var/www/html
sudo git clone https://github.com/coyote333666/ppm ppm
cd ppm
psql -f script.sql -U test

Install dependencies:

cd /var/www/html
sudo yarn add jquery-ui
sudo npm install tableexport

Then access the application in your browser at the given URL (localhost/ppm).