Posts

Showing posts from 2013

Numeric Drop-down With PHP ranges

Image
Here is an easy way to generate form numeric drop-down with ranges. $form = new Zend_Form(); $ranges = array( range(1, 20, 1) , range(30, 100, 10) , range(200, 1000, 100) ); $a = array(); foreach ( $ranges as $range ) { foreach ( $range as $r ) { $a[$r] = $r; } } $form->addElement('select', 'quantity', array( 'label' => 'Quantity' , 'required' => false , 'class' => 'form-control' , 'multiOptions' => array( '' => '--Select--' ) + $a )); Please note that the ranges are with different steps. Here is the result:

Enable pgpass under Windows XP

These are the steps I used to enable pgpass under Windows XP. Create file with name: pgpass.conf with this information in it: hostname:port:database:username:password see this for file data format Move the file to the %APP_DATA%\postgresql directory of the user running the backup ( not the db server user - postgres). In my case it was: C:\Documents and Settings\Windows User Name\Application Data\postgresql. Add --no-password option to the backup statement like this: "C:\Program Files\PostgreSQL\9.X\bin\pg_dump.exe" -h localhost -U postgres --no-password -C -f "database_name_dump.sql" database_name_db Done.

SSL certificate problem, verify that the CA cert is OK

Image
This is a followup post related to this issue. I have proposed a solution to this problem in a previous post . In short the solution was to download a certificate file from Mozilla and add this information to $CURL_OPTS array in base_facebook.php file. Today I have found this blog post suggesting using this http://curl.haxx.se/ca/cacert.pem certificate file. Either one should work. The second point I want to make is this. Previously I suggested appending CURLOPT_CAINFO to $CURL_OPTS array in base_facebook.php file. Now I think it will be better if I change the location information from my client code and not touch facebook.php library code. Here is how I did it: In my client code: require 'Facebook/src/facebook.php'; $facebook = new Facebook(array( 'appId' => 'some app id', 'secret' => 'some secret', 'cookie' => true, )); $facebook::$CURL_OPTS[CURLOPT_CAINFO]='path_to_certificate_file/cacert.pem&#