This repository has been archived by the owner on Nov 28, 2023. It is now read-only.
-
Notifications
You must be signed in to change notification settings - Fork 23
/
README
126 lines (92 loc) · 3.2 KB
/
README
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
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
---------------------------------
-- P4A - PHP For Applications. --
---------------------------------
------------------
-- Installation --
------------------
Just extract the archive under your web server
DOCUMENT_ROOT (eg: /var/www).
You should rename the directory
"p4a-version" to "p4a".
If you want to test drive a sample application built on P4A
open your browser and type:
http://localhost/p4a/applications/products_catalogue
products_catalogue is an example of a virtual catalogue
for shops. To have this application runnning take a look at
applications/products_catalogue/README
--------------------------
- ADVANCED INSTALLATION --
--------------------------
If you want to have p4a installed out of your document root, this will help
you. We use the debian standard way, extract the framework and put it in
/usr/share/p4a
edit your Apache's httpd.conf and add this lines:
Alias /p4a /usr/share/p4a
<Directory /usr/share/p4a>
Order allow,deny
Allow from all
</Directory>
-------------------
-- Documentation --
-------------------
You'll find P4A code reference under the "docs" folder.
All other documentation is available within P4A website:
http://p4a.sourceforge.net
------------------------------------
-- P4A compatibility: Server Side --
------------------------------------
Linux/Windows
Apache >= 1.3.0
IIS >= 6.0
php/mod_php >= 5.2.0
------------------------------------
-- P4A compatibility: Client Side --
------------------------------------
P4A works with all browsers that supports XHTML
and JavaScript.
The default theme instead uses CSS2 and some
more complex Javascript, so here you have the
tested browsers:
- Mozilla Firefox 2.x
- Internet Explorer 6.x, 7.x
- Safari 3.x
- Opera 9.25+ (has issues with P4A_DB_Navigator drag&drop)
- Google Chrome
-----------------------------------------
-- P4A compatibility: Database engines --
-----------------------------------------
P4A works with:
- MySQL
- PostgreSQL
- Oracle
- SQLite
- Microsoft SQL Server
To make P4A connect to a database you need PDO extensions
(pdo_mysql, pdo_pgsql, pdo_oci, pdo_sqlite, pdo_mssql).
All connections' charsets are set to UTF-8.
If you're using Microsoft SQL Server beware that only nchar and nvarchar
data type is unicode, thus do not use char and varchar because they're
not UTF-8 safe.
------------------
-- KNOWN ISSUES --
------------------
You can't switch between two application with the same
P4A_APPLICATION_NAME under the same virtual host
without closing the browser.
P4A can't handle database tables with numeric column names.
If you want to add calculated fields coming from a DB query
(such as DISTICT(example_field)) always use parenthesis and never
use the "DISTINCT example_field" syntax.
When creating a complex P4A_DB_Source, do not set an alias on the
primary key.
Oracle's "date" data field is not supported, you should use a char(10).
Within your application simply add:
$p4a_field->setType("date");
$p4a_field->data_field->setType("date");
If you set P4A_Table's width to 100% and anchor it in a frame/fieldset
this won't work cause all frame's cells are floating.
-------------
-- Authors --
-------------
Fabrizio Balliano <[email protected]>
Andrea Giardina <[email protected]>