{"id":1263,"date":"2018-01-19T19:22:37","date_gmt":"2018-01-19T19:22:37","guid":{"rendered":"http:\/\/goofy-trucks.flywheelsites.com\/phplib-and-multiple-databases-page-2\/"},"modified":"2018-01-19T19:24:39","modified_gmt":"2018-01-19T19:24:39","slug":"phplib-and-multiple-databases-page-2","status":"publish","type":"post","link":"https:\/\/phpbuilder.com\/phplib-and-multiple-databases-page-2\/","title":{"rendered":"PHPLib and Multiple Databases Page 2"},"content":{"rendered":"
\n
\n
By Peter Moulding<\/div>\n
on November 7, 2000<\/div>\n<\/p><\/div>\n
\n

Including PHPLIB<\/h2>\n
\n PHPLIB accesses SQL databases through a class named DB_Sql. You include the
\n version for your database in your code. I use the MySQL version in this
\n example.<\/div>\n
\n To get DB_Sql in to your code, install the PHPLIB files in their own
\n directory. Then, find your cgi-bin directory and create the phplib directory next
\n to the cgi-bin directory. Next, copy all the PHPLIB .inc files in to the phplib
\n directory. Finally, put the phplib directory in to the php.inc file in the line
\n starting with include_path =.<\/div>\n
\n The include_path is where PHP grabs files named in include() or require().
\n On my NT workstation, the include path is…<\/p>\n
\n include_path = \".;i:\/project52\/includes;i:\/project52\/phplib\";\n<\/pre>\n<\/div>\n
\n On the Linux production machine, it is…<\/p>\n
\n include_path = \".;\/home\/httpd\/includes;\/home\/httpd\/phplib\";\n <\/pre>\n<\/div>\n
\n At the top of each PHP page is…<\/div>\n
\n<\/p>\n
<?php<\/p>\n
<\/span>require(<\/span>common<\/span>.<\/span>php3<\/span>);<\/p>\n
<\/span>?>
\n
<\/span>
\n<\/span>
\n<\/code><\/font><\/div>\n
\n common.php3 is in the includes directory and contains all the data and
\n functions common to every page. In common.php3, are…<\/div>\n
\n<\/p>\n
<?php<\/p>\n
<\/span>require(<\/span>db_mysql<\/span>.<\/span>inc<\/span>);
\n
require(<\/span>ct_sql<\/span>.<\/span>inc<\/span>);
\n
require(<\/span>session<\/span>.<\/span>inc<\/span>);
\n
require(<\/span>auth<\/span>.<\/span>inc<\/span>);
\n
require(<\/span>perm<\/span>.<\/span>inc<\/span>);
\n
require(<\/span>user<\/span>.<\/span>inc<\/span>);
\n
require(<\/span>page<\/span>.<\/span>inc<\/span>);<\/p>\n
<\/span>?>
\n
<\/span>
\n<\/span>
\n<\/code><\/font><\/div>\n
\n Read the PHPLIB documentation at http:\/\/phplib.netuse.de and the fine
\n articles at https:\/\/phpbuilder.com to find out which includes you need.
\n Db_mysql.inc contains the DB_Sql class definition. If you want to use
\n PostGreSQL instead of MySQL, include db_pgsql.inc instead of db_mysql.inc.
\n There are 10 .incs covering MS SQL, Oracle, Sybase and others.<\/div>\n
\n *Note that for this example, require() and include() are exactly the
\n same. Require() and include() do work differently and have different
\n results when used in the middle of your code or in if() statements.<\/div>\n<\/div>\n
<\/p>\n
\n
\u00ab Previous Page<\/a><\/div>\n
1<\/a> <\/div>\n
| <\/div>\n
2<\/div>\n
| <\/div>\n
3<\/a> <\/div>\n
| <\/div>\n
4<\/a> <\/div>\n
| <\/div>\n
5<\/a> <\/div>\n
| <\/div>\n
6<\/a> <\/div>\n
Next Page \u00bb<\/a><\/div>\n<\/div><\/div>\n","protected":false},"excerpt":{"rendered":"
By Peter Moulding on 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… <\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-1263","post","type-post","status-publish","format-standard","hentry","category-tutorials"],"_links":{"self":[{"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts\/1263","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/comments?post=1263"}],"version-history":[{"count":1,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts\/1263\/revisions"}],"predecessor-version":[{"id":3156,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts\/1263\/revisions\/3156"}],"wp:attachment":[{"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/media?parent=1263"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/categories?post=1263"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/tags?post=1263"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}