I've been touching this up for 9 months now.

It has no known bugs, and I use it in several projects at work.

This works flawlessly with ODBC connections. I haven't tested it on anything else.

Implementation:
[PHP]//The Data Source Name, or DSN, contains the information required to connect to the database.
//replace foo:bar with your DSN
$db = new pdodb("foo:bar");[/PHP]

MattM wrote:Implementation:
[PHP]//The Data Source Name, or DSN, contains the information required to connect to the database.
//replace foo:bar with your DSN
$db = new pdodb("Excel");[/PHP]

That's what I'll try : running the roster on Excel - as one can approach it with DSN.
I'll post back with the result.....

Matt, you always come up with the most nifty things

This may be a good idea for the new codebase. Along with other stuff, because I'm also thinking about a way to efficiently load a lot of data into data holder objects.

PleegWat wrote:This may be a good idea for the new codebase. Along with other stuff, because I'm also thinking about a way to efficiently load a lot of data into data holder objects.

What are data holder objects? I know of PHP Data Objects, and of BLOB fields, but

tuigii wrote:

MattM wrote:Implementation:
[PHP]//The Data Source Name, or DSN, contains the information required to connect to the database.
//replace foo:bar with your DSN
$db = new pdodb("Excel");[/PHP]

That's what I'll try : running the roster on Excel - as one can approach it with DSN.
I'll post back with the result.....

it is Microsoft Jet for Access, I haven't heard of tapping into Excel before, I'm interested in your results.

The char/item/bag/skill/reputation classes in 1x are what I mean with data holder classes. They bundle the data with functions that use it. However, these classes should then also implement a generic interface that ties into the DB engine so it can load the data with only a couple of php statements, preferably with as few statements as possible.

Code: Select all


$guild = new roster_data_guild($guild_name, $realm);
$guild->select();
$guild->members->select('%bank');
$guild->members->bags->select();
$guild->members->bank->select();
$guild->loadRecursive();

$items = new roster_data_items();
foreach( $guild->members as $member_id => $member )
{
    foreach( $member->bags as $item )
    {
        $items->add($item);
    }
    foreach( $member->bank as $item )
    {
        $items->add($item);
    }
}
 

Etcetera. Here roster_data_guild, roster_data_member, roster_data_item are objects containing (usually) a single item from a single table. roster_data_members, roster_data_items (bad name, needs improvement) would be a descendant implementing (at least) ArrayAccess, and would contain a list of single-row objects. The array itself would act a s a template for containing rows, so if the template is set to load bag and bank contents, then rows added later are also set to load those.

MattM wrote:it is Microsoft Jet for Access, I haven't heard of tapping into Excel before, I'm interested in your results.

Just received from MSDN the Office 2007 'megapack' (it's longer then WoW to install : 4 DVD's - and it tries to change EVERY file on your disk) - but .... it 'could' work.

When activating addons, Excel comes to the foreground explain that it really doesn't like dynamic tables [where did we saw that before ]. "I should consider using MS SQL".

Nice to see that a recent Intel dual core really goes to 100 % for a couple of secondes when accesing the "data base".
Were talking real bloatware here....

tuigii wrote:

MattM wrote:it is Microsoft Jet for Access, I haven't heard of tapping into Excel before, I'm interested in your results.

Just received from MSDN the Office 2007 'megapack' (it's longer then WoW to install : 4 DVD's - and it tries to change EVERY file on your disk) - but .... it 'could' work.

When activating addons, Excel comes to the foreground explain that it really doesn't like dynamic tables [where did we saw that before ]. "I should consider using MS SQL".

Nice to see that a recent Intel dual core really goes to 100 % for a couple of secondes when accesing the "data base".
Were talking real bloatware here....

lol Bloatware is microsofts middle uhh something.

I didn't know you can have "tables" in excel.

zanix wrote:Matt, you always come up with the most nifty things

That means a lot to me