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

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,

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 I'

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() (h

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 "; echo $row[1]." and ".$row['NAME']." is the same"; } ?> Santosh - Original Message - From: "Hebat-Allah Farag" <[EMAIL PRO

[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: $conn=oci_conne