Skip to content
This repository

P4A - PHP For Applications

branch: master
README
---------------------------------
-- 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 <fabrizio@fabrizioballiano.it>
Andrea Giardina <andrea.giardina@crealabs.it>
Something went wrong with that request. Please try again.