summaryrefslogtreecommitdiff
path: root/example/README.md
blob: d70b595b52e3d8898c2ba1900e0ae5084b170182 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
# pg×html usage example

Here is an example that implements a very basic bug reporting system:
users can just report, view, and list (search) the bugs.

First of all, a database should be designed: `bugs.sql` contains
definitions and comments.

A common template, `common.xsl`, includes error handling and some
shared HTML. One can choose to show error details to users, or to hide
them.

`view.xsl` is a basic template for bug viewing.

`list.xsl` includes report and search forms, and lists the bugs.

To quickly try it, run `spawn-fcgi -p 5152 /bin/env pgxhtml` in this
directory, with database connection environment variables set if
needed, an `127.0.0.1 pgxhtml-test` entry in `/etc/hosts`, and a nginx
config akin to the following:

```
server {
    listen localhost:80;
    server_name pgxhtml-test;

    location / {
      include fastcgi_params;
      fastcgi_param PATH_INFO $fastcgi_script_name;
      fastcgi_pass 127.0.0.1:5152;
    }
}
```