php3-digest-helplists.php.net

• Next message: php3-digest-helplists.php.net: "php3 Digest 25 Apr 2000 04:57:40 -0000 Issue 1628"
• Previous message: php3-digest-helplists.php.net: "php3 Digest 24 Apr 2000 04:57:44 -0000 Issue 1626"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

php3 Digest 24 Apr 2000 16:57:44 -0000 Issue 1627

Topics (messages 87325 through 87425):

php3.0.16+gd1.8.1 compile problems
        87325 by: georgekwtrt.net

sorry for last msg... here's the rest
        87326 by: georgekwtrt.net

php3 and mod_perl
        87327 by: Mark Nold <marknalverstone.com.au>
        87334 by: Michael Dearman <mdearmaninficad.com>

again, sorry.... Q continues..
        87328 by: georgekwtrt.net

Database Choice
        87329 by: "Wizaerd" <wizaerdwizaerd.com>
        87350 by: Deirdre Saoirse <deirdredeirdre.net>
        87370 by: "Andrew Hill" <ahillopenlinksw.com>
        87382 by: Greg Breland <gbrelandhealthtech.net>
        87408 by: "Wizaerd" <wizaerdwizaerd.com>
        87414 by: "Doug Poland" <dpolandexecpc.com>
        87416 by: Greg Breland <gbrelandhealthtech.net>

assemble a query dynamically, using a loop?
        87330 by: Doug Semig <dougslistc3net.net>

web site to be shown up in search engines like yahoo.com
        87331 by: "usha" <ushamahesh.net>
        87335 by: "TV Karthick Kumar" <tvkarthickmailops.com>

RegEx Question
        87332 by: Michael Dearman <mdearmaninficad.com>
        87336 by: Zak Greant <zakfreeimages.com>
        87344 by: Michael Dearman <mdearmaninficad.com>
        87346 by: Michael Dearman <mdearmaninficad.com>

prompt out 'save as' box when clicked
        87333 by: hendry <hendrymcms.com>

Insert Date Into VFoxpro Table By Using ODBC.
        87337 by: dgoa <dgoaou.edu>
        87351 by: "Frank M. Kromann" <fmkswwwing.com>

REMOTE_ADDR and includes
        87338 by: Zak Greant <zakfreeimages.com>

case non-sensitive
        87339 by: "Toshihide Tony Nakamura" <tonyuickarate.com>
        87341 by: Zak Greant <zakfreeimages.com>
        87342 by: "Toshihide Tony Nakamura" <tonyuickarate.com>
        87352 by: Deirdre Saoirse <deirdredeirdre.net>
        87361 by: Stefan Ekman <stekmanhem.passagen.se>

fwrite error
        87340 by: Zak Greant <zakfreeimages.com>
        87371 by: "Rossi Designs" <webmasterrossidesigns.net>

another PHP commercial website
        87343 by: "Liu Ningjiang" <liuningjyourtender.com>
        87348 by: "Liu Ningjiang" <liuningjyourtender.com>

Site Navigation
        87345 by: Timothy Germer <tgermergladstone.uoregon.edu>
        87347 by: "Toshihide Tony Nakamura" <tonyuickarate.com>
        87353 by: Doug Semig <dougslistc3net.net>
        87386 by: "SANIsoft" <tariquenagpur.dot.net.in>
        87388 by: Michael Waples <mwaplesoptusnet.com.au>
        87392 by: David Garnier <david.garniereleve.emn.fr>
        87407 by: "SANIsoft" <tariquenagpur.dot.net.in>

Textfiled conversion
        87349 by: "Nico Blanke" <supportmasterbyte.de>
        87354 by: Doug Semig <dougslistc3net.net>

PHP3+MSSQL woes
        87355 by: "Frank M. Kromann" <fmkswwwing.com>

How do I return a txt file, from a call to a php3 url?
        87356 by: "Robert Chalmers" <robertchalmers.com.au>
        87358 by: "Jason Brooke" <jasonqgl.org>

what is the --with-mm option?
        87357 by: Paul Schreiber <pjschreiundergrad.math.uwaterloo.ca>

ODBC linux -> windows connect & php3 error
        87359 by: "Maarten" <m.stoltesamhoud.nl>
        87372 by: "Andrew Hill" <ahillopenlinksw.com>

help on loading gifs from a database
        87360 by: "Andy Davis" <AndyDavis007hotmail.com>

asp to php
        87362 by: "Srimanth R.C." <srimanthyahoo.com>
        87363 by: "A Robertson" <elite2000btinternet.com>

What did I mess up?
        87364 by: "VANTASSLE, GEORDON M. (AIT)" <GEORDON.M.VANTASSLEmsg.ameritech.com>
        87367 by: Soren Staun-Pedersen <stauncs.auc.dk>
        87368 by: "VANTASSLE, GEORDON M. (AIT)" <GEORDON.M.VANTASSLEmsg.ameritech.com>
        87377 by: "VANTASSLE, GEORDON M. (AIT)" <GEORDON.M.VANTASSLEmsg.ameritech.com>
        87425 by: Jean-Marc Libs <libscybercable.tm.fr>

Sybase DB library - using Apache / NT Configuration
        87365 by: Jay Lepore <jay.leporetrackeronline.com>

How to replace "First" instance of the matched pattern?
        87366 by: "Ted Knudson" <tedkmichianatoday.com>
        87397 by: Zak Greant <zakfreeimages.com>

preg_quote is undefined.
        87369 by: "Stewart Taylor" <stewartmydwelling.ndo.co.uk>
        87379 by: mocha_php <mocha_phpyahoo.com>

extension Java
        87373 by: ïÌÅÇ çÏÒÏÂÞÕË <oleggrql.net.ua>

PHP4 and .htaccess
        87374 by: "SANIsoft" <tariquenagpur.dot.net.in>
        87378 by: "SANIsoft" <tariquenagpur.dot.net.in>

Moving to Last Record
        87375 by: "TV Karthick Kumar" <tvkarthickmailops.com>
        87395 by: "Mark Roedel" <roedelmletu.edu>
        87404 by: "TV Karthick Kumar" <tvkarthickmailops.com>

multiple upload
        87376 by: Vadim Grepan <kezalmail.ru>

PHP Speed Optimization
        87380 by: "Jeff Strain" <jstrainsaddleman.com>
        87381 by: "George Papadakis" <georgepforthnet.gr>
        87383 by: "Martin Edelius" <martin.edeliusspirex.se>
        87385 by: "Mitch Vincent" <mitchvenux.net>

Apache vs IIS for NT...
        87384 by: "William X. Kerber" <dgoaou.edu>
        87387 by: Ashwin Kutty <Ashwin.KuttyDal.Ca>
        87389 by: Cynic <cynicmail.cz>
        87393 by: "Erik Mathy" <erikbutlerandco.com>
        87400 by: Ashwin Kutty <Ashwin.KuttyDal.Ca>
        87401 by: "Jason Cox" <jasoncwebpipe.net>
        87405 by: Michael Kimsal <michaeltapinternet.com>

GD 1.8.1 problems
        87390 by: Trace Pupke <pupketcofc.edu>

PHP4 with IBM-DB2
        87391 by: "Antonio S. Martins Jr." <shadowwnet.com.br>

Getting the HTTP_REFERER (Apache and PHP)
        87394 by: Donald Undeen <dundeegator.net>
        87418 by: "Craig Vincent" <webmasterwebdream.com>

str_replace prob
        87396 by: "Martin Dragun" <yegonyegon.sk>
        87399 by: "Mark Roedel" <roedelmletu.edu>

content publishing systems
        87398 by: Maarten Stolte <M.StolteSamhoud.nl>

[PHP-DEV] Re: [PHP3] PHP Speed Optimization
        87402 by: "Faisal Nasim" <faisalnasim.org>

Few more PHP numbers (NT ISAPI
        87403 by: Michael Kimsal <michaeltapinternet.com>
        87412 by: Zeev Suraski <zeevzend.com>

End of Table / Record
        87406 by: "TV Karthick Kumar" <tvkarthickmailops.com>

php3 + pdflib = $50
        87409 by: "Keith Ford" <keithKeithFord.com>

searching files for keywords
        87410 by: "Mike Sears" <neutrinoneutrinostudios.com>

My ?
        87411 by: Ashwin Kutty <Ashwin.KuttyDal.Ca>

embedding PHP results on a non-PHP enabled server
        87413 by: "peter tatischev" <peterthekeeper.com.ru>

D/B shopping cart
        87415 by: "John Portwin" <johnmobiletones.com>
        87417 by: Sterling Hughes <sterlingdesignmultimedia.com>

fwrite didn't work out .... bug????
        87419 by: Yamin Prabudy <minstarindo.net>
        87420 by: Sterling Hughes <sterlingdesignmultimedia.com>
        87422 by: Cynic <cynicmail.cz>
        87424 by: Zak Greant <zakfreeimages.com>

Multiple File Uploads
        87421 by: Jay Lepore <jay.leporetrackeronline.com>

Anyone have a copy of First Choice?
        87423 by: Greg Breland <gbrelandhealthtech.net>

Administrivia:

To subscribe to the digest, e-mail:
        php3-digest-subscribelists.php.net

To unsubscribe from the digest, e-mail:
        php3-digest-unsubscribelists.php.net

To post to the list, e-mail:
        php3lists.php.net

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

attached mail follows:

I am trying to compile php3.0.16 as a module for apache1.3.12, including gd
1.8.1. I am wanting the JPEG capabilities of the new GD

attached mail follows:

Anyway, as I was saying, I am trying to compile php3.0.16 with gd 1.8.1
with JPEG support on FreeBSD 3.3. I have installed JPEG-6b.
The important lines in gd's makefile look like this:

CFLAGS=-O -DHAVE_JPEG -DHAVE_LIBTTF
LIBS=-lm -lgd -lpng -lz -ljpeg -lttf

gd builds with ZERO warnings or errors.

attached mail follows:

I have no problems with Apache 1.3.12, mod_perl 1.21 (i think) and php3.0.15 on Solaris and Linux.

I found that none of it could be compiled as a DSO though.

mn

Mark Nold
marknalverstone.com.au
Systems Consultant

Change is inevitable, except from vending machines.

On Monday, 24 April 2000 4:51, Joao Pedras [SMTP:jpedraswebvolution.net] wrote:
> Greetings
>
> As every1 used php3 with mod_perl ?
>
> I compiled apache-1.3.12,mod_perl-1.23, php3-3.0.5 and php scripts go wild on
> me, especially those which generate forms.
>
> What did I do wrong ?
>
> l8r
>
> Joao
>
> ^\ /^
> O O
> ----------------------------------------o00-(_)-00o--------------------------
>
> Be free and open and breezy! Enjoy! Things won't get any better so
> get used to it.
>
> -----------------------------------------------------------------------------
> PGP key available upon request or may be cut at
> http://pedras.webvolution.net/pgpkey.html
>
>

attached mail follows:

I see where folks are using this combo.
Would appreciate some comments on how this works
out for them.

The best of both worlds?

Using PHP instead of something like emPerl?

Doesn't this hurt somehow having 2 interpreters loaded up?

Thanks,
M. Dearman

attached mail follows:

Whoever made CTRL-E equiv to "SEND" in Eudora should be shot. :) Anyhoo...

GD builds with no errors or warnings, and is installed in /usr/local. I run
PHP's configure as such:

./configure --with-apache=../apache_1.3.12 --with-mysql
--with-gd=/usr/local --with-jpeg-dir=/usr/local --enable-track-vars

to which I get this:

checking for png_info_init in -lpng... yes
checking for gdImageCreateFromPng in -lgd... yes
checking for gdImageCreateFromJpeg in -lgd... no

What's going on here? What am I missing? I really pine for JPEG support in
gd.

Any help would be appreciated.

George Kearns
georgekwtrt.net

attached mail follows:

Free would have to be a contraint too since it's merely something I'm
developing on my own for my own personal use... Is mySQL limited in any way
in regards to record size? I tried installing it from my distribution CD
(Mandrake 7.0) and had one hell of a time. Not to mention if I do get it
installed correctly, I have to recompile PHP right? And if I recompile PHP,
then I have to recompile Apache? Sheesh, all this compiling wears a person
out... :o)

> -----Original Message-----
> From: Deirdre Saoirse [mailto:deirdredeirdre.net]
> Sent: Sunday, April 23, 2000 8:22 PM
> To: Wizaerd
> Cc: Php3 Mailing List
> Subject: Re: [PHP3] Database Choice
>
>
> On Sat, 22 Apr 2000, Wizaerd wrote:
>
> > I had seen a message regarding a postgresql record is limited
> to 8k. Coming
> > from a SQL Server background, I found this completely unbelievable, so I
> > started extensive reading of the postgresql manual, and sure enough it's
> > true. Granted 8k isn't s tiny number, but it's sure not what I
> was hoping
> > for or expecting.
>
> You can do what we used to do in Oracle when we were limited to 32K: break
> the data into chunks. If free is important, that's a solution to the
> problem.
>
> You wind up with something like this:
>
> other_key part_no data
>
> Where other_key + part_no is unique.
>
> Just remember, it's only a pain once. When you write functions to break
> apart and reassemble, you'll only have to do it once.
>
> > As I read further and further into the documentation, I've started to
> > question my choice of using PostgreSQL... so now I'm looking
> for advice.
> > On a linux system, which database offers the most robust
> features and fast
> > performance?
>
> Are these ALL your constraints? Because you haven't said why you didn't
> choose, say, Informix, Sybase, DB2 or Oracle. In my experience, Oracle is
> often faster than Informix (but Oracle's a resource hog), Sybase and DB2
> are good. If network traffic between the database server and the back end
> is an issue, Oracle is a good choice.
>
> But MySql and PostgreSQL have an advantage over the others mentioned:
> they're free (in MySql's case, free for most uses).
>
> > I hear mySQL is fairly fast, but there are no stored
> > procedures, triggers, etc... which is very limiting.
>
> It's a limited implementation when that is all one needs.
>
> --
> _Deirdre * http://www.linuxcabal.org * http://www.deirdre.net
> "Dictators ride to and fro upon tigers which they dare not dismount.
> And the tigers are getting hungry." -- Winston Churchill
>
>
> --
> PHP 3 Mailing List <http://www.php.net/>
> To unsubscribe, send an empty message to php3-unsubscribelists.php.net
> To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net
> To search the mailing list archive, go to:
> http://www.php.net/mailsearch.php3
> To contact the list administrators, e-mail: php-list-adminlists.php.net

attached mail follows:

On Sun, 23 Apr 2000, Wizaerd wrote:

> Free would have to be a contraint too since it's merely something I'm
> developing on my own for my own personal use...

OK.

> Is mySQL limited in any way in regards to record size?

I never looked as it wasn't really relevant for what I was doing.

> I tried installing it from my distribution CD (Mandrake 7.0) and had one
> hell of a time. Not to mention if I do get it installed correctly, I
> have to recompile PHP right? And if I recompile PHP, then I have to
> recompile Apache? Sheesh, all this compiling wears a person out... :o)

You will have to recompile PHP, but you shouldn't have to recompile apache
at this point. One of the nice things about MySql is that you can use
phpMyAdmin to administer your database.

-- 
_Deirdre   *   http://www.linuxcabal.org   *   http://www.deirdre.net
"Dictators ride to and fro upon tigers which they dare not dismount.
 And the tigers are getting hungry." -- Winston Churchill

attached mail follows:

Hi Wizaerd,

If it's for personal use, then you can use Virtuoso, which supports SQL92, runs on pretty much any platform you like, and also allows you to map in back end datasources 'virtually'. (Virtuoso uses ODBC for it's I/O). Virtuoso is exeptionally fast and robust, so should allow you to prototype any production system you want, as well.

It downloads with a non-expiring 2 user license, and I've successfully worked with it with php. It also supports stored procedures (full SQL/PSM specification) triggers, etc, and it's maximum file size is 2gb, but you can stripe across multiple disks and break that limit.

Also, the 2.0 beta will be out in a week or so, and can store XML documents or create live XML views on SQL tables so you can play with PHP's XML functionality. It's available from www.openlinksw.com/virtuoso

Best regards, Andrew ---------------------------------------------------- Andrew Hill Technical Support Consultant OpenLink Software http://www.openlinksw.com Universal Database Connectivity Technology Providers

-----Original Message----- From: Wizaerd [mailto:wizaerdwizaerd.com] Sent: Sunday, April 23, 2000 2:55 AM To: Php3 Mailing List Subject: [PHP3] Database Choice

I'm learning PHP (and I gotta admit, it's been a real hoot) and I've chosen PostgreSQL as my database for storage. On some mailing list I'm a member of I had seen a message regarding a postgresql record is limited to 8k. Coming from a SQL Server background, I found this completely unbelievable, so I started extensive reading of the postgresql manual, and sure enough it's true. Granted 8k isn't s tiny number, but it's sure not what I was hoping for or expecting.

As I read further and further into the documentation, I've started to question my choice of using PostgreSQL... so now I'm looking for advice. On a linux system, which database offers the most robust features and fast performance? I hear mySQL is fairly fast, but there are no stored procedures, triggers, etc... which is very limiting. I know nothing about mSQL, so I'm just looking for some overall advice... should I stay with postgresql or move to another RDMS?

Thanx!

Joseph E. Sheble a.k.a. Wizaerd Wizaerd's Realm Canvas, 3D, Graphics, ColdFusion http://www.wizaerd.com ================================= Zanova, Inc. http://www.zanova.com Moving Business Forward..... =================================

--
PHP 3 Mailing List <http://www.php.net/>
To unsubscribe, send an empty message to php3-unsubscribelists.php.net
To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net
To search the mailing list archive, go to:
http://www.php.net/mailsearch.php3
To contact the list administrators, e-mail: php-list-adminlists.php.net

attached mail follows:

Are you sure this is this a problem for you?

I work for a company that writes very large medical databases, and this limit(on another db server) has only been a problem twice. The quickest was to hit this limit is to have a bunch of varchar(255), but it still takes 16 of them to hit this limit. Remember that blob types don't apply, as they usually just have a 4byte uid that takes up space. The rest of the data is handled outside the table.

If you do legitimately hit this problem, it is a pain to deal with, so I am not questioning your concern, only whether you need be concerned. This is not really a limit for 95% of tables.

> I had seen a message regarding a postgresql record is limited > to 8k.

attached mail follows:

While it's for personal use right now, ultimately it'll be in production. It's a help desk application, and it will need to contain a description area where users list the steps they used in order for our support department to duplicate the problem, as well as detailed instructions on how to fix it. I'm also working on a content management system that'll defintely need more than 8k to store the content... I'm far more comfortable putting this all in a database instead of hundreds (even thousands) of individual files all over...

> -----Original Message----- > From: Greg Breland [mailto:gbrelandhealthtech.net] > Sent: Monday, April 24, 2000 6:50 AM > To: 'PHP List' > Cc: 'Wizaerd' > Subject: RE: [PHP3] Database Choice > > > Are you sure this is this a problem for you? > > I work for a company that writes very large medical databases, and this > limit(on another db server) has only been a problem twice. The > quickest was > to hit this limit is to have a bunch of varchar(255), but it > still takes 16 > of them to hit this limit. Remember that blob types don't apply, as they > usually just have a 4byte uid that takes up space. The rest of > the data is > handled outside the table. > > If you do legitimately hit this problem, it is a pain to deal > with, so I am > not questioning your concern, only whether you need be concerned. This is > not really a limit for 95% of tables. > > > I had seen a message regarding a postgresql record is limited > > to 8k. > > -- > PHP 3 Mailing List <http://www.php.net/> > To unsubscribe, send an empty message to php3-unsubscribelists.php.net > To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net > To search the mailing list archive, go to: > http://www.php.net/mailsearch.php3 > To contact the list administrators, e-mail: php-list-adminlists.php.net

attached mail follows:

Since you have MSSQL experience, you cannot help but to look at Sybase. As you know, Sybase and SQL Server were "co-developed" until MS took SQL Server completely under it's wing with SQL Server 6.0. Sybase continued on it's own development path with vers 11 and now 12. Since both RDBMS use Transact SQL, many of your databases, stored procedures, etc. will port "easily" to Sybase. Sybase ver 11.0.3.3 is still completely free for development AND deployment. Ver 11.9 is free for development and I'm not sure about deployment.

On the other hand, there's not a lot of support for php/sybase. If you read the posts, there's lots of questions but not many answers. So if you're not a linux/sybase guru, you may be in for some bumps.

I'm currently trying to configure FreeBSD/php3/Sybase. I cannot get php to compile with sybase support. The cause is most likely my lack of knowledge concerning apache/php compilation with DSOs. Unless some kind soul out there has been down this road, I'll be very lucky to get it to work.

-- 
Doug Poland
dpolandexecpc.com 
> -----Original Message-----
> From: Wizaerd [mailto:wizaerdwizaerd.com]
> Sent: Monday, April 24, 2000 10:44
> To: Php3 Mailing List
> Subject: RE: [PHP3] Database Choice
> 
> 
> While it's for personal use right now, ultimately it'll be in production.
> It's a help desk application, and it will need to contain a description area
> where users list the steps they used in order for our support department to
> duplicate the problem, as well as detailed instructions on how to fix it.
> I'm also working on a content management system that'll defintely need more
> than 8k to store the content...  I'm far more comfortable putting this all
> in a database instead of hundreds (even thousands) of individual files all
> over...
> 
> > -----Original Message-----
> > From: Greg Breland [mailto:gbrelandhealthtech.net]
> > Sent: Monday, April 24, 2000 6:50 AM
> > To: 'PHP List'
> > Cc: 'Wizaerd'
> > Subject: RE: [PHP3] Database Choice
> >
> >
> > Are you sure this is this a problem for you?
> >
> > I work for a company that writes very large medical databases, and this
> > limit(on another db server) has only been a problem twice.  The
> > quickest was
> > to hit this limit is to have a bunch of varchar(255), but it
> > still takes 16
> > of them to hit this limit.  Remember that blob types don't apply, as they
> > usually just have a 4byte uid that takes up space.  The rest of
> > the data is
> > handled outside the table.
> >
> > If you do legitimately hit this problem, it is a pain to deal
> > with, so I am
> > not questioning your concern, only whether you need be concerned.  This is
> > not really a limit for 95% of tables.
> >
> > > I had seen a message regarding a postgresql record is limited
> > > to 8k.
> >
> > --
> > PHP 3 Mailing List <http://www.php.net/>
> > To unsubscribe, send an empty message to php3-unsubscribelists.php.net
> > To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net
> > To search the mailing list archive, go to:
> > http://www.php.net/mailsearch.php3
> > To contact the list administrators, e-mail: php-list-adminlists.php.net
> 
> 
> -- 
> PHP 3 Mailing List <http://www.php.net/>
> To unsubscribe, send an empty message to php3-unsubscribelists.php.net
> To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net
> To search the mailing list archive, go to: http://www.php.net/mailsearch.php3
> To contact the list administrators, e-mail: php-list-adminlists.php.net
> 

attached mail follows:

Well, any text field that uses more than 255 bytes usually has to be stored in a blob field like a memo or text field. This only counts as 4 bytes toward your 8000 byte limit. Again, unless you are working on something pretty odd, like medical forms that have 300 50 byte fields, then you should be fine. Long text descriptions will go in fields of type "text" and will not hurt you.

I maintain our Help Desk software, which is from a leading company in the Help Desk field and is Enterprise Class in that it will handle multiple sites. Our worst table, the call table, uses 1.2K per record. I would worry about this problem when you hit it. Chances are you never will. If you do, then it is not really that big a deal to make a one-to-one relationship and keep going.

> While it's for personal use right now, ultimately it'll be in > production. > It's a help desk application, and it will need to contain a > description area > where users list the steps they used in order for our support > department to > duplicate the problem, as well as detailed instructions on > how to fix it. > I'm also working on a content management system that'll > defintely need more > than 8k to store the content... I'm far more comfortable > putting this all > in a database instead of hundreds (even thousands) of > individual files all > over... > > > -----Original Message----- > > From: Greg Breland [mailto:gbrelandhealthtech.net] > > Sent: Monday, April 24, 2000 6:50 AM > > To: 'PHP List' > > Cc: 'Wizaerd' > > Subject: RE: [PHP3] Database Choice > > > > > > Are you sure this is this a problem for you? > > > > I work for a company that writes very large medical > databases, and this > > limit(on another db server) has only been a problem twice. The > > quickest was > > to hit this limit is to have a bunch of varchar(255), but it > > still takes 16 > > of them to hit this limit. Remember that blob types don't > apply, as they > > usually just have a 4byte uid that takes up space. The rest of > > the data is > > handled outside the table. > > > > If you do legitimately hit this problem, it is a pain to deal > > with, so I am > > not questioning your concern, only whether you need be > concerned. This is > > not really a limit for 95% of tables. > > > > > I had seen a message regarding a postgresql record is limited > > > to 8k. > > > > -- > > PHP 3 Mailing List <http://www.php.net/> > > To unsubscribe, send an empty message to > php3-unsubscribelists.php.net > > To subscribe to the digest, e-mail: > php3-digest-subscribelists.php.net > > To search the mailing list archive, go to: > > http://www.php.net/mailsearch.php3 > > To contact the list administrators, e-mail: > php-list-adminlists.php.net > > > -- > PHP 3 Mailing List <http://www.php.net/> > To unsubscribe, send an empty message to > php3-unsubscribelists.php.net > To subscribe to the digest, e-mail: > php3-digest-subscribelists.php.net > To search the mailing list archive, go to: > http://www.php.net/mailsearch.php3 > To contact the list administrators, e-mail: > php-list-adminlists.php.net >

attached mail follows:

I almost always build queries (especially UPDATE queries) dynamically.

Though I've never personally done this kind of stuff in a loop (are you sure your database is normalized?), this is how it might look for you particular example:

/* WARNING...COMPLETELY UNTESTED CODE! */ $colval = array($c1, $c2, $c3, $c4, $c5, $c6, $c7, $c8, $c9, $c10); $colname = array("col1", "col2", "col3", "col4", "col5", "col6", "col7", "col8", "col9", "col10"); $sql = "UPDATE T1 SET "; $needcomma = 0; $needupdate = 0; for ($x = 0; $x < 10; $x++) { if (strcasecmp($colval[$x], "y") == 0) { if ($needcomma) $sql .= ", "; else $needcomma = 1; $needupdate = 1; $sql .= $colname[$x]; $sql .= " '"; $sql .= $colval[$x]; $sql .= "'"; } } if ($needupdate > 0) { $sql .= " WHERE ID="; $sql .= $id; $result = mysql_query($sql); }

Well, that's just off the top of my head. Since I don't have a form handy that sets id and a bunch of c# variables, you'll have to test & debug this stuff yourself.

But I also always query out the current record (in this case, SELECT * FROM T1 WHERE ID=$id) and compare what's already in the database to what the user is submitting. After all, if they haven't changed anything, we don't have to run the UPDATE at all.

Good luck, Doug

At 08:56 PM 4/23/00 -0700, mark wrote: >Hi Phpers, > >Anybody ever put together a query statement dynamically? > >For example, if 3 of 10 checkboxes are checked from a >previous page, I'd like to loop inside a resultant query, >and actually make it work, with this as the result: > >$doit=mysql_query("update T1 set col1='y', col7='y', col10='y' where >id='$id'"); > >Instead of this .....update T1 set col1='$c1', col2='$c2', col3='$c3', >col4='$c4', col5='$c5', col6='$c6', col7='$c7', col8='$c8', col9='$c9', >col10='$c10'.... > >I've tried to loop inside a query, but could never get it to work. > >Thanks, > >Mark > > > >art-nude.com >

attached mail follows:

Hi all PHP experts,

I have made a website using mysql and PHP on apache web server. I want to achieve the following:

If somebody searches for handicrafts in yahoo.com or on a similar web search engine then URL to my web site should show up. Please tell me how to go about this. My web site displays jpgs of handicrafts.

Please tell me the series of steps I have to follow to achieve this.

Thanks Usha

attached mail follows:

Hi

Basically what you want now is to progress with the Search Engine Registration process. You can do it from any search engine. Just submit your URL and give the keywords, through which your website / homepage will get listed on a specific search engine. You have to do it manually for each and every search engine.

If you want to know more about search engines, just try this URL:

http://www.searchenginewatch.com and search for more URL's and you will get it.

Hope this helps you.

-- K

> Hi all PHP experts, > > I have made a website using mysql and PHP on apache web server. I want to > achieve the following: > > If somebody searches for handicrafts in yahoo.com or on a similar web search > engine then URL to my web site should show up. > Please tell me how to go about this. My web site displays jpgs of > handicrafts. > > Please tell me the series of steps I have to follow to achieve this. > > Thanks > Usha > > > > -- > PHP 3 Mailing List <http://www.php.net/> > To unsubscribe, send an empty message to php3-unsubscribelists.php.net > To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net > To search the mailing list archive, go to: http://www.php.net/mailsearch.php3 > To contact the list administrators, e-mail: php-list-adminlists.php.net >

attached mail follows:

Shailendra Majmundar wrote: > > Nope, ereg_replace is correct. The question is about the RegEx grammar as > supported by php3 and not about the call. > > Thanks > > -----Original Message----- > From: George Papadakis [mailto:georgepforthnet.gr] > Sent: Sunday, April 23, 2000 4:05 PM > To: Shailendra Majmundar; php3lists.php.net > Subject: Re: [PHP3] RegEx Question > > use ereg not ereg_repace. > > Gp. >

Tend to agree with George.

I got this to work.

<? $pat = "Specialist";

$str = " I am a Word Processing Specialist";

if (ereg("([a-zA-Z]+) ([a-zA-Z]+) $pat", $str, $arr)) { echo ("$arr[0]"); }else{ echo ("No match found."); } ?>

(for some reason I couldn't get the eregi to work with $pat = "specialist";)

Suprisingly, I got

"Word Processing Specialist"

Suprised me, because I thought the $arr[0] would only return all the matches in just the mem parens. But apparently it's snagging all the matches.

Of course it probably won't be this simple.

$str = " I am a PHP Specialist"; and you'll get the 'a'.

$str = " I am a PHP3 Specialist"; will have to use ([a-zA-Z0-9]+) or ([[:alnum:]])+

etc.,

If your searching over multiple lines, you might have to go to perl functions ( like preg_match ) and use stuff like the non greedy match on the quantifiers, the /s and /m single/multi line options and other neat stuff.

Got the above to work with this perl reg.

preg_match("|(\w+)\s+(\w+)\s+($pat)|i", $str, $arr))

M. Dearman

attached mail follows:

Hi Shailendra - Cool name btw!

>Folks, > >Here goes my regex puzzle: > >$t="specialist"; >$str="I am a Word Processing Specialist from New York"; >$profession=ereg_replace(".*([A-Z]*[a-z]*) *($t1) *([A-Z]*[a-z]*).*","\\1 >\\2 \\3",$str); > >I would expect the result to be > $profession to be "Word Processing Specialist". > >This does not parse properly in php3. > >Any suggestion on how'd I parse this??

Your regex does not output for the following reasons.

1.) $t1 is a valid variable name. However, $t1 is not set... 2.) The word boundaries (spaces) are not properly positioned 3.) The final substring will could only capture a match after 'Specialist'

The smallest amount of changes to fix your query would be:

Change your function from ereg_replace to eregi_replace (to perform case insensitive matching so that $t (specialist) can match Specialist)

Add spaces between words.

Move your final substring in front of the ($t) substring

Drop the 1 from the $t1.

ereg_replace(".* ([A-Z]*[a-z]*) ([A-Z]*[a-z]*) ($t) .*","\\1 \\2 \\3",$str)

For everyone on the list who is less experienced with regular expressions, lets go through the query step by step.

Here is the original expression: ".*([A-Z]*[a-z]*) *($t1) *([A-Z]*[a-z]*).*"

.* : match *any* character 0 or more times ( : capture any matches after this bracket til the closing ) is encountered [A-Z]*: match any upper case letter from A to Z 0 or more times [a-z]*: match any lower case letter from a to z 0 or more times ) : stop capturing the match * : match a space character 0 or more times ( : capture any matches after this bracket til the closing ) is encountered $t1 : try to substitute the value of $t1 for $t1. Since $t1 is not set, substitute an empty string * : match a space character 0 or more times ( : capture any matches after this bracket til the closing ) is encountered [A-Z]*: match any upper case letter from A to Z 0 or more times [a-z]*: match any lower case letter from a to z 0 or more times ) : stop capturing the match .* : match *any* character 0 or more times

Finally, here is a modified version of the regular expression:

$profession=eregi_replace(".* ([a-z]+) ([a-z]+) ($t) .*","\\1 \\2 \\3",$str);

Here is the modified expression: ".* ([a-z]+) ([a-z]+) ($t) .*"

.* : match *any* character 0 or more times : match a space character ( : capture any matches after this bracket til the closing ) is encountered [a-z]+: match any lower case letter from a to z 1 or more times ) : stop capturing the match : match a space character ( : capture any matches after this bracket til the closing ) is encountered [a-z]+: match any lower case letter from a to z 1 or more times ) : stop capturing the match ( : capture any matches after this bracket til the closing ) is encountered $t : substitute the value of $t (specialist) for $t. .* : match *any* character 0 or more times

Because eregi_replace does case-insensitive matching, I can simplify the query be only needing to be concerned with matching lower-case letters.

HTH,

Zak

attached mail follows:

Zak Greant wrote: > > Hi Shailendra - Cool name btw! > > >Folks, -snip-

Thanks for laying out the regex details.

> Finally, here is a modified version of the regular expression: > > $profession=eregi_replace(".* ([a-z]+) ([a-z]+) ($t) .*","\\1 \\2 \\3",$str); >

Printing $profession gives me the whole string. But, eregi_replace returns the modified string if there is a match, or the original string if there isn't a match.

How could you put this in a statement to test for sure your not getting a match and the orig is returned, to diff from somehow its matching but somehow your match is returning the whole string?

M. Dearman

attached mail follows:

Zak Greant wrote: > > Hi Shailendra - Cool name btw! > > >Folks, > > > >Here goes my regex puzzle: > > > >$t="specialist"; > >$str="I am a Word Processing Specialist from New York";

-snip-

> > Finally, here is a modified version of the regular expression: > > $profession=eregi_replace(".* ([a-z]+) ([a-z]+) ($t) .*","\\1 \\2 \\3",$str); > > Here is the modified expression: > ".* ([a-z]+) ([a-z]+) ($t) .*"

OK. It works fine. I like it. Was just using a string that hung it up as opposed to the original posters' string.

And that was "I am a Word Processing Specialist." No space before the last .* takes care of that.

M. Dearman

attached mail follows:

Dear everyone, I want to know how to prompt out the "save as " box when the user clicks on "save"button. and save all the datas from the database to the text file. Thanks in advance

Hendry Sumilo IT department Telp:04-6302622 MCMS Penang hendrymcms.com

attached mail follows:

My Experiences are that when you insert the date in foxpro over ODBC, you need to insert it in YYYY-MM-DD format. That is how it is stored.

let me know how it works out, dgoa

chchar wrote:

> Thank for your feedback. > > Yeap ! I already checked the date format, it displayed in > dd/mm/yyyy. But I had tried to add in the format as the displayed > format, still can't work. > > Any idea ? > > <? > $connect_paysonel = odbc_connect( 'PAYSONEL' , '', '' ); > if ( !$connect_paysonel) > {echo "error\n";} > > $my_date = '01/01/2000'; > $my_name = 'ABC'; > > $sql_stmt = "INSERT INTO testing values(\"$my_name\",\"$my_date\")"; > > $query_paysonel = odbc_exec($connect_paysonel, $sql_stmt); > ?> > > Error Message > Warning: SQL error: [Microsoft][ODBC Visual FoxPro Driver]Data type > mismatch., SQL state 22005 in SQLExecDirect in > C:\InetPub\www\IT\odbc_foxpro.php on line 10 > > Warning: SQL error: , SQL state 00000 in SQLExecDirect in > C:\InetPub\www\IT\odbc_foxpro.php on line 11 > > TIA, > Char > > -----Original Message----- > From: Frank M. Kromann [SMTP:fmkswwwing.com] > Sent: Saturday, April 22, 2000 3:01 PM > To: chchar > Subject: Re: [PHP3] Need Help On ODBC Connect To Visual > Foxpro. > > Hi, > > Try to select the date and display the result. This way you will see > the format needed ! > > - Frank > > >- > > Swwwing A/S > Frank M. Kromann > VP Development > Phone: +45 70 20 77 20 > Fax: +45 70 20 77 21 > http://www.swwwing.com <http://www.swwwing.com> > > Name: winmail.dat > winmail.dat Type: unspecified type (application/octet-stream) > Encoding: x-uuencode > > -- > PHP 3 Mailing List <http://www.php.net/> > To unsubscribe, send an empty message to php3-unsubscribelists.php.net > To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net > To search the mailing list archive, go to: http://www.php.net/mailsearch.php3 > To contact the list administrators, e-mail: php-list-adminlists.php.net

attached mail follows:

Hi,

Ok try changing the SQL statement to

$sql_stmt = "INSERT INTO testing values('$my_name','$my_date')";

replacing \" with '

- Frank

>Thank for your feedback. > >Yeap ! I already checked the date format, it displayed in >dd/mm/yyyy. But I had tried to add in the format as the displayed >format, still can't work. > > Any idea ? > ><? > $connect_paysonel = odbc_connect( 'PAYSONEL' , '', '' ); > if ( !$connect_paysonel) > {echo "error\n";} > > $my_date = '01/01/2000'; > $my_name = 'ABC'; > > $sql_stmt = "INSERT INTO testing values(\"$my_name\",\"$my_date\")"; > > $query_paysonel = odbc_exec($connect_paysonel, $sql_stmt); > ?> > >Error Message >Warning: SQL error: [Microsoft][ODBC Visual FoxPro Driver]Data type >mismatch., SQL state 22005 in SQLExecDirect in >C:\InetPub\www\IT\odbc_foxpro.php on line 10 > >Warning: SQL error: , SQL state 00000 in SQLExecDirect in >C:\InetPub\www\IT\odbc_foxpro.php on line 11 > > >TIA, > Char > > > -----Original Message----- > From: Frank M. Kromann [SMTP:fmkswwwing.com] > Sent: Saturday, April 22, 2000 3:01 PM > To: chchar > Subject: Re: [PHP3] Need Help On ODBC Connect To Visual >Foxpro. > > Hi, > > Try to select the date and display the result. This way you will see >the format needed ! > > - Frank

Swwwing A/S Frank M. Kromann VP Development Phone: +45 70 20 77 20 Fax: +45 70 20 77 21 http://www.swwwing.com

attached mail follows:

Hi gee,

Your code looks pretty good - you just need to make a few little changes.

gee wrote: [snip] >If my pages get a hit from a predefined IP address then "footer1.inc" gets >put in , but hits from all other IP's get "footer2.inc" put in. > >eg; ><?php >if ( getenv ( "REMOTE_ADDR" ) != "201.55.182.170" ) > include ("footer1.inc"); >else include (footer2.inc"); >} >?> ><head> ></head> ><body> >bla >bla ><? include("footer1.inc") if from the above IP address > else include("footer2.inc"); ?> ></body>

Just try something like this instead:

<?php $number = (getenv ('REMOTE_ADDR') == '201.55.182.170') ? 1 : 2; include ("footer$number.inc"); ?> <head></head> <body> <?php include ("footer$number.inc"); ?> </body>

HTH,

Zak

attached mail follows:

Hello,

I'm trying to run a simple search query. Do any of you know how to make it a case-insensitive? For example, if there is something like "Pet is allowed" in the data, and user enters "pet" as a keyword, I would still like the search to pick up the data.

Arigato~!

Tony

attached mail follows:

At 01:33 PM 4/23/00 -0500, you wrote: >Hello, > >I'm trying to run a simple search query. >Do any of you know how to make it a case-insensitive? >For example, if there is something like >"Pet is allowed" >in the data, and user enters >"pet" >as a keyword, I would still like the search to pick up >the data.

Hi Tony,

I am guessing that you are searching in a SQL database. Try using 'like' instead of = in your query.

i.e. SELECT * FROM table WHERE name LIKE 'ted'

You can also use ? and % as a wildcard characters. ? will match any single character, while % will match 0 or more characters.

HTH,

Zak

attached mail follows:

Thanks for the reply, Zak,

Actually, I am using "like", but the problem is that data has a word "Ted" and postgresql wouldn't pick it up if the search was run with "ted" instead of "Ted".

Tony

----- Original Message ----- From: Zak Greant <zakfreeimages.com> To: Toshihide Tony Nakamura <tonyuickarate.com> Cc: <php3lists.php.net> Sent: Monday, April 24, 2000 2:10 AM Subject: Re: [PHP3] case non-sensitive

> At 01:33 PM 4/23/00 -0500, you wrote: > >Hello, > > > >I'm trying to run a simple search query. > >Do any of you know how to make it a case-insensitive? > >For example, if there is something like > >"Pet is allowed" > >in the data, and user enters > >"pet" > >as a keyword, I would still like the search to pick up > >the data. > > Hi Tony, > > I am guessing that you are searching in a SQL database. Try using 'like' > instead of = in your query. > > i.e. SELECT * FROM table WHERE name LIKE 'ted' > > You can also use ? and % as a wildcard characters. ? will match any single > character, while % will match 0 or more characters. > > HTH, > > Zak > > > > > -- > PHP 3 Mailing List <http://www.php.net/> > To unsubscribe, send an empty message to php3-unsubscribelists.php.net > To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net > To search the mailing list archive, go to: http://www.php.net/mailsearch.php3 > To contact the list administrators, e-mail: php-list-adminlists.php.net > >

attached mail follows:

On Sun, 23 Apr 2000, Toshihide Tony Nakamura wrote:

> Actually, I am using "like", but the problem is that > data has a word "Ted" and postgresql wouldn't pick it > up if the search was run with "ted" instead of "Ted".

there's the UPPER operator

> > i.e. SELECT * FROM table WHERE name LIKE 'ted'

select * from table where upper(name) like upper('ted')

-- 
_Deirdre   *   http://www.linuxcabal.org   *   http://www.deirdre.net
"Dictators ride to and fro upon tigers which they dare not dismount.
 And the tigers are getting hungry." -- Winston Churchill

attached mail follows:

Toshihide Tony Nakamura wrote:

> Thanks for the reply, Zak, > > Actually, I am using "like", but the problem is that > data has a word "Ted" and postgresql wouldn't pick it > up if the search was run with "ted" instead of "Ted". >

In postgresql you can use a case-insensitive (regex) comparision operator:

SELECT * FROM table WHERE name ~* 'ted';

/Stefan

attached mail follows:

At 10:43 AM 4/24/00 +0000, you wrote: >I write a script like this > >$fd="directory/filename"; >$check=file_exsits($fd); > >if (!$check) { > fwrite($fd,$string); >} else { > blah...balh > } >I got an out that said >that the line 5 is not a valid File-Handler > >well accidentally my script run OK (just for once) I get a my file write >in $fd. >When i try for the second time that error comes up. >any suggestion what kind of mistake that i'd made

Hi Yamin,

Try using fopen to open the file handle before you try to write to it.

For example:

$fd = fopen ('directory/filename', 'a' ); if ($fd) fwrite ($fd, $string); else ...

Read the manual entry on fopen before you use it.

HTH,

Zak

attached mail follows:

You need to open a file before you can write to it. See:

http://php.net/manual/function.fopen.php3

Rossi Designs PO Box 1084 Holly Hill, FL 32125-1084 Phone : (904) 226-8979 URL : http://rossidesigns.net ----- Original Message ----- From: Yamin Prabudy <minstarindo.net> To: PHP3 Mailing List <php3lists.php.net> Sent: Monday, April 24, 2000 6:43 AM Subject: [PHP3] fwrite error

| I write a script like this | | $fd="directory/filename"; | $check=file_exsits($fd); | | if (!$check) { | fwrite($fd,$string); | } else { | blah...balh | } | I got an out that said | that the line 5 is not a valid File-Handler | | well accidentally my script run OK (just for once) I get a my file write | in $fd. | When i try for the second time that error comes up. | any suggestion what kind of mistake that i'd made | | | Thanks in advance | | -Yamin- | | -- | PHP 3 Mailing List <http://www.php.net/> | To unsubscribe, send an empty message to php3-unsubscribelists.php.net | To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net | To search the mailing list archive, go to: http://www.php.net/mailsearch.php3 | To contact the list administrators, e-mail: php-list-adminlists.php.net | |

attached mail follows:

I just finish a php website. www.yourtender.com. Anyone who is interested in the site can register as a merchant at URL http://www.yourtender.com/merchant/m_signup.php and play around with functions implements by me. Comments are welcome!!!

Thanks in advance.

attached mail follows:

I create the whole website by myself, which including writing php scripts, connecting to mysql database, design html page.

I used MySQL to do the search, which is not case sensitive.

Regards

Liu Ningjiang ----- Original Message ----- From: Toshihide Tony Nakamura To: Liu Ningjiang Sent: Monday, April 24, 2000 3:10 AM Subject: Re: [PHP3] another PHP commercial website

Liu,

Nice site! Did you create that website, or did you work on PHP part of it? I have a question for you: I did a search on "notebook" and "Notebook". How did you have both to pick up data "notebook"?

Tony ----- Original Message ----- From: Liu Ningjiang To: php3lists.php.net Sent: Monday, April 24, 2000 1:43 AM Subject: [PHP3] another PHP commercial website

I just finish a php website. www.yourtender.com. Anyone who is interested in the site can register as a merchant at URL http://www.yourtender.com/merchant/m_signup.php and play around with functions implements by me. Comments are welcome!!! Thanks in advance.

attached mail follows:

Hello Everyone,

I have a question about site navigation. I want to be able to display hierarchical locations, like Yahoo does (Home > Arts >). Any suggestions on how to create this?

Tim

attached mail follows:

Tim,

Just a suggestion, but you make 2 fields or tables to do this. You can have "category" field and "subcategory" field. When you find the data, you would store category into an array. Then you would use the value in category to search the match with subcategory for the same field. You would repeat this until there is no match, and you will end up with array of name of categories in the array.

I hope this would help.

Tony

----- Original Message ----- From: Timothy Germer <tgermergladstone.uoregon.edu> To: <php3lists.php.net> Sent: Monday, April 24, 2000 2:21 AM Subject: [PHP3] Site Navigation

> Hello Everyone, > > I have a question about site navigation. I want to be able to > display hierarchical locations, like Yahoo does (Home > Arts >). Any > suggestions on how to create this? > > Tim > > > -- > PHP 3 Mailing List <http://www.php.net/> > To unsubscribe, send an empty message to php3-unsubscribelists.php.net > To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net > To search the mailing list archive, go to: http://www.php.net/mailsearch.php3 > To contact the list administrators, e-mail: php-list-adminlists.php.net > >

attached mail follows:

When categorizing things, you can use a table like this:

CREATE TABLE category ( id int, name varchar(40), parent int );

It allows an unlimited number of top-level categories, each with an unlimited number of subcategories. A parent value of zero would indicate a top-level category. A parent value of anything other than zero would be a sub-category. It would be used along with 2 other tables.

CREATE TABLE link ( id int, url varchar(255), name varchar(40), short_description varchar(255), long_description varchar (255), );

CREATE TABLE link_category ( category int, link int };

I have implemented almost this exact schema on my own website (in PHP and PostgreSQL). It works very nicely. It is at http://blackbear.c3net.net (the Our Favorite Links section at the bottom of the page). The number of links is still sparse as it is a new addition to the website, but when you click through, you can see the heirarchy stuff going on.

Doug

At 12:21 AM 4/24/00 -0700, Timothy Germer wrote: >Hello Everyone, > > I have a question about site navigation. I want to be able to >display hierarchical locations, like Yahoo does (Home > Arts >). Any >suggestions on how to create this? > >Tim >

attached mail follows:

Search the archives for phphoo (specifically version 2) - sorry I lost original URl

It will do things exactlly as you want

HTH

Tarique ======================================= Creating not just Web Sites but Web Applications http://www.sanisoft-india.com

Search Engine for Nagpur http://nagpurcity.net =======================================

-----Original Message----- From: Doug Semig <dougslistc3net.net> To: php3lists.php.net <php3lists.php.net> Date: Monday, April 24, 2000 8:36 AM Subject: Re: [PHP3] Site Navigation

>When categorizing things, you can use a table like this: > >CREATE TABLE category ( > id int, > name varchar(40), > parent int >); > >It allows an unlimited number of top-level categories, each with an >unlimited number of subcategories. A parent value of zero would indicate a >top-level category. A parent value of anything other than zero would be a >sub-category. It would be used along with 2 other tables. > >CREATE TABLE link ( > id int, > url varchar(255), > name varchar(40), > short_description varchar(255), > long_description varchar (255), >); > >CREATE TABLE link_category ( > category int, > link int >}; > >I have implemented almost this exact schema on my own website (in PHP and >PostgreSQL). It works very nicely. It is at http://blackbear.c3net.net >(the Our Favorite Links section at the bottom of the page). The number of >links is still sparse as it is a new addition to the website, but when you >click through, you can see the heirarchy stuff going on. > >Doug > > >At 12:21 AM 4/24/00 -0700, Timothy Germer wrote: >>Hello Everyone, >> >> I have a question about site navigation. I want to be able to >>display hierarchical locations, like Yahoo does (Home > Arts >). Any >>suggestions on how to create this? >> >>Tim >> > > > >-- >PHP 3 Mailing List <http://www.php.net/> >To unsubscribe, send an empty message to php3-unsubscribelists.php.net >To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net >To search the mailing list archive, go to: http://www.php.net/mailsearch.php3 >To contact the list administrators, e-mail: php-list-adminlists.php.net >

attached mail follows:

also search at freshmeat.net, there is another yahoo type one called mythreads i think, also I haveseen a couple of others listed on the zend.com somewhere.

SANIsoft wrote: > > Search the archives for phphoo (specifically version 2) - sorry I lost > original URl > > It will do things exactlly as you want > > HTH > > Tarique > ======================================= > Creating not just Web Sites but Web Applications > http://www.sanisoft-india.com > > Search Engine for Nagpur http://nagpurcity.net > ======================================= > > -----Original Message----- > From: Doug Semig <dougslistc3net.net> > To: php3lists.php.net <php3lists.php.net> > Date: Monday, April 24, 2000 8:36 AM > Subject: Re: [PHP3] Site Navigation > > >When categorizing things, you can use a table like this: > > > >CREATE TABLE category ( > > id int, > > name varchar(40), > > parent int > >); > > > >It allows an unlimited number of top-level categories, each with an > >unlimited number of subcategories. A parent value of zero would indicate a > >top-level category. A parent value of anything other than zero would be a > >sub-category. It would be used along with 2 other tables. > > > >CREATE TABLE link ( > > id int, > > url varchar(255), > > name varchar(40), > > short_description varchar(255), > > long_description varchar (255), > >); > > > >CREATE TABLE link_category ( > > category int, > > link int > >}; > > > >I have implemented almost this exact schema on my own website (in PHP and > >PostgreSQL). It works very nicely. It is at http://blackbear.c3net.net > >(the Our Favorite Links section at the bottom of the page). The number of > >links is still sparse as it is a new addition to the website, but when you > >click through, you can see the heirarchy stuff going on. > > > >Doug > > > > > >At 12:21 AM 4/24/00 -0700, Timothy Germer wrote: > >>Hello Everyone, > >> > >> I have a question about site navigation. I want to be able to > >>display hierarchical locations, like Yahoo does (Home > Arts >). Any > >>suggestions on how to create this? > >> > >>Tim > >> > > > > > > > >-- > >PHP 3 Mailing List <http://www.php.net/> > >To unsubscribe, send an empty message to php3-unsubscribelists.php.net > >To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net > >To search the mailing list archive, go to: > http://www.php.net/mailsearch.php3 > >To contact the list administrators, e-mail: php-list-adminlists.php.net > > > > -- > PHP 3 Mailing List <http://www.php.net/> > To unsubscribe, send an empty message to php3-unsubscribelists.php.net > To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net > To search the mailing list archive, go to: http://www.php.net/mailsearch.php3 > To contact the list administrators, e-mail: php-list-adminlists.php.net

attached mail follows:

Exactly :http://mythreads.sourceforge.org

Mythreads and phpHoo2 are both nice, but... MyThreads is a large project, with tons of powerful features phpHoo2 is less powerful, but is still simple and flexible, and it comes with a nice tutorial, explaining exactly what you need.

At 00:11 25/04/2000 +1000, you wrote: >also search at freshmeat.net, there is another yahoo type one called >mythreads i think, >also I haveseen a couple of others listed on the zend.com somewhere. > > >SANIsoft wrote: > > > > Search the archives for phphoo (specifically version 2) - sorry I lost > > original URl > > > > It will do things exactlly as you want > > > > HTH > > > > Tarique > > ======================================= > > Creating not just Web Sites but Web Applications > > http://www.sanisoft-india.com > > > > Search Engine for Nagpur http://nagpurcity.net > > ======================================= > > > > -----Original Message----- > > From: Doug Semig <dougslistc3net.net> > > To: php3lists.php.net <php3lists.php.net> > > Date: Monday, April 24, 2000 8:36 AM > > Subject: Re: [PHP3] Site Navigation > > > > >When categorizing things, you can use a table like this: > > > > > >CREATE TABLE category ( > > > id int, > > > name varchar(40), > > > parent int > > >); > > > > > >It allows an unlimited number of top-level categories, each with an > > >unlimited number of subcategories. A parent value of zero would > indicate a > > >top-level category. A parent value of anything other than zero would be a > > >sub-category. It would be used along with 2 other tables. > > > > > >CREATE TABLE link ( > > > id int, > > > url varchar(255), > > > name varchar(40), > > > short_description varchar(255), > > > long_description varchar (255), > > >); > > > > > >CREATE TABLE link_category ( > > > category int, > > > link int > > >}; > > > > > >I have implemented almost this exact schema on my own website (in PHP and > > >PostgreSQL). It works very nicely. It is at http://blackbear.c3net.net > > >(the Our Favorite Links section at the bottom of the page). The number of > > >links is still sparse as it is a new addition to the website, but when you > > >click through, you can see the heirarchy stuff going on. > > > > > >Doug > > > > > > > > >At 12:21 AM 4/24/00 -0700, Timothy Germer wrote: > > >>Hello Everyone, > > >> > > >> I have a question about site navigation. I want to be able to > > >>display hierarchical locations, like Yahoo does (Home > Arts >). Any > > >>suggestions on how to create this? > > >> > > >>Tim > > >> > > > > > > > > > > > >-- > > >PHP 3 Mailing List <http://www.php.net/> > > >To unsubscribe, send an empty message to php3-unsubscribelists.php.net > > >To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net > > >To search the mailing list archive, go to: > > http://www.php.net/mailsearch.php3 > > >To contact the list administrators, e-mail: php-list-adminlists.php.net > > > > > > > -- > > PHP 3 Mailing List <http://www.php.net/> > > To unsubscribe, send an empty message to php3-unsubscribelists.php.net > > To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net > > To search the mailing list archive, go to: > http://www.php.net/mailsearch.php3 > > To contact the list administrators, e-mail: php-list-adminlists.php.net > >-- >PHP 3 Mailing List <http://www.php.net/> >To unsubscribe, send an empty message to php3-unsubscribelists.php.net >To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net >To search the mailing list archive, go to: http://www.php.net/mailsearch.php3 >To contact the list administrators, e-mail: php-list-adminlists.php.net

attached mail follows:

http://mythreads.sourceforge.net minor correction in the URL ;-)

T.

======================================= Creating not just Web Sites but Web Applications http://www.sanisoft-india.com

Search Engine for Nagpur http://nagpurcity.net =======================================

-----Original Message----- From: David Garnier <david.garniereleve.emn.fr> To: php3lists.php.net <php3lists.php.net> Date: Monday, April 24, 2000 2:43 PM Subject: Re: [PHP3] Site Navigation

>Exactly :http://mythreads.sourceforge.org > >Mythreads and phpHoo2 are both nice, but... >MyThreads is a large project, with tons of powerful features >phpHoo2 is less powerful, but is still simple and flexible, and it comes >with a nice tutorial, explaining exactly what you need. > >At 00:11 25/04/2000 +1000, you wrote: >>also search at freshmeat.net, there is another yahoo type one called >>mythreads i think, >>also I haveseen a couple of others listed on the zend.com somewhere. >> >> >>SANIsoft wrote: >> > >> > Search the archives for phphoo (specifically version 2) - sorry I lost >> > original URl >> > >> > It will do things exactlly as you want >> > >> > HTH >> > >> > Tarique >> > ======================================= >> > Creating not just Web Sites but Web Applications >> > http://www.sanisoft-india.com >> > >> > Search Engine for Nagpur http://nagpurcity.net >> > ======================================= >> > >> > -----Original Message----- >> > From: Doug Semig <dougslistc3net.net> >> > To: php3lists.php.net <php3lists.php.net> >> > Date: Monday, April 24, 2000 8:36 AM >> > Subject: Re: [PHP3] Site Navigation >> > >> > >When categorizing things, you can use a table like this: >> > > >> > >CREATE TABLE category ( >> > > id int, >> > > name varchar(40), >> > > parent int >> > >); >> > > >> > >It allows an unlimited number of top-level categories, each with an >> > >unlimited number of subcategories. A parent value of zero would >> indicate a >> > >top-level category. A parent value of anything other than zero would be a >> > >sub-category. It would be used along with 2 other tables. >> > > >> > >CREATE TABLE link ( >> > > id int, >> > > url varchar(255), >> > > name varchar(40), >> > > short_description varchar(255), >> > > long_description varchar (255), >> > >); >> > > >> > >CREATE TABLE link_category ( >> > > category int, >> > > link int >> > >}; >> > > >> > >I have implemented almost this exact schema on my own website (in PHP and >> > >PostgreSQL). It works very nicely. It is at http://blackbear.c3net.net >> > >(the Our Favorite Links section at the bottom of the page). The number of >> > >links is still sparse as it is a new addition to the website, but when you >> > >click through, you can see the heirarchy stuff going on. >> > > >> > >Doug >> > > >> > > >> > >At 12:21 AM 4/24/00 -0700, Timothy Germer wrote: >> > >>Hello Everyone, >> > >> >> > >> I have a question about site navigation. I want to be able to >> > >>display hierarchical locations, like Yahoo does (Home > Arts >). Any >> > >>suggestions on how to create this? >> > >> >> > >>Tim >> > >> >> > > >> > > >> > > >> > >-- >> > >PHP 3 Mailing List <http://www.php.net/> >> > >To unsubscribe, send an empty message to php3-unsubscribelists.php.net >> > >To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net >> > >To search the mailing list archive, go to: >> > http://www.php.net/mailsearch.php3 >> > >To contact the list administrators, e-mail: php-list-adminlists.php.net >> > > >> > >> > -- >> > PHP 3 Mailing List <http://www.php.net/> >> > To unsubscribe, send an empty message to php3-unsubscribelists.php.net >> > To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net >> > To search the mailing list archive, go to: >> http://www.php.net/mailsearch.php3 >> > To contact the list administrators, e-mail: php-list-adminlists.php.net >> >>-- >>PHP 3 Mailing List <http://www.php.net/> >>To unsubscribe, send an empty message to php3-unsubscribelists.php.net >>To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net >>To search the mailing list archive, go to: http://www.php.net/mailsearch.php3 >>To contact the list administrators, e-mail: php-list-adminlists.php.net > > >-- >PHP 3 Mailing List <http://www.php.net/> >To unsubscribe, send an empty message to php3-unsubscribelists.php.net >To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net >To search the mailing list archive, go to: http://www.php.net/mailsearch.php3 >To contact the list administrators, e-mail: php-list-adminlists.php.net >

attached mail follows:

Hi There.

I'd like to save a textarea to a mysql database. But when I show that text later, all the carriage-returns are gone. So is there any possibility to convert the cr's from a <textarea></textarea> to \n's for php3 ?

Best regards,

Nico Blanke

attached mail follows:

See the nl2br function in the PHP manual.

http://www.php.net/manual/function.nl2br.php

Doug

At 10:07 AM 4/24/00 +0200, Nico Blanke wrote: >Hi There. > >I'd like to save a textarea to a mysql database. But when I show that text >later, all the carriage-returns are gone. So is there any possibility to >convert the cr's from a <textarea></textarea> to \n's for php3 ? > >Best regards, > >Nico Blanke >

attached mail follows:

Hi Michael,

Do you have MS SQL server client installed ? You need the ntwdblib.dll in order to load the module.

And for your second post. with php3 the modules are named php3_mssql.dll and php3_mssql70.dll, for php4 the same dll's are named: php_mssql65.dll and php_mssql70.dll. I have no problems running either module.

- Frank

>Hello Frank, > >I'm having a similar problem, but I AM getting an error message. > >Fatal error: Unable to load dynamic library 'c:\winnt\php_mssql70.dll' >The specified procedure could not be found. in >D:\Inetpub\wwwroot\tytest\php\a.php on line 2 > >line 2= dl("php_mssql70.dll"); > >(this dll was just downloaded from your swwwing site today). > >The dll file is definitely in the c:\winnt directory - >any clues? I'm using a binary build of PHP4RC1 from a few days ago - >maybe Wednesday's build? NT4, SP6. Will I have to build it myself, >rather than using the binaries? > > > >Eric Pree wrote: > >> Oh. I installed the client, and now it loaded up great! Thanks! :) >> -----Original Message----- >> >> Hi Eric, >> >> The module is loaded either with the dl("php3_mssql.dll") command in the >> begining of your script or by extention=php3_mssql.dll in your php3.ini >> file. >> >> The module will only load if you have MSSQL Server Client tools installed on >> the maschine ! >> >> Does the system gives you an error message ? >> >> - Frank >> >> >This isn't even a code problem! I'm just trying to get the mssql extension >> >to load in PHP, and failing. I'm in WinNT, both the web server and PHP work >> >great, and I can load other modules like MySQL and crypt. I do have the >> dll >> >in the proper directory, but it's not showing up in php_info(), and I get >> >errors about mssql_connect() not being defined. This should be a simple >> >thing, and it's starting to piss me off. Oh, and I've tried both 3.0.9 and >> >3.0.16 of PHP, no dice either way. >> > > >-- >========================== >Michael Kimsal >http://www.tapinternet.com >734-480-9961 > > > >

Swwwing A/S Frank M. Kromann VP Development Phone: +45 70 20 77 20 Fax: +45 70 20 77 21 http://www.swwwing.com

attached mail follows:

Hi, I'm trying to figure out, how a call to a url like xxx.xxx/this.php3 can write out and return a txt file as a result?

any help much appreciated, ta Robert

attached mail follows:

Just follow the steps through - use fopen() to open the url, and another call to fopen() for your destination text file, then use fgets to read the url, then use fputs to write out the data to your destination file, and fclose() to close both calls to fopen()

jason

> Hi, > I'm trying to figure out, how a call to a url like xxx.xxx/this.php3 can > write out and return a txt file as a result? > > > any help much appreciated, > ta > Robert

attached mail follows:

On the ./configure for php4, what does --with-mm do?

Paul

shad 96c / 3B CS / mac activist / eda / fumbler fan of / jewel / sophie b. / sarah slean / steve poltz / emm gryner / / x-files / buffy / dawson's creek / habs / bills / 49ers / t h i n k d i f f e r e n t.

"and I need you more than I want you / and I want you for all time" --Jimmy Webb, "Wichita Lineman"

attached mail follows:

Hi,

you need to compile ODBC into PHP, and need some driver to connect to the windows machine too, check out www.unixodbc.org for help..

Maarten Stolte &Samhoud NetVenture ----- Original Message ----- From: Jared To: php3lists.php.net Sent: Sunday, April 23, 2000 7:33 PM Subject: [PHP3] ODBC linux -> windows connect & php3 error

Hello, Im trying to connect to a Winodws machine witha MS Acccess database on ODBC but when i try to call odbc_connectin php it keeps giving me this error: Fatal error: Call to unsupported or undefined function odbc_connect() in inc/functions.php on line 32 This makes no sense to me why it is doing this maybe someone can give me some assistance PHP3 on apache 1.3.9 Linux Mandrake 7.0 Connecting to Windows 98 with an odbc database setup.

Jared Armstrong

attached mail follows:

Hi Jared,

It looks as if you've not compiled php with ODBC. There is a howto at www.iodbc.org.

Best regards, Andrew ---------------------------------------------------- Andrew Hill Technical Support Consultant OpenLink Software http://www.openlinksw.com Universal Database Connectivity Technology Providers

-----Original Message----- From: Jared [mailto:jaredinfinet.com] Sent: Sunday, April 23, 2000 1:34 PM To: php3lists.php.net Subject: [PHP3] ODBC linux -> windows connect & php3 error

Hello, Im trying to connect to a Winodws machine witha MS Acccess database on ODBC but when i try to call odbc_connectin php it keeps giving me this error: Fatal error: Call to unsupported or undefined function odbc_connect() in inc/functions.php on line 32 This makes no sense to me why it is doing this maybe someone can give me some assistance PHP3 on apache 1.3.9 Linux Mandrake 7.0 Connecting to Windows 98 with an odbc database setup.

Jared Armstrong

attached mail follows:

Hi I was wondering if anyone could help me load some images to a web page from the picture path stored in a MySQL database. The document path is already in the database but I have problems getting the image to be output in the browser currently all I get is code or error messages!! I have been looking at the imagegif function am I on the right track? Thanks in advance Andy

attached mail follows:

i love it man!!! it's toooooooo good...

did you check out the logo at the site http://asp2php.naken.cc/ it converts asp code to php code. haven't tried it though. i suppose many of them would have tried it and would like to know the results.

it's like literally bullying Microsoft on ASP (I am sorry for MS fans). I also love the fact that PHP is growing exponentially.

regards, srimanth.

---
Srimanth R C
Mahindra British Telecom
Mumbai
Phone : 91-22-8529000
Fax   : 91-22-8528959
EMail : srimanthMahindraBT.com

attached mail follows:

Hi, This is fairly basic ASP but I guess you are unfamiliar with it. Just remember than in ASP you have to work with a database 'wrapper' that is like one level of abstraction above PHP's, so all access is done using ADODB connection and recordset objects with thier own methods.

> Set MyConn=Server.CreateObject("ADODB.Connection") this creates a database connection object

> MyConn.Open "driver={Microsoft Access Driver (*.mdb)};DBQ=" & >Server.mappath("Directory.mdb") this connects to the database

> Set RsProfile = Server.CreateObject("ADODB.RecordSet") this creates a recordset object to hold the results of the query

> ** RsProfile.Open "Select * From Profile Where Status = 'Yes' and Id >In(Select ProfileId From Category Where Item Like'%" & i &"%')" , >MyConn,adOpenstatic this runs the given on your database object with the given cursor type. If succesful the recordset object will be filled with the database results

> If NOT(RsProfile.BOF AND RsProfile.EOF) Then this checks that the recordset is not empty

> While NOT(RsProfile.EOF) and then loops through the recordset one record at a time until the end is reached .... > RsProfile.MoveNext > Wend > End If >next

HTH

Adam

attached mail follows:

I have a MySQL database that I'm trying to access via PHP. However, I get the following error from the web page:

Fatal error: Call to unsupported or undefined function mysql_connect() in ~$HOME/public_html/heraldry.php3 on line 14

The actual script that I've written goes something like this:

<? // connect to server $mysql_link = mysql_connect("real.private.hostname.here", "real.userID", "real.userPASSWD");

// select heraldry database mysql_select_db("heraldry", $mysql_link);

file://get everything from imperial table $query = "SELECT * FROM imperial "; $mysql_result = mysql_db_query("heraldry", $query, $mysql_link);

?>

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ I based this off of scripts printed in "Core PHP Programming" by Leon Atkinson.

CAn someone help me figure out WTF I missed?

Thanks, Geordon (who reads the digest of the list, so please respond directly!)

attached mail follows:

Do you use windows? Did you browse through php3.ini and check wether you enabled the mysql libs? I bet you did not.

Cheers,

> I have a MySQL database that I'm trying to access via PHP. However, I get > the following error from the web page: > > Fatal error: Call to unsupported or undefined function mysql_connect() in > ~$HOME/public_html/heraldry.php3 on line 14 > > The actual script that I've written goes something like this: > > <? > // connect to server > $mysql_link = mysql_connect("real.private.hostname.here", "real.userID", > "real.userPASSWD"); > > // select heraldry database > mysql_select_db("heraldry", $mysql_link); > > > file://get everything from imperial table > $query = "SELECT * FROM imperial "; > $mysql_result = > mysql_db_query("heraldry", $query, $mysql_link); > > > ?>

Soeren Staun-Pedersen - StaunSunSITE.auc.dk ------ "The internet is full, beat it" - Me.

attached mail follows:

Sorry, I should have mentioned that I'm using Linux, and installed php-3.0.16-2 via RPM. I do know that my PHP is working, as I have a (non-dB)script on another page that is responding correctly.

Thanks, G

-----Original Message----- From: Soren Staun-Pedersen [mailto:stauncs.auc.dk] Sent: Monday, April 24, 2000 7:39 AM To: VANTASSLE, GEORDON M. (AIT) Cc: 'php3lists.php.net' Subject: Re: [PHP3] What did I mess up?

Do you use windows? Did you browse through php3.ini and check wether you enabled the mysql libs? I bet you did not.

Cheers,

> I have a MySQL database that I'm trying to access via PHP. However, I get > the following error from the web page: > > Fatal error: Call to unsupported or undefined function mysql_connect() in > ~$HOME/public_html/heraldry.php3 on line 14 > > The actual script that I've written goes something like this: > > <? > // connect to server > $mysql_link = mysql_connect("real.private.hostname.here", "real.userID", > "real.userPASSWD"); > > // select heraldry database > mysql_select_db("heraldry", $mysql_link); > > > file://get everything from imperial table > $query = "SELECT * FROM imperial "; > $mysql_result = > mysql_db_query("heraldry", $query, $mysql_link); > > > ?>

Soeren Staun-Pedersen - StaunSunSITE.auc.dk ------ "The internet is full, beat it" - Me.

attached mail follows:

I'm guessing that I'm going to have to re-compile, if I'm reading this right.

http://castle.thecoventree.com/~gvantass/

This is my userpage on my server, which is currently showing phpinfo() and if I'm reading right, there is NO support for mysql compiled in.

Would someone please confirm that for me?

Thanks, (sigh) Geordon

-----Original Message----- From: Mike Sears [mailto:neutrinoneutrinostudios.com] Sent: Monday, April 24, 2000 11:08 AM To: VANTASSLE, GEORDON M. (AIT) Subject: RE: [PHP3] What did I mess up?

You may want to build PHP from the php source. I've used the PHP rpm's and had a great deal of problems. one of which was that there was no support for mysql. find out what your phpmod is compiled with by using phpinfo()

Matrix

Sorry, I should have mentioned that I'm using Linux, and installed php-3.0.16-2 via RPM. I do know that my PHP is working, as I have a (non-dB)script on another page that is responding correctly.

Thanks, G

attached mail follows:

On Mon, 24 Apr 2000, VANTASSLE, GEORDON M. (AIT) wrote:

> Sorry, I should have mentioned that I'm using Linux, and installed > php-3.0.16-2 via RPM. I do know that my PHP is working, as I have a > (non-dB)script on another page that is responding correctly. > > Thanks, > G

[snip]

Something to try:

> > I have a MySQL database that I'm trying to access via PHP. However, I get > > the following error from the web page: > > > > Fatal error: Call to unsupported or undefined function mysql_connect() in > > ~$HOME/public_html/heraldry.php3 on line 14 > > > > The actual script that I've written goes something like this: > > > > <? // load mysql support dl("mysql.so"); > > // connect to server > > $mysql_link = mysql_connect("real.private.hostname.here", "real.userID", > > "real.userPASSWD");

If this doesn't work, check that you have mysql and mysql-dev installed, and try recompiling php.

Good luck, Jean-Marc Libs

-- 
Les Journées du Libre les 12 et 13 mai à Strasbourg :
http://strasbourg.linuxfr.org/jl3
"While you're waiting, read the free novel we sent you.  It's a 
Spanish story about a guy named `Manual'" - Dilbert

attached mail follows:

Can anyone tell me where to find the DB library for using Sybase using an Apache / NT configuration.

I cannot find the proper php3_sybase dll files anywhere even though documentation indicates it is supported

Thank you Sincerely, Jay

attached mail follows:

Thanks that solved the problem.

The key phrase is "Regular expressions are complex beasts". I did not know what to look for. Now that I know I have found a more information on the subject. Thanks again.

Ted Knudson http://www.automatedcabinets.com http://www.pulsarusa.com

attached mail follows:

At 07:37 AM 4/24/00 -0500, Ted Knudson wrote: >Thanks that solved the problem. > >The key phrase is "Regular expressions are complex beasts". >I did not know what to look for. Now that I know I have found a more >information on the subject. >Thanks again.

Glad to help!

Zak

attached mail follows:

Hello,

I'm using php version 3.0.16 with apache 1.3.6 under Windows 95. The function preg_quote appears to be undefined, i.e. 'Fatal error: Call to unsupported or undefined function preg_quote()' occurrs when its called. However the other preg functions work fine.

Might this be a setup problem or a bug.

Regards

Stewart

attached mail follows:

At 01:59 PM 4/24/00 +0100, Stewart Taylor wrote: >Hello, > >I'm using php version 3.0.16 with apache 1.3.6 under Windows 95. >The function preg_quote appears to be undefined, i.e. 'Fatal error: Call >to unsupported or undefined function preg_quote()' occurrs when its >called. However the other preg functions work fine.

add this line extension=php3_pcre.dll to the c:\windows\php3.ini file in the ';Windows Extensions' section

attached mail follows:

Hi !

possible adjust Java support for php-4.0RC1-Win32 available on ÓÁÊÔÅ www.php.net)?

Oleg Gorobchuk.

attached mail follows:

Hello folks I was using the following .htaccess file with php 3.0.15

php3_track_vars on php3_track_errors on php3_magic_quotes_gpc on php3_magic_quotes_runtime off php3_include_path /home/sanisoft/www/sanisoftphp/:./ php3_auto_prepend_file /home/sanisoft/www/sanisoftphp/prepend.php3

my host has recently moved to PHP4 RC1

how would the .htacess file be different now?

TIA

Tarique

attached mail follows:

OK! looks like .htaccess itself is not working for my server :-(

Sorry for the panic mail

Tarique ======================================= Creating not just Web Sites but Web Applications http://www.sanisoft-india.com

Search Engine for Nagpur http://nagpurcity.net =======================================

-----Original Message----- From: SANIsoft <tariquenagpur.dot.net.in> To: PHP3 Mailing List <php3lists.php.net> Date: Monday, April 24, 2000 1:14 PM Subject: [PHP3] PHP4 and .htaccess

>Hello folks >I was using the following .htaccess file with php 3.0.15 > >php3_track_vars on >php3_track_errors on >php3_magic_quotes_gpc on >php3_magic_quotes_runtime off >php3_include_path /home/sanisoft/www/sanisoftphp/:./ >php3_auto_prepend_file /home/sanisoft/www/sanisoftphp/prepend.php3 > >my host has recently moved to PHP4 RC1 > >how would the .htacess file be different now? > >TIA > >Tarique > > > > >-- >PHP 3 Mailing List <http://www.php.net/> >To unsubscribe, send an empty message to php3-unsubscribelists.php.net >To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net >To search the mailing list archive, go to: http://www.php.net/mailsearch.php3 >To contact the list administrators, e-mail: php-list-adminlists.php.net >

attached mail follows:

Hi List..

I am using Php with Ms Access. In any database and in any table, through the following I will be able to move the record pointer to the Last record. This is in ASP.

Rs.Open "Select * From profile order by id", MyConn,adOpenstatic Rs.movelast

Same thing is there any way for me to do it in Php by writing a small query in sql / Ms Access.

Suggestions / Ideas are welcome.

Thanks in advance.

-- K

attached mail follows:

> -----Original Message----- > From: TV Karthick Kumar [mailto:tvkarthickmailops.com] > Sent: Monday, April 24, 2000 8:13 AM > To: PHP Mailing List > Subject: [PHP3] Moving to Last Record > > > I am using Php with Ms Access. In any database and in any > table, through the following I will be able to move the > record pointer to the Last record. > This is in ASP. > > Rs.Open "Select * From profile order by id", MyConn,adOpenstatic > Rs.movelast > > Same thing is there any way for me to do it in Php by > writing a small query in sql / Ms Access.

My (initial) approach would be to change "order by id" to "order by id desc" -- that'll reverse the sort order of your result set, making the last record returned by your original query the first.

Alternatively, the odbc_fetch_row() function allows you to specify a row number (assuming that your odbc drivers support that)...I'd assume the result of an odbc_num_rows() call would be useful in that case.

---
Mark Roedel             |  "Blessed is he who has learned to laugh
Systems Programmer      |   at himself, for he shall never cease
LeTourneau University   |   to be entertained."
Longview, Texas, USA    |                           -- John Powell

attached mail follows:

Yeah. I am happy to say you that I somehow managed to make it worked. The thing I wanted is to get the latest ID from a table and insert into another as a Profile Id field. I did it through max(id) query in the select statment ' Select max(id) from Profile' - so that I got the recent Id from the Profile Table and then inserted the same as Profile Id field into the Category table.

Now I am satisifed with the requirement.

Anyway thanks for your help.

-- K

> > > > > > I am using Php with Ms Access. In any database and in any > > table, through the following I will be able to move the > > record pointer to the Last record. > > This is in ASP. > > > > Rs.Open "Select * From profile order by id", MyConn,adOpenstatic > > Rs.movelast > > > > Same thing is there any way for me to do it in Php by > > writing a small query in sql / Ms Access. > > My (initial) approach would be to change "order by id" to "order by id > desc" -- that'll reverse the sort order of your result set, making the last > record returned by your original query the first. > > Alternatively, the odbc_fetch_row() function allows you to specify a row > number (assuming that your odbc drivers support that)...I'd assume the > result of an odbc_num_rows() call would be useful in that case

attached mail follows:

Hello All!

How can I upload a number of files from user computer without asking filename for every name (e.g. all *.dat files). Of couse I know how do it for one file :) ( <input type=file name=user_file value=\"Show\" size=20>" ... and copy(..))

Rgds, Vadim Grepan ------------------------ Moscow, Russia

attached mail follows:

I have a Helpdesk Management Utility that I have written in PHP. It is over 4 hundred lines of code. I was wondering to how to best optimize this. I do have several lines of code that are repeated. My main questions are: 1. How fast is a function contained with in a script. 2. If a require is within an if statement is the code required only if the if is true, or is it read on first scan of the document, and how fast is a require. 3. I am just curious because in today's world speed is needed, and if someone lags for just a few seconds they can get frustrated and leave. 4. Is their a better way to speed up scripts.

Right now the main problem with speed of the script is that it is still in the development stage on my old laptop that has 32 megs of ram running windows98, mssql server and pws. The Microsoft products are a resource hogs. I do want to know my options when I go to implement this.

Also, where can I find Database performance information for MYSQL vs MSSQL Server (as unbias as possible).

Jeff Strain

I really like the list although I do not have time to read 100% of the information.

******************************************************** Jeff Strain 80 WEST 900 South Helpdesk Administrator/Lead Operator P.O. BOX 3656 Saddleman, Inc. LOGAN UT. 84323-3656 Phone: (435)752-1000 jstrainsaddleman.com FAX: (435)752-5777 ********************************************************

attached mail follows:

Try not using functions. You will get approximately 30+ % more speed.

Gp.

attached mail follows:

What do you base these figures on? Your own tests or others? Are those tests available online?

I read somewhere (on this list I think) that a lot of comments slows down the scripts but I haven't checked that myself.

Best regards, Martin Edelius

Spirex Digital Design -------------------------------- www: http://www.spirex.se Mail: martin.edeliusspirex.se Phone: +46-31-514651, 0708-113711 Fax: +46-31-514331 Arods Industrivag 3c S-422 43 Hisings Backa -------------------------------- If I haven't got back to you or done what I'm supposed to, let me know again as I have too much to do for my own good...

----- Original Message ----- From: "George Papadakis" <georgepforthnet.gr> To: "Jeff Strain" <jstrainsaddleman.com>; <php-devlists.php.net>; <php3lists.php.net> Sent: Monday, April 24, 2000 3:52 PM Subject: Re: [PHP3] PHP Speed Optimization

> Try not using functions. > You will get approximately 30+ % more speed. > > Gp. > > > -- > PHP 3 Mailing List <http://www.php.net/> > To unsubscribe, send an empty message to php3-unsubscribelists.php.net > To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net > To search the mailing list archive, go to: http://www.php.net/mailsearch.php3 > To contact the list administrators, e-mail: php-list-adminlists.php.net > >

attached mail follows:

If you don't use variables or statements, I've found that everything is about 100000% faster. Oh but the drawback is that you don't do anything in any of your programs.

- Mitch

----- Original Message ----- From: Martin Edelius <martin.edeliusspirex.se> To: George Papadakis <georgepforthnet.gr>; Jeff Strain <jstrainsaddleman.com>; <php-devlists.php.net>; <php3lists.php.net> Sent: Monday, April 24, 2000 10:00 AM Subject: Re: [PHP3] PHP Speed Optimization

> What do you base these figures on? Your own tests or others? Are those tests > available online? > > I read somewhere (on this list I think) that a lot of comments slows down > the scripts but I haven't checked that myself. > > > Best regards, > Martin Edelius > > Spirex Digital Design > -------------------------------- > www: http://www.spirex.se > Mail: martin.edeliusspirex.se > Phone: +46-31-514651, 0708-113711 > Fax: +46-31-514331 > Arods Industrivag 3c > S-422 43 Hisings Backa > -------------------------------- > If I haven't got back to you or done what I'm supposed to, let me know again > as I have too much to do for my own good... > > ----- Original Message ----- > From: "George Papadakis" <georgepforthnet.gr> > To: "Jeff Strain" <jstrainsaddleman.com>; <php-devlists.php.net>; > <php3lists.php.net> > Sent: Monday, April 24, 2000 3:52 PM > Subject: Re: [PHP3] PHP Speed Optimization > > > > Try not using functions. > > You will get approximately 30+ % more speed. > > > > Gp. > > > > > > -- > > PHP 3 Mailing List <http://www.php.net/> > > To unsubscribe, send an empty message to php3-unsubscribelists.php.net > > To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net > > To search the mailing list archive, go to: > http://www.php.net/mailsearch.php3 > > To contact the list administrators, e-mail: php-list-adminlists.php.net > > > > > > > -- > PHP 3 Mailing List <http://www.php.net/> > To unsubscribe, send an empty message to php3-unsubscribelists.php.net > To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net > To search the mailing list archive, go to: http://www.php.net/mailsearch.php3 > To contact the list administrators, e-mail: php-list-adminlists.php.net > >

attached mail follows:

This is a little off topic, but I'm going to have to install a web server on an NT machine and I wondered what kind of performance difference there was between IIS and Apache 1.3.9 for Windows NT? How about for win98?

Thank you for the help, dgoa

attached mail follows:

Apache is much better in terms of performance than IIS regardless of NT or 98.. Also, IIS has a lot of security issues that keep propping up everyday.. Havent heard too many of apache..

"William X. Kerber" wrote:

> This is a little off topic, but I'm going to have to install a web server on an > NT machine and I wondered what kind of performance difference there was between > IIS and Apache 1.3.9 for Windows NT? How about for win98? > > Thank you for the help, > dgoa > > -- > PHP 3 Mailing List <http://www.php.net/> > To unsubscribe, send an empty message to php3-unsubscribelists.php.net > To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net > To search the mailing list archive, go to: http://www.php.net/mailsearch.php3 > To contact the list administrators, e-mail: php-list-adminlists.php.net

--
Ashwin
kutty..
Systems Administrator
Dalhousie University Libraries

attached mail follows:

You need NT Server to install IIS (cut-down PWS gets installed on WKS instead - at least it got when I tried to install IIS from NT Option Pack.. or was it Resource Kit?). The same applies to Win98. On the contrary, you can have full-blown Apache on NT Server and WKS, and on Win98 as well.

I use Apache, because I find it easier to configure and maintain. I didn't do any benchmarks, though.

There's one more problem with win32 env - on IIS & PWS you can have either CGI or ISAPI version of PHP, CGI being slower and missing some functionality, while ISAPI being somewhat buggy and incomplete - at least from what I've spotted on the list recently. Apache in win32 env can use only the CGI version of PHP because of threading - this is what Andi Gutmans sent me about this: (Sun, 09 Apr)

>I know the windows version is multi-threaded and therefore could >not be implemented with PHP 3. PHP 4 however takes care of this >issue. >What it really takes is someone to step up and start writing this >support. I don't see any of the PHP core developers doing this in >the near future because we are very busy with getting PHP 4 out >of the door and some are busy with their jobs. >Also, I am not sure in what stage Apache 2 is (well it's Alpha but >I'm not sure if it's a useable alpha). I know the API is >completely different from Apache 1.3.x's API so the question is >also if the person should aim for Apache 2.x or 1.3.x.

At 09:04 24.4.2000 -0500, William X. Kerber wrote the following: -------------------------------------------------------------- >This is a little off topic, but I'm going to have to install a web server on an >NT machine and I wondered what kind of performance difference there was between >IIS and Apache 1.3.9 for Windows NT? How about for win98? > >Thank you for the help, >dgoa > > >-- >PHP 3 Mailing List <http://www.php.net/> >To unsubscribe, send an empty message to php3-unsubscribelists.php.net >To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net >To search the mailing list archive, go to: http://www.php.net/mailsearch.php3 >To contact the list administrators, e-mail: php-list-adminlists.php.net ------end of quote------

____________________________________________________________ Cynic:

A member of a group of ancient Greek philosophers who taught that virtue constitutes happiness and that self control is the essential part of virtue.

cynicmail.cz ICQ: 2808 2505

attached mail follows:

Hi all!

Haven't heard of many security problems with Apache, eh? Well, sorry to say, but all software that deals with public access (be it an OS, a database or a webserver) has security issues. The Apache 1.3.12 release was made witht he express purpose of being a security patch, for example. It's just that everyone, me included, likes to ramp on MSoft. But don't think for a moment there aren't plenty of security issues with non-MS, even open source, products.

re: performance...I'd love to see some numbers for a WinNT Apache/PHP-cgi install versus a IIS4/PHP-isapi install. The bulk of word-of-mouth I have heard about Apache on NT is that it's not there yet in performance. There's reason that the Apache folks have a HUGE disclaimer on the Apache for Windows page webpage. Check it out: http://www.apache.org/docs/windows.html .

Um, Win 98 doesn't even bear considering. It's just not built to be a server-type OS. Even NT workstation will do a much better job. Maybe if it's just a small intranet based app for a dozen people, at most. Anything larger than that I really wouldn't try.

If you don't want to deal with IIS, you could always run an Xitami server ( http://www.imatix.com/ ). It's great little freeware web/ftp server (SSL support costs $99, non SSL is free) that takes up little system resources. I've used it on many an intranet based app and know several folks who use it for high traffic sites. Easy as heck to configure and serves pages plenty, plenty fast. The next version will support ISAPI modules (read: PHP4 isapi installs will rock!!!!!!).

Again, all products have their good and bad points. A little research about them, indeed, even using them yourself, before making big 'ol judgements is generally the best path. Just a little IMHO. :)

Have a lovely Monday, if that's actually possible...and a late Happy Easter...

Salute! - Erik

-----Original Message----- From: Ashwin Kutty <Ashwin.KuttyDal.Ca> To: William X. Kerber <dgoaou.edu> Cc: PHP3 Mailing List <php3lists.php.net> Date: Monday, April 24, 2000 7:12 AM Subject: Re: [PHP3] Apache vs IIS for NT...

> >Apache is much better in terms of performance than IIS regardless of NT or 98.. >Also, IIS has a lot of security issues that keep propping up everyday.. Havent >heard too many of apache.. > > >"William X. Kerber" wrote: > >> This is a little off topic, but I'm going to have to install a web server on an >> NT machine and I wondered what kind of performance difference there was between >> IIS and Apache 1.3.9 for Windows NT? How about for win98? >> >> Thank you for the help, >> dgoa >> >> -- >> PHP 3 Mailing List <http://www.php.net/> >> To unsubscribe, send an empty message to php3-unsubscribelists.php.net >> To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net >> To search the mailing list archive, go to: http://www.php.net/mailsearch.php3 >> To contact the list administrators, e-mail: php-list-adminlists.php.net > >-- >Ashwin >kutty.. >Systems Administrator >Dalhousie University Libraries > > > > >-- >PHP 3 Mailing List <http://www.php.net/> >To unsubscribe, send an empty message to php3-unsubscribelists.php.net >To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net >To search the mailing list archive, go to: http://www.php.net/mailsearch.php3 >To contact the list administrators, e-mail: php-list-adminlists.php.net

attached mail follows:

FYI, I have used the two.. Apache still runs smoother than IIS... I got no beef with Msoft.. I have over 500+ client PC's now running the Win OS and one of my servers is also a licensing server with Win as its OS.. About performance, try it yourself and you will know.. I run it, so I do know!

About security issues, I do know about apache, as I said, I havent heard many, but they exist ofcourse.. IIS takes the cup for the most number of security issues however, dont believe me, try reading up on the BUGTRAQ archives sometimes, or even the number of patches they have released or are in the process of releasing!

Erik Mathy wrote:

> Hi all! > > Haven't heard of many security problems with Apache, eh? Well, sorry to > say, but all software that deals with public access (be it an OS, a database > or a webserver) has security issues. The Apache 1.3.12 release was made > witht he express purpose of being a security patch, for example. It's just > that everyone, me included, likes to ramp on MSoft. But don't think for a > moment there aren't plenty of security issues with non-MS, even open source, > products. > > re: performance...I'd love to see some numbers for a WinNT > Apache/PHP-cgi install versus a IIS4/PHP-isapi install. The bulk of > word-of-mouth I have heard about Apache on NT is that it's not there yet in > performance. There's reason that the Apache folks have a HUGE disclaimer on > the Apache for Windows page webpage. Check it out: > http://www.apache.org/docs/windows.html . > > Um, Win 98 doesn't even bear considering. It's just not built to be a > server-type OS. Even NT workstation will do a much better job. Maybe if it's > just a small intranet based app for a dozen people, at most. Anything larger > than that I really wouldn't try. > > If you don't want to deal with IIS, you could always run an Xitami > server ( http://www.imatix.com/ ). It's great little freeware web/ftp server > (SSL support costs $99, non SSL is free) that takes up little system > resources. I've used it on many an intranet based app and know several folks > who use it for high traffic sites. Easy as heck to configure and serves > pages plenty, plenty fast. The next version will support ISAPI modules > (read: PHP4 isapi installs will rock!!!!!!). > > Again, all products have their good and bad points. A little research > about them, indeed, even using them yourself, before making big 'ol > judgements is generally the best path. Just a little IMHO. :) > > Have a lovely Monday, if that's actually possible...and a late Happy > Easter... > > Salute! > - Erik > > -----Original Message----- > From: Ashwin Kutty <Ashwin.KuttyDal.Ca> > To: William X. Kerber <dgoaou.edu> > Cc: PHP3 Mailing List <php3lists.php.net> > Date: Monday, April 24, 2000 7:12 AM > Subject: Re: [PHP3] Apache vs IIS for NT... > > > > >Apache is much better in terms of performance than IIS regardless of NT or > 98.. > >Also, IIS has a lot of security issues that keep propping up everyday.. > Havent > >heard too many of apache.. > > > > > >"William X. Kerber" wrote: > > > >> This is a little off topic, but I'm going to have to install a web server > on an > >> NT machine and I wondered what kind of performance difference there was > between > >> IIS and Apache 1.3.9 for Windows NT? How about for win98? > >> > >> Thank you for the help, > >> dgoa > >> > >> -- > >> PHP 3 Mailing List <http://www.php.net/> > >> To unsubscribe, send an empty message to php3-unsubscribelists.php.net > >> To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net > >> To search the mailing list archive, go to: > http://www.php.net/mailsearch.php3 > >> To contact the list administrators, e-mail: php-list-adminlists.php.net > > > >-- > >Ashwin > >kutty.. > >Systems Administrator > >Dalhousie University Libraries > > > > > > > > > >-- > >PHP 3 Mailing List <http://www.php.net/> > >To unsubscribe, send an empty message to php3-unsubscribelists.php.net > >To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net > >To search the mailing list archive, go to: > http://www.php.net/mailsearch.php3 > >To contact the list administrators, e-mail: php-list-adminlists.php.net > > -- > PHP 3 Mailing List <http://www.php.net/> > To unsubscribe, send an empty message to php3-unsubscribelists.php.net > To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net > To search the mailing list archive, go to: http://www.php.net/mailsearch.php3 > To contact the list administrators, e-mail: php-list-adminlists.php.net

--
Ashwin
kutty..
Systems Administrator
Dalhousie University Libraries

attached mail follows:

In my experience, apache seems to be a little slower. HOWEVER, I find ASP to be extremely chunky so overall apache/PHP is faster than IIS/ASP. As far as security goes, NT is pretty much a joke. I'm on the ASP security mailing list from Microsoft and you wouldn't believe some of the holes in IIS. There is a security checklist of about 10 pages of things you need to do to make NT 'secure' most of which include edidting the registry. But to answer your original question, there is a reason that over 50% of the universe runs apache on the webservers, it's just better!

Regards, Jason

---------- Original Message ---------------------------------- From: "William X. Kerber" <dgoaou.edu> Date: Mon, 24 Apr 2000 09:04:34 -0500

>This is a little off topic, but I'm going to have to install a web server on an >NT machine and I wondered what kind of performance difference there was between >IIS and Apache 1.3.9 for Windows NT? How about for win98? > >Thank you for the help, >dgoa > > >-- >PHP 3 Mailing List <http://www.php.net/> >To unsubscribe, send an empty message to php3-unsubscribelists.php.net >To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net >To search the mailing list archive, go to: http://www.php.net/mailsearch.php3 >To contact the list administrators, e-mail: php-list-adminlists.php.net > >

_______________________________________________________ Site Design, Hosting, and E-Commerce at www.webpipe.net

attached mail follows:

A fun site to show people is http://www.aspsourcecode.com, written in PHP. Doesn't work with all NT servers, but a good many out there are still wide open. I posted about this on the zend site, but thought some of you here might find it fun as well.

Jason Cox wrote:

> In my experience, apache seems to be a little slower. HOWEVER, I find ASP to be extremely chunky so overall apache/PHP is faster than IIS/ASP. As far as security goes, NT is pretty much a joke. I'm on the ASP security mailing list from Microsoft and you wouldn't believe some of the holes in IIS. There is a security checklist of about 10 pages of things you need to do to make NT 'secure' most of which include edidting the registry. But to answer your original question, there is a reason that over 50% of the universe runs apache on the webservers, it's just better! > > Regards, > Jason > > ---------- Original Message ---------------------------------- > From: "William X. Kerber" <dgoaou.edu> > Date: Mon, 24 Apr 2000 09:04:34 -0500 > > >This is a little off topic, but I'm going to have to install a web server on an > >NT machine and I wondered what kind of performance difference there was between > >IIS and Apache 1.3.9 for Windows NT? How about for win98? > > > >Thank you for the help, > >dgoa > > > > > >-- > >PHP 3 Mailing List <http://www.php.net/> > >To unsubscribe, send an empty message to php3-unsubscribelists.php.net > >To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net > >To search the mailing list archive, go to: http://www.php.net/mailsearch.php3 > >To contact the list administrators, e-mail: php-list-adminlists.php.net > > > > > > _______________________________________________________ > Site Design, Hosting, and E-Commerce at www.webpipe.net > > -- > PHP 3 Mailing List <http://www.php.net/> > To unsubscribe, send an empty message to php3-unsubscribelists.php.net > To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net > To search the mailing list archive, go to: http://www.php.net/mailsearch.php3 > To contact the list administrators, e-mail: php-list-adminlists.php.net

--
==========================
Michael Kimsal
http://www.tapinternet.com
734-480-9961

attached mail follows:

I do have them installed. I stated at the beginning of my first message that I compliled and installed libjpeg (jpeg-6b) and libpng (libpng-1.0.6) installed (also freetype and zlib). I've included my directory listings of /usr/local/include and /usr/local/lib.

I built and installed them in this order: zlib 1.1.3 freetype 1.3.1 libpng 1.0.6 jpeg 6b gd 1.8.1

I compiled gd with these settings and did not get any errors while compiling: CFLAGS=-O -DHAVE_JPEG -DHAVE_LIBTTF LIBS=-lm -lgd -lpng -lz -ljpeg -lttf LIBDIRS=-L. -L/usr/local/lib INCLUDEDIRS=-I/usr/local/include -I/usr/local/include/freetype

Any other ideas? Let me know if there is anything I can do to run some checks to see if they are all installed correctly.

Thanks for your help.

Trace Pupke pupketcofc.edu

---
Here's my /usr/local/include (minus misc files)
      9363 Apr 21 11:08 disptmpl.h
d      512 Apr 19 14:28 freetype
      9165 Apr 19 16:25 gd.h
       917 Apr 19 16:26 gd_io.h
      2673 Apr 19 16:26 gdcache.h
       490 Apr 19 16:26 gdfontg.h
       488 Apr 19 16:26 gdfontl.h
       451 Apr 19 16:26 gdfontmb.h
       452 Apr 19 16:26 gdfonts.h
       484 Apr 19 16:26 gdfontt.h
      1258 Apr 19 16:11 jconfig.h
     13936 Apr 19 16:11 jerror.h
     12458 Apr 19 16:11 jmorecfg.h
     46205 Apr 19 16:11 jpeglib.h
      7207 Apr 21 11:08 lber.h
     24945 Apr 21 11:08 ldap.h
      1361 Apr 21 11:08 ldap_cdefs.h
       423 Apr 20 12:19 linkage.h
      3353 Apr 19 17:03 ltdl.h
     52064 Apr 20 12:19 mail.h
      4602 Apr 19 17:04 mcrypt.h
      3661 Apr 19 16:41 mhash.h
    117483 Apr 19 14:48 png.h
     28150 Apr 19 14:48 pngconf.h
      4915 Apr 20 12:19 rfc822.h
      2771 Apr 21 11:08 srchpref.h
      7810 Apr 19 14:32 zconf.h
     40898 Apr 19 14:32 zlib.h
Here's my /usr/local/lib (minus misc libs)
   2716760 Apr 20 12:18 libc-client.a
    324544 Apr 19 16:25 libgd.a
    414910 Apr 19 16:11 libjpeg.a
       461 Apr 19 16:11 libjpeg.la
        17 Apr 19 16:11 libjpeg.so -> libjpeg.so.62.0.0
    237568 Apr 19 16:11 libjpeg.so.62.0.0
    179612 Apr 21 11:08 liblber.a
       665 Apr 21 11:08 liblber.la
   1335508 Apr 21 11:08 libldap.a
       665 Apr 21 11:08 libldap.la
    105786 Apr 19 17:03 libltdl.a
       640 Apr 19 17:03 libltdl.la
        16 Apr 19 17:03 libltdl.so -> libltdl.so.1.1.2
     81920 Apr 19 17:03 libltdl.so.1.1.2
d     2048 Apr 19 17:04 libmcrypt
    131480 Apr 19 17:04 libmcrypt.a
       652 Apr 19 17:04 libmcrypt.la
        18 Apr 19 17:04 libmcrypt.so -> libmcrypt.so.4.0.1
     98304 Apr 19 17:04 libmcrypt.so.4.0.1
    765340 Apr 19 16:41 libmhash.a
       646 Apr 19 16:41 libmhash.la
        17 Apr 19 16:41 libmhash.so -> libmhash.so.2.0.0
    507904 Apr 19 16:41 libmhash.so.2.0.0
    376518 Apr 19 14:48 libpng.a
    311296 Apr 19 14:48 libpng.so.2.1.0.6
       630 Apr 19 14:27 libttf.la
        15 Apr 19 14:27 libttf.so -> libttf.so.4.2.0
   1024000 Apr 19 14:27 libttf.so.4.2.0
    159906 Apr 19 14:32 libz.a
> -----Original Message-----
> From: Rasmus Lerdorf [mailto:rasmusphp.net]
> Sent: Saturday, April 22, 2000 3:07 AM
> To: Trace Pupke
> Cc: php3lists.php.net
> Subject: Re: [PHP3] GD 1.8.1 problems
> 
> 
> You probably don't have libjpeg and pibpng installed.  GD-1.8.1 needs
> these.
> 
> -Rasmus
> 
> On Fri, 21 Apr 2000, Trace Pupke wrote:
> 
> > I'm trying to compile PHP 3.0.16 with GD 1.8.1.
> > I was able to get GD to compile just fine using
> > freetype 1.3.1, png 1.0.6, jpg 6b and zlib 1.1.3.
> > But when I do my ./configure for PHP (
> > 	./configure \
> > 	--with-apache=/usr/archive/src/apache_1.3.12 \
> > 	--with-imap=/usr/local \
> > 	--with-ftp \
> > 	--with-gd=/usr/local \
> > 	--with-jpeg-dir=/usr/local \
> > 	--with-ttf=/usr/local \
> > 	--with-mysql=/usr/local/mysql \
> > 	--with-msql \
> > 	--with-ldap \
> > 	--with-xml \
> > 	--with-zlib=/usr/local \
> > 	--enable-debug=no \
> > 	--enable-safe-mode=no \
> > 	--enable-track-vars \
> > 	--enable-magic-quotes=no \
> > 	--enable-debugger=no \
> > 	--enable-memory-limit \
> > 	--disable-short-tags \
> > 	--with-mcrypt=/usr/local \
> > 	--with-mhash=/usr/local
> > ), I get the following when it gets to the GD part:
> > 
> > checking for compress in -lz... yes
> > checking for png_info_init in -lpng... yes
> > checking for gdImageCreateFromPng in -lgd... no
> > checking for gdImageCreateFromJpeg in -lgd... no
> > checking for gdImageCreateFromGif in -lgd... no
> > checking for gdImageLzw in -lgd... no
> > checking for gdImageColorResolve in -lgd... yes
> > checking for gdImageString16 in -lgd... yes
> > checking whether to include GD support... no
> > checking whether to include FreeType support... /usr/local
> > configure: warning: No gd support found. Skipping FreeType 
> Configuration
> > 
> > I know that since GIF support was dropped in GD that
> > gdImageCreateFromGif and gdImageLzw would report no, but
> > gdImageCreateFromPng and gdImageCreateFromJpeg are not
> > working.
> > 
> > I double checked, and all the libraries, header files
> > and binaries for GD are in /usr/local/lib, include, bin
> > 
> > All the other libraries are detected fine.
> > 
> > Any ideas? Thanks.
> > 
> > _________________________________________________________________
> > 
> > Trace Pupke                        pupketcofc.edu

attached mail follows:

Hi All, I know I already ask this, but I didn't get an answer! I'm trying to compile PHP4-RC1 with support to IBM DB2. What I already did: - compile with --with-ibm-db2 parameter, works fine! - compile as a cgi interpreter (not as a module), works fine! - compile as apache module (--with-apxs), the apache server dies without error, if I use "gdb httpd" it give me no errors!

My system: RH 6.2 / Kernel 2.2.14 PHP 4.0RC1 DB2 6.1 (Client and SDK) I can access the DB on the AIX host via CLI! Apache 1.3.12 My configure parameters: ./configure --with-config-file-path=/etc/httpd/conf --with-ibm-db2 --enable-safe-mode --with-apxs=/usr/sbin/apxs --enable-magic-quotes --enable-trans-sid --enable-track-vars Anybody already made this work? Will I need to work whit the CGI version when need to access DB2 ?

+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+ | Antonio S. Martins Jr. - System Analist | "Only The Shadow Knows | | WorldNet Internet Maringa - PR - Brasil | what evil lurks in the | | E-Mail: shadowwnet.com.br | Heart of Men!" | | shadowuem.br | !!! Linux User: 52392 !!! | +-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+ This e-mail message is 100% Microsoft free!

/"\ \ / CAMPANHA DA FITA ASCII - CONTRA MAIL HTML X ASCII RIBBON CAMPAIGN - AGAINST HTML MAIL / \

attached mail follows:

I'm a bit apprehensive about posting this to the PHP group, as it may be an apache problem, but I figure if there's anyone that knows how to configure Apache, it's a PHP programmer.

I can't seem to get the $GLOBALS["HTTP_REFERER"] variable to be set.

I've complied in mod_log_referer in apache, I'm using PHP4RC1, using Dynamic Libraries (mod_so complied into apache). I can get both up and running, but when I do php_info, the HTTP_REFERER isn't listed under "HTTP Request Headers." I can look at my referer_log, and see that the referer is being logged at least "some " of the time.

a Sample of the referer_log file is : http://siamese.gator.net/test.php -> /test.php - -> /test.php - -> /test.php

Note: I did have to hack my apxs script, as per the PHP faq, to get apxs to work.

Perhaps my problem is so convoluted that no one could help without seeing my system (RedHat 6.2, latest stable version of Apache), But perhaps someone out there has had the same problem, and it's as simple as showing me your ./configure lines for Apache and PHP.

Thanks in advance, and if this is an incorrectly posted message, please let me know so I won't do it again.

Don Undeen dundeegator.net

attached mail follows:

> I can't seem to get the $GLOBALS["HTTP_REFERER"] variable to be set. > > I've complied in mod_log_referer in apache, I'm using PHP4RC1, using > Dynamic Libraries (mod_so complied into apache). I can get both up and > running, but when I do php_info, the HTTP_REFERER isn't listed under > "HTTP Request Headers." I can look at my referer_log, and see that the > referer is being logged at least "some " of the time.

It's not the mod_log_referer module you need...it's the mod_env module that must be compiled into Apache to pass environment variables to php & cgi scripts.

Sincerely,

Craig Vincent

attached mail follows:

I cannot use str_replace() function. It generates this error

Call to unsupported or undefined function str_replace()

I am using PHP 3.0.5 on debian linux.

Everything works well on my home computer (win98,php3)

What could be wrong?

Thanks

Yegon

attached mail follows:

> -----Original Message----- > From: Martin Dragun [mailto:yegonyegon.sk] > Sent: Monday, April 24, 2000 10:01 AM > To: php3lists.php.net > Subject: [PHP3] str_replace prob > > > I cannot use str_replace() function. It generates this error > Call to unsupported or undefined function str_replace() > I am using PHP 3.0.5 on debian linux. > Everything works well on my home computer (win98,php3) > What could be wrong?

Str_replace() was introduced in PHP 3.0.6. Consider upgrading.

---
Mark Roedel             |  "Blessed is he who has learned to laugh
Systems Programmer      |   at himself, for he shall never cease
LeTourneau University   |   to be entertained."
Longview, Texas, USA    |                           -- John Powell 

attached mail follows:

Hi

I wanted to know what (free) content publishing systems there are, since i need to buy or build one for a customer. Free would be nice, but dollarware is ok too, just need as many options as possible to investigate.

regards,

Maarten Stolte

attached mail follows:

| I read somewhere (on this list I think) that a lot of comments slows down | the scripts but I haven't checked that myself.

It doesn't make any noticeable difference. Although a single comment might be a bit faster (few nanoseconds) than the multi-line comment (/* ... */) (comments checking is done in the lexer).

| | > Try not using functions. | > You will get approximately 30+ % more speed.

This doesn't make much difference.... its an interpreted language, and the only speed loss I can think about is the initialization of another pool to store local variables.

I don't know for sure but I wonder if functions are saved in the form of special tokens which don't need rechecking for syntax once compiled... Zeev?

Thanks.

Faisal

attached mail follows:

Hello yet again,

I'm having to retract some of what I wrote before - well, maybe not retract, but expand.

(FYI, Jorge, the numbers I wrote before were with the optimizer in place).

When I first got the ISAPI module, I wanted to test it out against ASP on the same server, but not rewrite all my scripts to start with, so I wrote some small database loops (select * from, insert into, update, etc.) to run through 1000, 500000 and 1 million times. PHP was beating ASP on every count, sometimes a lot, and sometimes a little. *ONE* test showed PHP slower, one time, out of, perhaps, 80 or so iterations I did during testing.

Based on this, I proceeded to convert part of a project. What I found was that PHP was indeed slower on the same hardware. The problem seems to be that the ISAPI module hits the CPU hard when loading a PHP file - regardless of if there's any PHP in it or not.

With perfmon on, I watch the CPU go up and down. Loading a PHP page causes a hit - this hit varies with how large the file is. A 25 byte file shows a small hit - 2%?. A large file (17k) shows a LARGE hit - 40-50%. Only for a moment, then it's back down, but it's there. 5-10 concurrent hits on semi-large pages can slow things to a crawl momentarily. This is, unfortunately, not acceptable for my client's situation right now. I was hoping that PHP/NT would be a good compromise for us - they've got NT, we have PHP experience. However, given this performance hit right now, we'll have to keep the bulk of this in ASP. There are some smaller scripts that we'll probably convert - things that do a lot of DB admin work, but don't have much HTML in them, and parts that won't get many concurrent hits.

I wanted to publicly state these findings, just as I had the other ones, for anyone interested in running PHP on NT, especially after the great numbers I ran before. It may be excellent for your situation, but evaluate and test first before going live!

Jorge Macias wrote:

> This message was sent from Geocrawler.com by "Jorge Macias" <jmaciasprotel.net.mx> > > It would be great if you do some testing using > the zend optimizer for php ... > > --------------------------------------- > Hello again y`all. > > I`ve done a bit more testing, completely on NT > (sp6) > with ASP against PHP. Both systems were running > on a > single 450mhz with 256 megs, connected via tcp/ip > on > a local network to a dual processor xeon 550 SQL > Server 7 > (NT - sp6) with 1 gig.

<snip>

========================== Michael Kimsal http://www.tapinternet.com 734-480-9961

attached mail follows:

On Mon, 24 Apr 2000, Michael Kimsal wrote:

> Hello yet again, > > I'm having to retract some of what I wrote before - well, > maybe not retract, but expand. > > (FYI, Jorge, the numbers I wrote before were with > the optimizer in place). > > When I first got the ISAPI module, I wanted to test it > out against ASP on the same server, but not rewrite > all my scripts to start with, so I wrote some small > database loops (select * from, insert into, update, > etc.) to run through 1000, 500000 and 1 million times. > PHP was beating ASP on every count, sometimes a lot, > and sometimes a little. *ONE* test showed PHP > slower, one time, out of, perhaps, 80 or so iterations > I did during testing. > > Based on this, I proceeded to convert part of a project. > What I found was that PHP was indeed slower on the > same hardware. The problem seems to be that > the ISAPI module hits the CPU hard when loading a PHP > file - regardless of if there's any PHP in it or not.

I'm not sure I'm understanding what you benchmarked; Undoubtfully, loading a page through PHP (even without any code) is slower than displaying a plain HTML page not through PHP. You're talking about a CPU hit; Is it a performance hit in comparison to what, ASP? Plain HTML?

Zeev

-- 
Zeev Suraski <zeevzend.com>
http://www.zend.com/

attached mail follows:

How to find the End of Table / Records in a table ??.

I need to find out and if it's end of table I just wanted to alert the user with some messages ?.

How to do it ?.

-- K

attached mail follows:

I've got $50 for the first person that resolves my problem. I have a site that used Apache 1.3 with PHP3 as a module and also included pdflib2.01. I then screwed up my apache install and went to rebuild things. Now I cannot get apache to build with the packages I have. I could jump to PHP4 but I need to know if phplib is compatible as I also rely upon it.

If you can tell me the package versions needed and they get me up and running, then you pocket the $50 as a consulting fee. Here is what I attempted to use:

zlib 1.1.3 freetype 2.1.0 jpeg-6b png 1.0.6 tiff 3.4 gd 1.3 pdflib 2.01

configure apache 1.3.12 configure php 3.0.16 build php configure apache for php as a module make <**BOOM** I have no idea where this error comes from.>

gcc -c -I../os/unix -I../include -DLINUX=2 -DUSE_HSREGEX -DUSE_EXPAT -I.. /lib /expat-lite -DNO_DL_NEEDED `../apaci` util.c util.c: In function `ap_find_token': util.c:1368: `test_char_table' undeclared (first use this function) util.c:1368: (Each undeclared identifier is reported only once util.c:1368: for each function it appears in.) util.c:1368: `T_HTTP_TOKEN_STOP' undeclared (first use this function) util.c: In function `ap_escape_shell_cmd': util.c:1427: `test_char_table' undeclared (first use this function) util.c:1427: `T_ESCAPE_SHELL_CMD' undeclared (first use this function) util.c: In function `ap_escape_path_segment': util.c:1554: `test_char_table' undeclared (first use this function) util.c:1554: `T_ESCAPE_PATH_SEGMENT' undeclared (first use this function) util.c: In function `ap_os_escape_path': util.c:1583: `test_char_table' undeclared (first use this function) util.c:1583: `T_OS_ESCAPE_PATH' undeclared (first use this function) make[3]: *** [util.o] Error 1 make[2]: *** [subdirs] Error 1 make[2]: Leaving directory `/usr/src/apache/src' make[1]: *** [build-std] Error 2 make[1]: Leaving directory `/usr/src/apache' make: *** [build] Error 2

____________________________________ www.KeithFord.com ICQ-15705088 info-256.971.9711 cell-256.603.3932 day-800.500.8381 fax-419.858.8833

attached mail follows:

one of the projects I'm working on requires me to check the /etc/passwd file for existing entries. now I can open the file easy enough, but I'm not sure as to how about actually searching the file for specific keywords.

Matrix

attached mail follows:

Hi,

I was wondering if there was something already out there (in terms of code), that lets users setup a My WebPage interface.. i.e. something along the lines of My Netscape or My Yahoo etc..

Thanks..

--
Ashwin
kutty..
Systems Administrator
Dalhousie University Libraries

attached mail follows:

Hi! I have two servers one of which supports PHP, and postgre, and another one I am running my web-site on. I have a small banner-rotator PHP-script on my PHP-enabled server, so the question is "am I able to include the resulting HTML string into the code on the non-PHP enabled server?" without using <iframe> tags, cause not all browsers support those.

Thanks, /*------------------------------------------------------*/ Peter Tatischev: peterthekeeper.com.ru http://www.thekeeper.com.ru

attached mail follows:

I'm just about to finish off a PHP-based shopping cart system that uses a MySQL database to store what the users want to purchase and the details for each order.

One thing I've been wondering:

- am I being unneccessarily paranoid in storing the user's IP address in the database along with their ID number? I've just got visions of users managing to change their ID number and finding out what people have in their carts (as on my application we will be storing peoples mobile phone numbers with each order).

Thanks for help John

attached mail follows:

John Portwin wrote: > > I'm just about to finish off a PHP-based shopping cart system that uses a > MySQL database to store what the users want to purchase and the details for > each order. > > One thing I've been wondering: > > - am I being unneccessarily paranoid in storing the user's IP address in the > database along with their ID number? I've just got visions of users managing > to change their ID number and finding out what people have in their carts > (as on my application we will be storing peoples mobile phone numbers with > each order).

No, but be mindful of three things:

1. Most users IP addresses change when they log off the internet.

2. You should always make them enter in a user id and password if they want to delete or add things to their cart (you can however save this userid and password in a cookie so they don't have to enter it every time they modify their cart).

3. ALWAYS make them re-enter they're credit card number when they try to purchase something.

Sterling

attached mail follows:

I had try all the suggestion for my first mail..... and i'm sure i do nothing wrong with the script my script is

$fd="directory/filename"; $string="the string goes here"; fwrite($fd,$string);

I got this kind of error

Warning: Supplied argument is not a valid File-Handle resource in /hasian/project/test/coba.php on line 5

any more hit on me

Thanks in advance

-Yamin Prabudy-

attached mail follows:

Yamin Prabudy wrote: > > I had try all the suggestion for my first mail..... > and i'm sure i do nothing wrong with the script

Don't be so sure.

> my script is > > $fd="directory/filename"; > $string="the string goes here"; > fwrite($fd,$string); >

Yup it's something wrong with your script.

Correct:

$fd = "directory/filename"; $string = "The string goes here";

$fp = fopen ($fd, "w") or die ("Cannot open file: $fd"); fwrite ($fp, $string); fclose ($fp) or die ("Cannot close file: $fd");

You need to open the file before you write to it. Read the manual.

> I got this kind of error > > Warning: Supplied argument is not a valid File-Handle resource in > /hasian/project/test/coba.php on line 5 >

Which is the correct error. > any more hit on me >

Sterling

attached mail follows:

$fd = "directory/filename" ; $string = "the string goes here" ;

$fp = fopen( $fd , 'a' ) ; fwrite( $fp , $string ) ;

IIRC someone told you you had to fopen the file first.

At 06:28 25.4.2000 +0700, Yamin Prabudy wrote the following: -------------------------------------------------------------- >I had try all the suggestion for my first mail..... >and i'm sure i do nothing wrong with the script >my script is > > >$fd="directory/filename"; >$string="the string goes here"; >fwrite($fd,$string); > >I got this kind of error > >Warning: Supplied argument is not a valid File-Handle resource in >/hasian/project/test/coba.php on line 5 > >any more hit on me > >Thanks in advance > >-Yamin Prabudy- > >-- >PHP 3 Mailing List <http://www.php.net/> >To unsubscribe, send an empty message to php3-unsubscribelists.php.net >To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net >To search the mailing list archive, go to: http://www.php.net/mailsearch.php3 >To contact the list administrators, e-mail: php-list-adminlists.php.net ------end of quote------

____________________________________________________________ Cynic:

A member of a group of ancient Greek philosophers who taught that virtue constitutes happiness and that self control is the essential part of virtue.

cynicmail.cz ICQ: 2808 2505

attached mail follows:

At 06:28 AM 4/25/00 +0700, Yamin Prabudy wrote: >I had try all the suggestion for my first mail..... >and i'm sure i do nothing wrong with the script >my script is > > >$fd="directory/filename"; >$string="the string goes here"; >fwrite($fd,$string);

Yamin,

The $fd in fwrite must be a file stream pointer that has been returned by fopen, fsockopen or popen.

$fp = fopen ('file.name', 'w'); fwrite ($fp, 'this is a test'); fclose ($fp);

Zak

attached mail follows:

Has anybody seen a script that allows for more than one file to be uploaded but using only one submit button?

I have been trying painfully to pull that one off.

Sincerely,

Jay Lepore Cox Enterprises TrackerOnline 1-800-543-8085 Ext#205 mailto:Jay.Leporetrackeronline.com

attached mail follows:

This is an old DOS word processor that can not be bought anymore. My grandfather uses it on an old 286, and the first.dat file was accidentally deleted. I had the disks, but after all these years, they are dead. I really need the entire program as there were so many versions of FC and the first.dat file is different between versions.

I looked into getting him a newer "better" computer, but there are problems with new OSs, including Linux, that prevent moving him off DOS. Non-computer users tend to just turn the computer off a lot, and tend not to like taking more than 4 seconds to boot up. Also, for elderly, the mouse can prove to be impossible to use because of reduced coordination.

I used this Tandy 286 for several hours this weekend. It is amazing how usable they still are, after 12years. I love Prince of Persia.

• Next message: php3-digest-helplists.php.net: "php3 Digest 25 Apr 2000 04:57:40 -0000 Issue 1628"
• Previous message: php3-digest-helplists.php.net: "php3 Digest 24 Apr 2000 04:57:44 -0000 Issue 1626"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]