News Feed
Sections




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

IBM developerWorks:
Starting to use ODBC with PHP
May 25, 2011 @ 09:07:28

On IBM's developerWorks site there's a new tutorial that wants to help you get started with ODBC in PHP, using the iodbc libraries and extension for PHP to connect to a database and pull back results.

Let's look at how a typical Linux-Apache-PHP-MySQL (LAMP) environment can be transformed into this flexible Linux-Apache-PHP-ODBC (LAPO) environment. There are two general options for ODBC drivers on Linux: iODBC and unixODBC. Both sets of drivers have their own pros and cons, and both work with PHP, but they work with different sets of databases. My choice is iODBC because of its traditionally strong connection to web programming languages like PHP and Ruby, as well as its stability in working with ODBC-friendly databases like MySQL and OpenLink Virtuoso.

There's a few steps in there to help you get the needed tools installed (linux server) to make the connection. Snippets of code are included showing how to connect to the server, run some simple SQL statements, fetch returned row information and do some basic debugging of the connection.

0 comments voice your opinion now!
odbc tutorial database iodbc install


blog comments powered by Disqus

Similar Posts

Rob Allen: Implementing a ZF2 development mode

PHPBuilder.com: Use jQuery to Build a Newsletter Subscription Popup with a MySQL/PHP Backend

Binary Tides Blog: Setup Apache 2.4 and Php FPM with mod proxy fcgi on Ubuntu 13.10

Systems Architect:API-based Web Application with Backbone, Require.js and Slim framework

Dan Barrett: Setting Up a LAMP Stack on Debian My Way


Community Events

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


laravel podcast php7 library community interview voicesoftheelephpant opinion api install introduction release performance example symfony2 series version extension framework conference

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