BC remote Oracle DBA - Call (800) 766-1884  
Oracle Consulting Oracle Training Development

Remote DBA

Remote DBA Plans  

Remote DBA Service

Remote DBA RAC

   
Remote DBA Oracle Home
Remote DBA Oracle Training
Remote DBA SQL Tuning Consulting
Remote DBA Oracle Tuning Consulting
Remote DBA Data Warehouse Consulting
Remote DBA Oracle Project Management
Remote DBA Oracle Security Assessment
Remote DBA Unix Consulting
Burleson Books
Burleson Articles
Burleson Web Courses
Burleson Qualifications
Oracle Links
Remote DBA Oracle Monitoring
Remote DBA Support Benefits
Remote DBA Plans & Prices
Our Automation Strategy
What We Monitor
Oracle Apps Support
Print Our Brochure
Contact Us (e-mail)
Oracle Job Opportunities
Oracle Consulting Prices





   

 

 

 

Remote DBA services

Remote DBA Support

Remote DBA RAC

Remote DBA Reasons

Remote Oracle Tuning

Remote DBA Links

Oracle DBA Support

Oracle DBA Forum

Oracle Disaster

Oracle Training

Oracle Tuning

Oracle Training

 Remote DBA SQL Server

Remote MSSQL Consulting

Oracle DBA Hosting

Oracle License Negotiation

 

 


 

 

 

 

 
 

Installing ADOdb

Oracle Tips by Burleson Consulting

The purpose of this section is to describe the installation of ADOdb. ADOdb does not come with PHP; it needs to be downloaded separately.  ADOdb can be downloaded from http://adodb.sourceforge.net

The installation is extremely simple. It consists of downloading the file, unpacking it and moving the resulting directory to the proper place. The proper place is any directory in the PHP search path.  The PHP search path is defined in the php.ini file by setting the include_path directory as shown in the example below:

;;;;;;;;;;;;;;;;;;;;;;;;;
; Paths and Directories ;
;;;;;;;;;;;;;;;;;;;;;;;;;

; UNIX: "/path1:/path2"
include_path = ".:/usr/local/lib/php:/usr/local/PHP"
;
; Windows: "\path1;\path2"
;include_path = ".;c:\php\includes"

The current directory and “/usr/local/lib/php” directories are put in the include path by the installation. The third directory, “/usr/local/PHP” is put in the path for the express purpose of downloading the third-party software, like ADOdb.

If PHP is installed as an Apache module, the Apache server needs to be restarted for the new settings to take effect.

This all prepares the reader to download either adodb454.tgz or adodb454.zip, depending on preferences. GUI utilities, such as WinZip can recognize both GNU gzip/tar format and older ZIP formats. It might be helpful to download the file ending in .tgz because it is smaller than the ZIP file. The contents of both files are the same and consist of the “adodb” directory, like the one pictured below:

This folder contains all files that ADOdb consists of and is essentially copied in the “right place” during the installation process. There is no need to modify anything in the adodb directory. In fact, doing so may render ADOdb unusable. Here is what is shown when the folder is entered:

ADOdb consists of 162 files and its total size is 1.5 MB which means that it is a very small library, by modern standards.

Now, that the proper directory is designated and the file downloaded, all that is left to do is to unpack the file in the designated directory. Voila!  The installation is complete. The result looks like the following:

$ pwd
/usr/local/PHP
$ ls -l
total 4
drwxr-xr-x  13 root root 4096 Dec 12 21:20 adodb
$

Note that adodb is owned by root, to prevent unauthorized updates of the library and a possible security breach.

Installation is the same on both Windows and UNIX platforms. Documentation is good and plentiful, and it contains a great tutorial on how to use ADOdb with Oracle written by John Lim, the author of ADOdb library.

SEE CODE DEPOT FOR FULL SCRIPTS


The above book excerpt is from  "Easy Oracle PHP: Creating Dynamic Web Pages with Oracle Data". 

You can buy it direct from the publisher for 50%-off and get instant access to the code depot of Oracle tuning scripts:

http://www.rampant-books.com/book_2005_2_php_oracle.htm

 


Expert Remote DBA

BC is America's oldest and largest Remote DBA Oracle support provider.  Get real Remote DBA experts, call
BC Remote DBA today.

 

 

Remote DBA Service
 

Oracle Tuning Book

 

Advance SQL Tuning Book 

BC Oracle support

Oracle books by Rampant

Oracle monitoring software

 

 

 

 

 

 

BC Remote Oracle Support

Remote DBA

Remote DBA Services

Copyright © 1996 -  2013 by Burleson. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation.



Hit Counter