NYCPHP Meetup

NYPHP.org

[nycphp-talk] TTF Issue

Rafi Sheikh Rafi.Sheikh at Ingenix.com
Tue Mar 30 12:08:10 EST 2004


Hi List:

BASICS: Apache 1.3.29
	  PHP 4.3.4 (compiled with gd and ttf)
	  TrueType installed
OS:	AIX 5 on a IBM machine
OTHER: Correctly listed TTF_DIRECTORY path in jpgraph.php

BACKGROUND: Using jpgraph to produce some dynamic graphs from MySQL db.

ISSUE: Looks like a TrueType issue.  The graph appears correctly but without
Titles or lables on either axis.

I have tried jpgraph forum but cannot get anyone to answer (low traffic
perhaps).  This list has had helped me from my novice days (starting) to now
(mid level)...so if this is off-topic my apologies... however, any
suggestion is deeply appreciated!

SUMMARY: graphs image appears but without title or axis labels.  Font used
are VERDANA, or TIMES

Much regards,

Rafi

-----Original Message-----
From: talk-request at lists.nyphp.org [mailto:talk-request at lists.nyphp.org]
Sent: Tuesday, March 30, 2004 11:00 AM
To: talk at lists.nyphp.org
Subject: talk Digest, Vol 10, Issue 58


Send talk mailing list submissions to
	talk at lists.nyphp.org

To subscribe or unsubscribe via the World Wide Web, visit
	http://lists.nyphp.org/mailman/listinfo/talk
or, via email, send a message with subject or body 'help' to
	talk-request at lists.nyphp.org

You can reach the person managing the list at
	talk-owner at lists.nyphp.org

When replying, please edit your Subject line so it is more specific
than "Re: Contents of talk digest..."


Today's Topics:

   1. SecurityFocus Newsletter #242 blah blah (Daniel Convissor)
   2. Re: Which XMLRPC server/client do you use?
      (Adam Maccabee Trachtenberg)
   3. RE: Which XMLRPC server/client do you use? (Mark Armendariz)
   4. PEAR::DB insertID??? (Eric Rank)
   5. Re: PEAR::DB insertID??? (Daniel Convissor)
   6. Re: PEAR::DB insertID??? (Christopher R. Merlo)
   7. Re: PEAR::DB insertID??? (Adam Maccabee Trachtenberg)
   8. Re: PEAR::DB insertID??? (Christopher R. Merlo)
   9. Re: PEAR::DB insertID??? (Eric Rank)
  10. Re: PEAR::DB insertID??? (Eric Rank)
  11. Re: PEAR::DB insertID??? (Adam Maccabee Trachtenberg)


----------------------------------------------------------------------

Message: 1
Date: Tue, 30 Mar 2004 01:21:33 -0500
From: Daniel Convissor <danielc at analysisandsolutions.com>
Subject: [nycphp-talk] SecurityFocus Newsletter #242 blah blah
To: NYPHP Talk <talk at lists.nyphp.org>
Message-ID: <20040330062132.GA19494 at panix.com>
Content-Type: text/plain; charset=us-ascii

PHP stuff in SecurityFocus Newsletter #242

PHP-Nuke Error Manager Module Multiple Vulnerabilities
http://www.securityfocus.com/bid/9911

phpBB profile.php avatarselect Cross-Site Scripting Vulnerab...
http://www.securityfocus.com/bid/9938

JelSoft VBulletin Private.PHP Cross-Site Scripting Vulnerabi...
http://www.securityfocus.com/bid/9940

phpBB Multiple Input Validation Vulnerabilities
http://www.securityfocus.com/bid/9942

JelSoft VBulletin Multiple Module Index.PHP Cross-Site Scrip...
Remote: Yes
http://www.securityfocus.com/bid/9943

Invision Gallery Multiple SQL Injection Vulnerabilities
http://www.securityfocus.com/bid/9944

Invision Power Top Site List Comments function id Parameter ...
http://www.securityfocus.com/bid/9945

PHP-Nuke MS-Analysis Module Multiple Remote Path Disclosure ...
http://www.securityfocus.com/bid/9946

PHP-Nuke MS-Analysis Module Multiple Cross-Site Scripting Vu...
http://www.securityfocus.com/bid/9947

PHP-Nuke MS-Analysis Module HTTP Referrer Field SQL Injectio...
http://www.securityfocus.com/bid/9948

--Dan

-- 
 T H E   A N A L Y S I S   A N D   S O L U T I O N S   C O M P A N Y
            data intensive web and database programming
                http://www.AnalysisAndSolutions.com/
 4015 7th Ave #4, Brooklyn NY 11232  v: 718-854-0335 f: 718-854-0409

------------------------------

Message: 2
Date: Tue, 30 Mar 2004 01:22:50 -0500 (EST)
From: Adam Maccabee Trachtenberg <adam at trachtenberg.com>
Subject: Re: [nycphp-talk] Which XMLRPC server/client do you use?
To: NYPHP Talk <talk at lists.nyphp.org>
Message-ID: <Pine.LNX.4.58.0403300117230.25355 at miranda.org>
Content-Type: TEXT/PLAIN; charset=US-ASCII

On Tue, 30 Mar 2004, Faber Fedor wrote:

> The XML-RPC from the O'Reilly book is now working, but I'm a bit
> bothered that there isn't any traffic in the orums for over two years
> and that other people had questions like I did and never got answers.
> I'd like to find something with a bit more support.

I would like to propose the PEAR XML-RPC class. It's a vital part of
PEAR (i.e. the whole system fails to function if it's broken), so you
know it's going to be supported.

David Sklar's new "Essential PHP Tools: Modules, Extensions, and
Accelerators" (Apress) has a whole chapter on PEAR's XML-RPC
class. There's also the PEAR Manual
(http://pear.php.net/manual/en/package.webservices.php).

This package isn't as fast as the bundled C extension (libxmlrpc), but
that code is essentially orphaned, AFAIK. So, while it may work,
you're on your own for support.

-adam

-- 
adam at trachtenberg.com
author of o'reilly's php cookbook
avoid the holiday rush, buy your copy today!

------------------------------

Message: 3
Date: Tue, 30 Mar 2004 03:18:15 -0500
From: "Mark Armendariz" <nyphp at enobrev.com>
Subject: RE: [nycphp-talk] Which XMLRPC server/client do you use?
To: "'NYPHP Talk'" <talk at lists.nyphp.org>
Message-ID: <E1B8ES4-0000qr-9h at server1057.webserver33.com>
Content-Type: text/plain;	charset="us-ascii"

While on the subject, not sure if this was posted (looked, but didn't see
it), ran across this earlier today:

http://webservices.xml.com/pub/a/ws/2004/03/24/phpws.html

Info about XML-RPC, SOAP and REST with php

Mark



------------------------------

Message: 4
Date: Tue, 30 Mar 2004 09:13:00 -0600
From: "Eric Rank" <erank at isthmus.com>
Subject: [nycphp-talk] PEAR::DB insertID???
To: "NYPHP Talk" <talk at lists.nyphp.org>
Message-ID: <002101c41669$7dd9f630$8b01a8c0 at DB>
Content-Type: text/plain;	charset="iso-8859-1"

Howdy folks,

I haven't looked extensively at the PEAR documentation, but from what I did
see, I couldn't find a means of getting an inserted ID after an insert
query. Using mysql_insert_id($dbh->connection) works, but abstracting away
from db-specific code is the whole point of PEAR::DB right? Any thoughts?

Eric


------------------------------

Message: 5
Date: Tue, 30 Mar 2004 10:35:56 -0500
From: Daniel Convissor <danielc at analysisandsolutions.com>
Subject: Re: [nycphp-talk] PEAR::DB insertID???
To: NYPHP Talk <talk at lists.nyphp.org>
Message-ID: <20040330153556.GA25422 at panix.com>
Content-Type: text/plain; charset=us-ascii

Hi Eric:

On Tue, Mar 30, 2004 at 09:13:00AM -0600, Eric Rank wrote:
> 
> query. Using mysql_insert_id($dbh->connection) works, but abstracting away
> from db-specific code is the whole point of PEAR::DB right? Any thoughts?

Not all DBMS's provide that capacity.  The closest thing DB has is 
sequences.  Read that Intro section in the manual.  I'd provide a URI, but 
pear.php.net isn't responding right now.

--Dan

-- 
 T H E   A N A L Y S I S   A N D   S O L U T I O N S   C O M P A N Y
            data intensive web and database programming
                http://www.AnalysisAndSolutions.com/
 4015 7th Ave #4, Brooklyn NY 11232  v: 718-854-0335 f: 718-854-0409

------------------------------

Message: 6
Date: Tue, 30 Mar 2004 10:42:58 -0500
From: "Christopher R. Merlo" <cmerlo at ncc.edu>
Subject: Re: [nycphp-talk] PEAR::DB insertID???
To: NYPHP Talk <talk at lists.nyphp.org>
Message-ID: <20040330154258.GG19121 at ncc.edu>
Content-Type: text/plain; charset="us-ascii"

On 2004-03-30 09:13 -0600, Eric Rank <erank at isthmus.com> wrote:

> I haven't looked extensively at the PEAR documentation, but from what I
did
> see, I couldn't find a means of getting an inserted ID after an insert
> query. Using mysql_insert_id($dbh->connection) works, but abstracting away
> from db-specific code is the whole point of PEAR::DB right? Any thoughts?

I'm not using PEAR::DB (yet), but what I do with MySQL when I need to
find this out is:

1) Lock the table
2) Insert what needs to get inserted
3) Query the ID out of the table order by id desc limit 1
4) Unlock the table

This assumes, of course, that your IDs are auto_increment.
HTH,
-c

-- 
  cmerlo at ncc.edu             http://turing.matcmp.ncc.edu/~cmerlo

Windows:  You'll wish we were kidding.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 232 bytes
Desc: not available
Url :
http://lists.nyphp.org/pipermail/talk/attachments/20040330/606018fc/attachme
nt-0001.bin

------------------------------

Message: 7
Date: Tue, 30 Mar 2004 10:57:03 -0500 (EST)
From: Adam Maccabee Trachtenberg <adam at trachtenberg.com>
Subject: Re: [nycphp-talk] PEAR::DB insertID???
To: NYPHP Talk <talk at lists.nyphp.org>
Message-ID: <Pine.LNX.4.58.0403301053190.11293 at miranda.org>
Content-Type: TEXT/PLAIN; charset=US-ASCII

> I'm not using PEAR::DB (yet), but what I do with MySQL when I need to
> find this out is:
>
> 1) Lock the table
> 2) Insert what needs to get inserted
> 3) Query the ID out of the table order by id desc limit 1
> 4) Unlock the table

Bleach. :) Use mysql_insert_id() instead and you can skip the table locking.

http://us4.php.net/manual/en/function.mysql-insert-id.php

Yes, it's smart enough to return your insert id even if a different
process inserts another row into the table in between your insert and
the call to mysql_insert_id().

-adam

-- 
adam at trachtenberg.com
author of o'reilly's php cookbook
avoid the holiday rush, buy your copy today!

------------------------------

Message: 8
Date: Tue, 30 Mar 2004 11:00:32 -0500
From: "Christopher R. Merlo" <cmerlo at ncc.edu>
Subject: Re: [nycphp-talk] PEAR::DB insertID???
To: NYPHP Talk <talk at lists.nyphp.org>
Message-ID: <20040330160032.GH19121 at ncc.edu>
Content-Type: text/plain; charset="us-ascii"

On 2004-03-30 10:57 -0500, Adam Maccabee Trachtenberg
<adam at trachtenberg.com> wrote:

> Bleach. :) Use mysql_insert_id() instead and you can skip the table
locking.
> 
> http://us4.php.net/manual/en/function.mysql-insert-id.php

Oh, cool!  I love this list.  :)

-- 
  cmerlo at ncc.edu             http://turing.matcmp.ncc.edu/~cmerlo

Windows:  You'll wish we were kidding.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 232 bytes
Desc: not available
Url :
http://lists.nyphp.org/pipermail/talk/attachments/20040330/310be561/attachme
nt-0001.bin

------------------------------

Message: 9
Date: Tue, 30 Mar 2004 10:16:53 -0600
From: "Eric Rank" <erank at isthmus.com>
Subject: Re: [nycphp-talk] PEAR::DB insertID???
To: "NYPHP Talk" <talk at lists.nyphp.org>
Message-ID: <00a001c41672$69d86a50$8b01a8c0 at DB>
Content-Type: text/plain;	charset="iso-8859-1"

Thanks for the tips. mysql_insert_id() it is.

Although I am curious about the forementioned sequences. I'll look a little
deeper.

For some context:

Perhaps it's obvious, perhaps it's not, the whole point of grabbing the id
of an auto-incremented record is to records to related tables using the
inserted id as a foreign key. For example, after insterting a record into a
'user' table, I need to use the id of that user as the 'userid' in an
'emailaddresses' table. I just imagined that the best way to do this is to
use something analagous to mysql_inserted_id() to get the id. Is there a
better way to do a series of related inserts?

Eric.


----- Original Message ----- 
From: "Adam Maccabee Trachtenberg" <adam at trachtenberg.com>
To: "NYPHP Talk" <talk at lists.nyphp.org>
Sent: Tuesday, March 30, 2004 9:57 AM
Subject: Re: [nycphp-talk] PEAR::DB insertID???


> > I'm not using PEAR::DB (yet), but what I do with MySQL when I need to
> > find this out is:
> >
> > 1) Lock the table
> > 2) Insert what needs to get inserted
> > 3) Query the ID out of the table order by id desc limit 1
> > 4) Unlock the table
>
> Bleach. :) Use mysql_insert_id() instead and you can skip the table
locking.
>
> http://us4.php.net/manual/en/function.mysql-insert-id.php
>
> Yes, it's smart enough to return your insert id even if a different
> process inserts another row into the table in between your insert and
> the call to mysql_insert_id().
>
> -adam
>
> -- 
> adam at trachtenberg.com
> author of o'reilly's php cookbook
> avoid the holiday rush, buy your copy today!
> _______________________________________________
> talk mailing list
> talk at lists.nyphp.org
> http://lists.nyphp.org/mailman/listinfo/talk


------------------------------

Message: 10
Date: Tue, 30 Mar 2004 10:40:44 -0600
From: "Eric Rank" <erank at isthmus.com>
Subject: Re: [nycphp-talk] PEAR::DB insertID???
To: "NYPHP Talk" <talk at lists.nyphp.org>
Message-ID: <00df01c41675$bf269ce0$8b01a8c0 at DB>
Content-Type: text/plain;	charset="iso-8859-1"

Actually, after looking at the sequences in PEAR::DB, I think that might be
an interesting solution. Although the docs are pretty scant. Does anyone
have more experience using this?

Eric.


----- Original Message ----- 
From: "Eric Rank" <erank at isthmus.com>
To: "NYPHP Talk" <talk at lists.nyphp.org>
Sent: Tuesday, March 30, 2004 10:16 AM
Subject: Re: [nycphp-talk] PEAR::DB insertID???


> Thanks for the tips. mysql_insert_id() it is.
>
> Although I am curious about the forementioned sequences. I'll look a
little
> deeper.
>
> For some context:
>
> Perhaps it's obvious, perhaps it's not, the whole point of grabbing the id
> of an auto-incremented record is to records to related tables using the
> inserted id as a foreign key. For example, after insterting a record into
a
> 'user' table, I need to use the id of that user as the 'userid' in an
> 'emailaddresses' table. I just imagined that the best way to do this is to
> use something analagous to mysql_inserted_id() to get the id. Is there a
> better way to do a series of related inserts?
>
> Eric.
>
>
> ----- Original Message ----- 
> From: "Adam Maccabee Trachtenberg" <adam at trachtenberg.com>
> To: "NYPHP Talk" <talk at lists.nyphp.org>
> Sent: Tuesday, March 30, 2004 9:57 AM
> Subject: Re: [nycphp-talk] PEAR::DB insertID???
>
>
> > > I'm not using PEAR::DB (yet), but what I do with MySQL when I need to
> > > find this out is:
> > >
> > > 1) Lock the table
> > > 2) Insert what needs to get inserted
> > > 3) Query the ID out of the table order by id desc limit 1
> > > 4) Unlock the table
> >
> > Bleach. :) Use mysql_insert_id() instead and you can skip the table
> locking.
> >
> > http://us4.php.net/manual/en/function.mysql-insert-id.php
> >
> > Yes, it's smart enough to return your insert id even if a different
> > process inserts another row into the table in between your insert and
> > the call to mysql_insert_id().
> >
> > -adam
> >
> > -- 
> > adam at trachtenberg.com
> > author of o'reilly's php cookbook
> > avoid the holiday rush, buy your copy today!
> > _______________________________________________
> > talk mailing list
> > talk at lists.nyphp.org
> > http://lists.nyphp.org/mailman/listinfo/talk
>
> _______________________________________________
> talk mailing list
> talk at lists.nyphp.org
> http://lists.nyphp.org/mailman/listinfo/talk


------------------------------

Message: 11
Date: Tue, 30 Mar 2004 11:54:16 -0500 (EST)
From: Adam Maccabee Trachtenberg <adam at trachtenberg.com>
Subject: Re: [nycphp-talk] PEAR::DB insertID???
To: NYPHP Talk <talk at lists.nyphp.org>
Message-ID: <Pine.LNX.4.58.0403301147410.26189 at miranda.org>
Content-Type: TEXT/PLAIN; charset=US-ASCII

On Tue, 30 Mar 2004, Eric Rank wrote:

> Actually, after looking at the sequences in PEAR::DB, I think that might
be
> an interesting solution. Although the docs are pretty scant. Does anyone
> have more experience using this?

In my continual pursuit of plugging David's book, I suggest "Essential
PHP Tools: Modules, Extensions, and Accelerators" by David Sklar. The
first chapter is on PEAR::DB and the second is on ADODB.

http://www.amazon.com/exec/obidos/ASIN/1590592808/trachtenberg-20/ref=nosim

Of course, Daniel knows more about PEAR::DB than Mr. Pear himself, but
it's sometimes easier to read up about a subject before subjecting the
maintainer to questions.

-adam

-- 
adam at trachtenberg.com
author of o'reilly's php cookbook
avoid the holiday rush, buy your copy today!

------------------------------

_______________________________________________
talk mailing list
talk at lists.nyphp.org
http://lists.nyphp.org/mailman/listinfo/talk


End of talk Digest, Vol 10, Issue 58
************************************


This e-mail, including attachments, may include confidential and/or
proprietary information, and may be used only by the person or entity to
which it is addressed. If the reader of this e-mail is not the intended
recipient or his or her authorized agent, the reader is hereby notified that
any dissemination, distribution or copying of this e-mail is prohibited. If
you have received this e-mail in error, please notify the sender by replying
to this message and delete this e-mail immediately.



More information about the talk mailing list