Skip to content

Server side library of simple functions in plain PHP (without Json) for managing the pagination of dynamic data tables (datagrid) generated by a Postgresql database. It also allows you to sort the result by columns.

License

Notifications You must be signed in to change notification settings

coyote333666/ppm

Repository files navigation

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.

image

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).

About

Server side library of simple functions in plain PHP (without Json) for managing the pagination of dynamic data tables (datagrid) generated by a Postgresql database. It also allows you to sort the result by columns.

Topics

Resources

License

Code of conduct

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published