Re: cvs: php-bugs-web / all.php
| From: | Derick Rethans | Date: | Thu, 16 May 2002 19:37:19 +0000 |
| Subject: | Re: cvs: php-bugs-web / all.php | ||
| References: | 1 | Groups: | php.mirrors |
| Request: | Send a blank email to php-mirrors+get-10262@lists.php.net to get a copy of this message | ||
On Thu, 16 May 2002, Jim Winstead wrote:
> good grief. if you need a dump of the bugs database, just ask.
That's a nice idea, but as the data gets update later on, a dump is not
real time enough... Would shell be possible?
Derick
>
> jim
>
> On Thu, May 16, 2002 at 07:34:02PM -0000, Derick Rethans wrote:
> > derick Thu May 16 15:34:02 2002 EDT
> >
> > Added files:
> > /php-bugs-web all.php
> > Log:
> > - Get all bugs in a PHP var
> > # (I'm working on a bug weed out thing, this is needed for it)
> >
> >
> >
> > Index: php-bugs-web/all.php
> > +++ php-bugs-web/all.php
> > <?php
> >
> > mysql_pconnect("localhost","nobody","");
> > mysql_select_db("php3");
> >
> > $qs = array (
> > array ('bugs', 'SELECT * FROM bugdb', 'id'),
> > array ('comments', 'SELECT * FROM bugdb_comments', 'bug')
> > );
> >
> > $d = array();
> >
> > foreach ($qs as $q) {
> > $r = mysql_query ($q[1]);
> > while ($rec = mysql_fetch_assoc($r)) {
> > $d[$rec[$q[2]][$q[0]][] = $rec;
> > }
> > }
> > var_export ($d);
> > ?>
> >
> >
>
---------------------------------------------------------------------------
Derick Rethans http://www.jdimedia.nl/derick/
JDI Media Solutions http://www.jdimedia.nl/
---------------------------------------------------------------------------