[PHP-DB] Retreving X, Y, Z from the Geometry column in oracle 10g

2008-02-20 Thread Hebat-Allah Farag
Dear all , I am stick since 2 days at the same point, I am using 10g, PHP my problem now is how to fecth the X, Y , z coordinates from the geometry column to view it on my web page, i don't understand the (SDO_ORDINATES), what is its type how i can deal with it. my simple code is:

Re: [PHP-DB] Retreving X, Y, Z from the Geometry column in oracle 10g

2008-02-20 Thread santosh
Following is sample code. oci_fetch_array returns resultset in array form. Details are available on http://in2.php.net/manual/en/function.oci-fetch-array.php ?php $connection = oci_connect(apelsin, kanistra); $query = SELECT id, name FROM fruits; $statement = oci_parse ($connection, $query);

Re: [PHP-DB] Retreving X, Y, Z from the Geometry column in oracle 10g

2008-02-20 Thread Evert Lammerts
You'll need an oracle - oci8 expert for this. A little googling told me that in order to use user defined data types (and i guess enhanced build in data types as GEOMETRY too) you will need oci8 functions (http://bugs.php.net/bug.php?id=39887), specifically the function bind_array_by_name()

RE: [PHP-DB] independent session data for multiple browser windows

2008-02-20 Thread Gary Wardell
They'll be accessing different account records in different windows. I keep track of the current account id in the session data, as well as a number of other account-specific items. Once I was made aware of the multiple-window requirement, and started looking more closely at sessions, it

Re: [PHP-DB] independent session data for multiple browser windows

2008-02-20 Thread Charles Whitaker
On Feb 16, 2008, at 1:31 AM, Tobias Franzén wrote: Charles Whitaker wrote: Greetings, I have a nearly-completed accounts/billing database using PHP and MySQL, and was just informed that users will want to access the database via multiple windows in one browser on the same machine, so

Re: [PHP-DB] Retreving X, Y, Z from the Geometry column in oracle 10g

2008-02-20 Thread Christopher Jones
Hebat-Allah Farag wrote: I am stick since 2 days at the same point, I am using 10g, PHP my problem now is how to fecth the X, Y , z coordinates from the geometry column to view it on my web page, i don't understand the (SDO_ORDINATES), what is its type how i can deal with it. my simple