[pmwiki-users] Simple question - best way to attach database to show in table
Knut Alboldt
pmwiki at alboldt.de
Thu Sep 27 15:11:05 CDT 2007
Hi !
Jon Fowler schrieb:
> Hi Ben,
>
> Followed your instructions but now get:
>
> "Unable to include adodb.inc.php"
>
> Instead of my home page.
>
> Any ideas?
Is ADODB installed on your site ?
If yes, is the directory of the file adodb.inc.php within the specified
PHP-Include-Path ?
You should check php.ini or if possible call phpinfo() on your site to
get the settings of php.ini, entry:
include_path .;c:\gnu\php5\pear
The location of the php.ini you can get from the output of phpinfo.php:
Loaded Configuration File C:\GNU\php5\config\apache2\php.ini
(e.g. on a windows site)
If you got access to your php.ini you can add the directory to the
include_path, if not you can set this by:
ini_set("include_path",ini_get("include_path).":/PATH/TO/ADODB");
in your config.php. This will add the directory of ADODB at the end. The
call must be done before the first include of adodb.inc.php
Knut
>
> Thanks,
>
> Jon
>
> Hi
>
> On 9/26/07, *Ben Stallings* <ben at interdependentweb.com
> <mailto:ben at interdependentweb.com>> wrote:
>
> Jon Fowler wrote:
> > I took out the Select Query with comment so my config now looks like:
> >
> > $Databases['connection_name'] = array(
> > 'driver' => 'mysql',
> > 'hostname' => ' sql2.byethost13.com <http://sql2.byethost13.com>
> <http://sql2.byethost13.com>',
> > 'database' => 'b13_961097_central',
> > 'username' => 'b13_961097',
> > 'password' => 'lionheart');
>
> Looks fine, except I'd recommend you change 'connection_name' to
> something meaningful to you, such as 'central'.
>
> > #$FarmD/cookbook/selectquery.php
>
> This is probably why your wiki disappeared, when the line wasn't
> commented out. The syntax for including a file is
>
> include "$FarmD/cookbook/selectquery.php";
>
> or if you're using DataQuery instead,
>
> include "$FarmD/cookbook/dataquery.php";
>
> > Also I can't find any simple info on how to call a table. Is there a
> > guide on this I'm missing? Or something simple on MySQL syntax?
> >
> > Sorry for being dim. I'll write the guide for other dummies once
> I get
> > it...!
>
> Yah, I realize the docs could use some work, and thanks for your offer
> to help! If you're going to use DataQuery, then assuming you have the
> include_once line above, your next step is to go to the
> DataQuery.DataQuery page of your wiki and see if you can list the
> contents of the table. See instructions at
> http://workscited.net/dataquery/Main/StatusScreen .
>
> You may also want to install DataPlates, as it will save you a lot of
> work creating templates.
>
> Let me know how it goes! --Ben
>
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> pmwiki-users mailing list
> pmwiki-users at pmichaud.com
> http://www.pmichaud.com/mailman/listinfo/pmwiki-users
More information about the pmwiki-users
mailing list