Hello world from firebird php on windows

download windows setup for firebird
in my case i test 2.0.5 rc2
http://www.firebirdsql.org/download/prerelease/win32/Firebird-2.0.5.13206_0_win32_RC2.exe
Download flamerobin
in my case 0.9.1.x
ttp://ovh.dl.sourceforge.net/sourceforge/flamerobin/flamerobin-snapshot-0.9.1.1822-setup.exe
download php zip or setup version from php.net
http://ar.php.net/distributions/php-5.2.8-Win32.zip
in my case i have unziped on d:\php5.2.x
rename the default ini to php.ini
uncomment the line with interbase.dll

extension=php_interbase.dll
run cmd.exe
Start->Run
cmd.exe
d:
cd php5.2.x
run
or php -m to see if interbase module is enabled

next create an test script
like this one

and run it like
php test.php from command line
next you need to install apache or nginx and enable them on windows
read the install.txt from php dir

http://gist.github.com/39050

adding locale in debian and php

sudo apt-get install language-pack-ro-base or
sudo apt-get install language-pack-fr-base

sudo dpkg-reconfigure locales

locale -a
C
de_AT.utf8
de_BE.utf8
de_CH.utf8
de_DE.utf8
de_LU.utf8
en_US.utf8
fr_BE.utf8
fr_CA.utf8
fr_CH.utf8
fr_FR.utf8
fr_LU.utf8
POSIX
ro_RO.utf8


write an php test script locales.php

setlocale(LC_TIME, 'ro_RO.UTF8'); // note the charset info !
echo strftime("%B");

php locales.php
august

In PHP 5 there are some new firebird functions if you migrate from php4. Here is the list of them:

• ibase_affected_rows() - Return the number of rows that were affected by the previous query
• ibase_backup() - Initiates a backup task in the service manager and returns immediately
• ibase_commit_ret() - Commit a transaction without closing it
• ibase_db_info() - Request statistics about a database
• ibase_drop_db() - Drops a database
• ibase_errcode() - Return an error code
• ibase_free_event_handler() - Cancels a registered event handler
• ibase_gen_id() - Increments the named generator and returns its new value
• ibase_maintain_db() - Execute a maintenance command on the database server
• ibase_name_result() - Assigns a name to a result set
• ibase_num_params() - Return the number of parameters in a prepared query
• ibase_param_info() - Return information about a parameter in a prepared query
• ibase_restore() - Initiates a restore task in the service manager and returns immediately
• ibase_rollback_ret() - Rollback transaction and retain the transaction context
• ibase_server_info() - Request statistics about a database server
• ibase_service_attach() - Connect to the service manager
• ibase_service_detach() - Disconnect from the service manager
• ibase_set_event_handler() - Register a callback function to be called when events are posted
• ibase_wait_event() - Wait for an event to be posted by the database

php example for amazon webservice (soap getFunctions)


$wsdl_url =
"http://soap.amazon.com/schemas3/AmazonWebServices.wsdl";
$client = new SoapClient($wsdl_url);
var_dump($client->__getFunctions());

surprise in latest ubuntu hardy server

I have dist-upgraded my server from gutsy to hardy
I needed for php > 5.2.3

and the server says

Apache/2.2.6 (Ubuntu) PHP/5.2.4-2ubuntu4 with Suhosin-Patch