 |
 |
 |
 |
|
|
|
PHPLIB and Multiple Databases
Including PHPLIB
PHPLIB accesses SQL databases through a class named DB_Sql. You include the
version for your database in your code. I use the MySQL version in this
example.
To get DB_Sql in to your code, install the PHPLIB files in their own
directory. Then, find your cgi-bin directory and create the phplib directory next
to the cgi-bin directory. Next, copy all the PHPLIB .inc files in to the phplib
directory. Finally, put the phplib directory in to the php.inc file in the line
starting with include_path =.
The include_path is where PHP grabs files named in include() or require().
On my NT workstation, the include path is...
include_path = ".;i:/project52/includes;i:/project52/phplib";
On the Linux production machine, it is...
include_path = ".;/home/httpd/includes;/home/httpd/phplib";
At the top of each PHP page is...
<?php
require(common.php3);
?>
common.php3 is in the includes directory and contains all the data and
functions common to every page. In common.php3, are...
<?php
require(db_mysql.inc);
require(ct_sql.inc);
require(session.inc);
require(auth.inc);
require(perm.inc);
require(user.inc);
require(page.inc);
?>
Read the PHPLIB documentation at http://phplib.netuse.de and the fine
articles at http://www.phpbuilder.com to find out which includes you need.
Db_mysql.inc contains the DB_Sql class definition. If you want to use
PostGreSQL instead of MySQL, include db_pgsql.inc instead of db_mysql.inc.
There are 10 .incs covering MS SQL, Oracle, Sybase and others.
*Note that for this example, require() and include() are exactly the
same. Require() and include() do work differently and have different
results when used in the middle of your code or in if() statements.
[ Next Page ]
| Comments: | ||
| RE: PHP Server | Kanta | 02/11/05 04:03 |
| RE: Play movie at web site with PHP | dinesh | 12/11/04 03:29 |
| PHP Server | lid | 10/16/02 12:09 |
| 2 or more Level of Queries Solns? | onez | 10/10/02 10:58 |
| sql server &PHP | ali alinia | 09/11/02 05:47 |
| where can i get PHPLIB? | Alex | 07/26/02 21:33 |
| Help Mysql_fecth_row undefined | Ronal Y | 07/18/02 02:26 |
| RE: Play movie at web site with PHP | Spacecat | 07/09/02 03:05 |
| How to hook up the database to the site? | David | 07/05/02 23:56 |
| myconnect() function not working | Salim Pinjar | 06/20/02 08:46 |
| Play movie at web site with PHP | Danny | 05/06/02 08:58 |
| Help me! | ldvhai | 04/24/02 23:56 |
| sql server | Hatem Gamal | 03/25/02 10:14 |
| help me pls.... | zabehry | 03/23/02 01:37 |
| RE: PHP with Oracle | yoke | 02/22/02 23:09 |
| Checkbox to DB | steque | 02/04/02 09:06 |
| TEST!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! | Sheep | 01/21/02 21:48 |
| RE: PHP & Interbase | Surojit Niyogi | 11/06/01 12:19 |
| PHP & Interbase | Maxi | 10/26/01 13:26 |
| Where can I get PHPLIB? | Zenons | 10/19/01 06:20 |
| globals $db_connect, $db_database | Michael Assink | 09/20/01 18:43 |
| RE: PHP with Oracle | Hassan | 08/27/01 06:11 |
| RE: Hellllppppp! | K Black | 08/11/01 18:03 |
| help me !!! | danilo | 07/03/01 11:43 |
| PHPLIB with PHP4 | Ricardo Matos | 06/07/01 13:27 |
| RE: PHP with Oracle | Rach | 05/31/01 01:34 |
| RE: PHP with Oracle | Rach | 05/31/01 01:25 |
| RE: All Bad Ideas | Gold | 05/17/01 18:55 |
| Do I need *.dll | ceria | 03/27/01 19:52 |
| RE: .inc files, bad idea | dsh | 02/11/01 17:43 |
| RE: PHP with Oracle | raj | 02/05/01 15:03 |
| hello newbie here. | frederick | 02/04/01 19:23 |
| How can I log on a persistant oracle connect | Richard Schottdorf | 01/09/01 11:01 |
| RE: PHP with Oracle | Joerg Behrens | 12/19/00 14:20 |
| Utilisation de php4 avec paradox | Zarambaud | 12/18/00 04:29 |
| RE: Why not just use ADODB -- its simpler? | Nikolai Steenstrup | 12/11/00 21:20 |
| RE: Sybase connection problem? | Joeri Cornelissens | 12/11/00 09:28 |
| Hellllppppp! | Carrie | 12/10/00 05:17 |
| PHP Data Synchronization | girish | 12/05/00 01:42 |
| RE: conversion of outer join in oracle to postgre | Tom Anderson | 11/29/00 18:02 |
| RE: All Bad Ideas | aris | 11/28/00 03:05 |
| RE: Why not just use OOP? | Robert Campbell | 11/17/00 08:30 |
| RE: .inc files, bad idea | Jan Lehnardt | 11/13/00 16:27 |
| RE: extends OOPs? | Peter Moulding | 11/13/00 14:28 |
| .inc files, bad idea | Josh Duncan | 11/13/00 13:33 |
| PHP with Oracle | Hareshkumar Khandal | 11/12/00 23:59 |
| RE: OOPs? | Ying Zhang | 11/12/00 03:27 |
| conversion of outer join in oracle to postgre | Atul Vaze | 11/11/00 06:14 |
| OOPs? | Peter Moulding | 11/10/00 18:46 |
| RE: Disappointed | Rex Byrns | 11/10/00 09:50 |
| RE: Disappointed | Tim Perdue, PHPBuilder.com | 11/09/00 12:08 |
| RE: Disappointed | Tom Anderson | 11/09/00 11:32 |
| Disappointed | Tim Perdue, PHPBuilder.com | 11/09/00 10:41 |
| RE: All Bad Ideas | John Lim | 11/09/00 09:22 |
| RE: Why not just use ADODB -- its simpler? | John Lim | 11/09/00 09:06 |
| Great LIB, I'm it's power user! :-) | Ahmad Anvari | 11/08/00 15:00 |
| RE: Why not just use ADO-DB? | Tom Anderson | 11/08/00 13:50 |
| RE: extend classes, not rewrite code | Joe Link | 11/08/00 13:12 |
| Why not just use ADO-DB? | Lucien Ceder | 11/08/00 12:23 |
| All Bad Ideas | Tom Anderson | 11/08/00 11:12 |
| extend classes, not rewrite code | Donncha O Caoimh | 11/08/00 08:13 |
| Sybase connection problem? | Toni Tunkkari | 11/08/00 02:26 |
| Why not just use OOP? | Willo van der Merwe | 11/08/00 02:05 |
|
If you are looking for help, please post on the appropriate forum here. Your questions will be answered much more quickly. | ||
