PHP Database: Others

Welcome to the concluding part of the series Using SQLite with PHP 5. As you ll possibly know, PHP 5 comes equipped with a fully-featured RDBMS called SQLite that definitely can make your life as a PHP developer much easier. It s particularly helpful if you want to get rid of MySQL at least for a time while maintaining the data layer of your application completely isolated from the business logic.

In this article, I will briefly describe how to compile PHP with ORACLE 8i support. When I tried to compile php with oracle support on Solaris 2.6, I received lots of problems. After tedious search on the internet, I have found a solution. I have following configuration: ORACLE 8.1.6 PHP 4.0.6 Apache 1.3.19 (Already Installed) Firstly unpack php as root: #tar zxvf php-4.0.6.tar.gz #cd php-4.0.6 Because apache is already installed, I want PHP to ...

In a previous series of articles, I covered the IBM DB2 Universal Database (DB2 UDB) plug-in for Microsoft Visual Studio .NET that lets Microsoft-trained application developers quickly develop .NET applications that run against DB2 UDB databases, whether they reside on the z/OS, i5/OS, AIX, Windows, Linux, HP-UX, or Solaris operating systems. Universal is truly an appropriate part of the DB2 UDB name because the approach used for appl...

In this article, I will talk a little about installing and using InterBase with php4. It includes: Some words about Interbase Getting and installing InterBase Compiling/configuring php with InterBase support Creating an example database Some code examples Some Words About InterBase InterBase is around since the mid 80 s. The database has made a long way, and was eventually opensourced by by Borland/Inprise in July 2000. The version now available...

In an era where data becomes volumetric in every business, much attention has been given to proper database management and the ease of data access. Businesses that use MS Access begin to look for an alternative which allows better database performance, higher reliability, higher flexibility, yet inexpensive. With the numerous choices available in the market, considering you don t want to put too much investment on it, only one, MySQL, stands out ...

Before commencing this tutorial, i have to say that for the ODBC setup section, I used the work of Leo West. His page on ODBC setup and interfacing with Ms-SQL server was most usefull to my original work project... Until my boss changed the project specs to make the database to be MS-Access, instead of MySQL. If you need to find out more information about SQL, go here. Summary of Contents Creating an Access database Setting up an ODBC Conn...

If you use PHP 5 to build web-based applications that access a database, you might want to consider SQLite. A lighter option than MySQL, this database may still suit your purposes if you don t need all of MySQL s bells and whistles. This three-part series covers many of SQLite s most useful features.

Here is the code from my Linux Journal article on how to build a business application using PostgreSQL s transactions and PHP4. Download Code Common.php ?php//connect to postgres database$conn=pg_pconnect(user=tperdue dbname=linuxjournal);//see if our connection was successfulif (!$conn) { //connection failed - exit the page with an error //you could also try to proceed without the ...

Which database do I use: Postgres or MySQL? This age-old question has plagued developers for, what, at least a couple years now. I ve used both databases extensively (MySQL for about one year and Postgres for about 2 years) and was curious if the performance differences between the two were as stark as the MySQL website suggests. I had actually benchmarked the two databases back in September 1999 when we were starting to lay the groundwork for S...

Ericson Smith Following Tim Perdue s excellent article on the comparison between MySQL and Postgresql, I decided to take a shot at installing and using this database. For most of our work I use MySQL and will continue to do so, because of its ease of use and unrivaled select query speed, and also because there is no point in trying to mess around with production systems that already work fine. But some new projects suffered greatly from MySQL s ...

There s something patently unfair going on here. For some reason, almost every PHP tutorial on the planet makes the implicit assumption that if you re using PHP with a database, that database is going to be MySQL.

There is a great misconception that SQLite is not available for PHP4, rather only for PHP5. In fact, SQLite support has been around for quite some time courtesy of the bindings available via the PHP Extension Community Library (PECL). This tutorial is intended to show you how to install the SQLite PECL Extension in PHP4. Following its installation I will walk through a basic example of using SQLite to access a database stored in a flat file. So ...

Are you one of those PHP developers looking for a tight and powerful RDBMS, other than MySQL, in order to build your next database-driven website? Then hopefully your search is finished. Welcome to the second installment of the series Using SQLite with PHP 5. Comprised of three articles, this series walks you through the implementation of the most important methods that come bundled with SQLite and shows you how to use them with numerous practi...