GnuCash and PHP

Youssef Ltaief ltai0001 at
Sun Oct 5 22:11:07 EDT 2008

how can I help?
I am running vista

I have followed the instructions here

but where do I go from there?
how do I see the code?

I appreciate your time, I am new to this


----- Original Message ----
From: Albert Lash <albert.lash at>
To: Derek Atkins <warlord at>
Cc: gnucash-devel at
Sent: Sunday, October 5, 2008 8:46:16 PM
Subject: Re: GnuCash and PHP

Hi Derek,

Yes, I'm planning on doing the whole process over again with the new
SQL code. When I do, I'll add it to the GnuCash wiki.


On Sun, Oct 5, 2008 at 9:09 PM, Derek Atkins <warlord at> wrote:
> Hi,
> a) could you put this into
> b) can you verify that this is what the new dbi-sql-backend looks like?
> -derek
> Quoting Albert Lash <albert.lash at>:
>> Hi Jeremy,
>> This is a great idea. I've been working on a web-based accounting
>> system, and I've been working to get it to use the same SQL backend as
>> GnuCash.
>> Its not there yet, but I've done some research on the SQL backend,
>> though its a little out dated now:
>> Albert
>> On Sun, Oct 5, 2008 at 8:00 PM, Jeremy Andrews
>> <jeremy at> wrote:
>>> Hello,
>>> I'm exploring the possibility of accessing some GnuCash data through a
>>> PHP application.  The short term goal would be the ability to browse
>>> financial information through a web browser.  While a long time user of
>>> GnuCash, I've never explored it at the code level before.  I spent some
>>> time this afternoon poking around, and have a few general questions.
>>> Is there a library and/or API making it possible for external programs
>>> to access GnuCash data?  I'd prefer accessing through an API, rather
>>> than parsing the XML data files directly, or even directly accessing the
>>> new SQL back-end.
>>> Specifically, my goal is to work on a PHP extension.  The first function
>>> I would be interested in would be to retrieve the accounts tree.  The
>>> API of this PHP function is not particularly important at this time,
>>> though my thought would be that I would specify a depth, and a parent
>>> (NULL parent if depth is 0).  Ideally, this would return the same
>>> information that is found in the Accounts tab: Account Name,
>>> Description, and Total.
>>> Later functions would continue to expose additional information via the
>>> PHP extension.  I would personally use this PHP extension to write a
>>> module for the Drupal CMS, making certain accounting information
>>> available online.
>>> Down the road, it could be useful to provide PHP functions for updating
>>> information, not just viewing it.  But this is beyond what I need now,
>>> and not what I wish to focus on in the present.
>>> Can anyone point me in the right direction for getting started?  How can
>>> I programmatically access the necessary GnuCash data from an external
>>> program?  Or is there a better way to achieve my goals that I'm not
>>> considering?
>>> Thanks,
>>>  -Jeremy
>>> _______________________________________________
>>> gnucash-devel mailing list
>>> gnucash-devel at
>> _______________________________________________
>> gnucash-devel mailing list
>> gnucash-devel at
> --
>      Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
>      Member, MIT Student Information Processing Board  (SIPB)
>      URL:    PP-ASEL-IA     N1NWH
>      warlord at MIT.EDU                        PGP key available
gnucash-devel mailing list
gnucash-devel at


More information about the gnucash-devel mailing list