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:
        [EMAIL PROTECTED]

To unsubscribe from the digest, e-mail:
        [EMAIL PROTECTED]

To post to the list, e-mail:
        [EMAIL PROTECTED]


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


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:[EMAIL PROTECTED]]
Sent: Tuesday, March 13, 2001 6:58 AM
To: Angerer, Chad; 'Simon Garner'; Boget, Chris;
[EMAIL PROTECTED]
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 [EMAIL PROTECTED] 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:[EMAIL PROTECTED]]
> Sent: Monday, March 12, 2001 2:43 PM
> To: Boget, Chris; [EMAIL PROTECTED]
> Subject: Re: [PHP] Good Free PHP Editor?
>
>
> From: "Boget, Chris" <[EMAIL PROTECTED]>
>
>>> 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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]





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/> 
 




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
:-)




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 [EMAIL PROTECTED]
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)
> [EMAIL PROTECTED]
> www.phpbeginner.com
> 
> 
> 
> 
> -----Original Message-----
> From: Jens Nedal [mailto:[EMAIL PROTECTED]]
> Sent: Monday, March 12, 2001 7:24 PM
> To: [EMAIL PROTECTED]
> 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: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
> 
> 





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:[EMAIL PROTECTED]]
Sent: 13 March 2001 13:43
To: Rudolf Visagie
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP] Oracle error messages


Rudolf Visagie [[EMAIL PROTECTED]] 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
> [EMAIL PROTECTED]
> 
> 
> -- 
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]

-- 
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.

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




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
[EMAIL PROTECTED]

-----Original Message-----
From: Greig, Euan [mailto:[EMAIL PROTECTED]]
Sent: 13 March 2001 04:25
To: Hardy Merrill; Rudolf Visagie
Cc: [EMAIL PROTECTED]
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(...

-----Original Message-----
From: Hardy Merrill [mailto:[EMAIL PROTECTED]]
Sent: 13 March 2001 13:43
To: Rudolf Visagie
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP] Oracle error messages


Rudolf Visagie [[EMAIL PROTECTED]] 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
> [EMAIL PROTECTED]
> 
> 
> -- 
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]

-- 
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.

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




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
<[EMAIL PROTECTED]>.

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: [EMAIL PROTECTED]
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.





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






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

 [EMAIL PROTECTED]


""Scott Fletcher"" <[EMAIL PROTECTED]> wrote in message 
98lcdl$89d$[EMAIL PROTECTED]">news:98lcdl$89d$[EMAIL PROTECTED]...
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



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]






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)
 [EMAIL PROTECTED]
 www.phpbeginner.com




-----Original Message-----
From: Ide, Jim [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 13, 2001 10:15 PM
To: '[EMAIL PROTECTED]'
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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]






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)
 [EMAIL PROTECTED]
 www.phpbeginner.com




-----Original Message-----
From: John Meyer [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 13, 2001 10:47 PM
To: Jason Stechschulte
Cc: [EMAIL PROTECTED]
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:[EMAIL PROTECTED]]
Sent: Tuesday, March 13, 2001 6:38 AM
To: John Meyer
Cc: [EMAIL PROTECTED]
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.

<horridcode>
for($i = 0; $i < sizeof($privs); $i++) {
   $$privs[$i] = 1;
   session_register($privs[$i]);
}
</horridcode>


--
Jason Stechschulte
[EMAIL PROTECTED]
--
I surely do hope that's a syntax error.
             -- Larry Wall in <[EMAIL PROTECTED]>


--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]






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 ([EMAIL PROTECTED])
Web-developer at : www.TomDeeDom.com & www.Impression.nl

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





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 ([EMAIL PROTECTED])
> 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: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>





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.' ">
<!-- repeat as many times as you have frames -->
?>
</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.







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,
#  [EMAIL PROTECTED]
#  President of Design Shark,
#  http://www.designshark.com/
#  Quick Contact:  http://www.designshark.com/messaging.ihtml
#  Tel: 905-684-2952
##########################################################





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, [EMAIL PROTECTED] at
[EMAIL PROTECTED] 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:[EMAIL PROTECTED]]
> Sent: Thursday, March 08, 2001 3:10 PM
> To: [EMAIL PROTECTED]
> 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?
> 





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
[EMAIL PROTECTED]







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

/Fredrik

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

Mike <[EMAIL PROTECTED]> 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
> [EMAIL PROTECTED]




> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]




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"" <[EMAIL PROTECTED]> wrote in message 
98lff3$4ec$[EMAIL PROTECTED]">news:98lff3$4ec$[EMAIL PROTECTED]...
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
[EMAIL PROTECTED]




-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]








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.


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




On 13 Mar 2001 03:40:30 -0800, Joe Njeru <[EMAIL PROTECTED]> 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.




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/




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




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 [[EMAIL PROTECTED]] 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: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]




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

py

----- Original Message -----
From: Hardy Merrill <[EMAIL PROTECTED]>
To: Jordan Elver <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
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 [[EMAIL PROTECTED]] 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: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> > To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>





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 <[EMAIL PROTECTED]>
> To: Jordan Elver <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> 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 [[EMAIL PROTECTED]] 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: [EMAIL PROTECTED]
> > > For additional commands, e-mail: [EMAIL PROTECTED]
> > > To contact the list administrators, e-mail:
> > > [EMAIL PROTECTED]
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> > To contact the list administrators, e-mail: [EMAIL PROTECTED]




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








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>




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?




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:[EMAIL PROTECTED]>   .   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






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







----- Original Message -----
From: "Lasse Laurila" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
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





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
[EMAIL PROTECTED]
http://www.rosomm-partner.de






Aaron,

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

Joe

-----Ursprungliche Nachricht-----
Von: Aaron Tuller [mailto:[EMAIL PROTECTED]]
Gesendet: Dienstag, 13. Marz 2001 05:41
An: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
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:[EMAIL PROTECTED]]
>Gesendet: Montag, 12. Marz 2001 23:26
>An: [EMAIL PROTECTED]; [EMAIL PROTECTED]
>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: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>To contact the list administrators, e-mail: [EMAIL PROTECTED]


--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]





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
        [EMAIL PROTECTED]





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
[EMAIL PROTECTED]
760.753.6766
########################




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

 [EMAIL PROTECTED]



"Nicole Lallande" <[EMAIL PROTECTED]> wrote in message 
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
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
[EMAIL PROTECTED]
760.753.6766
########################

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]






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
[EMAIL PROTECTED]






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






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





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: [EMAIL PROTECTED]
Phone: 816.210.7145
Fax: 816.753.1952

-----Original Message-----
From: John Donagher [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 13, 2001 9:31 AM
To: Dan Harrington
Cc: [EMAIL PROTECTED]
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)&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


--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]






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: [EMAIL PROTECTED]
Phone: 816.210.7145
Fax: 816.753.1952

-----Original Message-----
From: John Donagher [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 13, 2001 9:31 AM
To: Dan Harrington
Cc: [EMAIL PROTECTED]
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)&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


--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]






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:[EMAIL PROTECTED]]
> Sent: Tuesday, March 13, 2001 12:26 PM
> To: John Donagher; Dan Harrington
> Cc: [EMAIL PROTECTED]
> 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: [EMAIL PROTECTED]
> Phone: 816.210.7145
> Fax: 816.753.1952
>
> -----Original Message-----
> From: John Donagher [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, March 13, 2001 9:31 AM
> To: Dan Harrington
> Cc: [EMAIL PROTECTED]
> 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: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>





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: [EMAIL PROTECTED]
Phone: 816.210.7145
Fax: 816.753.1952

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


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:[EMAIL PROTECTED]]
> Sent: Tuesday, March 13, 2001 12:26 PM
> To: John Donagher; Dan Harrington
> Cc: [EMAIL PROTECTED]
> 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: [EMAIL PROTECTED]
> Phone: 816.210.7145
> Fax: 816.753.1952
>
> -----Original Message-----
> From: John Donagher [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, March 13, 2001 9:31 AM
> To: Dan Harrington
> Cc: [EMAIL PROTECTED]
> 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: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>


--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]







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:[EMAIL PROTECTED]]
> > Sent: Tuesday, March 13, 2001 12:26 PM
> > To: John Donagher; Dan Harrington
> > Cc: [EMAIL PROTECTED]
> > 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: [EMAIL PROTECTED]
> > Phone: 816.210.7145
> > Fax: 816.753.1952
> >
> > -----Original Message-----
> > From: John Donagher [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, March 13, 2001 9:31 AM
> > To: Dan Harrington
> > Cc: [EMAIL PROTECTED]
> > 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: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> > To contact the list administrators, e-mail: [EMAIL PROTECTED]
> >
> >
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> > To contact the list administrators, e-mail: [EMAIL PROTECTED]
> >
> 
> 
> 

-- 

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





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: [EMAIL PROTECTED]
Phone: 816.210.7145
Fax: 816.753.1952

-----Original Message-----
From: John Donagher [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 13, 2001 9:54 AM
To: Dan Harrington
Cc: Robert Covell; [EMAIL PROTECTED]
Subject: RE: [PHP] Payflow Pro



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:[EMAIL PROTECTED]]
> > Sent: Tuesday, March 13, 2001 12:26 PM
> > To: John Donagher; Dan Harrington
> > Cc: [EMAIL PROTECTED]
> > 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: [EMAIL PROTECTED]
> > Phone: 816.210.7145
> > Fax: 816.753.1952
> >
> > -----Original Message-----
> > From: John Donagher [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, March 13, 2001 9:31 AM
> > To: Dan Harrington
> > Cc: [EMAIL PROTECTED]
> > 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: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> > To contact the list administrators, e-mail: [EMAIL PROTECTED]
> >
> >
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> > To contact the list administrators, e-mail: [EMAIL PROTECTED]
> >
>
>
>

--

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







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





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: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>To contact the list administrators, e-mail: [EMAIL PROTECTED]

##########################################################
#  Rick St Jean,
#  [EMAIL PROTECTED]
#  President of Design Shark,
#  http://www.designshark.com/
#  Quick Contact:  http://www.designshark.com/messaging.ihtml
#  Tel: 905-684-2952
##########################################################





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: [EMAIL PROTECTED]
Phone: 816.210.7145
Fax: 816.753.1952

-----Original Message-----
From: Dan Harrington [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 13, 2001 4:41 PM
To: [EMAIL PROTECTED]
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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]







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 |
| [EMAIL PROTECTED]     403-291-2770, 403-259-6795 (fax)            |
\====================================================================/




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/





In article <[EMAIL PROTECTED]>,
 [EMAIL PROTECTED] (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




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
[EMAIL PROTECTED]







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

Jerry Lake            - [EMAIL PROTECTED]
Web Designer
Europa Communications - http://www.europa.com
Pacifier Online     - http://www.pacifier.com


-----Original Message-----
From: Jordan Elver [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 13, 2001 12:13 PM
To: Pierre-Yves Lemaire
Cc: [EMAIL PROTECTED]
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

On Tuesday 13 March 2001 12:35, you wrote:
> check out,
> dirname() // Returns directory name component of path
>
> py
>
> ----- Original Message -----
> From: Hardy Merrill <[EMAIL PROTECTED]>
> To: Jordan Elver <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> 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 [[EMAIL PROTECTED]] 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: [EMAIL PROTECTED]
> > > For additional commands, e-mail: [EMAIL PROTECTED]
> > > To contact the list administrators, e-mail:
> > > [EMAIL PROTECTED]
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> > To contact the list administrators, e-mail: [EMAIL PROTECTED]

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]






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            - [EMAIL PROTECTED]
Web Designer
Europa Communications - http://www.europa.com
Pacifier Online     - http://www.pacifier.com


-----Original Message-----
From: Jerry Lake [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 13, 2001 12:36 PM
To: [EMAIL PROTECTED]
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            - [EMAIL PROTECTED]
Web Designer
Europa Communications - http://www.europa.com
Pacifier Online     - http://www.pacifier.com


-----Original Message-----
From: Jordan Elver [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 13, 2001 12:13 PM
To: Pierre-Yves Lemaire
Cc: [EMAIL PROTECTED]
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

On Tuesday 13 March 2001 12:35, you wrote:
> check out,
> dirname() // Returns directory name component of path
>
> py
>
> ----- Original Message -----
> From: Hardy Merrill <[EMAIL PROTECTED]>
> To: Jordan Elver <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> 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 [[EMAIL PROTECTED]] 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: [EMAIL PROTECTED]
> > > For additional commands, e-mail: [EMAIL PROTECTED]
> > > To contact the list administrators, e-mail:
> > > [EMAIL PROTECTED]
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> > To contact the list administrators, e-mail: [EMAIL PROTECTED]

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]



--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]






-----Original Message-----
From: Jerry Lake [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 13, 2001 9:55 PM
To: [EMAIL PROTECTED]
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





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/





-----Original Message-----
From: Aviv Revach [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 12, 2001 10:01 PM
To: [EMAIL PROTECTED]
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





----- Original Message -----
From: "Aviv Revach" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
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





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

Regards
Martin Cameron





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: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]





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 [[EMAIL PROTECTED]] 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: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> > To contact the list administrators, e-mail: [EMAIL PROTECTED]
> 
> 
> -- 
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]




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
[EMAIL PROTECTED]
800-994-6364
www.webintellects.com
--------------------------------------------





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
> [EMAIL PROTECTED]
> 800-994-6364
> www.webintellects.com
> --------------------------------------------
> 
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]





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.






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)
([EMAIL PROTECTED]         Systems Engineer II)
([EMAIL PROTECTED]                   Network Operations)
<-----Enthalpy.org-------------http://enthalpy.org----->
([EMAIL PROTECTED]             The World of Nothing)
<------------------------------------------------------>






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 :}

<-----CoreComm-Internet-Services---http://core.com----->
(Jon Marshall                 CoreComm Services Chicago)
([EMAIL PROTECTED]         Systems Engineer II)
([EMAIL PROTECTED]                   Network Operations)
<-----Enthalpy.org-------------http://enthalpy.org----->
([EMAIL PROTECTED]             The World of Nothing)
<------------------------------------------------------>

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)
> ([EMAIL PROTECTED]         Systems Engineer II)
> ([EMAIL PROTECTED]                   Network Operations)
> <-----Enthalpy.org-------------http://enthalpy.org----->
> ([EMAIL PROTECTED]             The World of Nothing)
> <------------------------------------------------------>
> 
> 
> -- 
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
> 
> 





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            - [EMAIL PROTECTED]
Web Designer
Europa Communications - http://www.europa.com
Pacifier Online     - http://www.pacifier.com





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/





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:[EMAIL PROTECTED]]
Sent: Monday, March 12, 2001 4:15 PM
To: [EMAIL PROTECTED]
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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




  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





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)
([EMAIL PROTECTED]         Systems Engineer II)
([EMAIL PROTECTED]                   Network Operations)
<-----Enthalpy.org-------------http://enthalpy.org----->
([EMAIL PROTECTED]             The World of Nothing)
<------------------------------------------------------>





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)
>([EMAIL PROTECTED]         Systems Engineer II)
>([EMAIL PROTECTED]                   Network Operations)
><-----Enthalpy.org-------------http://enthalpy.org----->
>([EMAIL PROTECTED]             The World of Nothing)
><------------------------------------------------------>
>
>
>--
>PHP General Mailing List (http://www.php.net/)
>To unsubscribe, e-mail: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>To contact the list administrators, e-mail: [EMAIL PROTECTED]


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





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" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
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)
> ([EMAIL PROTECTED]         Systems Engineer II)
> ([EMAIL PROTECTED]                   Network Operations)
> <-----Enthalpy.org-------------http://enthalpy.org----->
> ([EMAIL PROTECTED]             The World of Nothing)
> <------------------------------------------------------>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>






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

<-----CoreComm-Internet-Services---http://core.com----->
(Jon Marshall                 CoreComm Services Chicago)
([EMAIL PROTECTED]         Systems Engineer II)
([EMAIL PROTECTED]                   Network Operations)
<-----Enthalpy.org-------------http://enthalpy.org----->
([EMAIL PROTECTED]             The World of Nothing)
<------------------------------------------------------>

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" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> 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)
> > ([EMAIL PROTECTED]         Systems Engineer II)
> > ([EMAIL PROTECTED]                   Network Operations)
> > <-----Enthalpy.org-------------http://enthalpy.org----->
> > ([EMAIL PROTECTED]             The World of Nothing)
> > <------------------------------------------------------>
> >
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> > To contact the list administrators, e-mail: [EMAIL PROTECTED]
> >
> >
> 
> 
> -- 
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
> 
> 





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




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, [EMAIL PROTECTED] 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: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>To contact the list administrators, e-mail: [EMAIL PROTECTED]

##########################################################
#  Rick St Jean,
#  [EMAIL PROTECTED]
#  President of Design Shark,
#  http://www.designshark.com/
#  Quick Contact:  http://www.designshark.com/messaging.ihtml
#  Tel: 905-684-2952
##########################################################





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:[EMAIL PROTECTED]]
Sent: Tuesday, March 13, 2001 3:56 PM
To: [EMAIL PROTECTED]
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



At 06:31 PM 3/13/01 -0500, [EMAIL PROTECTED] 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: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>To contact the list administrators, e-mail: [EMAIL PROTECTED]

##########################################################
#  Rick St Jean,
#  [EMAIL PROTECTED]
#  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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]





>>>>> "YO" == Yasuo Ohgaki <[EMAIL PROTECTED]> writes:

    YO> ----- Original Message -----
    YO> From: "Chung Ha-Nyung" <[EMAIL PROTECTED]>
    YO> To: <[EMAIL PROTECTED]>
    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 <[EMAIL PROTECTED]>





 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 <[EMAIL PROTECTED]>




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.




In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] (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




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: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]





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






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 ??

py





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









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




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: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
> 




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:

> 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: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]





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: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]




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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>To contact the list administrators, e-mail: [EMAIL PROTECTED]
>






> 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
[EMAIL PROTECTED]
Web Design Team, Melbourne IT
Fetch the comfy chair!




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: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>To contact the list administrators, e-mail: [EMAIL PROTECTED]

##########################################################
#  Rick St Jean,
#  [EMAIL PROTECTED]
#  President of Design Shark,
#  http://www.designshark.com/
#  Quick Contact:  http://www.designshark.com/messaging.ihtml
#  Tel: 905-684-2952
##########################################################






 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" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>; "php" <[EMAIL PROTECTED]>
> 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: [EMAIL PROTECTED]
> > >For additional commands, e-mail: [EMAIL PROTECTED]
> > >To contact the list administrators, e-mail:
[EMAIL PROTECTED]
> >
> > ##########################################################
> > #  Rick St Jean,
> > #  [EMAIL PROTECTED]
> > #  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: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> > To contact the list administrators, e-mail: [EMAIL PROTECTED]
> >
>



Reply via email to