php-windows Digest 19 Dec 2001 11:05:33 -0000 Issue 908
Topics (messages 10991 through 11004):
Has anyone figured out the Access slash problems?
10991 by: Asendorf, John
search form doesn't work fine
10992 by: Afan Pasalic
10993 by: Afan Pasalic
10995 by: George Nicolae
permanent connections to mysql with php under windows
10994 by: Tekin Suleyman
10999 by: Phillip Oertel
Re: PHP 4.0.6 on Apache 2.0.28
10996 by: Jeffery Seiffert
Session question
10997 by: Rconover.americanbridge.net
11003 by: Michael Sims
closing an ODBC connection to mysql
10998 by: ben
11000 by: George Nicolae
11001 by: Asendorf, John
11002 by: Asendorf, John
ISAPI and 4.1 on IIS 5.0
11004 by: Andres Petralli
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]
----------------------------------------------------------------------
--- Begin Message ---
I am trying to use MySQL on a new projest, but I have a number of Access
databases which seem to get confused with only runtime magic quotes on...
I've turned off GPC and sybase style magic quotes but have broken roughly
half of the Access db apps...
The more I look at it, the more it confuses me.
The two things I'm doing that are causing problems, 1) entering data into
them via ODBC from form entries, 2) retreiving that data and formating it
into web pages...
\' \\\' \" \\\"
I've been trying the AccessAddSlashes workaround but I must be using it
incorrectly, because that doesn't seem to be helping either.
Anyone?
John
---------------------
John Asendorf - [EMAIL PROTECTED]
Web Applications Developer
http://www.lcounty.com - NEW FEATURES ADDED DAILY!
Licking County, Ohio, USA
740-349-3631
Nullum magnum ingenium sine mixtura dementiae fuit
--- End Message ---
--- Begin Message ---
Hi people,
question is not 100% related to PHP but I hope somebody can help me:
I created form to search through site (PHP/MySQL) but if you click enter button -
nothing's happened. If you click "Search" (submit) button - script works fine.
Any clue?
Thanks for any help.
Afan
--- End Message ---
--- Begin Message ---
Me, again. Found mistake. It is PHP related:
Script:
if($SubmitSearch)
{
// Show results!
}
?>
<form method="post" action="<?php echo $PATH_INFO; ?>">
<b>Search by:</b><br><br>
season:<br>
<select name="SearchBySeason" size=1 style="font-size: 10px;">
<option value=0 SELECTED>Search by Season</option>
<option value=3>Season 3</option>
<option value=2>Season 2</option>
<option value=1>Season 1</option>
</select><br><br>
or by keyword:<br>
<input type=Text name=SearchByKeyword size=22><br><br>
<input type="Submit" name="SubmitSearch" value="Search" style="font-size:
10px;"><br><br>
</form>
If you click on enter button - var $SubmitSearch doesn't get any value
GOTCHA!
Afan
----- Original Message -----
From: Afan Pasalic
To: [EMAIL PROTECTED]
Sent: Tuesday, December 18, 2001 12:57 PM
Subject: [PHP-WIN] search form doesn't work fine
Hi people,
question is not 100% related to PHP but I hope somebody can help me:
I created form to search through site (PHP/MySQL) but if you click enter button -
nothing's happened. If you click "Search" (submit) button - script works fine.
Any clue?
Thanks for any help.
Afan
--- End Message ---
--- Begin Message ---
I have the same problme. i think is a bug in php.i do the follow:
1. i make one more option <option value=""></option> that i leave empty
2. in action file I verify if (!empty(SearchBySeason)) not if
($SubmitSearch)
It works!
--
Best regards,
George Nicolae
IT Manager
___________________
X-Playin - Professional Web Design
www.x-playin.f2s.com
"Afan Pasalic" <[EMAIL PROTECTED]> wrote in message
005701c187ee$8e02f810$311f49d1@VAIO">news:005701c187ee$8e02f810$311f49d1@VAIO...
Me, again. Found mistake. It is PHP related:
Script:
if($SubmitSearch)
{
// Show results!
}
?>
<form method="post" action="<?php echo $PATH_INFO; ?>">
<b>Search by:</b><br><br>
season:<br>
<select name="SearchBySeason" size=1 style="font-size: 10px;">
<option value=0 SELECTED>Search by Season</option>
<option value=3>Season 3</option>
<option value=2>Season 2</option>
<option value=1>Season 1</option>
</select><br><br>
or by keyword:<br>
<input type=Text name=SearchByKeyword size=22><br><br>
<input type="Submit" name="SubmitSearch" value="Search" style="font-size:
10px;"><br><br>
</form>
If you click on enter button - var $SubmitSearch doesn't get any value
GOTCHA!
Afan
----- Original Message -----
From: Afan Pasalic
To: [EMAIL PROTECTED]
Sent: Tuesday, December 18, 2001 12:57 PM
Subject: [PHP-WIN] search form doesn't work fine
Hi people,
question is not 100% related to PHP but I hope somebody can help me:
I created form to search through site (PHP/MySQL) but if you click enter
button - nothing's happened. If you click "Search" (submit) button - script
works fine.
Any clue?
Thanks for any help.
Afan
--- End Message ---
--- Begin Message ---
hi, didn;t get any replies to my last post, maybe someone can help with this
one.
when ever i try and make a permanent connection to my mysql database on my
windows2000, apache server, i get the following warning:
Warning: Unknown persistent list entry type in module shutdown (11) in
Unknown on line 0
i don't get any warning with non-permenent connections, or when i run the
same code on a linux server. any ideas?
tekin
--- End Message ---
--- Begin Message ---
Tekin Suleyman wrote:
> when ever i try and make a permanent connection to my mysql database on my
> windows2000, apache server, i get the following warning:
>
> Warning: Unknown persistent list entry type in module shutdown (11) in
> Unknown on line 0
i asked the same question in php.general on 12/16/01 and John Lim responded:
"This is a known bug with persistent database connections. Switching to
non-persistent connections or ISAPI avoids this problem."
you could also set your error_reporting to E_ERROR if you know what
you're doing. not recommended while developing !
phil.
--- End Message ---
--- Begin Message ---
I could not get the php4apache.dll module to work either. Using the CGI
binary method of php works. If you have the PHP Manual PDF it is on page 46
of Chapter 2 Installation
Hope this helps
"Alek Andreev" <[EMAIL PROTECTED]> wrote in message
000201c17c24$1f8ac6e0$55404850@juno">news:000201c17c24$1f8ac6e0$55404850@juno...
> Hi!
>
> I installed Apache 2.0.28 and tried to install PHP 4.0.6 on it, but it
> said it "can't find the php4apache.dll module". (It worked fine on
> Apache 1.3.x)
> What should I do? Is there a special module for apache 2 and where can I
> get it?
>
> _____
>
> Regards,
> Alek Andreev
> [EMAIL PROTECTED]
> Homepage <http://www.neophode.f2s.com/>
> ICQ UIN: 46504242
>
>
--- End Message ---
--- Begin Message ---
I was wondering how I can stop the following message from posting when a
user hits the back button when I am using sessions?
Ryan Conover
[EMAIL PROTECTED]
[EMAIL PROTECTED]
http://www.pitt.edu/~rscst25/
--- End Message ---
--- Begin Message ---
At 05:02 PM 12/18/2001 -0500, [EMAIL PROTECTED] wrote:
>I was wondering how I can stop the following message from posting when a
>user hits the back button when I am using sessions?
Look for this section in your php.ini:
; Set to {nocache,private,public} to determine HTTP caching aspects.
session.cache_limiter = nocache
Set it to an empty string, like this:
session.cache_limiter =
And restart IIS/Apache/whatever. This makes the "page has expired" message
come up much less frequently. It still comes up if the last POST action
included a file upload, however...
I haven't personally ran across any ill effects from unsetting that option,
but there might be. I haven't investigated it thoroughly yet. You have
been warned. :)
--- End Message ---
--- Begin Message ---
Hello
I've installed mysql and php on W2K with IIS5.0 and I'm having some trouble
closing my connection, which is established via odbc.
I have been using the following php code to connect:
$link = odbc_connect("forum", "ben", "dulwich")
or die("Could not connect");
print "Connected successfully";
This connects successfully. I then execute my query, which returns a result.
All is fine so far.
Unfortunately, when I come to close the connection, I have a problem:
mysql_free_result ($result);
print "Connection about to be closed";
// Closing connection
odbc_close($link)
or die ("connection not closed");
It always prints "connection not closed". Is this because the connection is
not closing, or simply that the "or die" option is not applicable for the
statement "odbc_close()"? I've read the manual and been through tutorials
etc but haven't found any conclusive answers on this, and I'd be gratefull
for any help!
Thanks very much in advance.
Ben
--- End Message ---
--- Begin Message ---
odbc_close($link) is a void function. didn't return anything. look in
documentation at odbc_close();
--
Best regards,
George Nicolae
IT Manager
___________________
X-Playin - Professional Web Design
www.x-playin.f2s.com
"Ben" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Hello
>
> I've installed mysql and php on W2K with IIS5.0 and I'm having some
trouble
> closing my connection, which is established via odbc.
>
> I have been using the following php code to connect:
>
> $link = odbc_connect("forum", "ben", "dulwich")
> or die("Could not connect");
> print "Connected successfully";
>
>
>
> This connects successfully. I then execute my query, which returns a
result.
> All is fine so far.
>
> Unfortunately, when I come to close the connection, I have a problem:
>
> mysql_free_result ($result);
>
> print "Connection about to be closed";
> // Closing connection
> odbc_close($link)
> or die ("connection not closed");
> It always prints "connection not closed". Is this because the connection
is
> not closing, or simply that the "or die" option is not applicable for the
> statement "odbc_close()"? I've read the manual and been through tutorials
> etc but haven't found any conclusive answers on this, and I'd be gratefull
> for any help!
>
> Thanks very much in advance.
>
> Ben
>
>
--- End Message ---
--- Begin Message ---
I know this may not be very helpful, but is there a reason you're not using
the native MySQL calls or adodb?
In the meantime, have you tried:
if ( !odbc_close($link) ) {
die ("connection not closed");
}
---------------------
John Asendorf - [EMAIL PROTECTED]
Web Applications Developer
http://www.lcounty.com - NEW FEATURES ADDED DAILY!
Licking County, Ohio, USA
740-349-3631
Nullum magnum ingenium sine mixtura dementiae fuit
> -----Original Message-----
> From: ben [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, December 18, 2001 6:40 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP-WIN] closing an ODBC connection to mysql
>
>
> Hello
>
> I've installed mysql and php on W2K with IIS5.0 and I'm
> having some trouble
> closing my connection, which is established via odbc.
>
> I have been using the following php code to connect:
>
> $link = odbc_connect("forum", "ben", "dulwich")
> or die("Could not connect");
> print "Connected successfully";
>
>
>
> This connects successfully. I then execute my query, which
> returns a result.
> All is fine so far.
>
> Unfortunately, when I come to close the connection, I have a problem:
>
> mysql_free_result ($result);
>
> print "Connection about to be closed";
> // Closing connection
> odbc_close($link)
> or die ("connection not closed");
> It always prints "connection not closed". Is this because the
> connection is
> not closing, or simply that the "or die" option is not
> applicable for the
> statement "odbc_close()"? I've read the manual and been
> through tutorials
> etc but haven't found any conclusive answers on this, and I'd
> be gratefull
> for any help!
>
> Thanks very much in advance.
>
> Ben
>
>
>
> --
> PHP Windows 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]
>
--- End Message ---
--- Begin Message ---
nevermind... I guess it's a void function... someone had a better answer
before I could type mine... :(
---------------------
John Asendorf - [EMAIL PROTECTED]
Web Applications Developer
http://www.lcounty.com - NEW FEATURES ADDED DAILY!
Licking County, Ohio, USA
740-349-3631
Nullum magnum ingenium sine mixtura dementiae fuit
> -----Original Message-----
> From: Asendorf, John [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, December 18, 2001 6:53 PM
> To: ben; Php-Windows (E-mail)
> Subject: RE: [PHP-WIN] closing an ODBC connection to mysql
>
>
> I know this may not be very helpful, but is there a reason
> you're not using
> the native MySQL calls or adodb?
>
> In the meantime, have you tried:
>
> if ( !odbc_close($link) ) {
>
> die ("connection not closed");
>
> }
>
> ---------------------
> John Asendorf - [EMAIL PROTECTED]
> Web Applications Developer
> http://www.lcounty.com - NEW FEATURES ADDED DAILY!
> Licking County, Ohio, USA
> 740-349-3631
> Nullum magnum ingenium sine mixtura dementiae fuit
>
>
> > -----Original Message-----
> > From: ben [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, December 18, 2001 6:40 PM
> > To: [EMAIL PROTECTED]
> > Subject: [PHP-WIN] closing an ODBC connection to mysql
> >
> >
> > Hello
> >
> > I've installed mysql and php on W2K with IIS5.0 and I'm
> > having some trouble
> > closing my connection, which is established via odbc.
> >
> > I have been using the following php code to connect:
> >
> > $link = odbc_connect("forum", "ben", "dulwich")
> > or die("Could not connect");
> > print "Connected successfully";
> >
> >
> >
> > This connects successfully. I then execute my query, which
> > returns a result.
> > All is fine so far.
> >
> > Unfortunately, when I come to close the connection, I have
> a problem:
> >
> > mysql_free_result ($result);
> >
> > print "Connection about to be closed";
> > // Closing connection
> > odbc_close($link)
> > or die ("connection not closed");
> > It always prints "connection not closed". Is this because the
> > connection is
> > not closing, or simply that the "or die" option is not
> > applicable for the
> > statement "odbc_close()"? I've read the manual and been
> > through tutorials
> > etc but haven't found any conclusive answers on this, and I'd
> > be gratefull
> > for any help!
> >
> > Thanks very much in advance.
> >
> > Ben
> >
> >
> >
> > --
> > PHP Windows 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 Windows 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]
>
--- End Message ---
--- Begin Message ---
Hi everyone,
I was wondering wheter it is now safe to use the ISAPI module of 4.1 on
an IIS 5.0 server? I tried it with 4.0.2 and had consistent problems
because of some thread issues (I think at least). Also, in the past I've
always been discouraged from using the ISAPI filter, since it was held
to be unstable. Is this now resolved with 4.1?
Greets,
Andres
--
Andres Petralli, Arpanet AG
Steinengraben 18, 4002 Basel, Switzerland
Tel: +41 (0)61 276 96 60, Fax: +41 (0)61 276 96 66
http://www.arpanet.ch/
PGP: CDD7 E772 D14B 407A 4343 6901 74A5 A74D AE98 6BE4
--- End Message ---
