Re: [Rlib-users] Rlib and PHP

[Bob D. <bd...@si...>]

A semi example

rlib_add_datasource_mysql($rlib, "sql1", "some host", .... );
rlib_add_datasource_mysql($rlib, "sql2", "some port", .... );
rlib_add_query_as($rlib, "sql1", "select * from whatever", "q1");
rlib_add_query_as($rlib, "sql2", "select * from whatever", "q2");
rlib_add_resultset_follower($rlib, "q1", "q2");
rlib_add_report..
execute
spool

However that's not exactly what you are looking for.  The
resuletset_follower is only good when there then number of rows in the
resultsets is the same

What you are probably looking for is what I'm developing now.. the
concept of report parts.. check the archives of the mailing list for my
proposal.  I should have a prototype working with in 2 weeks or so

- bob

On Wed, 2004-08-04 at 16:28 +0200, Vincent Pinget wrote:
> It it possible to have some example with multiple mysql ressources ? In
> fact, I would like to know if it possible to have a main loop and use one of
> field of the result of the main loop in a second loop .. like :
> 
> main loop : select id1, field1, field2 from table1;
> 2nd loop : select ch1, ch2 from table2 where ch3 = id1;
> 
> 
> ----- Original Message ----- 
> From: "Bob Doan" <bd...@si...>
> To: "Vincent Pinget" <vin...@co...>
> Cc: "RLIB USERS" <rli...@li...>
> Sent: Wednesday, August 04, 2004 3:45 PM
> Subject: Re: [Rlib-users] Rlib and PHP
> 
> 
> > Right now you would have to use MYSQL Groups and use
> >
> > rlib_add_datasource_mysql_from_group
> >
> > - bob
> >
> > On Wed, 2004-08-04 at 14:28 +0200, Vincent Pinget wrote:
> > > Now it is working fine via a web server ---
> > >
> > > My script (see below) succes to connect a Mysql via "normal"
> connection...
> > > Do you know how to specify a Mysql port different thant 3306 ! I saw
> inside
> > > the source of rlib the notion of mysql.options->port but i didn't know
> how
> > > to specify it in PHP ....
> > >
> > > Thanks again...
> > >
> > > <?
> > > dl ("librlib.so");
> > > $format = "html";
> > > $sql_host = "localhost";
> > > $sql_users = "xxxx";
> > > $sql_password = "";
> > > $sql_database = "test";
> > > $rlib = rlib_init();
> > > rlib_add_datasource_mysql($rlib, "mysql", $sql_host,
> > > $sql_users,$sql_password, $sql_database);
> > > rlib_add_query_as($rlib, "mysql", "select * from example", "example");
> > >
> > > ...
> > > ?>
> > >
> > >
> > >
> > > ----- Original Message ----- 
> > > From: "Bob Doan" <bd...@si...>
> > > To: "Vincent Pinget" <vin...@co...>
> > > Cc: "RLIB USERS" <rli...@li...>
> > > Sent: Tuesday, August 03, 2004 4:04 PM
> > > Subject: Re: [Rlib-users] Rlib and PHP
> > >
> > >
> > > > Ahhh.. Ok
> > > >
> > > > What type of system is this on?
> > > >
> > > > And what prefix did you install rlib in?
> > > >
> > > > It's a prefix apache can't see.
> > > >
> > > > Typically look in /etc/ld.so.conf to see what are the normal LD
> prefix's
> > > > and if libr-mysql isn't there apache won't know about it.  If thats
> the
> > > > case the easiest thing to do is install rlib in a place where apache
> can
> > > > find it.
> > > >
> > > > - bob
> > > >
> > > > On Tue, 2004-08-03 at 09:28 +0200, Vincent Pinget wrote:
> > > > > Hi,
> > > > >
> > > > > I tried with all formats but it didn't work via the web server (but
> all
> > > > > works via the command line)
> > > > >
> > > > > I saw this in the error_log of Apache :
> > > > > Could Not Load MYSQL Input [libr-mysql.so: cannot open shared object
> > > file:
> > > > > No such file or directory]
> > > > > [Tue Aug  3 09:38:37 2004] [notice] child pid 14090 exit signal
> > > Segmentation
> > > > > fault (11)
> > > > >
> > > > > Does it mean something ??
> > > > > The modification I done in the util.h is wrong ??
> > > > >
> > > > > Thanks
> > > > >
> > > > > ----- Original Message ----- 
> > > > > From: "Bob Doan" <bd...@si...>
> > > > > To: "Vincent Pinget" <vin...@co...>
> > > > > Cc: "RLIB USERS" <rli...@li...>
> > > > > Sent: Monday, August 02, 2004 4:44 PM
> > > > > Subject: Re: [Rlib-users] Rlib and PHP
> > > > >
> > > > >
> > > > > > Try HTML output please.. If that works then try
> > > > > >
> > > > > > http://www.sicompos.com/~bdoan/rlib-1.2.1.tar.gz
> > > > > >
> > > > > > with PDF
> > > > > >
> > > > > > We found a bug w/ content types and IE w/ PDF
> > > > > >
> > > > > > Some versions of IE require a content type of PDF and a
> content-size
> > > > > >
> > > > > > We will have an official release out the door soon
> > > > > >
> > > > > > -bob
> > > > > >
> > > > > > On Mon, 2004-08-02 at 16:25 +0200, Vincent Pinget wrote:
> > > > > > > No message in the error_log and in the acces_log file i have :
> > > > > > > 192.168.201.2 - - [02/Aug/2004:16:28:10 +0200] "GET /essai.php
> > > HTTP/1.1"
> > > > > 200
> > > > > > > 5
> > > > > > >
> > > > > > > The script used is :
> > > > > > >
> > > > > > > <?
> > > > > > > dl ("librlib.so");
> > > > > > > $format = "html";
> > > > > > >
> > > > > > > $sql_host = "localhost";
> > > > > > > $sql_users = "xxxx";
> > > > > > > $sql_password = "";
> > > > > > > $sql_database = "test";
> > > > > > >
> > > > > > > $rlib = rlib_init();
> > > > > > > rlib_add_datasource_mysql($rlib, "mysql", $sql_host, $sql_users,
> > > > > > > $sql_password, $sql_database);
> > > > > > > rlib_add_query_as($rlib, "mysql", "select * from example",
> > > "example");
> > > > > > > rlib_add_report($rlib, "report.xml");
> > > > > > > rlib_set_output_format_from_text($rlib, $format);
> > > > > > >
> > > > > > > rlib_execute($rlib);
> > > > > > > header( rlib_get_content_type($rlib));
> > > > > > >
> > > > > > > rlib_spool($rlib);
> > > > > > > rlib_free($rlib);
> > > > > > >
> > > > > > > ?>
> > > > > > >
> > > > > > > and nothing append when i called it via Internet Explorer
> > > > > > >
> > > > > > >
> > > > > > > ----- Original Message ----- 
> > > > > > > From: "Bob Doan" <bd...@si...>
> > > > > > > To: "Vincent Pinget" <vin...@co...>
> > > > > > > Cc: "RLIB USERS" <rli...@li...>
> > > > > > > Sent: Monday, August 02, 2004 3:09 PM
> > > > > > > Subject: Re: [Rlib-users] Rlib and PHP
> > > > > > >
> > > > > > >
> > > > > > > > Hi,
> > > > > > > >
> > > > > > > > What's in your apache error_log/message_log and what web
> browser
> > > are
> > > > > you
> > > > > > > > testing with?
> > > > > > > >
> > > > > > > > - bob
> > > > > > > >
> > > > > > > > On Mon, 2004-08-02 at 14:22 +0200, Vincent Pinget wrote:
> > > > > > > > > Hi,
> > > > > > > > >
> > > > > > > > > I have compiled Rlib with Mysql, PHP and CPDF.. It was fine
> and
> > > the
> > > > > > > > > example from the documentation work fine if i lauched it
> from
> > > the
> > > > > > > > > command line... but i didn't success to lauch in from the
> > > explorer
> > > > > via
> > > > > > > > > website...
> > > > > > > > >
> > > > > > > > > works :
> > > > > > > > > shell > php report.php
> > > > > > > > > and generate a PDF
> > > > > > > > >
> > > > > > > > > DON't WORK
> > > > > > > > > http://serveur/report.php
> > > > > > > > >
> > > > > > > > > Please, could you tell me what is happening...
> > > > > > > > >
> > > > > > > > > More information :
> > > > > > > > > When i lauched via command line, there were always text
> file - i
> > > > > > > > > looked the source code and i saw the function r_debug ... so
> i
> > > put
> > > > > at
> > > > > > > > > the begin of the file util.h the line :
> > > > > > > > > #define DISABLERDEBUG 1
> > > > > > > > > to desactive the output from r_debug, but it changed
> anything to
> > > my
> > > > > > > > > problem...
> > > > > > > > >
> > > > > > > > > Thanks for your help
> > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > -------------------------------------------------------
> > > > > > > This SF.Net email is sponsored by OSTG. Have you noticed the
> changes
> > > on
> > > > > > > Linux.com, ITManagersJournal and NewsForge in the past few
> weeks?
> > > Now,
> > > > > > > one more big change to announce. We are now OSTG- Open Source
> > > Technology
> > > > > > > Group. Come see the changes on the new OSTG site. www.ostg.com
> > > > > > > _______________________________________________
> > > > > > > Rlib-users mailing list
> > > > > > > Rli...@li...
> > > > > > > https://lists.sourceforge.net/lists/listinfo/rlib-users
> > > > > >
> > > > > >
> > > > > >
> > > > > > -------------------------------------------------------
> > > > > > This SF.Net email is sponsored by OSTG. Have you noticed the
> changes
> > > on
> > > > > > Linux.com, ITManagersJournal and NewsForge in the past few weeks?
> Now,
> > > > > > one more big change to announce. We are now OSTG- Open Source
> > > Technology
> > > > > > Group. Come see the changes on the new OSTG site. www.ostg.com
> > > > > > _______________________________________________
> > > > > > Rlib-users mailing list
> > > > > > Rli...@li...
> > > > > > https://lists.sourceforge.net/lists/listinfo/rlib-users
> > > > > >
> > > > >
> > > > >
> > > > >
> > > > > -------------------------------------------------------
> > > > > This SF.Net email is sponsored by OSTG. Have you noticed the changes
> on
> > > > > Linux.com, ITManagersJournal and NewsForge in the past few weeks?
> Now,
> > > > > one more big change to announce. We are now OSTG- Open Source
> Technology
> > > > > Group. Come see the changes on the new OSTG site. www.ostg.com
> > > > > _______________________________________________
> > > > > Rlib-users mailing list
> > > > > Rli...@li...
> > > > > https://lists.sourceforge.net/lists/listinfo/rlib-users
> > > >
> > > >
> > > >
> > > > -------------------------------------------------------
> > > > This SF.Net email is sponsored by OSTG. Have you noticed the changes
> on
> > > > Linux.com, ITManagersJournal and NewsForge in the past few weeks? Now,
> > > > one more big change to announce. We are now OSTG- Open Source
> Technology
> > > > Group. Come see the changes on the new OSTG site. www.ostg.com
> > > > _______________________________________________
> > > > Rlib-users mailing list
> > > > Rli...@li...
> > > > https://lists.sourceforge.net/lists/listinfo/rlib-users
> > > >
> > >
> > >
> > >
> > > -------------------------------------------------------
> > > This SF.Net email is sponsored by OSTG. Have you noticed the changes on
> > > Linux.com, ITManagersJournal and NewsForge in the past few weeks? Now,
> > > one more big change to announce. We are now OSTG- Open Source Technology
> > > Group. Come see the changes on the new OSTG site. www.ostg.com
> > > _______________________________________________
> > > Rlib-users mailing list
> > > Rli...@li...
> > > https://lists.sourceforge.net/lists/listinfo/rlib-users
> >
> >
> >
> > -------------------------------------------------------
> > This SF.Net email is sponsored by OSTG. Have you noticed the changes on
> > Linux.com, ITManagersJournal and NewsForge in the past few weeks? Now,
> > one more big change to announce. We are now OSTG- Open Source Technology
> > Group. Come see the changes on the new OSTG site. www.ostg.com
> > _______________________________________________
> > Rlib-users mailing list
> > Rli...@li...
> > https://lists.sourceforge.net/lists/listinfo/rlib-users
> >