NEOHAPSIS - Peace of Mind Through Integrity and Insight

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com

Neohapsis > Archives > PHP Discussion Digest> 2001-03

From: php-general-digest-helplists.php.net
Date: Tue Mar 13 2001 - 19:55:58 CST

Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

php-general Digest 14 Mar 2001 01:55:58 -0000 Issue 565

Topics (messages 43660 through 43753):

Re: Good Free PHP Editor?
        43660 by: John Meyer
        43661 by: Knotek Vlastimil
        43684 by: Dennis Gearon

Re: Quotes in inputfields & Reload
43662 by: Jens Nedal

Re: Oracle error messages
43663 by: Greig, Euan
43674 by: Rudolf Visagie

Employment Opportunities - UK based.
43664 by: Paul Tweedy

include() from one server to another server
43665 by: Scott Fletcher
43668 by: Chris Lee

Re: Detect if user has changed form data
43666 by: PHPBeginner.com

Re: Variable variables
43667 by: PHPBeginner.com

PHP | MySQL Search
43669 by: Andre \"Tuin\" Boontjes
43698 by: David Bouw

Re: update two frames at once?
43670 by: Paul

Re: TXT files
43671 by: Rick St Jean

Re: $HTTP_POST_VARS
43672 by: David Minor

Web Page/MySql
        43673 by: Mike
        43676 by: Fredrik Wahlberg
        43679 by: Chris Lee

Naming cookies
43675 by: Tristan.Pretty.risk.sungard.com

Re: Two Way Encryption
43677 by: Chris Adams

PHP.Net India
43678 by: Mukul Sabharwal

Getting path of script
        43680 by: Jordan Elver
        43689 by: Hardy Merrill
        43691 by: Pierre-Yves Lemaire
        43707 by: Jordan Elver

Changing Directory rights with chgrp or exec("chown")
43681 by: Dominique Paquin

RE:Two Way Encryption
43682 by: Dennis Gearon

DICKHEAD multi level marketers
43683 by: Dennis Gearon
43687 by: Ashley M. Kirchner

Upload user account
43685 by: Lasse Laurila
43726 by: Henrik Hansen

Oracle Fulltext indices?
43686 by: Jens Kisters

Re: Cache Database-driven site
43688 by: Joe Maier

PHPDoc and file with function only
43690 by: Remi Ricard

selected option values not being captured by form processing software
43692 by: Nicole Lallande
43694 by: Chris Lee

searching over static pages...
43693 by: Marcos

Payflow Pro
        43695 by: Dan Harrington
        43699 by: John Donagher
        43700 by: Robert Covell
        43701 by: Robert Covell
        43702 by: Dan Harrington
        43703 by: Robert Covell
        43704 by: John Donagher
        43705 by: Robert Covell
        43721 by: Dan Harrington
        43724 by: Rick St Jean
        43727 by: Robert Covell

[?] Call a function with a button/link click?
43696 by: John Voth

Getting location bar and stripping file-ending of a string..
43697 by: Aviv Revach
43716 by: CC Zona

Mysql Show SQL
43706 by: Mike

write form data to a text file
        43708 by: Jerry Lake
        43709 by: Jerry Lake
        43710 by: Christian Joergensen

Seeking for files ending with '.txt' ..
        43711 by: Aviv Revach
        43712 by: Christian Joergensen
        43723 by: Henrik Hansen

Maintaining Session State Across Clusters
        43713 by: Martin Cameron
        43714 by: Michael Kimsal
        43715 by: Hardy Merrill

Session problem
43717 by: Brandon Orther
43719 by: Jack Dempsey

Session abuse?
43718 by: Soma Interesting

fputs?
43720 by: enthalpy
43725 by: enthalpy

attach file from server to an email
43722 by: Jerry Lake

Getting name of the main file from external included script..
43728 by: Aviv Revach
43736 by: Johnson, Kirk

Server side maps
43729 by: Kevin Williams

replacing a line in a file
        43730 by: enthalpy
        43732 by: Aviv Revach
        43733 by: Henrik Hansen
        43737 by: enthalpy

need some help..
        43731 by: PeterOblivion.aol.com
        43735 by: Rick St Jean
        43740 by: Brandon Orther

Re: [Q] session variables wouldn't keep contents.
43734 by: Chung Ha-Nyung
43743 by: Chung Ha-Nyung

Finding existence of a value in a table
        43738 by: Dennis Gearon
        43739 by: CC Zona
        43741 by: Michael Kimsal

error on connect
43742 by: Peter Houchin

phpize ??
43744 by: Pierre-Yves Lemaire

PHP and Oracle Zombie processes
43745 by: Bob Kakalec

tutorials on good database design
        43746 by: Justin French
        43747 by: Jeff Oien
        43748 by: Michael Kimsal
        43749 by: Jack Dempsey
        43750 by: Philip Hallstrom
        43751 by: Jason Murray
        43752 by: Rick St Jean
        43753 by: web100.co.uk

Administrivia:

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

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

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

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

attached mail follows:

Actually, I picked up htmlkit when it was mentioned in this group and it's
just as good as Visual InterDev, in my opinion.

-----Original Message-----
From: Jens Nedal [mailto:jnedalostry.com]
Sent: Tuesday, March 13, 2001 6:58 AM
To: Angerer, Chad; 'Simon Garner'; Boget, Chris;
php-generallists.php.net
Subject: Re: [PHP] Good Free PHP Editor?

About good editors with FTP inbuilt on the Windows side. Most of the FTP
features are crap! Completly. The only Editor i know that works good with
its inbilt FTP feature is BBEdit, but that again is another platform.

BUT if you want a good combination on Windows side you could use Ultraedit
and FTP-Netdrive. That programm maps FTP-Host to your Explorer and does all
teh upload etc. So you just open and write and thats it. No messing around.

regards, Jens

on 12.03.2001 21:48 Uhr, Angerer, Chad at cangereribsys.com wrote:

> Yes I use it with NT and run into occasional memory management problems as
> well. It is a great editor but has small issues that really can annoy a
> person. Also the FTP engine blows. It can be most unpredictable.
>
> Chad
>
> -----Original Message-----
> From: Simon Garner [mailto:sgarnerexpio.co.nz]
> Sent: Monday, March 12, 2001 2:43 PM
> To: Boget, Chris; php-generallists.php.net
> Subject: Re: [PHP] Good Free PHP Editor?
>
>
> From: "Boget, Chris" <Chris.Bogetwild.net>
>
>>> HomeSite is great. www.allaire.com
>>> - not totally free I'm afraid, but there is an eval version.
>>> - runs under Windows yes
>>> - supports syntax highlighting for lots of languages
>>> including HTML, PHP,
>>> Perl, SQL, ASP (VB/JS).
>>> - can edit multiple files yes
>>> - shows line numbers in gutter on left hand side
>>> - supports regular-expression based search & replace across multiple
>>> files/directories
>>> - nice interface.
>>
>> Has the worst memory management of any software I've ever used.
>> I have to reboot at lest 10 times a day when I use it. The support
>> forum on their site is filled with complaints on this issue. Their
> response
>> to this issue was not to fix the memory leak (or whatever it is) but to
>> issue a warning when resources are getting dangerously low to give
>> you the opportunity to save all your work before you reboot. Beyond
>> that, their stance is "Well, if you don't like it, return it and we'll
> give
>> you a refund".
>> If this wasn't the only piece of software that handled projects the way
>> we needed, we'd have thrown out this piece of garbage software a *long*
>> time ago.
>>
>> Chris
>>
>
>
>
> Running under Win2K I can have HomeSite 4.5.1 open for weeks, working on
10+
> files, without any problems whatsoever.
>
> However, I used to run it under Win98 and it would crash 1-2 times per
> day...
>
>
> Regards
>
> Simon Garner
>

-- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribe

lists.php.net For additional commands, e-mail: php-general-help

lists.php.net To contact the list administrators, e-mail: php-list-admin

lists.php.net

attached mail follows:

If you are running under Windows, try HTML-Kit. It's free, and so powerfull. At the following page you can download editor, and a lot of plugins, inlcluding PHP one. http://www.chami.com/html-kit/ <http://www.chami.com/html-kit/>

attached mail follows:

I have tried many editors on windblows for php.

UltraEdit-32 is good, but it doesn't show the whole filename, just the msdos version of the filename. Hard to hunt for files that have same name almost.

So I didn't bother with it after that.

I use EditPlus-2. Has built in FTP. Almost beyond complaint, except it won't let you 'save as' to a different remote file name if the file is already a remote file. Other than that, works fine.

It's only 39.00. If you want do download it every 3 days, no problem.

Did I forget to mention that Ultra-32 puts values in your registry that prevent you from reusing a new or old copy of the demo download? They didn't put much time into the naming of these 'trigger' variables, so you can't find them and remove them, but probably not after I post this :-)

attached mail follows:

Ah yeah, thx everybody

That does it and i am a littel pissed since i can go over alllooott of code now to insert that. BATCH here i come!

Jens

on 12.03.2001 17:49 Uhr, PHPBeginner.com at php-generalphpbeginner.com wrote:

> hi Jens, > > PHP automatically escape the dangerous characters from the user input on > form submissions. > > there are several ways to escape that back : > > stripslashes() > urlencode() > htmlentities() > > read about these, they will soon become your solutions. > > > > Sincerely, > > Maxim Maletsky > Founder, Chief Developer > > PHPBeginner.com (Where PHP Begins) > maximphpbeginner.com > www.phpbeginner.com > > > > > -----Original Message----- > From: Jens Nedal [mailto:jnedalostry.com] > Sent: Monday, March 12, 2001 7:24 PM > To: php-generallists.php.net > Subject: [PHP] Quotes in inputfields & Reload > > > Hy everybody, > > Well here is the deal (Probably an easy one 8)) > I have several inputfields and check if the are valid or have content. > If an error occurs and the page reloads i simply echo the content of the > fields back into the input fields, viola, wonderful. > > BUT if there are " eg. Quotes in those fields they suddenly read \" instead > of " as they should 8( > > I guess that the parser is doing something to it there since " is a > sensitive char in php. BUT how can i get the content to be reloaded > correctly into the fields again. > > Here an example of how those fields look like > > <input type=text name=v_email value="<?php echo($v_email); ?>" size=40> > > tried it like this too, no difference: > <input type=text name=v_email value="<?php echo("$v_email"); ?>" size=40> > > > thx in advance, Jens Nedal > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribelists.php.net > For additional commands, e-mail: php-general-helplists.php.net > To contact the list administrators, e-mail: php-list-adminlists.php.net > >

attached mail follows:

To suppress the error messages on a single command, you can put an in front of it, eg: $conn=ora_plogon(...

-----Original Message----- From: Hardy Merrill [mailto:merrillmissioncriticallinux.com] Sent: 13 March 2001 13:43 To: Rudolf Visagie Cc: php-generallists.php.net Subject: Re: [PHP] Oracle error messages

Rudolf Visagie [Rudolfqedi.co.za] wrote: > Hi All, > > Does anybody have an idea how to stop the automatic error and warning > messages from the Oracle data base being displayed on the screen. I want to > do my own error message display but by the time I get the error message > using OCIError it was already displayed on the screen anyway.

In your php.ini file, you want to set "display_errors = Off", and "log_errors = On".

> > Rudolf Visagie > rudolfqedi.co.za > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribelists.php.net > For additional commands, e-mail: php-general-helplists.php.net > To contact the list administrators, e-mail: php-list-adminlists.php.net

-- Hardy Merrill Mission Critical Linux, Inc. http://www.missioncriticallinux.com

************************************************************************** Any opinions expressed in this email are those of the individual and not necessarily the Company. This email and any files transmitted with it, including replies and forwarded copies (which may contain alterations) subsequently transmitted from the Company, are confidential and solely for the use of the intended recipient. If you are not the intended recipient or the person responsible for delivering to the intended recipient, be advised that you have received this email in error and that any use is strictly prohibited.

**************************************************************************

attached mail follows:

Thanks guys,

In the meantime I also discovered that setting the error reporting level works, e.g. in

// redefine the user error constants define (FATAL,E_USER_ERROR); define (ERROR,E_USER_WARNING); define (WARNING,E_USER_NOTICE); // set the error reporting level for this script error_reporting (FATAL | ERROR | WARNING);

the errors are not displayed and can be handled with my own error handler. The user errors would be PHP generated errors and any other errors (in other words not FATAL, ERROR or WARNING) are Oracle database errors.

Rudolf Visagie rudolfqedi.co.za

-----Original Message----- From: Greig, Euan [mailto:Euan.Greigbrann.com] Sent: 13 March 2001 04:25 To: Hardy Merrill; Rudolf Visagie Cc: php-generallists.php.net Subject: RE: [PHP] Oracle error messages

To suppress the error messages on a single command, you can put an in front of it, eg: $conn=ora_plogon(...

In your php.ini file, you want to set "display_errors = Off", and "log_errors = On".

-- Hardy Merrill Mission Critical Linux, Inc. http://www.missioncriticallinux.com

**************************************************************************

attached mail follows:

My apologies for using the list, but it's the best way to contact the PHP community.

We are a successful web agency based in the UK and are looking for talented html and technical developers.

Our company 5e, has progressed from two to almost twenty people over the last couple of years, working with an excellent client list with well known brands. We utilise a variety of platforms for development, including an increasing emphasis on Linux/PHP/MySQL to deliver high-profile web applications.

Due to continued expansion, we are now looking for in-house permanent html-ers and technical developers (sorry freelance not possible). We have excellent facilities, the latest kit and have eventful after-hours socials. You may even get the opportunity to write for internet magazines when they ask us to review web sites!

Your core skills will include PHP/Perl, MySQL (or a similar RDBMS), Apache configuration, and a general enthusiasm for Linux and open-source software. Knowledge of other languages and platforms (Lasso, Win2K, MacOS) is also an advantage.

Take a look at our site <http://www.5emedia.net> to see what we're up to. If you think you fit the bill, we'd love to hear from you - email us at <recruitment5emedia.net>.

Best regards,

Paul Tweedy 5emedia Limited

The web development team that walked away with two (count 'em, TWO) BT eBusiness Innovation Awards! __________________________________________________ Bedford Heights - Manton Lane - Bedford - MK40 7PA

Tel: 01234 402500 (International: +44 1234 402500) Fax: 01234 244541

Email: pault5emedia.net www: http://www.5emedia.net _______________________________________________________ internet sites - ecommerce - screensavers - multimedia

DISCLAIMER

The opinions expressed in this email are not necessarily the opinion of 5emedia Limited.

The content of this e-mail contains proprietary information which is confidential and may be legally privileged. It is for the intended recipient only. If an addressing or transmission error has misdirected this email, please notify the author by replying to this email and informing them of this matter as soon as possible. If you are not the intended recipient you must not use, disclose, distribute, copy, print or rely in any way on the information in this email. In addition, you must erase all of the information contained in this email immediately after notifying the author.

attached mail follows:

Hi!

I tried to use the php code, "include()" to have the ghost server to point to the file in the origial server. And I got the error message instead.

>Warning: Failed opening 'https://www.whatever.com/DBconn.ini' for inclusion >(include_path='.:/usr/local/lib/php.ini') in >/home/website/ghost_ecbi/secure/ecbi_index.php on line 15

The URL address point to the original server. The include_path="/usr/local/lib/php.ini" refer to the path in the ghost server. From the look of it, I get the impression that the PHP code, include() is not the correct function to use. Is there any other way?

Thanks, Scott

attached mail follows:

include_once can handel http connection if

--disable-url-fopen-wrapper

is not compiled intophp or

allow_url_fopen = off

in php.ini

then you can use http, not https though, secure connections are not supported. also not that when using include() this way that the script is accually executed on the other side, not accually included. ie.

include_file.php <?php echo "hello"; $test = 'chris lee'; ?>

index.php <?php include_once(http://$SERVER_NAME/include_file.php); ?>

this will echo

hello

and $test will not be avalible to index.php

include() work very differnert depending on how it is used.

Chris Lee Mediawaveonline.com

ph. 250.377.1095 ph. 250.376.2690 fx. 250.554.1120

leemediawaveonline.com

""Scott Fletcher"" <scottabcoa.com> wrote in message news:98lcdl$89d$1toye.p.sourceforge.net... Hi!

I tried to use the php code, "include()" to have the ghost server to point to the file in the origial server. And I got the error message instead.

>Warning: Failed opening 'https://www.whatever.com/DBconn.ini' for inclusion >(include_path='.:/usr/local/lib/php.ini') in >/home/website/ghost_ecbi/secure/ecbi_index.php on line 15

Thanks, Scott

-- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribelists.php.net For additional commands, e-mail: php-general-helplists.php.net To contact the list administrators, e-mail: php-list-adminlists.php.net

attached mail follows:

no,

the JavaScript is the only way to do that.

When you close your browser JavaScript is what can do a check, PHP does nothing - it's not in your browser - it's on the server.

Plus, with JavaScript this kind of things are much cooler.

Sincerely,

Maxim Maletsky Founder, Chief Developer

PHPBeginner.com (Where PHP Begins) maximphpbeginner.com www.phpbeginner.com

-----Original Message----- From: Ide, Jim [mailto:jidelgb-inc.com] Sent: Tuesday, March 13, 2001 10:15 PM To: 'php-generallists.php.net' Subject: [PHP] Detect if user has changed form data

Is there an easy way to detect if a user has changed the values in the fields of an HTML form? I want to be able to check this during the onUnload event and warn the user that he/she has not clicked the "Save" button to save changes to the form fields.

The only way I can see to do this is to use JavaScript to loop thru the variables and compare the current (possibly changed) value to the value in the defaultValue property. I'm hoping that there is a "UserHasChangedFormVariables" property (or something similar) that I don't know about that someone will tell me about :)

A pointer to existing code that does this would be appreciated.

Many thanks - Jim

-- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribe

lists.php.net For additional commands, e-mail: php-general-help

lists.php.net To contact the list administrators, e-mail: php-list-admin

lists.php.net

attached mail follows:

Hey, there are also arrays,

these can do much more and can be used most of the times you think of var-var solution...

Sincerely,

Maxim Maletsky Founder, Chief Developer

PHPBeginner.com (Where PHP Begins) maximphpbeginner.com www.phpbeginner.com

-----Original Message----- From: John Meyer [mailto:john_meyergeocities.com] Sent: Tuesday, March 13, 2001 10:47 PM To: Jason Stechschulte Cc: php-generallists.php.net Subject: RE: [PHP] Variable variables

Okay, that makes a little sense, but isn't there some sort of collection that will do the same thing (coming from vb).

-----Original Message----- From: Jason Stechschulte [mailto:jpstechunoh.edu] Sent: Tuesday, March 13, 2001 6:38 AM To: John Meyer Cc: php-generallists.php.net Subject: Re: [PHP] Variable variables

On Tue, Mar 13, 2001 at 06:36:10AM -0700, John Meyer wrote: > Okay, I read about this feature in the php manual. What I can't figure out > is why in the world would anybody want to use this feature? Not to start a > flame war, just would like an explanation of why this feature is useful.

I've really only used them once, but they were handy for that situation. I had a column in a mysql table that was a set column of user privileges, and I wanted to register every value in the set as a session variable.

-- Jason Stechschulte jpstech

unoh.edu -- I surely do hope that's a syntax error. -- Larry Wall in <199710011752.KAA21624

wall.org>

attached mail follows:

Hya'll,

I've got a little problem with coding some php/mysql, this is what I have :

--------------------------------------------------------------------- Table Search --------------------------------------------------------------------- HouseID | FacilityID | SurroundingID | PriceID | TypeID | CountryID | --------------------------------------------------------------------- 1 | 1 | 0 | 3 | 4 | 2 | 1 | 3 | 0 | 3 | 4 | 2 | 1 | 5 | 0 | 3 | 4 | 2 | 1 | 0 | 3 | 3 | 4 | 2 | 2 | 0 | 0 | 3 | 5 | 2 | 2 | 0 | 1 | 3 | 5 | 2 | 2 | 5 | 0 | 3 | 5 | 2 | ---------------------------------------------------------------------

Query 1 :

(I only want result on houses which are in country 2 and in price 3 and facility 1 must be included on the spot)

I've used : SELECT HouseID FROM Search WHERE CountryID='2' AND PriceID='3' AND (FacilityID='5')

Result 1 :

HouseID 1 and HouseID 2 this one is right.

Query 2 :

(I only want result on houses which are in country 2 and in price 3 and facility 1 and 5 must be included on the spot)

I've used : SELECT HouseID FROM Search WHERE CountryID='2' AND PriceID='3' AND (FacilityID='1' OR FacilityID='5')

Result 2 :

again HouseID 1 and HouseID 2, the problem here is that HouseID 2 doesn't contain Facility 1.

The problem here is just that when I give more criteria to the query the result is or equal or even bigger then when I give less criteria, it should be just the other way around, that is I want a more detailed result, does anyone have the solution for this problem ?

A. Boontjes aka Tuin (TuinTomDeeDom.com) Web-developer at : www.TomDeeDom.com & www.Impression.nl

-- Hi! I'm a .signature virus! Copy me into your ~/.signature to help me spread! --

attached mail follows:

Hi there..

Try:

SELECT HouseID FROM Search WHERE (CountryID='2' AND PriceID='3' OR (FacilityID='1' OR FacilityID='5'))

The extra brackets are only to make it easier to read.. (For me it is..)

What you basically asked where all records in which CountryID is 2 and PriceID is 3 AND (only) where the facilityID is 1 or 5.. But you want everything with CountryID is 2 and PriceID is 3 OR when the facilityID is 1 or 5

Hope this helps..

Bye Bye David

> Hya'll, > > I've got a little problem with coding some php/mysql, this is what I have : > > --------------------------------------------------------------------- > Table Search > --------------------------------------------------------------------- > HouseID | FacilityID | SurroundingID | PriceID | TypeID | CountryID | > --------------------------------------------------------------------- > 1 | 1 | 0 | 3 | 4 | 2 | > 1 | 3 | 0 | 3 | 4 | 2 | > 1 | 5 | 0 | 3 | 4 | 2 | > 1 | 0 | 3 | 3 | 4 | 2 | > 2 | 0 | 0 | 3 | 5 | 2 | > 2 | 0 | 1 | 3 | 5 | 2 | > 2 | 5 | 0 | 3 | 5 | 2 | > --------------------------------------------------------------------- > > Query 1 : > > (I only want result on houses which are in country 2 and in price 3 and > facility 1 must be included on the spot) > > I've used : > > SELECT HouseID FROM Search WHERE CountryID='2' AND PriceID='3' AND > (FacilityID='5') > > Result 1 : > > HouseID 1 and HouseID 2 this one is right. > > Query 2 : > > (I only want result on houses which are in country 2 and in price 3 and > facility 1 and 5 must be included on the spot) > > I've used : > > SELECT HouseID FROM Search WHERE CountryID='2' AND PriceID='3' AND > (FacilityID='1' OR FacilityID='5') > > Result 2 : > > again HouseID 1 and HouseID 2, the problem here is that HouseID 2 doesn't > contain Facility 1. > > The problem here is just that when I give more criteria to the query the > result is or equal or even bigger then when I give less criteria, it should > be just the other way around, that is I want a more detailed result, does > anyone have the solution for this problem ? > > > A. Boontjes aka Tuin (TuinTomDeeDom.com) > Web-developer at : www.TomDeeDom.com & www.Impression.nl > > -- > Hi! I'm a .signature virus! Copy me into your ~/.signature to help me > spread! > -- > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribelists.php.net > For additional commands, e-mail: php-general-helplists.php.net > To contact the list administrators, e-mail: php-list-adminlists.php.net > >

attached mail follows:

This may work, but it defeats the purpose of frames, which is to reduce reloading time. You would need to point to the frameset page, and have variables passed into each frame:

<html> <head> <title>(your title)</title> </head> <frameset rows="45%,55%" frameborder="NO" border="0" framespacing="0" cols="*" > <?echo ' <frame name="topFrame" scrolling="NO" name="top" src="master_title.php?put_your parameters_here='.$blablabla.' ">  ?> </frameset> </body> </html>

> > Hello al! > > > > > > Is it possible to have two frames updated when cliking on one link? I > > have > > > a > > > page that is broken into 4 parts: > > > master title > > > section title > > > d section screen > > > i > > > r > > > . > > > > > > what I want is that when a link is clicked on in the directory (the left > > > column), I'd like to update the section title *and* the section screen... > > > > > > It seemed a cool layout at the time, but I'm thinking this isn't easily > > > possible and I might just have to incorporate a section title on the > > section > > > screen... But before I rewrite it, I thought I'd ask here.

attached mail follows:

include() require() readfile

or fopen the file and use fgets to read.

Rick

At 07:41 AM 3/13/01 -0300, Bruno Freire wrote: >Hey Everybody! >Its me...Bruno From Brazil. > >Look, >How can i read txt files with php???? > >Thanks!!!! >See ya!

########################################################## # Rick St Jean, # rstjeaninternet.look.ca # President of Design Shark, # http://www.designshark.com/ # Quick Contact: http://www.designshark.com/messaging.ihtml # Tel: 905-684-2952 ##########################################################

attached mail follows:

I am having a similar problem as the original poster. In my case, I _want_ the second sumbission to overwrite the first, but it's not happening. What I have is a radio button list all named="update" each with it's own value (ie. 2,3,4,5,etc.). The form is self-submitting and tests on 'update' to know how to proceed. What I'm experiencing is that after the first submission, printing out '$HTTP_POST_VARS' array gives the correct update value. Subsequent submissions also show this same value no matter what value is selected in the form.

I've tried using 'unset($HTTP_POST_VARS[update]);' at the end of the script after the var has been used and reprintingg the HTTP_POST_VARS array which shows that it was unset, but on resubmission of the form, it reappears!

losing hair, David Minor

on 3/8/01 5:45 PM, php-general-digest-helplists.php.net at php-general-digest-helplists.php.net wrote:

> Explained here: > http://www.php.net/manual/en/language.variables.external.php > > Basically name the variables with []. For example: > > <input type=text name="Name[]"> > > In your example, the second is actually overwriting the first. > > > Nate > > -----Original Message----- > From: mat t [mailto:matremail.net] > Sent: Thursday, March 08, 2001 3:10 PM > To: php-generallists.php.net > Subject: [PHP] $HTTP_POST_VARS > > > Please can you help: > > I can't send duplicate input types to $HTTP_POST_VARS > For example: > ---------------HTML------------------- > First person: > > NAME <input type="text" name="Name" size="24" value=""> > <input name="Name_type" type="hidden" value="textbox"> > > Phone No.<input type="text" name="Phone" size="24" value=""> > <input name="Phone_type" type="hidden" value="textbox"> > > Second Person: > > NAME <input type="text" name="Name" size="24" value=""> > <input name="Name_type" type="hidden" value="textbox"> > > Phone No.<input type="text" name="Phone" size="24" value=""> > <input name="Phone_type" type="hidden" value="textbox"> > > ------------------------------------------------------- > > Then when I use : > > reset ($HTTP_POST_VARS); > while (list ($key, $val) = each ($HTTP_POST_VARS)) > { > echo "$key => $val<br>\n"; > } > > Here is the output > > ----------------Output-------------------------- > > Name => > Name_type => textbox > Phone => > Phone_type => textbox > > ------------------------------------------------ > > What happened to the Second person? > How can I stop it ignoring duplicates and insert in the array 1 by 1? >

attached mail follows:

I have a Mysql Database on a web site.On very large record retrieval I want to split the recorset so there is "Page 1, Page 2...."links at the bottom.This is the only part I dont have.Any Suggestions?

Thank Mike P mpelosoprinceton.edu

attached mail follows:

Read this (http://www.phpbuilder.com/columns/rod20000221.php3) article over at phpbuilder which covers exactly that.

/Fredrik

>>>>>>>>>>>>>>>>>> Ursprungligt meddelande <<<<<<<<<<<<<<<<<<

Mike <mpelosoprinceton.edu> skrev 2001-03-13, kl. 16:52:00 angående ämnet [PHP] Web Page/MySql:

> I have a Mysql Database on a web site.On very large record retrieval I want > to split the recorset so there is "Page 1, Page 2...."links at the > bottom.This is the only part I dont have.Any Suggestions?

> Thank > Mike P > mpelosoprinceton.edu

> -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribelists.php.net > For additional commands, e-mail: php-general-helplists.php.net > To contact the list administrators, e-mail: php-list-adminlists.php.net

attached mail follows:

simple example

<?php

$database_db = 'bookmarks'; include_once('database_class.egn');

$HOW_MANY = 10;

if (!isset($pos)) $pos = 0;

$pos_prev = $pos - $HOW_MANY; $pos_next = $pos + $HOW_MANY;

$product_count = $database->count('site', '');

$result = $database->select_array('', 'site', "LIMIT $pos, $HOW_MANY"); foreach($result as $pos => $val) echo $val['site_address'] ."<br>\n";

if ($pos_prev >= 0) echo " <a href='$PHP_SELF?pos=$pos_prev'>Back</a> ";

echo " <a href='$PHP_SELF?pos=0'>Home</a> ";

if ( $pos_next < $product_count ) echo " <a href='$PHP_SELF?pos=$pos_next'>Next</a> ";

""Mike"" <mpelosoprinceton.edu> wrote in message news:98lff3$4ec$1toye.p.sourceforge.net... I have a Mysql Database on a web site.On very large record retrieval I want to split the recorset so there is "Page 1, Page 2...."links at the bottom.This is the only part I dont have.Any Suggestions?

Thank Mike P mpelosoprinceton.edu

-- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribe

lists.php.net For additional commands, e-mail: php-general-help

lists.php.net To contact the list administrators, e-mail: php-list-admin

lists.php.net

attached mail follows:

Afternoon guys and girls I have a queston regarding cookies...

I have a login form that takes the member name and password from a MySQL Database.

I have three fields: member pw userlevel

I want to set a cokkie to remember the user and thier user level, so I named the cookie - authlevel$userlevel --- as I have three levels of security access, I opted for a dynamic cookie name,that changed depending on thier userlevel.

Can I include a variable in the cookie name? I am having probs getting this to work correctly, and this is my first guess as to why it isn't working.

I have included two codes, the first is my login script, and the second is on my secure pages above the head tag.

If anyone can spot my error, I'll gladly furnish them with a beer and a toblerone.

Thanks in advance, Tris...

====================================

<PRE>

if ((!$member) || (!$pw)) { header("Location: http://www.mysite.com"); exit; }

$db_name = "my_database"; $table_name = "userlist";

$connection = mysql_connect("my_database_host", "my_username", "my_password") or die("Couldn't connect.");

$db = mysql_select_db($db_name, $connection) or die("Couldn't select database.");

$sql = "SELECT * FROM $table_name WHERE member = \"$member\" AND pw = \"$pw\" ";

$result = mysql_query($sql) or die ("Can't execute query.");

while($row = mysql_fetch_array($result)) { $userlevel = $row['userlevel']; $member = $row['member']; $pw = $row['pw']; }

$num = mysql_numrows($result);

if (($num != 0) && ($userlevel = '1') || ($userlevel = '2') || ($userlevel = '3')) {

$cookie_name = "authlevel$userlevel"; $cookie_value = "ok"; $cookie_expire = ""; $cookie_domain =""; setcookie($cookie_name, $cookie_value, $cookie_expire, "/", $cookie_domain, 0);

$display_block ="

<p><B>You are now logged into STN Treasury</b><BR>You are logged in under the mail address, <B>$member</B>, you can now access the site as per your assigned access level <B>$userlevel</B>.<P><a href=\"secreta.php\">Link to level 1</A><BR><a href=\"secretb.php\">Link to level 2</A><BR><a href=\"secretc.php\">Link to level 3</A> ";

} else {

header("Location: http://www.mysite.com"); exit; }

==================================

if (($authlevel1 =="ok") || ($authlevel2 =="ok") || ($authlevel3 =="ok")) {

$msg ="<P>Hello, and welcome to level 1 of the secret test area...";

} else { header( "location:http://www.mysite.com"); exit; }

</PRE>

=======================================

********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager.

This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses.

**********************************************************************

attached mail follows:

On 13 Mar 2001 03:40:30 -0800, Joe Njeru <joenjerugatewayonline.co.ke> wrote: >I'm looking for a two way encryption function that I can use to encrypt a >cookie value. I have had experience with MD5 but its one way. Is there one I >can use with a key in php?

Check out the mcrypt extension for conventional cryptography. If you need public key encryption, someone produced an extension which uses OpenSSL not all that long ago.

attached mail follows:

Hi,

Well this is the second time I've made such an announcement. I was wondering if some individuals or groups would be interested in mirroring PHP.net for indian programmers, so that downloads are faster ?

If not a complete mirror, atleast manuals, and binaries, and tars.

thanks, www.devhome.net

===== To find out more about me : http://www.geocities.com/mimodit My bookmarks are available http://mukul.free.fr

__________________________________________________ Do You Yahoo!? Yahoo! Auctions - Buy the things you want at great prices. http://auctions.yahoo.com/

attached mail follows:

Hi, I want to get the path of a script. I know about HTTP_SERVER_VARS["SCRIPT_FILENAME"] this returns someting like:

/phpcode/misc/phpinfo.php

But I want to strip off the file name and just have the directory path, like:

/phpcode/misc/

Any ideas?

Jord

attached mail follows:

How 'bout using a Perl regex with $HTTP_SERVER_VARS["SCRIPT_NAME"] like this:

echo "Starting with SCRIPT_NAME=[" . $HTTP_SERVER_VARS["SCRIPT_NAME"] . "]<BR>"; if (preg_match("/(\S+)\/\S+$/", $HTTP_SERVER_VARS["SCRIPT_NAME"], $matches)) { echo "Found $matches[1]<br>"; }

HTH.

-- 
Hardy Merrill
Mission Critical Linux, Inc.
http://www.missioncriticallinux.com
Jordan Elver [jjelverworldsites.net] wrote:
> Hi,
> I want to get the path of a script. I know about 
> HTTP_SERVER_VARS["SCRIPT_FILENAME"] this returns someting like: 
> 
> /phpcode/misc/phpinfo.php
> 
> But I want to strip off the file name and just have the directory path, like:
> 
> /phpcode/misc/
> 
> Any ideas?
> 
> Jord
> 
> -- 
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-general-unsubscribelists.php.net
> For additional commands, e-mail: php-general-helplists.php.net
> To contact the list administrators, e-mail: php-list-adminlists.php.net

attached mail follows:

check out, dirname() // Returns directory name component of path

----- Original Message ----- From: Hardy Merrill <merrillmissioncriticallinux.com> To: Jordan Elver <jjelverworldsites.net> Cc: <php-generallists.php.net> Sent: Tuesday, March 13, 2001 5:21 PM Subject: Re: [PHP] Getting path of script

> How 'bout using a Perl regex with $HTTP_SERVER_VARS["SCRIPT_NAME"] > like this: > > echo "Starting with SCRIPT_NAME=[" . $HTTP_SERVER_VARS["SCRIPT_NAME"] . "]<BR>"; > if (preg_match("/(\S+)\/\S+$/", $HTTP_SERVER_VARS["SCRIPT_NAME"], $matches)) { > echo "Found $matches[1]<br>"; > } > > HTH. > > -- > Hardy Merrill > Mission Critical Linux, Inc. > http://www.missioncriticallinux.com > > Jordan Elver [jjelverworldsites.net] wrote: > > Hi, > > I want to get the path of a script. I know about > > HTTP_SERVER_VARS["SCRIPT_FILENAME"] this returns someting like: > > > > /phpcode/misc/phpinfo.php > > > > But I want to strip off the file name and just have the directory path, like: > > > > /phpcode/misc/ > > > > Any ideas? > > > > Jord > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: php-general-unsubscribelists.php.net > > For additional commands, e-mail: php-general-helplists.php.net > > To contact the list administrators, e-mail: php-list-adminlists.php.net > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribelists.php.net > For additional commands, e-mail: php-general-helplists.php.net > To contact the list administrators, e-mail: php-list-adminlists.php.net >

attached mail follows:

Hi, Thanks for all the suggestions.

I worked out a fix in the meantime:

$path = strstr(strrev($SCRIPT_FILENAME), '/'); echo strrev($path);

Cheers, Jord

On Tuesday 13 March 2001 12:35, you wrote: > check out, > dirname() // Returns directory name component of path > > py > > ----- Original Message ----- > From: Hardy Merrill <merrillmissioncriticallinux.com> > To: Jordan Elver <jjelverworldsites.net> > Cc: <php-generallists.php.net> > Sent: Tuesday, March 13, 2001 5:21 PM > Subject: Re: [PHP] Getting path of script > > > How 'bout using a Perl regex with $HTTP_SERVER_VARS["SCRIPT_NAME"] > > like this: > > > > echo "Starting with SCRIPT_NAME=[" . $HTTP_SERVER_VARS["SCRIPT_NAME"] > > . > > "]<BR>"; > > > if (preg_match("/(\S+)\/\S+$/", $HTTP_SERVER_VARS["SCRIPT_NAME"], > > $matches)) { > > > echo "Found $matches[1]<br>"; > > } > > > > HTH. > > > > -- > > Hardy Merrill > > Mission Critical Linux, Inc. > > http://www.missioncriticallinux.com > > > > Jordan Elver [jjelverworldsites.net] wrote: > > > Hi, > > > I want to get the path of a script. I know about > > > HTTP_SERVER_VARS["SCRIPT_FILENAME"] this returns someting like: > > > > > > /phpcode/misc/phpinfo.php > > > > > > But I want to strip off the file name and just have the directory path, > > like: > > > /phpcode/misc/ > > > > > > Any ideas? > > > > > > Jord > > > > > > -- > > > PHP General Mailing List (http://www.php.net/) > > > To unsubscribe, e-mail: php-general-unsubscribelists.php.net > > > For additional commands, e-mail: php-general-helplists.php.net > > > To contact the list administrators, e-mail: > > > php-list-adminlists.php.net > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: php-general-unsubscribelists.php.net > > For additional commands, e-mail: php-general-helplists.php.net > > To contact the list administrators, e-mail: php-list-adminlists.php.net

attached mail follows:

Hi all,

Is it possible to change the group rights on a directory like this?

chgrp("/home/www/host/sitedir.com", "site1.com");

It doesn't work for me and i have tried this: exec(chown apache:site1.com /home/www/host/sitedir.com")

Where sitedir.com is the directory i wish to be affected and site1.com is the group that i want assigned to it. Is their a way to make this work??

Thanks Dominique Paquin

attached mail follows:

I would look at 'TINY', very powerful, very fast (the processor in your watch can do it), and open and free.

><snip> >I'm looking for a two way encryption function that I can use to encrypt a >cookie value. I have had experience with MD5 but its one way. Is there one I >can use with a key in php? >< more snip>

attached mail follows:

Anyone care to write me in private about how to trace where stuff like this REALLY comes from, i.e. the correct mail server, mailbox?

attached mail follows:

Dennis Gearon wrote:

> Anyone care to write me in private about how to trace where stuff like > this REALLY comes from, i.e. the correct mail server, mailbox?

www.spamcop.com

AMK4

--
W |
  |  I haven't lost my mind; it's backed up on tape somewhere.
  |____________________________________________________________________
  ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
  Ashley M. Kirchner <mailto:ashleypcraft.com>   .   303.442.6410 x130
  SysAdmin / Websmith                           .     800.441.3873 x130
  Photo Craft Laboratories, Inc.             .        eFax 248.671.0909
  http://www.pcraft.com                  .         3550 Arapahoe Ave #6
  .................. .  .  .     .               Boulder, CO 80303, USA

attached mail follows:

On what user account are PHP uploads handled? I tested the upload script from PHP docs and it worked fine only if I gave the world write access to the destination directory (the one I moved the file with move_uploaded_file() function).

How should this be done safely?

Lasse

attached mail follows:

----- Original Message ----- From: "Lasse Laurila" <lasselaurila.net> To: <php-generallists.php.net> Sent: Tuesday, March 13, 2001 6:07 PM Subject: [PHP] Upload user account

> On what user account are PHP uploads handled? I tested the upload script > from PHP docs and it worked fine only if I gave the world write access to > the destination directory (the one I moved the file with > move_uploaded_file() function). > > How should this be done safely?

You dont need world writable, the webserver only needs to be able to write in the dir where the file should be, more safely make the webserver user the owner of the dir.

-- Henrik Hansen

attached mail follows:

Hi, everybody!

Does Oracle offer a feature similar to MySQL's Fulltext-index?

-- Grüße aus dem schönen Kleve Jens Kisters

rosomm et partner Agentur für neue Medien GmbH Dienstleistungszentrum am Weißen Tor - Eingang B Gocher Landstrasse 2 47551 Kleve / Bedburg-Hau

Telefon: 02821 - 97856-20 Telefax: 02821 - 97856-77 j.kistersrosomm-partner.de http://www.rosomm-partner.de

attached mail follows:

Aaron,

this is obviously exactly what i need!! Thanks a lot - this saved me days of work!

Joe

-----Ursprungliche Nachricht----- Von: Aaron Tuller [mailto:mandelbaumolywa.net] Gesendet: Dienstag, 13. Marz 2001 05:41 An: PHPmaiersoft.de Cc: php-generallists.php.net Betreff: Re: AW: [PHP] Cache Database-driven site

all you need to do is wrap your pages in:

ob_start();

// your code

$page = ob_get_contents();

// write $page to a file or whatever you want to do

and then depending on if this script is being called by cron or just when people load the page you can either do an ob_end_flush() or ob_end_clean()

it's easy.

At first I didn't beleive output buffering was that cool, now I thnk it's one of the best things PHP has to offer. You can use it for a lot of things, check it out.

-aaron

At 12:40 AM +0100 3/13/01, Joe Maier wrote: >Aaron, >i would love to believe what you say. >But i couldn't find any buffering functions in the online docs. > >Could you please gimme a pointer on where i can find these functions >and what's their name. Are they available in php3? > >Thanks a lot, >Joe > >-----Ursprungliche Nachricht----- >Von: Aaron Tuller [mailto:mandelbaumolywa.net] >Gesendet: Montag, 12. Marz 2001 23:26 >An: JMaiermaiersoft.de; php-generallists.php.net >Betreff: Re: [PHP] Cache Database-driven site > > >At 11:19 PM +0100 3/12/01, Joachim Maier wrote: >>To create the HTML-cache page i need to build the whole HTML-page content >in >>memory, instead of echoing it back to the user's browser, and finally write >>it to disk. That means, i have to write all HTML in php-code. I can't just >>embed php-parts in html tags. > >that's not true. see the output buffering functions. > >-aaron > >-- >PHP General Mailing List (http://www.php.net/) >To unsubscribe, e-mail: php-general-unsubscribelists.php.net >For additional commands, e-mail: php-general-helplists.php.net >To contact the list administrators, e-mail: php-list-adminlists.php.net

-- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribe

lists.php.net For additional commands, e-mail: php-general-help

lists.php.net To contact the list administrators, e-mail: php-list-admin

lists.php.net

attached mail follows:

Hi,

I'm trying to document a file which include only function and it does not work can you help me on that.

The file look like: /** * Small comments * * Bigger comments lkjadfhlkjgaljfdgag ;kajhdflhgdsbf * module mod1 * modulegroup mod_group1 */

/** * Small comment for the function * * Bigger comment for the function kjhdlakhdlakjfhlakdhf * param string first param * return boolean A value to be returned */ function tata($str) { return 1; }

I'm able to document file which contains class.

Remi Ricard papaDocvideotron.ca

attached mail follows:

Hi,

Working on a code that uses a select/option field. All my other fields are passing through to the form processing software just fine. Meloni's PHP Essentials does this funky thing, declaring each function value as selected or not although she shows it with the individual values not with variable - and I don't understand why she is doing that - I don't see it anywhere else. What I do know is whether I try her if_else selected method or without, my value is not being passed through http.

echo "<td width=\"550\" align=\"left\"><select name=\"select_product\">"; echo "<option value=\"\">Cat. ID No? Description Pkg Size Price</option>"; while ($row = mysql_fetch_array($result)) { $catid[] = $row["Cat_ID"]; } for ($i=0; $i < sizeof($catid); $i++) { $cat = $catid[$i];

if($select_product =="cat") { echo "<option value=\"$cat\" selected>$cat</option>"; } else { echo "<option value=\"$cat\">$cat</option>"; }

Thanks,

Nicole

-- ######################## Nicole Lallande nicole

nmlconsulting.com 760.753.6766 ########################

attached mail follows:

your checking the value every time you loop so that you can see if that value is checked or not. Im sure Ive missunderstood your question... please email.

<?php function selected($val_1, $val_2) { if ($val_1 == $val_2) return ' selected '; else return; } include_once('database_class.egn');

$result = $database->select_array('', 'country', '');

echo " <form method='post' action='$PHP_SELF'> <select name='country'> ";

foreach($result as $pos => $val) { $this_country = $val['country']; echo " <option value='$this_country'". selected($country, $this_country) .">$this_country "; } echo " </select> <input type='submit' name='done' value='Submit'> </form> ";

-- 
 Chris Lee
 Mediawaveonline.com
 ph. 250.377.1095
 ph. 250.376.2690
 fx. 250.554.1120
 leemediawaveonline.com
"Nicole Lallande" <mipanamipana.com> wrote in message news:3AAE5A92.8295BE0Fmipana.com...
Hi,
Working on a code that uses a select/option field.  All my other fields
are passing through to the form processing software just fine.  Meloni's
PHP Essentials does this funky thing, declaring each function value as
selected or not although she shows it with the individual values not
with variable - and I don't understand why she is doing that - I don't
see it anywhere else.  What I do know is whether I try her if_else
selected method or without, my value is not being passed through http.   
echo "<td width=\"550\" align=\"left\"><select
name=\"select_product\">";
echo "<option value=\"\">Cat. ID No? Description  Pkg Size 
Price</option>";  
  
       while ($row = mysql_fetch_array($result)) {
         $catid[] = $row["Cat_ID"];       
}
       for ($i=0; $i < sizeof($catid); $i++) {
         $cat = $catid[$i];                 
  if($select_product =="cat") {
     echo "<option value=\"$cat\" selected>$cat</option>";
  } else {
     echo "<option value=\"$cat\">$cat</option>";
  }   
Thanks,
Nicole                                                
-- 
########################
Nicole Lallande
nicolenmlconsulting.com
760.753.6766
########################
-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-general-unsubscribelists.php.net
For additional commands, e-mail: php-general-helplists.php.net
To contact the list administrators, e-mail: php-list-adminlists.php.net

attached mail follows:

hi, i have a mysql table like this:

------------- id | htmlpage (or php) ------------- 3 baco.php 23 help.php 43 admin.html

i have been using htdig before i have made those changes. it work really well but know i do not want to receive a response like

http://mydomain.com/admin.html

Instead, i want to receive

http://mydomain.com/?id=43

i do not know if i how can i modify htdig in order to do that. Even though i am not really sure if htdig will be the better solution. Anyway .. all my searchable information is under html pages (or php), how can i search into those files and return the id from my database?

any suggestion will be appreciated,

thanks in advance,

marcos marcosival.es

attached mail follows:

Hello, I am using Payflow Pro as a payment processor on RedHat Linux and I need to be able to specify the cert directory so that we can process transactions. I can make things work with a shell script:

---
#!/bin/sh
PFPRO_CERT_PATH=/usr/local/ssl/certs;export PFPRO_CERT_PATH
./pfpro test-payflow.verisign.com 443
"TRXTYPE=S&TENDER=C&VENDOR=(ourvendorname)&PARTNER=(ourpartner)&USER=(ouruse
rname)
&PWD=(ourpassword)&ACCT=5105105105105100&ExpDate=1210&AMT=1.00" 10
--
and the test transaction works fine.
However,
when I use the payflow pro processing functions in PHP, I get the error:
The response: Array ( [RESULT] => -31 [RESPMSG] => The certificate chain did
not validate, no local certificate found )
The reason for this is that I need to set the cert path to go and look for
the  f73e89fd.0 file in my certs directory, and I don't
know how to tell it to look for it.
I've already tried setting the environment variable
PFPRO_CERT_PATH=/usr/local/ssl/certs but that doesn't make a difference.
It doesn't seem to be an option I can set in the config.h file for the
payflow pro SDK that I downloaded.
What's the deal?  Anyone know how to fix this problem?
Yes, I've RTM and STN already.
Thanks
Dan

attached mail follows:

Hi Dan-

I'm one of the two guys who wrote the extension.

This would seem to be a different SDK than the one we use. Can you point me to (or send me) the one you downloaded? I'm unfamiliar with the VENDOR and PARTNER attributes, and I'm not sure I understand the point behind using your own client certificate (unless it replaced the USER&PWD authentication method, which it apparently doesn't).

Can you touch on what these are for? We can surely add support for the cert_path, I'm just not sure I understand what advantage it provides over using Verisign's default certificate, which is compiled into their SDK.

John

On Tue, 13 Mar 2001, Dan Harrington wrote:

> Hello, > I am using Payflow Pro as a payment processor on RedHat Linux and I need to > be able to specify the cert directory so that we can process transactions. > I can make things work with a shell script: > > --- > #!/bin/sh > PFPRO_CERT_PATH=/usr/local/ssl/certs;export PFPRO_CERT_PATH > ./pfpro test-payflow.verisign.com 443 > "TRXTYPE=S&TENDER=C&VENDOR=(ourvendorname)&PARTNER=(ourpartner)&USER=(ouruse > rname) > &PWD=(ourpassword)&ACCT=5105105105105100&ExpDate=1210&AMT=1.00" 10 > -- > > and the test transaction works fine. > > However, > > when I use the payflow pro processing functions in PHP, I get the error: > > The response: Array ( [RESULT] => -31 [RESPMSG] => The certificate chain did > not validate, no local certificate found ) > > The reason for this is that I need to set the cert path to go and look for > the f73e89fd.0 file in my certs directory, and I don't > know how to tell it to look for it. > > I've already tried setting the environment variable > PFPRO_CERT_PATH=/usr/local/ssl/certs but that doesn't make a difference. > > It doesn't seem to be an option I can set in the config.h file for the > payflow pro SDK that I downloaded. > > What's the deal? Anyone know how to fix this problem? > > Yes, I've RTM and STN already. > > Thanks > Dan > > >

John Donagher Application Engineer Intacct Corp. - Powerful Accounting on the Web 408-395-0989 720 University Ave. Los Gatos CA 95032 www.intacct.com

Public key available off http://www.keyserver.net Key fingerprint = 4024 DF50 56EE 19A3 258A D628 22DE AD56 EEBE 8DDD

attached mail follows:

I believe that he is using the V3 SDK that Verisign just released. I just went through this same thing. The support in PHP 4.0.2+ is for the V2.11 beta SDK. The API in the new V3 sdk is completely different and was unusable with the current PHP implementation (i.e. There is no PNVersion() function). Once I obtained the beta V2.11 SDK from Verisign life was good. PHP will need to updated to support V3 prior to it being utilized.

Sincerely,

Robert T. Covell President / Owner Rolet Internet Services, LLC Web: www.rolet.com Email: rcovellrolet.com Phone: 816.210.7145 Fax: 816.753.1952

-----Original Message----- From: John Donagher [mailto:johnwebmeta.com] Sent: Tuesday, March 13, 2001 9:31 AM To: Dan Harrington Cc: php-generallists.php.net Subject: Re: [PHP] Payflow Pro

Hi Dan-

I'm one of the two guys who wrote the extension.

John

On Tue, 13 Mar 2001, Dan Harrington wrote:

John Donagher Application Engineer Intacct Corp. - Powerful Accounting on the Web 408-395-0989 720 University Ave. Los Gatos CA 95032 www.intacct.com

Public key available off http://www.keyserver.net Key fingerprint = 4024 DF50 56EE 19A3 258A D628 22DE AD56 EEBE 8DDD

attached mail follows:

I forgot. THe new VENDER and PARTNER are exclusive to the new SDK. The beta V2.11 will still work with the new V3 architecture that Verisign has put in place but it will not utilize the new functionallity. This I have verified with Verisign due to the PHP not supporting the new SDK yet.

Sincerely,

Robert T. Covell President / Owner Rolet Internet Services, LLC Web: www.rolet.com Email: rcovellrolet.com Phone: 816.210.7145 Fax: 816.753.1952

-----Original Message----- From: John Donagher [mailto:johnwebmeta.com] Sent: Tuesday, March 13, 2001 9:31 AM To: Dan Harrington Cc: php-generallists.php.net Subject: Re: [PHP] Payflow Pro

Hi Dan-

I'm one of the two guys who wrote the extension.

John

On Tue, 13 Mar 2001, Dan Harrington wrote:

John Donagher Application Engineer Intacct Corp. - Powerful Accounting on the Web 408-395-0989 720 University Ave. Los Gatos CA 95032 www.intacct.com

Public key available off http://www.keyserver.net Key fingerprint = 4024 DF50 56EE 19A3 258A D628 22DE AD56 EEBE 8DDD

attached mail follows:

I removed the PNVersion from the code (by force) and it works now....all I need is to be able to tell it where to find the f73e89fd.0 file (in my ssl certs path) and it should work. Functionally, it seems to work, its just that it can't find that file.

> -----Original Message----- > From: Robert Covell [mailto:rcovellrolet.com] > Sent: Tuesday, March 13, 2001 12:26 PM > To: John Donagher; Dan Harrington > Cc: php-generallists.php.net > Subject: RE: [PHP] Payflow Pro > > > I believe that he is using the V3 SDK that Verisign just released. I just > went through this same thing. The support in PHP 4.0.2+ is for the V2.11 > beta SDK. The API in the new V3 sdk is completely different and was > unusable with the current PHP implementation (i.e. There is no PNVersion() > function). Once I obtained the beta V2.11 SDK from Verisign life > was good. > PHP will need to updated to support V3 prior to it being utilized. > > Sincerely, > > Robert T. Covell > President / Owner > Rolet Internet Services, LLC > Web: www.rolet.com > Email: rcovellrolet.com > Phone: 816.210.7145 > Fax: 816.753.1952 > > -----Original Message----- > From: John Donagher [mailto:johnwebmeta.com] > Sent: Tuesday, March 13, 2001 9:31 AM > To: Dan Harrington > Cc: php-generallists.php.net > Subject: Re: [PHP] Payflow Pro > > > > Hi Dan- > > I'm one of the two guys who wrote the extension. > > This would seem to be a different SDK than the one we use. Can > you point me > to > (or send me) the one you downloaded? I'm unfamiliar with the VENDOR and > PARTNER > attributes, and I'm not sure I understand the point behind using your own > client certificate (unless it replaced the USER&PWD authentication method, > which it apparently doesn't). > > Can you touch on what these are for? We can surely add support for the > cert_path, I'm just not sure I understand what advantage it provides over > using > Verisign's default certificate, which is compiled into their SDK. > > John > > On Tue, 13 Mar 2001, Dan Harrington wrote: > > > Hello, > > I am using Payflow Pro as a payment processor on RedHat Linux and I need > to > > be able to specify the cert directory so that we can process > transactions. > > I can make things work with a shell script: > > > > --- > > #!/bin/sh > > PFPRO_CERT_PATH=/usr/local/ssl/certs;export PFPRO_CERT_PATH > > ./pfpro test-payflow.verisign.com 443 > > > "TRXTYPE=S&TENDER=C&VENDOR=(ourvendorname)&PARTNER=(ourpartner)&US > ER=(ouruse > > rname) > > &PWD=(ourpassword)&ACCT=5105105105105100&ExpDate=1210&AMT=1.00" 10 > > -- > > > > and the test transaction works fine. > > > > However, > > > > when I use the payflow pro processing functions in PHP, I get the error: > > > > The response: Array ( [RESULT] => -31 [RESPMSG] => The certificate chain > did > > not validate, no local certificate found ) > > > > The reason for this is that I need to set the cert path to go > and look for > > the f73e89fd.0 file in my certs directory, and I don't > > know how to tell it to look for it. > > > > I've already tried setting the environment variable > > PFPRO_CERT_PATH=/usr/local/ssl/certs but that doesn't make a difference. > > > > It doesn't seem to be an option I can set in the config.h file for the > > payflow pro SDK that I downloaded. > > > > What's the deal? Anyone know how to fix this problem? > > > > Yes, I've RTM and STN already. > > > > Thanks > > Dan > > > > > > > > -- > > John Donagher > Application Engineer > Intacct Corp. - Powerful Accounting on the Web > 408-395-0989 > 720 University Ave. > Los Gatos CA 95032 > www.intacct.com > > Public key available off http://www.keyserver.net > Key fingerprint = 4024 DF50 56EE 19A3 258A D628 22DE AD56 EEBE 8DDD > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribelists.php.net > For additional commands, e-mail: php-general-helplists.php.net > To contact the list administrators, e-mail: php-list-adminlists.php.net > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribelists.php.net > For additional commands, e-mail: php-general-helplists.php.net > To contact the list administrators, e-mail: php-list-adminlists.php.net >

attached mail follows:

I did the same thing (Removed the PNVersion) and Apache seg faulted at weird times. Now I am not a C guru so I might have done something wrong but this solution was not reliable due to our clients utilizing a system that we were not sure was stable.

Sincerely,

Robert T. Covell President / Owner Rolet Internet Services, LLC Web: www.rolet.com Email: rcovellrolet.com Phone: 816.210.7145 Fax: 816.753.1952

-----Original Message----- From: Dan Harrington [mailto:danharringtons.net] Sent: Tuesday, March 13, 2001 1:41 PM To: Robert Covell; John Donagher Cc: php-generallists.php.net Subject: RE: [PHP] Payflow Pro

-- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribe

lists.php.net For additional commands, e-mail: php-general-help

lists.php.net To contact the list administrators, e-mail: php-list-admin

lists.php.net

attached mail follows:

This is something the extension will probably have to implement.

I'm going to have to talk to Verisign; there seems to be a difference between a Signio account and a Verisign account, because there are two different manager interfaces. There is no new SDK available in the Signio interface, so I'll have to see if I can get our account moved over.

John

On Tue, 13 Mar 2001, Dan Harrington wrote:

> I removed the PNVersion from the code (by force) and it works now....all I > need > is to be able to tell it where to find the f73e89fd.0 file (in my ssl certs > path) > and it should work. Functionally, it seems to work, its just that it can't > find > that file. > > > > -----Original Message----- > > From: Robert Covell [mailto:rcovellrolet.com] > > Sent: Tuesday, March 13, 2001 12:26 PM > > To: John Donagher; Dan Harrington > > Cc: php-generallists.php.net > > Subject: RE: [PHP] Payflow Pro > > > > > > I believe that he is using the V3 SDK that Verisign just released. I just > > went through this same thing. The support in PHP 4.0.2+ is for the V2.11 > > beta SDK. The API in the new V3 sdk is completely different and was > > unusable with the current PHP implementation (i.e. There is no PNVersion() > > function). Once I obtained the beta V2.11 SDK from Verisign life > > was good. > > PHP will need to updated to support V3 prior to it being utilized. > > > > Sincerely, > > > > Robert T. Covell > > President / Owner > > Rolet Internet Services, LLC > > Web: www.rolet.com > > Email: rcovellrolet.com > > Phone: 816.210.7145 > > Fax: 816.753.1952 > > > > -----Original Message----- > > From: John Donagher [mailto:johnwebmeta.com] > > Sent: Tuesday, March 13, 2001 9:31 AM > > To: Dan Harrington > > Cc: php-generallists.php.net > > Subject: Re: [PHP] Payflow Pro > > > > > > > > Hi Dan- > > > > I'm one of the two guys who wrote the extension. > > > > This would seem to be a different SDK than the one we use. Can > > you point me > > to > > (or send me) the one you downloaded? I'm unfamiliar with the VENDOR and > > PARTNER > > attributes, and I'm not sure I understand the point behind using your own > > client certificate (unless it replaced the USER&PWD authentication method, > > which it apparently doesn't). > > > > Can you touch on what these are for? We can surely add support for the > > cert_path, I'm just not sure I understand what advantage it provides over > > using > > Verisign's default certificate, which is compiled into their SDK. > > > > John > > > > On Tue, 13 Mar 2001, Dan Harrington wrote: > > > > > Hello, > > > I am using Payflow Pro as a payment processor on RedHat Linux and I need > > to > > > be able to specify the cert directory so that we can process > > transactions. > > > I can make things work with a shell script: > > > > > > --- > > > #!/bin/sh > > > PFPRO_CERT_PATH=/usr/local/ssl/certs;export PFPRO_CERT_PATH > > > ./pfpro test-payflow.verisign.com 443 > > > > > "TRXTYPE=S&TENDER=C&VENDOR=(ourvendorname)&PARTNER=(ourpartner)&US > > ER=(ouruse > > > rname) > > > &PWD=(ourpassword)&ACCT=5105105105105100&ExpDate=1210&AMT=1.00" 10 > > > -- > > > > > > and the test transaction works fine. > > > > > > However, > > > > > > when I use the payflow pro processing functions in PHP, I get the error: > > > > > > The response: Array ( [RESULT] => -31 [RESPMSG] => The certificate chain > > did > > > not validate, no local certificate found ) > > > > > > The reason for this is that I need to set the cert path to go > > and look for > > > the f73e89fd.0 file in my certs directory, and I don't > > > know how to tell it to look for it. > > > > > > I've already tried setting the environment variable > > > PFPRO_CERT_PATH=/usr/local/ssl/certs but that doesn't make a difference. > > > > > > It doesn't seem to be an option I can set in the config.h file for the > > > payflow pro SDK that I downloaded. > > > > > > What's the deal? Anyone know how to fix this problem? > > > > > > Yes, I've RTM and STN already. > > > > > > Thanks > > > Dan > > > > > > > > > > > > > -- > > > > John Donagher > > Application Engineer > > Intacct Corp. - Powerful Accounting on the Web > > 408-395-0989 > > 720 University Ave. > > Los Gatos CA 95032 > > www.intacct.com > > > > Public key available off http://www.keyserver.net > > Key fingerprint = 4024 DF50 56EE 19A3 258A D628 22DE AD56 EEBE 8DDD > > > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: php-general-unsubscribelists.php.net > > For additional commands, e-mail: php-general-helplists.php.net > > To contact the list administrators, e-mail: php-list-adminlists.php.net > > > > > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: php-general-unsubscribelists.php.net > > For additional commands, e-mail: php-general-helplists.php.net > > To contact the list administrators, e-mail: php-list-adminlists.php.net > > > > >

John Donagher Application Engineer Intacct Corp. - Powerful Accounting on the Web 408-395-0989 720 University Ave. Los Gatos CA 95032 www.intacct.com

Public key available off http://www.keyserver.net Key fingerprint = 4024 DF50 56EE 19A3 258A D628 22DE AD56 EEBE 8DDD

attached mail follows:

Yea, the old accounts do not have the new SDK. If you want to sign up for a V3 account you can utilize our VeriSign signup sheet at http://www.rolet.com/ecommerce.php3 which has been linked to the new V3 system. I actually just tried it and it seems that they are having a problem at the other end bring up the form.

Sincerely,

Robert T. Covell President / Owner Rolet Internet Services, LLC Web: www.rolet.com Email: rcovellrolet.com Phone: 816.210.7145 Fax: 816.753.1952

-----Original Message----- From: John Donagher [mailto:johnwebmeta.com] Sent: Tuesday, March 13, 2001 9:54 AM To: Dan Harrington Cc: Robert Covell; php-generallists.php.net Subject: RE: [PHP] Payflow Pro

This is something the extension will probably have to implement.

John

On Tue, 13 Mar 2001, Dan Harrington wrote:

John Donagher Application Engineer Intacct Corp. - Powerful Accounting on the Web 408-395-0989 720 University Ave. Los Gatos CA 95032 www.intacct.com

Public key available off http://www.keyserver.net Key fingerprint = 4024 DF50 56EE 19A3 258A D628 22DE AD56 EEBE 8DDD

attached mail follows:

Is anyone on this list using the PayFlow Pro extensions for PHP? If so, I would like to know what version of the SDK you are using, and if you have knowledge of anyone at Verisign who deals with PHP.

So far, I have only found out that they don't support PHP.

Thanks Dan Harrington

attached mail follows:

apparently opayc has Payflow as one of the processors. Both the cheque and the card service. If it changes then you get a new driver. Comes with source code I am sure.

Rick

At 03:40 PM 3/13/01 -0700, Dan Harrington wrote:

>Is anyone on this list using the PayFlow Pro extensions for PHP? >If so, I would like to know what version of the SDK you are using, and >if you have knowledge of anyone at Verisign who deals with PHP. > >So far, I have only found out that they don't support PHP. > >Thanks >Dan Harrington > > >-- >PHP General Mailing List (http://www.php.net/) >To unsubscribe, e-mail: php-general-unsubscribelists.php.net >For additional commands, e-mail: php-general-helplists.php.net >To contact the list administrators, e-mail: php-list-adminlists.php.net

attached mail follows:

Dan, The V2.11 SDK that they have is supported by PHP. They (Verisign & PHP developers) actually went to great lengths ensure that it did work by release the beta V2.11. The reason that the SDK your using (V3) does not work with PHP is due to it just being released about 1 1/2 monthes ago. So PHP does support Payflow Pro just not the newest version, yet. You can still utilize the same payment links and V2.11 features, but will have to wait for PHP to support V3 for the bleeding edge stuff.

Sincerely,

Robert T. Covell President / Owner Rolet Internet Services, LLC Web: www.rolet.com Email: rcovellrolet.com Phone: 816.210.7145 Fax: 816.753.1952

-----Original Message----- From: Dan Harrington [mailto:danharringtons.net] Sent: Tuesday, March 13, 2001 4:41 PM To: php-generallists.php.net Subject: [PHP] Payflow Pro

Is anyone on this list using the PayFlow Pro extensions for PHP? If so, I would like to know what version of the SDK you are using, and if you have knowledge of anyone at Verisign who deals with PHP.

So far, I have only found out that they don't support PHP.

Thanks Dan Harrington

-- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribe

lists.php.net For additional commands, e-mail: php-general-help

lists.php.net To contact the list administrators, e-mail: php-list-admin

lists.php.net

attached mail follows:

I am wondering how to call a function simply by clicking a button or a hyperlink?

I would like to use this technique to avoid passing things in a link

Presently, I use this technique: <a href="../php/delete_something.php?tid=$thing_id">Delete</a>

I would like to clean things up by having one central or common include file and just call functions out of it. The problem lies in the passing of variables to that function - how to set something up so that the user can click on something to activate that function with a variable.

Psuedocode:

if( buttonclick ) delete_thing($thing_id)

Am I making sense?

Thanks in advance. John

-- 
/====================================================================\
| John Voth       Mobiltex Data Ltd.Calgary, Alberta,Canada, T1Y-4T7 |
| jvothmobiltex.com     403-291-2770, 403-259-6795 (fax)            |
\====================================================================/

attached mail follows:

Hey!

I have a few questions:

1. How could I get the browser's location bar value (the full path of the file we are dealing with)? I have index.php3 which include's an external php3 script("ext.php3"), and I need the 'ext.php3' script to get the full path of the main file it was called from - 'index.php3'.

2. Let's say I have a string such as: "http://www.blabla.com/dir1/dir2/file.php3", How can I can strip the file-ending(".php3") out the string?

Thank you in advance -

Aviv Revach

BRILLIANeT Website - http://www.brillianet.com/

attached mail follows:

In article <4.3.1.2.20010312204052.00a94380mail.brillianet.com>, aviv_rbrillianet.com (Aviv Revach) wrote:

> 2. Let's say I have a string such as: > "http://www.blabla.com/dir1/dir2/file.php3", > How can I can strip the file-ending(".php3") out the string?

Option 1: parse_url() Option 2: strpos() & str_replace() Option 3: ereg_replace() or preg_replace()

-- CC

attached mail follows:

Im trying to use the SHOW syntax and the following code is returning nothing.The Table name is correct and there are records in the table (not that that should matter).I dont get an error.

<?php require("Connection.php"); $query="Show Columns from Inventory"; $result= mysql_query($query); while ($row = mysql_fetch_row($result)); { for ($i =1;$i<mysql_num_fields($result);$i++) {echo $row[$i]; }} ?>

Thanks Mike mpelosoprinceton.edu

attached mail follows:

How can I write the form data a user fills out and send it to a text file?

Jerry Lake - jerryleuropa.com Web Designer Europa Communications - http://www.europa.com Pacifier Online - http://www.pacifier.com

-----Original Message----- From: Jordan Elver [mailto:jord.elvervirginnet.co.uk] Sent: Tuesday, March 13, 2001 12:13 PM To: Pierre-Yves Lemaire Cc: php-generallists.php.net Subject: Re: [PHP] Getting path of script

Hi, Thanks for all the suggestions.

I worked out a fix in the meantime:

$path = strstr(strrev($SCRIPT_FILENAME), '/'); echo strrev($path);

Cheers, Jord

-- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribe

lists.php.net For additional commands, e-mail: php-general-help

lists.php.net To contact the list administrators, e-mail: php-list-admin

lists.php.net

attached mail follows:

This goes along with my previous question I don't see a php function to make a file

I am trying to use an online form to create an addweb profile.ini file to in turn be emailed to my customer service dept. so they can save the file into the addweb batch directory for an import and autorun thus saving the time of re-typing all of the form information.

when my form gets filled out I need to be able to create a new file, write text to it from the variables and then email it to a CSR

any ideas on where to start with this are greatly appreciated.

Thanks,

Jerry Lake - jerryleuropa.com Web Designer Europa Communications - http://www.europa.com Pacifier Online - http://www.pacifier.com

-----Original Message----- From: Jerry Lake [mailto:jerryleuropa.com] Sent: Tuesday, March 13, 2001 12:36 PM To: php-generallists.php.net Subject: [PHP] write form data to a text file

How can I write the form data a user fills out and send it to a text file?

Jerry Lake - jerryleuropa.com Web Designer Europa Communications - http://www.europa.com Pacifier Online - http://www.pacifier.com

Hi, Thanks for all the suggestions.

I worked out a fix in the meantime:

$path = strstr(strrev($SCRIPT_FILENAME), '/'); echo strrev($path);

Cheers, Jord

-- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribe

lists.php.net For additional commands, e-mail: php-general-help

lists.php.net To contact the list administrators, e-mail: php-list-admin

lists.php.net

attached mail follows:

-----Original Message----- From: Jerry Lake [mailto:jerryleuropa.com] Sent: Tuesday, March 13, 2001 9:55 PM To: php-generallists.php.net Subject: RE: [PHP] write form data to a text file

> This goes along with my previous question > I don't see a php function to make a file

Cut'n'paste from: <http://www.php.net/manual/en/function.fopen.php>

-- 'r' - Open for reading only; place the file pointer at the beginning of the file.

'r+' - Open for reading and writing; place the file pointer at the beginning of the file.

'w' - Open for writing only; place the file pointer at the beginning of the file and truncate the file to zero length. If the file does not exist, attempt to create it.

'w+' - Open for reading and writing; place the file pointer at the beginning of the file and truncate the file to zero length. If the file does not exist, attempt to create it.

'a' - Open for writing only; place the file pointer at the end of the file. If the file does not exist, attempt to create it.

'a+' - Open for reading and writing; place the file pointer at the end of the file. If the file does not exist, attempt to create it. --

Hint: Look for options with "If the file does not exist, attempt to create it." :)

-- Christian Jørgensen http://www.razor.dk

attached mail follows:

Hey!

I have a directory that contains many files. Some of these files have a '.txt' ending. I would like to know how could I locate each one of the '.txt' files.

For each file I find, I need to do a certain action, and should continue the search.

Thank you in advance -

Aviv Revach

BRILLIANeT Website - http://www.brillianet.com/

attached mail follows:

-----Original Message----- From: Aviv Revach [mailto:aviv_rbrillianet.com] Sent: Monday, March 12, 2001 10:01 PM To: php-generallists.php.net Subject: [PHP] Seeking for files ending with '.txt' ..

> I have a directory that contains many files. Some of these files have a > '.txt' ending. > I would like to know how could I locate each one of the '.txt' files.

This is easily done using PEAR:

<?php

require_once "File/Find.php";

$pattern = ".*\.txt$"; // Pattern... $start_in = $DOCUMENT_ROOT; // Where to start...

$f=new File_Find(); $array=$f->search($pattern, $start_in);

(sizeof($array) == 0) ? print "Didn't find any files\n" : foreach($array as $filename) print "$filename<br>\n";

> For each file I find, I need to do a certain action, and should continue > the search.

Here, i just print the filenames.

-- Christian Jorgensen http://www.razor.dk

attached mail follows:

----- Original Message ----- From: "Aviv Revach" <aviv_rbrillianet.com> To: <php-generallists.php.net> Sent: Monday, March 12, 2001 10:01 PM Subject: [PHP] Seeking for files ending with '.txt' ..

> Hey! > > I have a directory that contains many files. Some of these files have a > '.txt' ending. > I would like to know how could I locate each one of the '.txt' files. > > For each file I find, I need to do a certain action, and should continue > the search.

$dh = opendir("/tmp"); while( $file = readdir($dh)) { if ($file != "." && $file != ".."{ ereg("[.]([a-z]{2,3})$", $file, $extention); if($extention == ".txt") echo "yehaa file ends with .txt"; else echo "darn no .txt"; } }

or something like that

-- Henrik Hansen

attached mail follows:

Does anyone know if it is possible to maintain session state across a cluster of four web servers?

Regards Martin Cameron

attached mail follows:

Use a database to store the session information.

Or store everything in files on one machine and map connections from the other servers to the main one.

(I prefer the first method)

Martin Cameron wrote:

> Does anyone know if it is possible to maintain session state across a > cluster of four web servers? > > Regards > Martin Cameron > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribelists.php.net > For additional commands, e-mail: php-general-helplists.php.net > To contact the list administrators, e-mail: php-list-adminlists.php.net

attached mail follows:

How about mounting a shared disk on all 4 webservers, and storing your session files on that? The database option is probably best though.

HTH.

-- 
Hardy Merrill
Mission Critical Linux, Inc.
http://www.missioncriticallinux.com
Michael Kimsal [michaeltapinternet.com] wrote:
> Use a database to store the session information.
> 
> Or store everything in files on one machine and map connections
> from the other servers to the main one.
> 
> (I prefer the first method)
> 
> 
> Martin Cameron wrote:
> 
> > Does anyone know if it is possible to maintain session state across a
> > cluster of four web servers?
> >
> > Regards
> > Martin Cameron
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail: php-general-unsubscribelists.php.net
> > For additional commands, e-mail: php-general-helplists.php.net
> > To contact the list administrators, e-mail: php-list-adminlists.php.net
> 
> 
> -- 
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-general-unsubscribelists.php.net
> For additional commands, e-mail: php-general-helplists.php.net
> To contact the list administrators, e-mail: php-list-adminlists.php.net

attached mail follows:

Hello,

Does anyone know how to fix this error?

Warning: open(/tmp\sess_4fb4c5778fe97ab351baca1d8db90abf, O_RDWR) failed: m (2) in c:/htdocs/br/br.php on line 2

Thank you,

-------------------------------------------- Brandon Orther WebIntellects Design/Development Manager brandonwebintellects.com 800-994-6364 www.webintellects.com --------------------------------------------

attached mail follows:

you're using php for windows, right? well, you try to open /tmp which is a *nix standard directory...i think you can fix that in your php.ini

jack

Brandon Orther wrote: > > Hello, > > Does anyone know how to fix this error? > > Warning: open(/tmp\sess_4fb4c5778fe97ab351baca1d8db90abf, O_RDWR) failed: m > (2) in c:/htdocs/br/br.php on line 2 > > Thank you, > > -------------------------------------------- > Brandon Orther > WebIntellects Design/Development Manager > brandonwebintellects.com > 800-994-6364 > www.webintellects.com > -------------------------------------------- > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribelists.php.net > For additional commands, e-mail: php-general-helplists.php.net > To contact the list administrators, e-mail: php-list-adminlists.php.net

attached mail follows:

I'm wondering about the limitations of session variables in PHP4 with regards to over-use. For example I've been taking huge advantage of them and would like to store about 14k per session - its actually only three or four variables, but one of them is multiple depth array. Does this seem a reasonable use of session variables, or have I gone too far? :)

Thanks.

attached mail follows:

can you use str_replace or ereg_replace in an fputs statement?

something like this

fputs("$fpoint2", "str_replace($oldcrypt, $newcrypt, $shadow[2])");

i need to replace a string in a file. the string is in an array tho.. is that why this isnt working?

<-----CoreComm-Internet-Services---http://core.com-----> (Jon Marshall CoreComm Services Chicago) (jonathon.marshallcore.com Systems Engineer II) (enthalpycore.com Network Operations) <-----Enthalpy.org-------------http://enthalpy.org-----> (enthalpyenthalpy.org The World of Nothing) <------------------------------------------------------>

attached mail follows:

figured it out

just had to use fread first.

$fpoint3 = fopen ($testshadow, "r+") or die("couldnt open shadow file again"); $contents = fread ($fpoint3, $shadowfilesize); fputs ($fpoint3, ereg_replace("$data[0]:$shadow[1]", "$data[0]:$data[1]", $contents));

tho i will say it was a pain in the ass to get it to work..

now i can delete all my echo lines so i could follow the script with stdout :}

On Tue, 13 Mar 2001, enthalpy wrote:

> > can you use str_replace or ereg_replace in an fputs statement? > > something like this > > fputs("$fpoint2", "str_replace($oldcrypt, $newcrypt, $shadow[2])"); > > i need to replace a string in a file. the string is in an array tho.. is that why this isnt working? > > <-----CoreComm-Internet-Services---http://core.com-----> > (Jon Marshall CoreComm Services Chicago) > (jonathon.marshallcore.com Systems Engineer II) > (enthalpycore.com Network Operations) > <-----Enthalpy.org-------------http://enthalpy.org-----> > (enthalpyenthalpy.org The World of Nothing) > <------------------------------------------------------> > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribelists.php.net > For additional commands, e-mail: php-general-helplists.php.net > To contact the list administrators, e-mail: php-list-adminlists.php.net > >

attached mail follows:

Ok, I created a form handler that writes the .ini file that I need for an auto-import, now what should I look at attach it to an email the file is just ascii text

Jerry Lake - jerryleuropa.com Web Designer Europa Communications - http://www.europa.com Pacifier Online - http://www.pacifier.com

attached mail follows:

Hey!

I already asked this once before, but nobody seems to answer. That's why I'm re-writing my question.

I have a main file named: "main.php3" It includes an external php3 script named: "ext.php3"

Inside of the 'ext.php3' script - I need to know the full path of the file which included it (in this case - 'http://www......./dir1/dir2/main.php3'). How could I do that?

Thank you in advance -

Aviv Revach

BRILLIANeT Website - http://www.brillianet.com/

attached mail follows:

Aviv, I'm not quite sure what you are asking. If you are just doing an include() or a require() on a chunk of code, then I think the usual server variables will give you the path of the main file, e.g. $PHP_SELF. If you are doing a *redirect* to a *different page*, then you could look at $HTTP_REFERER, or pass the main page name as a GET attached to the URL.

Hope this helps.

Kirk

-----Original Message----- From: Aviv Revach [mailto:aviv_rbrillianet.com] Sent: Monday, March 12, 2001 4:15 PM To: php-generallists.php.net Subject: [PHP] Getting name of the main file from external included script..

Hey!

I already asked this once before, but nobody seems to answer. That's why I'm re-writing my question.

I have a main file named: "main.php3" It includes an external php3 script named: "ext.php3"

Inside of the 'ext.php3' script - I need to know the full path of the file which included it (in this case - 'http://www......./dir1/dir2/main.php3'). How could I do that?

Thank you in advance -

Aviv Revach

BRILLIANeT Website - http://www.brillianet.com/

-- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribe

lists.php.net For additional commands, e-mail: php-general-help

lists.php.net To contact the list administrators, e-mail: php-list-admin

lists.php.net

attached mail follows:

Is it possible to use server side maps with PHP, as you can in CGI ?

Also is it possible to determine the x & y co-ords of a mouseclick ?

regards

attached mail follows:

having problems replacing a line in a file.

need to search the whole document for a string and then replace that line with a string.

any ideas?

this is causing lots of problems now.

any ideas?

attached mail follows:

Hey!

I didn't try to analyze your code, but why not using the file() function which opens a file and puts it's content into an array.

After doing that, you could seek that array line-by-line for "$data[0]:$shadow[1]" and replace it with $data[0]:$data[1].

Since you're dealing with full lines in your script, file() is the best choice (though, sometimes not the fastest). It will also improve your code by making it much easier to read than when using fopen(), fread(), etc.. as you're doing now.

Best Regards -

Aviv Revach

At 17:29 13/03/01 -0600, enthalpy wrote:

>having problems replacing a line in a file. > >need to search the whole document for a string and then replace that line >with a string. > >any ideas? > >this is causing lots of problems now. > >$fpoint3 = fopen ($testshadow, "r+") or die("couldnt open shadow file again"); >$contents = fread ($fpoint3, $shadowfilesize); >fputs ($fpoint3, ereg_replace("$data[0]:$shadow[1]", "$data[0]:$data[1]", >$contents)); >fclose ($fpoint3); > >any ideas? > ><-----CoreComm-Internet-Services---http://core.com-----> >(Jon Marshall CoreComm Services Chicago) >(jonathon.marshallcore.com Systems Engineer II) >(enthalpycore.com Network Operations) ><-----Enthalpy.org-------------http://enthalpy.org-----> >(enthalpyenthalpy.org The World of Nothing) ><------------------------------------------------------> > > >-- >PHP General Mailing List (http://www.php.net/) >To unsubscribe, e-mail: php-general-unsubscribelists.php.net >For additional commands, e-mail: php-general-helplists.php.net >To contact the list administrators, e-mail: php-list-adminlists.php.net

XOR-Coders Mega Programming Resource Site! - http://members.xoom.com/xorcoders/

attached mail follows:

maybe this?

while($line = fgets($fp, 1024)) { $line = str_replace("replace_this", "with_this", $line); $content .= $line; }

fwrite($fp, $content);

--
Henrik Hansen
----- Original Message -----
From: "enthalpy" <enthalpycore.com>
To: <php-generallists.php.net>
Sent: Wednesday, March 14, 2001 12:29 AM
Subject: [PHP] replacing a line in a file
>
> having problems replacing a line in a file.
>
> need to search the whole document for a string and then replace that line
with a string.
>
> any ideas?
>
> this is causing lots of problems now.
>
> $fpoint3 = fopen ($testshadow, "r+") or die("couldnt open shadow file
again");
> $contents = fread ($fpoint3, $shadowfilesize);
> fputs ($fpoint3, ereg_replace("$data[0]:$shadow[1]", "$data[0]:$data[1]",
$contents));
> fclose ($fpoint3);
>
> any ideas?
>
> <-----CoreComm-Internet-Services---http://core.com----->
> (Jon Marshall                 CoreComm Services Chicago)
> (jonathon.marshallcore.com         Systems Engineer II)
> (enthalpycore.com                   Network Operations)
> <-----Enthalpy.org-------------http://enthalpy.org----->
> (enthalpyenthalpy.org             The World of Nothing)
> <------------------------------------------------------>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-general-unsubscribelists.php.net
> For additional commands, e-mail: php-general-helplists.php.net
> To contact the list administrators, e-mail: php-list-adminlists.php.net
>
>

attached mail follows:

that could work but i dont want to append the new line a the bottom which it looks like thats what your doing. i need to replace the line where it is

On Wed, 14 Mar 2001, Henrik Hansen wrote:

> maybe this? > > while($line = fgets($fp, 1024)) { > $line = str_replace("replace_this", "with_this", $line); > $content .= $line; > } > > fwrite($fp, $content); > > -- > Henrik Hansen > ----- Original Message ----- > From: "enthalpy" <enthalpycore.com> > To: <php-generallists.php.net> > Sent: Wednesday, March 14, 2001 12:29 AM > Subject: [PHP] replacing a line in a file > > > > > > having problems replacing a line in a file. > > > > need to search the whole document for a string and then replace that line > with a string. > > > > any ideas? > > > > this is causing lots of problems now. > > > > $fpoint3 = fopen ($testshadow, "r+") or die("couldnt open shadow file > again"); > > $contents = fread ($fpoint3, $shadowfilesize); > > fputs ($fpoint3, ereg_replace("$data[0]:$shadow[1]", "$data[0]:$data[1]", > $contents)); > > fclose ($fpoint3); > > > > any ideas? > > > > <-----CoreComm-Internet-Services---http://core.com-----> > > (Jon Marshall CoreComm Services Chicago) > > (jonathon.marshallcore.com Systems Engineer II) > > (enthalpycore.com Network Operations) > > <-----Enthalpy.org-------------http://enthalpy.org-----> > > (enthalpyenthalpy.org The World of Nothing) > > <------------------------------------------------------> > > > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: php-general-unsubscribelists.php.net > > For additional commands, e-mail: php-general-helplists.php.net > > To contact the list administrators, e-mail: php-list-adminlists.php.net > > > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribelists.php.net > For additional commands, e-mail: php-general-helplists.php.net > To contact the list administrators, e-mail: php-list-adminlists.php.net > >

attached mail follows:

Im moving servers within the week.. and I got about 600mbs worth of stuff on there, and me being on 56K its nearly an impossible tasks.

I thought up of a solution, but need to get it implemented. Have a script open a directory and fopen all the files from the remote server and transfer it to my new one. Anyone ever done something similar to this? is it possible?

- Thanks

attached mail follows:

Do you have a friend with FTP and DSL??... pull out your drive an go to their place.

Rick

At 06:31 PM 3/13/01 -0500, PeterOblivionaol.com wrote: >Im moving servers within the week.. and I got about 600mbs worth of stuff on >there, and me being on 56K its nearly an impossible tasks. > >I thought up of a solution, but need to get it implemented. Have a script >open a directory and fopen all the files from the remote server and transfer >it to my new one. Anyone ever done something similar to this? is it possible? > >- Thanks > >-- >PHP General Mailing List (http://www.php.net/) >To unsubscribe, e-mail: php-general-unsubscribelists.php.net >For additional commands, e-mail: php-general-helplists.php.net >To contact the list administrators, e-mail: php-list-adminlists.php.net

attached mail follows:

Why, Don't you use the ftp functions to ftp everything over, instead of reading in all the files. If you can get telnet access you could ftp them straight from your telnet connection.

-----Original Message----- From: Rick St Jean [mailto:rstjeaninternet.look.ca] Sent: Tuesday, March 13, 2001 3:56 PM To: php-generallists.php.net Subject: Re: [PHP] need some help..

Do you have a friend with FTP and DSL??... pull out your drive an go to their place.

Rick

-- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribe

lists.php.net For additional commands, e-mail: php-general-help

lists.php.net To contact the list administrators, e-mail: php-list-admin

lists.php.net

attached mail follows:

>>>>> "YO" == Yasuo Ohgaki <yohgakihotmail.com> writes:

YO> ----- Original Message ----- YO> From: "Chung Ha-Nyung" <alitakldp.org> YO> To: <php-generallists.php.net> YO> Sent: Tuesday, March 13, 2001 3:19 PM YO> Subject: [PHP] [Q] session variables wouldn't keep contents. > > Hi guys, > > Some php programs doesn't seem to work normally in a certain > server. Those wokred correctly in my Debian box. > Session is the problem.

YO> The code seems wrong. Although, it can work. It depends on php.ini.

> > It seems that the contents of session variables disappears after > reloading the php page. Here is the program. > > ---- test.php ---- > > > <?php > session_start();

YO> You must start session before output anything to browser, or you must use YO> buffering to do this, YO> or you must use URL mode for session. YO> i.e. This code sends "<html><body>" before starting session and cookie header YO> must be sent before if session is cookie mode.

YO> I recommend to write session_start() before programmers do anything.

I modified that way. But no effect. still not work correctly. After reloading, session variables are emptied. ;(

> if(!session_is_registered("name")) { > "; > session_register("name"); > $HTTP_SESSION_VARS["name"] = "test"; > "; > > $session_name = $HTTP_SESSION_VARS["name"]; > "; > echo "session_name = $session_name"; > > > > ---- test.php ---- > > Can I handle it with only php configuration file? Or Do I have to > modify my php programs?

YO> I'm not sure what do you want to handle "it". Just *poor* english. ;P solving the above trouble.

YO> Starting session can handle in php.ini and inside code.

> > In addition to this, I have a few questions about the work of session > in php 4.0.4 > > Q1) Do I have to use session_start() explicitly although session.auto_start > is set to 1 in php.ini?

YO> No.

YO> Session will be started automatically, so programmer does not have to write it. YO> I recommend to write session_start(), though.

YO> Also, session will be started implicitly if programmer uses session functions YO> even without setting session.auto_start to true. It should work, if programmer YO> didn't send any output to browser before. i.e. Programmer does not even have to YO> write session_start() even if session.auto_start is false. I don't recommend it, YO> though.

> Q2) Do I have to use session_register("variable_name")? > In my Debian woody box, it seems to run well without it.

YO> It seems works fine on my box without it when I use $HTTP_SESSION_VARS at least. YO> I think it will not work without $HTTP_SESSION_VARS. YO> (PHP4.0.4pl1/Apache/RedHat Linux7)

I use only $HTTP_SESSION_VARS. ;)

YO> Regards, YO> -- YO> Yasuo Ohgaki

-- 
 Chung Ha-Nyung <alitakldp.org>

attached mail follows:

My second example program. ---- a.php ---- <?php session_start(); session_register("name"); $HTTP_SESSION_VARS["name"] = "test";

echo session_encode(); ?> ---- a.php ---- result is as following. ==================== !name| ====================

and, /tmp/sess_7d755f490ba4e50da20d7167e2966771 file has only "!name|" without any stuff relating to "test" which I inserted into $HTTP_SESSION_VARS["name"]

I can't figure out why this odd things happen. apache and php's configuration files are the same as thoes in my home computer and both of two computer use Debian/woody.

Anybody has some clues about it? why session variables' contents wouldn't stored.

Regard,

-- 
 Chung Ha-Nyung <alitakldp.org>

attached mail follows:

I would like to return ONE ROW if possible from a query that would tell me whether a value exists in a table. I've tried:

SELECT FieldValueIn, COUNT(*) FROM TableOfInterest WHERE FieldValueIn=ValueOfInterest GROUP BY FieldValueIn;

I can't seem to figure out how to test the return results to see if there is no rows with that value. Any help soon would be very nice.

attached mail follows:

In article <3AAEB627.712ABC23oit.edu>, gearondOIT.EDU (Dennis Gearon) wrote:

> I would like to return ONE ROW if possible from a query that would tell > me > whether a value exists in a table.

If the query could result in more than one record, but you only want to see one, 'limit 1' is helpful.

> SELECT FieldValueIn, COUNT(*) FROM TableOfInterest WHERE > FieldValueIn=ValueOfInterest GROUP BY FieldValueIn; > > I can't seem to figure out how to test the return results to see if > there is no rows with that value.

http://www.php.net/mysql-num-rows

-- CC

attached mail follows:

try

select count(fieldvaluein) from FROM TableOfInterest WHERE FieldValueIn=ValueOfInterest

You don't need the GROUP if you just want the count - from your post and title, it sounds like you just want to know if a value exists in the table. You don't need to know what the value IS, because you're testing for it in the first place, right?

The first value (only value!) back from that query will be a number between 0 and how ever many rows match the query.

Dennis Gearon wrote:

> I would like to return ONE ROW if possible from a query that would tell > me > whether a value exists in a table. I've tried: > > SELECT FieldValueIn, COUNT(*) FROM TableOfInterest WHERE > FieldValueIn=ValueOfInterest GROUP BY FieldValueIn; > > I can't seem to figure out how to test the return results to see if > there is no > rows with that value. Any help soon would be very nice. > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribelists.php.net > For additional commands, e-mail: php-general-helplists.php.net > To contact the list administrators, e-mail: php-list-adminlists.php.net

attached mail follows:

Hiya, I was wondering if some one could shed some light on this error message for me

Warning: MySQL Connection Failed: Can't initialize character set 12 (path: default) in /usr/local/apache/vfsa-erentals-temp/login.php on line 25

I can figure out that the connection failed but i don't understand "Can't initialize character set 12 (path: default)"

Have only got this message since moving over to a Unix machine if any one could shed some light on this it would be great :)

thanks Peter

attached mail follows:

Hello,

I am trying to install apc php cache. When I try to run phpize, I get:

unable to find config.m4 make shure you run phpize in the top level directory of the module

Can somebody tell me how to run phpize and by the way, what is phpize ??

attached mail follows:

When I execute an sql statement against my Oracle database from PHP, I create an oracle <zombie> process. This eventually hits a "number of zombie process" limit and prevents my page from executing.

The queries work properly (except for the zombie problem).

Here is a sample that creates the zombie process:

putenv("ORACLE_HOME=/h/app/oracle/product/8.1.6"); putenv("ORACLE_SID=dbase_name"); putenv("TNS_ADMIN=/h/app/oracle/product/8.1.6/network/admin"); // thought this might help the zombie problem

$conn=OCILogon("get_rid_of" , "zombie");

$sql_get_info="SELECT OppID, OppTitle FROM TEST WHERE OppID=4"; $stmt = OCIParse($conn,$sql_get_info);

OCIExecute($stmt);

OCIFetch($stmt));

$valid_opp_id = OCIResult($stmt, "OPPID"); $valid_opp_title = OCIResult($stmt, "OPPTITLE");

OCIFreeStatement($stmt);

///// using a separate query to get the clob...... $clob_field="OPPTEXT"; // this field in UPPPER CASE $sql="SELECT $clob_field from TEST WHERE OppID=$oid";

$stmt = OCIParse($conn, $sql); $clob_text = OCINewDescriptor($conn,OCI_D_LOB); OCIDefineByName($stmt, $clob_field, &$clob_text); OCIExecute($stmt); OCIFetch($stmt); $valid_text=$clob_text->load();

$clob_text->free(); OCIFreeStatement($stmt);

Here is how I configured PHP 4.0.3pl1 (this is from phpinfo();) :

./configure --with-apxs=/usr/local/apache/bin/apxs --with-config-file-path=/etc/httpd --with-oracle=/ora8/m01/app/oracle/product/8.1.6

I also added OCI8 support via.. --with-oci8=/ora8/m01/app/oracle/product/8.1.6 ... phpinfo(); states oci8 support is "enabled".

I did --enable-sigchild but I don't see it showing in the phpinfo(); ???

I am using: Oracle 8.1.6, Apache 1.3.12 , RedHat 6.0 - all on one server.

Any ideas on what I might be doing wrong? Am I missing something? Any help would be greatly appreciated.

Thanks,

Bob

attached mail follows:

hi,

i'm looking for some good tutorials / articles / books on database design, no, i'm not talking about the classic employee contact database that nearly every site has lingering somewhere... i'm after the good stuff:

smart data design smart data planning unique keys taking advantage of relational databases etc etc

Justin French

attached mail follows:

MySQL by Paul DuBois is a very good one. Jeff Oien

> hi, > > i'm looking for some good tutorials / articles / books on database > design, no, i'm not talking about the classic employee contact database > that nearly every site has lingering somewhere... i'm after the good stuff: > > smart data design > smart data planning > unique keys > taking advantage of relational databases > etc etc > > Justin French > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribelists.php.net > For additional commands, e-mail: php-general-helplists.php.net > To contact the list administrators, e-mail: php-list-adminlists.php.net >

attached mail follows:

Hmmmm... while there are abstract ideas which are generally useful and prudent to adhere to, I don't think most people understand them too well as abstracts and need concrete examples to map them to.

Hence the employee contact database examples. And simple shopping cart examples. :)

Do you have some real-life examples that you'd care to discuss in the open? Using real-life examples (with the added realism of budgets, legacy code, deadlines, etc.) may help everyone here.

Justin French wrote:

attached mail follows:

As usual, O'Reilly did a great job with MySQL/mSQL by Randy Jay Yarger, George Reese and Tim King

jack Justin French wrote: > > hi, > > i'm looking for some good tutorials / articles / books on database > design, no, i'm not talking about the classic employee contact database > that nearly every site has lingering somewhere... i'm after the good stuff: > > smart data design > smart data planning > unique keys > taking advantage of relational databases > etc etc > > Justin French > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribelists.php.net > For additional commands, e-mail: php-general-helplists.php.net > To contact the list administrators, e-mail: php-list-adminlists.php.net

attached mail follows:

You could try the book SQL for Smarties by Joe Celko... I'm not through it yet, but it's got some theory (but not enough to make your head hurt) and goes over all the various SQL commands... in the TOC there's stuff on how to implement directed graphs (such as the organizational path from you to the CEO, etc..) and other crazy stuff...

-philip

In article <3AAECB75.28EF3C09indent.com.au> you write: >hi, > >i'm looking for some good tutorials / articles / books on database >design, no, i'm not talking about the classic employee contact database >that nearly every site has lingering somewhere... i'm after the good stuff: > >smart data design >smart data planning >unique keys >taking advantage of relational databases >etc etc > >Justin French > >-- >PHP General Mailing List (http://www.php.net/) >To unsubscribe, e-mail: php-general-unsubscribelists.php.net >For additional commands, e-mail: php-general-helplists.php.net >To contact the list administrators, e-mail: php-list-adminlists.php.net >

attached mail follows:

> Hmmmm... while there are abstract ideas which are generally useful > and prudent to adhere to, I don't think most people understand them > too well as abstracts and need concrete examples to map them to. > > Hence the employee contact database examples. And simple > shopping cart examples. :)

True - I find the best way to explain database design to someone is by having them design a database (as with someone here last week whom I helped out with an office sports tipping database as a little how-to-SQL project) and help them out as they go.

> Do you have some real-life examples that you'd care to discuss in the > open? Using real-life examples (with the added realism of budgets, > legacy code, deadlines, etc.) may help everyone here.

I agree - throw us some examples of what you're thinking about, Justin.

Jason

-- Jason Murray jasonm

melbourneit.com.au Web Design Team, Melbourne IT Fetch the comfy chair!

attached mail follows:

One of my co-worker has a phenominal book on sql. You will want something that covers the different type of joins... when to use them, as well as database normalization, reinforcing data integrity with foreign and primary keys. You will also want some transact sql in there and some indexing. There are many tutorials in stuff like phpbuilder.com. It is a good starting place.

Rick

At 12:37 PM 3/14/01 +1100, Justin French wrote: >hi, > >i'm looking for some good tutorials / articles / books on database >design, no, i'm not talking about the classic employee contact database >that nearly every site has lingering somewhere... i'm after the good stuff: > >smart data design >smart data planning >unique keys >taking advantage of relational databases >etc etc > >Justin French > >-- >PHP General Mailing List (http://www.php.net/) >To unsubscribe, e-mail: php-general-unsubscribelists.php.net >For additional commands, e-mail: php-general-helplists.php.net >To contact the list administrators, e-mail: php-list-adminlists.php.net

attached mail follows:

I recommend mysql.com , there annotated online manual is the db's :) shame i cant seem to find the annotated php manual !!

Neil ----- Original Message ----- > From: "Rick St Jean" <rstjeaninternet.look.ca> > To: <justinindent.com.au>; "php" <php-generallists.php.net> > Sent: Wednesday, March 14, 2001 2:00 AM > Subject: Re: [PHP] tutorials on good database design > > > > One of my co-worker has a phenominal book on sql. You will want something > > that covers the different > > type of joins... when to use them, as well as database normalization, > > reinforcing data integrity with > > foreign and primary keys. You will also want some transact sql in there > > and some indexing. There > > are many tutorials in stuff like phpbuilder.com. It is a good starting > place. > > > > Rick > > > > At 12:37 PM 3/14/01 +1100, Justin French wrote: > > >hi, > > > > > >i'm looking for some good tutorials / articles / books on database > > >design, no, i'm not talking about the classic employee contact database > > >that nearly every site has lingering somewhere... i'm after the good > stuff: > > > > > >smart data design > > >smart data planning > > >unique keys > > >taking advantage of relational databases > > >etc etc > > > > > >Justin French > > > > > >-- > > >PHP General Mailing List (http://www.php.net/) > > >To unsubscribe, e-mail: php-general-unsubscribelists.php.net > > >For additional commands, e-mail: php-general-helplists.php.net > > >To contact the list administrators, e-mail: php-list-adminlists.php.net > > > > ########################################################## > > # Rick St Jean, > > # rstjeaninternet.look.ca > > # President of Design Shark, > > # http://www.designshark.com/ > > # Quick Contact: http://www.designshark.com/messaging.ihtml > > # Tel: 905-684-2952 > > ########################################################## > > > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: php-general-unsubscribelists.php.net > > For additional commands, e-mail: php-general-helplists.php.net > > To contact the list administrators, e-mail: php-list-adminlists.php.net > > >

Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]