Category: PHP

P4A 3.4.4 is out!

Changelog:

- Zend Framework was updated to 1.10.1
- P4A_Data_Source::exportToCSV() method was marked as deprecated
- P4A_Data_Source::exportAsCSV() now can be called directly from an event handler
- translations were updated

Download P4A 3.4.4

Share/bookmark:
Digg StumbleUpon Facebook Reddit Mixx del.icio.us Google Live NewsVine

P4A 3.4.3 is out!

Changelog:

- Zend Framework was updated to 1.9.5
- jQuery::form was updated to 2.36
- tooltip javascript was enhanced to make it location aware (bug #1908495)
- setTooltip() methods were moved to P4A_Widget
- tooltip support was added to P4A_Tab_Pane
- PEAR::Net_Useragent_Detect was updated to 2.5.1
- tooltips hiding methods now have a timeout to allow clicking links inside the
tooltip itself
- new_window parameter was added to P4A_Redirect_To_File() and P4A_Redirect_To_Url()
global functions
- P4A_DB_Source::_composePkString() was fixed handling multiple primary keys
(bug #2833159)
- onautocomplete event was added, it can be used to create a custom search for
fields instead of using P4A’s default one
- P4A_DB_Source::setTable() now supports a second parameter “alias”
- P4A_DB_Source::setTableAlias() and getTableAlias() methods were added
- P4A_DB_Source::addJoin*() methods now support alias on table (see code reference)
- P4A_Table elements/page user selector was added (disabled by default)
- P4A_Table::showElementsOnPageBar() and P4A_Table::hideElementsOnPageBar() were added

Download P4A 3.4.3

Share/bookmark:
Digg StumbleUpon Facebook Reddit Mixx del.icio.us Google Live NewsVine

P4A 3.4.2 is out!

Changelog:

- a bug with backslashes stripping was solved (bug #2853694)
- a typo was fixed in P4A_DB (profiler activation)
- P4A_Tab_Pane now correctly handles disabled pages
- a bug with P4A_Table’s ordering with P4A_DB_Source having a group clause was solved
- Zend Framework was updated to 1.9.4
- P4A_Thumbnail_Generator won’t generate a thumb bigger than the original image
- P4A_Data_Source::exportAsCSV() was reworked allowing field ordering and field descriptions

Download P4A 3.4.2

Share/bookmark:
Digg StumbleUpon Facebook Reddit Mixx del.icio.us Google Live NewsVine

How to install PHP PDO_OCI on Ubuntu Jaunty

This is a revamped guide, previously wrote for gutsy, enjoy!

1) prerequisites

First of all we’ll install the php5-dev package which contains some utilities we’ll need for the build process:

sudo apt-get install php5-dev

then you’ve to find out your ORACLE_HOME environment variable, try executing:

env | grep ORACLE_HOME=

If this command outputs something like:

ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server

then you can jump to section “2) Getting and compiling PDO_OCI” otherwise go on thru this section.

If this guide we’ll just see how to find out which is your ORACLE_HOME directory if you’ve installed the oracle-xe server package. If you’ve installed instantclient or anything else please refer to the product documentation. So you’ve an installed and configured oracle-xe instance on your machine, now type:

cat /etc/init.d/oracle-xe |grep ORACLE_HOME=

the command should print something like:

ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server

now we’ve to export this variable to the current terminal session, we’ll do that with this command:

export ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server

and the environment variable will be configured.

2) Getting and compiling PDO_OCI

Just cut and paste these simple commands to download PDO_OCI from the web and prepare it for the build phase:

cd /tmp
pecl download pdo_oci
tar xvfz PDO_OCI-1.0.tgz
cd PDO_OCI-1.0
phpize
mkdir include
ln -s /usr/include/php5/ include/php
./configure

now everything should be setup and we can build the driver and install it with:

make && make install

If everything is fine you can continue

3) Configuring PHP and Apache

if everything is fine you can go on editing your php.ini file and adding this line:

extension=pdo_oci.so

now create a phpinfo.php file under your apache’s document root, containing this line:

<?php phpinfo();

point your browser to:

http://localhost/phpinfo.php

and search for the “environment” section, it should look like the one in the next screenshot:
environment variables
if you see the ORACLE_HOME line everything it’s ok, jump to the “4) Closure” section otherwise edit /etc/apache2/envvars file and add the ORACLE_HOME configuration, it will be something like this (on a single line):

export ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server

4) Closure

Restart your apache and you’re done:

sudo /etc/init.d/apache2 restart

Share/bookmark:
Digg StumbleUpon Facebook Reddit Mixx del.icio.us Google Live NewsVine

P4A 3.4.1 is out

Hello everybody, the new release of our beloved PHP Framework is ready to be downloaded, this is a maintenance release but we’re adding a frequently requested feature, DB logging and profiling! Just take a look at the “products_catalogue”’s index.php and check the new P4A_DB_PROFILE constant, enable it and run the application to find our how easy is to take care about your DBs :-)

Full changelog:

- strong/em are now supported by P4A tooltips
- DSN charset support was added to set DB connection charset
- Zend Framework was updated to 1.9.2
- jquery::maskedInput plugin was updated to 1.2.2
- P4A_Object::__call() method was changed from private to public for PHP 5.3 compliance
- P4A_Tab_Pane’s CSS padding was changed a bit to fix a rendering bug on firefox/chrome
- P4A_DB_PROFILE constant was added, it will output every query executed on every DB

Download P4A 3.4.1

Share/bookmark:
Digg StumbleUpon Facebook Reddit Mixx del.icio.us Google Live NewsVine

Vote for P4A on PHPmagazine

Yudi Setiawan suggested to phpmagazine to include our beloved P4A in the frameworks list.

If you’ve a moment, vote for P4A:
http://trends.phpmagazine.net/frameworks/

Share/bookmark:
Digg StumbleUpon Facebook Reddit Mixx del.icio.us Google Live NewsVine

P4A 3.4 rocks out

It’s been a long time since 2003 when we created the first release of P4A (formerly named MerlinWork), we passed from PHP4 to PHP5, from PEAR to Zend Framework, from PEAR::DB to MDB2 to ADODB to Zend_DB, we got jQuery under our hood and with P4A 3.2 we gained a great great great stability and powerfulness.

P4A 3.4 is not an extremely giant leap, our base engines were updated (Zend Framework, jQuery, jQuery UI), we have a few new widgets (P4A_Progress_Bar and P4A_Dir_Navigator) and we got a lot a bugs fixed continuing to gain stability.

On the enterprise side we have a better Oracle support (most of all using LOBs).

On the rendering side we migrated a lot of code to jQuery UI and jQuery CSS framework, so we can relay on a stable cross browser CSS/widget framework and avoid a lot of troubles with the browser rendering.

Updating is suggested to everyone!
Enjoy our new beloved web application framework release!

Download P4A 3.4.0
Official P4A website

Complete changelog:

- Zend Framework was updated to 1.8.4
- jQuery was updated to 1.3.2
- jQuery UI was updated to 1.7.2
- P4A_Tab_Pane was converted to jQuery UI
- P4A_Fieldset and P4A_Tab_Pane now have rounder borders
- a note about handling dates with Oracle was added to the README file
- outline CSS property was removed
- If magic_quotes_gpc are enebled P4A strips out all slashes from $_POST,
$_GET, $_COOKIE and $_REQUEST
- P4A_Dir_Navigator widget was added
- P4A_Widget::composeStringActions() method now uses
P4A_Quote_Javascript_String()
- a bug with P4A_Dir_Source and hidden files was solved
- P4A_Dir_Source::getNumRows() method was added
- P4A_I18N::format() support for “filesize” data type was added
- P4A_Dir_Source now supports file size and last modification time
- P4A_Dir_Source’s cache was removed due to refactoring
- P4A_Simple_Edit_Mask now supports empty $source constructor param
(default is the mask name)
- P4A_Progress_Bar widget was added
- P4A footer was moved to allow better centering when sidebars are visible
- when uploading a file, it will have a temporary file until the corresponding
record won’t be saved
- a bug with P4A_Strip_Double_Backslashes global function was fixed
(thanks to bobkoure)
- a bug with Zend_Framework and Oracle was fixed (stripped zend_db_rownum column)
- P4A_DB_Navigator now can work also without recursor (flat list is shown)
- P4A_Mask::displayText() method was marked as deprecated, you can now use
P4A_Mask::display() that now has no hardcoded object reference
- P4A_Data_Source::isFirstRow() and isLastRow() methods were added
- a bug with P4A_Message and IE7 was solved
- Oracle’s LOBs are now supported
- P4A_Object’s ID generation algorithm was changed (thanks to pbond81 and Mario Spada)
- P4A_Table thumbnail generation speed was improved (bug #2220506) (thanks to pbond81)
- P4A_Box’s ul/ol is now rendered (bug #2634061) (thanks to bes_sf)
- a note about aliases on P4A_DB_Source’s PK was added to the README file
- P4A_DB_Source now automatically detects Oracle’s NUMBER data type
- P4A_Tab_Pane’s height honoring bug was fixed (bug #2815814)
- P4A_Widget::composeStringActions() now handles parameters with backslashes inside
- a bug with P4A_I18N::format() of boolean data was fixed
- a bug with multicheckbox’s CSS on some browsers was fixed
- a bug with P4A_DB_Source::saveRow and multiple primary keys was solved

Share/bookmark:
Digg StumbleUpon Facebook Reddit Mixx del.icio.us Google Live NewsVine

2009 Sourceforge Community Choice Award

We’re approaching P4A 3.4.0 release, we need your help making P4A a little more famous, you can do a lot for our project, click the following banner and nominate P4A for the “best tool or utility for developers” category.

Thank you so much!

Share/bookmark:
Digg StumbleUpon Facebook Reddit Mixx del.icio.us Google Live NewsVine

P4A 3.2.2 is out!

Changelog:

- P4A_Table’s image cols are now centered horizontally
- P4A_Button::setTooltip() and getTooltip() methods were added
- afterupload event typo was fixed
- P4A_Thumbnail_Generator::renderToFile() method was added
- P4A_Mask::getSource() method was added
- Zend Framework was updated to 1.7.7
- a bug with P4A_Fieldset theme was fixed (thanks to Mario Spada)
- P4A_DB::singleton() DB type verification is now case insensitive (bug #2643785) (thanks to BES)
- a few modifications were done on screen.css file for a better theme result (thanks to pbond81)
- The way we managed P4A_Validate translations was rewritten to fit the new rules by Zend Framework (we need your help translating the new messages)
- a bug with P4A_DB_Source::setWhere() method was fixed
- translations were synchronized
- auto file inclusion system was updated to avoid reading Mac hidden files
- a bug with P4A_DB_Source::addGroup() method was solved (internal syntax change due to a Zend Framework change)
- p4a_load_js() javascript function was updated to avoid errors if no callback function is passed

Download P4A 3.2.2

Share/bookmark:
Digg StumbleUpon Facebook Reddit Mixx del.icio.us Google Live NewsVine

P4A 3.2.1 released!

Changelog:

  • Zend Framework was updated to 1.7.4
  • PEAR::Net_Useragent_Detect was updated to 2.5.0
  • jQuery::form was updated to 2.19
  • P4A_DB_Source::setQuery() now strips out final semicolon from the passed SQL query (if present) (bug #2557215)
  • P4A_DB_Source::setWhere() now calls a firstRow() if the DB_Source isn’t in the “new row” state (bug #2316271)
  • P4A_Filename2File() now uses the fileinfo module if no mime type is detected otherways (bug #2121565)
  • a bug with P4A_Field::getAsDate() and Internet Explorer was fixed (thanks to Mario Spada)
  • P4A_Thumbnail_Generator::setWidth() now resets the max_width to avoid conflicts
  • P4A_Thumbnail_Generator::setHeight() now resets the max_height to avoid conflicts
  • P4A_Thumbnail_Generator::setMaxWidth() now resets the width to avoid conflicts
  • P4A_Thumbnail_Generator::setMaxHeight() now resets the height to avoid conflicts
  • P4A_Thumbnail_Generator::processFile() height/width calculation was
    rewritten in order to fix bug #2270922

Download P4A 3.2.1 now!

Share/bookmark:
Digg StumbleUpon Facebook Reddit Mixx del.icio.us Google Live NewsVine