php-windows Digest 26 Oct 2004 20:11:08 -0000 Issue 2441
Topics (messages 24809 through 24819):
Re: CGI binary vs. ISAPI module
24809 by: Sudeep
mysql question
24810 by: Patrick Roane
24811 by: Luis Moreira
Re: Cookies!
24812 by: Nunners
Problems installing PHP on IIS 6?
24813 by: Murray . PlanetThoughtful
24814 by: Bowden, Zeb
24815 by: Murray . PlanetThoughtful
Re: Changing loaction of php.ini file
24816 by: Jason Barnett
Re: Question......
24817 by: Jason Barnett
Re: Access deined - yet another MySQL problem
24818 by: Jason Barnett
zip_enrty_read fails to return data
24819 by: Matthew Richardson
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 ---
Hi chris,
Please don't use PWS to work with php. It's a total mess. Session and cookies wont
work. I am telling this from my experience. First i tried PWS for my php scripts with
CGI binary mode. Later, after consultations and advise from my online friends i
decided to move away and opted for apache web server which is free and fast. I went
for manual installation (separately) for apache 1.3 , php 4.8(zip), and MySQl 4. It
works fine now. But there are installation kits...that installs everything(php,apache,
mysql,phpmyadmin...) which are available now. Few of them can be found here......in
this link:
http://www.hotscripts.com/PHP/Software_and_Servers/Installation_Kits/
Try it....
....SuDeEp....
Chris Ollar <[EMAIL PROTECTED]> wrote:
I'm brand new to PHP. Which is a better method to use for attaching and
running PHP scripts on a PWS for Win 98? CGI binary or ISAPI module
My ultimate goal is to impliment an attendance database using PHP and MySQL.
Thanks to all in advance.
-chris
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
---------------------------------
Do you Yahoo!?
Yahoo! Mail - You care about security. So do we.
--- End Message ---
--- Begin Message ---
I am learning the mysql basics and was wondering what
I'm doing wrong. I'm using the MySQL.exe console to
create a simple table, but I keep getting these syntax
errors.
All I'm doing is typing the code and than pressing
enter. Is there more I have to do? Here is my code:
CREAT TABLE phonelist(
id INT PRIMARY KEY,
firstName VARCHAR(15),
lastName VARCHAR(15),
email VARCHAR(20),
phone VARCHAR(15)
);
thanks-
=====
----------------
"forget your lust for the rich man's gold. All that you need, is in your soul. You can
do this if you try. All that I want for you my son, is to be satisfied"
~ Lynard Skynard
--- End Message ---
--- Begin Message ---
Nothing wrong, besides missing a character.
I tried your instructions with the full word CREATE and it worked fine...
Luis
Patrick Roane wrote:
I am learning the mysql basics and was wondering what
I'm doing wrong. I'm using the MySQL.exe console to
create a simple table, but I keep getting these syntax
errors.
All I'm doing is typing the code and than pressing
enter. Is there more I have to do? Here is my code:
CREAT TABLE phonelist(
id INT PRIMARY KEY,
firstName VARCHAR(15),
lastName VARCHAR(15),
email VARCHAR(20),
phone VARCHAR(15)
);
thanks-
=====
----------------
"forget your lust for the rich man's gold. All that you need, is in your soul. You can do
this if you try. All that I want for you my son, is to be satisfied"
~ Lynard Skynard
--- End Message ---
--- Begin Message ---
Hi Dale,
Sorry for emailing you again (and anyone else who can help) - but I'm
getting a bit desperate!
I've got to finish this project today - 2 hours to go!!!!
I need to sort out the user authentication into the application - I'm using
IIS & PHP5 - which is proving a bit of a nightmare. I've decided cookies
are a no go, because of the cookie problems with IIS... so sessions it is!
However, I've looked at all sorts of things on the net, and can't find
anything that will help me write an user authentication setup for my web
pages....
Please please please can someone assist me!
Thanks
James
> -----Original Message-----
> From: Dale Attree [mailto:[EMAIL PROTECTED]
> Sent: 12 October 2004 18:23
> To: Nunners
> Subject: RE: [PHP-WIN] Cookies!
>
> Yes, same concept, different implementation.
>
> -----Original Message-----
> From: Nunners [mailto:[EMAIL PROTECTED]
> Sent: 12 October 2004 16:34
> To: [EMAIL PROTECTED]
> Subject: RE: [PHP-WIN] Cookies!
>
>
> Could I also do this, using a link to mysql instead of the file? If so,
> then this might be a good option?!!!
>
> Cheers
> Nunners
>
> > -----Original Message-----
> > From: Dale Attree [mailto:[EMAIL PROTECTED]
> > Sent: 12 October 2004 14:52
> > To: Nunners
> > Subject: RE: [PHP-WIN] Cookies!
> >
> > You can always use sessions in conjunction with file handling, where you
> > create a file using the username as the filename, storing all your
> > previous
> > cookie information in the file as well as an expiration date and the
> have
> > a
> > default access function that loads the file's content into the global
> > session array and verifies the remaining time of the user.
> >
> > -----Original Message-----
> > From: Nunners [mailto:[EMAIL PROTECTED]
> > Sent: 11 October 2004 10:27
> > To: 'Sudeep Zamudra'
> > Cc: [EMAIL PROTECTED]
> > Subject: RE: [PHP-WIN] Cookies!
> >
> >
> > If I'm going to use sessions, I understand how to start them etc, but is
> > it
> > possible to have them "alive" for 24 hours?
> >
> > With the cookies, I was able to, once the user logged in, keep them
> logged
> > in for 24 hours.
> >
> > As it's an application we are providing for our customers, one of the
> > things
> > I'm able to stipulate is that they have IE6 & Cookies turned on!
> >
> > Any thoughts?
> >
> > Cheers
> > James
> >
> > > -----Original Message-----
> > > From: Sudeep Zamudra [mailto:[EMAIL PROTECTED]
> > > Sent: 09 October 2004 09:14
> > > To: James Nunnerley
> > > Cc: [EMAIL PROTECTED]
> > > Subject: Re: [PHP-WIN] Cookies!
> > >
> > > Hi James,
> > >
> > > Php on IIS or PWS are known to have problems with session
> > and
> > > cookie. Try using session instead of cookie. That's the safest way.
> Also
> > > anyone can disable cookies on the client side where by your login
> > > authentcation may fail. So best way is use session instead of cookie.
> > For
> > > details pls refer "php session handling" in the php Manual.
> > >
> > > ....SuDeEp....
> > >
> > > James Nunnerley <[EMAIL PROTECTED]> wrote:
> > > I'm trying to create a simple login script for user to the web
> > application
> > > I'm
> > > writing. I previously wrote it for using PHP4 & Apache, however I've
> > > recently
> > > had to move to IIS5, and also upgraded to PHP5.
> > > [script]
> > > if (isset($_POST["username"]) AND isset($_POST["password"])) {
> > > $res=mysql_query('SELECT username, password, agent_id FROM user where
> > > username="'.$_POST["username"].'"');
> > > if (mysql_num_rows($res)==0) {
> > > $message="Username does not exist.";
> > > } elseif (mysql_num_rows($res)==1) {
> > > while ($user=mysql_fetch_array($res)) {
> > > if (strtolower($user["password"])!=strtolower($_POST["password"])) {
> > > $message="Incorrect Password.";
> > > } else {
> > > setcookie("username",$user["username"],time()+31449600,"/");
> > > setcookie("agent_ID",$user["agent_id"],time()+31449600,"/");
> > > setcookie("logged_in",time(),time()+60*60*12,"/");
> > > header("Location: http://".$_SERVER["HTTP_HOST"]."/";);
> > > exit;
> > > }
> > > }
> > > }
> > > }
> > > [/script]
> > >
> > > The above works fine on Apache, but on IIS, it would seem no cookie is
> > > set.
> > > I've found something suggesting I change php.exe to nph-php.exe - is
> > this
> > > true,
> > > does it work - it seems a little drastic - is there another way around
> > it?
> > >
> > > Cheers as ever
> > > Nunners
> > >
> > > --
> > > PHP Windows Mailing List (http://www.php.net/)
> > > To unsubscribe, visit: http://www.php.net/unsub.php
> > >
> > >
> > > __________________________________________________
> > > Do You Yahoo!?
> > > Tired of spam? Yahoo! Mail has the best spam protection around
> > > http://mail.yahoo.com
> >
> > --
> > PHP Windows Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
> >
> >
> >
>
>
>
>
>
>
--- End Message ---
--- Begin Message ---
Hi All,
I'm having problems getting PHP 4.3.9 working in either ISAPI or CGI mode
with IIS 6.0. I've consulted various 'how to install PHP with IIS' pages and
followed what instructions I've found, but without any luck.
My current attempt it to get CGI working.
In my various attempts to get this working I have:
- copied php4ts.dll to \windows\system32
- copied php.ini to \windows
- edited php.ini to set cgi.force_redirect = 0
- assigned both my administrator and anonymous internet users full
rights to php.exe
- confirmed that when I'm attempting to run a php script that it is
in the root of the site and should be available
- stopped and restarted the IIS service at each step to make sure
that changes are enabled
No matter what I do, the server doesn't appear to want to recognize php
files. It will serve .htm and .asp files without any problems, but gives me
a 'The page cannot be found' (404) error whenever I try to run a php file
through the browser. PHP -I in a command browser returns the phpinfo values
as expected.
Anyone have any suggestions? I'm somewhat at the end of my rope here. Truly,
any help appreciated.
Much warmth,
Murray
<http://www.planetthoughtful.org/> http://www.planetthoughtful.org
Building a thoughtful planet,
One quirky comment at a time.
--- End Message ---
--- Begin Message ---
Have you added PHP as a web service extension? And what about adding it
as an application extension? (Home Directory -> Configuration)
-----Original Message-----
From: Murray @ PlanetThoughtful [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 26, 2004 12:43 PM
To: [EMAIL PROTECTED]
Subject: [PHP-WIN] Problems installing PHP on IIS 6?
Hi All,
I'm having problems getting PHP 4.3.9 working in either ISAPI or CGI
mode
with IIS 6.0. I've consulted various 'how to install PHP with IIS' pages
and
followed what instructions I've found, but without any luck.
My current attempt it to get CGI working.
In my various attempts to get this working I have:
- copied php4ts.dll to \windows\system32
- copied php.ini to \windows
- edited php.ini to set cgi.force_redirect = 0
- assigned both my administrator and anonymous internet users
full
rights to php.exe
- confirmed that when I'm attempting to run a php script that
it is
in the root of the site and should be available
- stopped and restarted the IIS service at each step to make
sure
that changes are enabled
No matter what I do, the server doesn't appear to want to recognize php
files. It will serve .htm and .asp files without any problems, but gives
me
a 'The page cannot be found' (404) error whenever I try to run a php
file
through the browser. PHP -I in a command browser returns the phpinfo
values
as expected.
Anyone have any suggestions? I'm somewhat at the end of my rope here.
Truly,
any help appreciated.
Much warmth,
Murray
<http://www.planetthoughtful.org/> http://www.planetthoughtful.org
Building a thoughtful planet,
One quirky comment at a time.
--- End Message ---
--- Begin Message ---
Hi Zeb,
Ah! Thank you! It appears I was missing the step of enabling php.exe as a
web service extension...
Many thanks again!
Much warmth,
Murray
http://www.planetthoughtful.org
Building a thoughtful planet,
One quirky comment at a time.
-----Original Message-----
From: Bowden, Zeb [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 27 October 2004 3:04 AM
To: [EMAIL PROTECTED]
Subject: RE: [PHP-WIN] Problems installing PHP on IIS 6?
Have you added PHP as a web service extension? And what about adding it
as an application extension? (Home Directory -> Configuration)
-----Original Message-----
From: Murray @ PlanetThoughtful [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 26, 2004 12:43 PM
To: [EMAIL PROTECTED]
Subject: [PHP-WIN] Problems installing PHP on IIS 6?
Hi All,
I'm having problems getting PHP 4.3.9 working in either ISAPI or CGI
mode
with IIS 6.0. I've consulted various 'how to install PHP with IIS' pages
and
followed what instructions I've found, but without any luck.
My current attempt it to get CGI working.
In my various attempts to get this working I have:
- copied php4ts.dll to \windows\system32
- copied php.ini to \windows
- edited php.ini to set cgi.force_redirect = 0
- assigned both my administrator and anonymous internet users
full
rights to php.exe
- confirmed that when I'm attempting to run a php script that
it is
in the root of the site and should be available
- stopped and restarted the IIS service at each step to make
sure
that changes are enabled
No matter what I do, the server doesn't appear to want to recognize php
files. It will serve .htm and .asp files without any problems, but gives
me
a 'The page cannot be found' (404) error whenever I try to run a php
file
through the browser. PHP -I in a command browser returns the phpinfo
values
as expected.
Anyone have any suggestions? I'm somewhat at the end of my rope here.
Truly,
any help appreciated.
Much warmth,
Murray
<http://www.planetthoughtful.org/> http://www.planetthoughtful.org
Building a thoughtful planet,
One quirky comment at a time.
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--- End Message ---
--- Begin Message ---
FYI - respond to the list not to me personally. The list will respond faster
than I will and can often provide extra insight. Plus it sometimes irritates me
(not this time though ;)
I know Microsoft has made most of us forget about the command line, but the *nix
tradition for it is great and shows through in PHP. Just use the -h flag to get
command line help, i.e.
cd\path\to\your\phpdir
php-cgi -h
That will give all of the help info for using PHP on the command line. You can
figure it out from there ;)
--- End Message ---
--- Begin Message ---
I'm not a VC programmer so I won't promise this works, but you could try
building PHP from source into your project. I do know that different SAPI's can
be written and PHP can be embedded within another application. Try checking out
_sapi_module_struct in the source.
Raul Ionescu wrote:
I wonder if it's possible to access php functions from inside dlls from
Visual Basic or Visual C?
Any ideas?
---------------------------------------------------------------
Castiga un telefon cu Personalitate! Exclusiv pentru femei, exclusiv pe ele.ro!
--- End Message ---
--- Begin Message ---
This error is about 80% of the time caused because of errors loading libmysql.
But usually putting that library in the system32 folder solves the problem. Do
you have any other errors? Make sure you're restarting the server after you've
moved the files. Heck try throwing libmysql back in php/ext just for kicks
(though I doubt that works).
Adam Clauss wrote:
Recently installed PHP 5.0.2 on Windows Server 2003, MySQL 4.0.xx
running on the same machine. I initially installed PHP using the
installer, but then downloaded the zip file and extracted the ext folder
to c:\php\ext.
I have enabled the php_mysql extension in php.ini. I have placed
libmysql.dll in c:\windows\system32.
I added Everyone as Full Control to the c:\php\ext folder. Yet when
attempting to load a page that uses MySQL I get the error:
PHP Startup: Unable to load dynamic library 'c:/php/ext\php_mysql.dll' -
Access is denied.
This appears in the webbrowser. I get a similar error in a messagebox
on the server itself.
I'm almost certain permissions are set correctly - I can use the
Microsoft SQL extension with no problems (enabled it as well in php.ini).
Any ideas?
Thanks!
--- End Message ---
--- Begin Message ---
Hello,
I'm trying to write the contents of a zip file to disk. Unfortunately
the script creates zero length files. The problem has to be with
zip_entry_read below...
$zipFile = zip_open($uploadFile);
$zipEntry = zip_read($zipFile)
$filePointer = fopen($outputXLSFile, 'w+b');
$fileBuffer = zip_entry_read($zipEntry,
zip_entry_filesize($zipEntry));
fwrite($filePointer, $fileBuffer);
fclose($filePointer);
Thoughts?
Thanks in advance!
--- End Message ---
