News Feed
Sections




News Archive
Looking for more information on how to do PHP the right way? Check out PHP: The Right Way

Christopher Jones' Blog:
Location Awareness With Oracle Spatial in PHP
March 27, 2008 @ 07:50:11

Christopher Jones has posted a script to his blog today giving an example of how you can use the Spatial functionality of Oracle in a PHP application:

Oracle Spatial is a powerful library for adding location awareness to applications. This script uses the core subset of Spatial, called Oracle Locator, which is included in all Oracle Database editions.

His example connects to the database resource and makes a few example SQL queries: one that uses the sod_nn() function built in to the Spatial package to grab the store locations close to the customers, another that finds the latitude and longitude for a customer's information and a method for querying an object collection of locations in a given area.

2 comments voice your opinion now!
oracle database spatial locator example latitude longitude proximity


blog comments powered by Disqus

Similar Posts

Christopher Jones' Blog: Customer Interview on PHP & Oracle 11g Connection Pooling (DRCP) in Oracle

Andrei Zmievski's Blog: Bloom Filters Quickie

Christopher Jones' Blog: Vote to have more PHP sessions at Oracle Open World

Mike Willbanks' Blog: PHP Performance Series: Maximizing Your MySQL Database

CodePoets.co.uk: How to use PHP and PEAR MDB2 (Tutorial)


Community Events

Don't see your event here?
Let us know!


opinion framework language threedevsandamaybe introduction release voicesoftheelephpant series wordpress podcast community api library unittest interview development extension feature laravel laravel5

All content copyright, 2015 PHPDeveloper.org :: info@phpdeveloper.org - Powered by the Solar PHP Framework