PHPBuilder - PHPLib and Multiple Databases Page 2



RSS Twitter
Articles Databases

PHPLib and Multiple Databases - Page 2

by: Peter Moulding
|
November 7, 2000

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.

« Previous Page
1
|
2
|
3
|
4
|
5
|
6
Next Page »

Comment and Contribute

Your comment has been submitted and is pending approval.

Author:
Peter Moulding

Comment:



Comment:

(Maximum characters: 1200). You have characters left.