php-windows Digest 28 Aug 2003 07:36:45 -0000 Issue 1890
Topics (messages 21263 through 21267):
Using Sablotron to parse remote XML via xslt (to HTML)
21263 by: Ryan Vesely
Re: Displaying one record per page
21264 by: Croskerry, Dan
21266 by: Harpreet
21267 by: Bobo Wieland
Re: Web page timeout with PHP 4.3.3 on IIS & Win2K
21265 by: Matt Blacker
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,
I am having many difficulties getting sablotron php extentions to work in my
environment for remote xml. Here's what I am using:
OS: WIndows 2000
PHP version: 4.3.3RC4
Expat version: 1.95.6
Sablotron Version: 0.97
Server Software: IIS 5.0
If the files are stored locally, and I getcwd() for the filebase, then the
conversion works fine. But, if I try to run this against a remote xml file,
it chokes. Do you have a working example of using sablotron in the
environment listed above that accomplishes this task? I have tried setting
the code located here:
http://www.php.net/manual/en/function.xslt-set-scheme-handlers.php to use my
instance of xml/xsl files, but even that does not work.
I also noticed that 4.3.3 was released this week, but I did not see this
problem documented in the release notes.
Thanks in advance for any help,
----------------------------------------------------------------
Ryan Vesely
Sales Engineer
Pinnacor
685 Market Street, Suite 500
San Francisco, CA 94105
tel 415.369.4762
fax 415.512.2085
The preceding e-mail message contains privileged, confidential information.
Intended conveyance is only to designated and named recipient(s). If you
feel that you may have received this message in error or if you are not the
named recipient, please notify Pinnacor at once at the sender's email
address, or call 212.691.7900. Unauthorized use, dissemination, distribution
or reproduction of this message is strictly prohibited and may be unlawful.
--- End Message ---
--- Begin Message ---
What database are you using? MySQL, MSSQL, Oracle...?
-----Original Message-----
From: Harpreet [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 27, 2003 2:33 PM
To: [EMAIL PROTECTED]
Subject: [PHP-WIN] Displaying one record per page
I have a sql command that returns more then one rows. I want to display one
record per page using NEXT to show the other records. Each page displaying
one record.
Help is appreciated.
Regards,
Harpreet Kaur
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--- End Message ---
--- Begin Message ---
MSSQL and MYSQL both. I need a solution for both as the web app is going to
run on b oth databases.
----- Original Message -----
From: "Croskerry, Dan" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 27, 2003 4:16 PM
Subject: RE: [PHP-WIN] Displaying one record per page
> What database are you using? MySQL, MSSQL, Oracle...?
>
> -----Original Message-----
> From: Harpreet [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, August 27, 2003 2:33 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP-WIN] Displaying one record per page
>
>
> I have a sql command that returns more then one rows. I want to display
one
> record per page using NEXT to show the other records. Each page displaying
> one record.
>
> Help is appreciated.
>
> Regards,
> Harpreet Kaur
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--- End Message ---
--- Begin Message ---
If I understood you correct you could do something like this with mysql:
<code>
$recnum = (isset($_GET["recnum"])) ? $_GET["recnum"] : 1;
$q = "SELECT * FROM table LIMIT ".$recnum.",1";
$r = mysql_query($q, $link_id);
$row = mysql_fetch_object($r);
print ($row->some_field);
print ("<a href='thispage.php?recnum=".max($recnum-1,1)."'>PREV</a>");
print ("<a href='thispage.php?recnum=".($recnum+1)."'>NEXT</a>");
mysql_free_result($r);
</code>
.bobo [EMAIL PROTECTED]
----- Original Message -----
From: "Harpreet" <[EMAIL PROTECTED]>
To: "Croskerry, Dan" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, August 28, 2003 5:38 AM
Subject: Re: [PHP-WIN] Displaying one record per page
> MSSQL and MYSQL both. I need a solution for both as the web app is going
to
> run on b oth databases.
>
> ----- Original Message -----
> From: "Croskerry, Dan" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Wednesday, August 27, 2003 4:16 PM
> Subject: RE: [PHP-WIN] Displaying one record per page
>
>
> > What database are you using? MySQL, MSSQL, Oracle...?
> >
> > -----Original Message-----
> > From: Harpreet [mailto:[EMAIL PROTECTED]
> > Sent: Wednesday, August 27, 2003 2:33 PM
> > To: [EMAIL PROTECTED]
> > Subject: [PHP-WIN] Displaying one record per page
> >
> >
> > I have a sql command that returns more then one rows. I want to display
> one
> > record per page using NEXT to show the other records. Each page
displaying
> > one record.
> >
> > Help is appreciated.
> >
> > Regards,
> > Harpreet Kaur
> >
> > --
> > PHP Windows Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
> > --
> > PHP Windows Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
>
--- End Message ---
--- Begin Message ---
Hi, I would check to make sure the php.exe is getting executed properly
from the new location, you say it starts it but how do you know this?
If you want to make sure it is using the new file go into IIS, then go
to properties on the website you want php on and then go to the home
directory tab. On this tab click configuration and it will bring up
another window. It will list all the extensions it will execute, find
*.php in the list and edit it. Look at where it is looking for php and
fix it if it is wrong.
I'm sorry if I misunderstood you, I upgraded from 4.3.2 to 4.3.3 last
night and it worked perfectly, but I didn't use the installer I just
used the zip.
Matt
P.S Sorry I think I sent this message to Scott also.
-----Original Message-----
From: Scott Stricker [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 27 August 2003 4:49 AM
To: [EMAIL PROTECTED]
Subject: [PHP-WIN] Re: Web page timeout with PHP 4.3.3 on IIS & Win2K
I'm trying to run phpmyAdmin on a machine running Windows 2000 with IIS.
Previously, I'd installed PHP 4.3.2 with the only tweak to the install
changing the default volume from C: to D:. Did not touch any other
options
during the install. Went to my phpmyAdmin site and it worked as I
expected.
Today, I installed PHP 4.3.3, again changing the default folder from C:
to
D:. Now when I start phpmyAdmin, php.exe starts to handle the request
for
index.php, but it never finishes. Behavior in my web browser is that
the
request finally times out.
In the IIS configuration tool that comes with Win2K, there are
properties
for the WWW service, and everything below. When I installed 4.3.2, I
was
asked if I wanted to register php.exe to handle php requests for the WWW
service and nothing else. I checked to box to say yes. When I
installed
4.3.3, I was asked if I wanted to do the registration for the WWW
service,
the Default Web Site, and most virtual directories underneath it. I
tried
both setting up only the WWW service and all options, both with the same
results.
Again, in all 4.3.3 cases, perl.exe is running, php.exe -i seems to give
no
errors and running php.exe index.php in the IUSR environment all seemt
to
work okay.
If anyone would like more info, please let me know what you need to know
and
I'll try to answer the question.
Thanks
--
E. Scott Stricker - NGIT @ Smartlink
"M.Staiger" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
>
> "Scott Stricker" <[EMAIL PROTECTED]> schrieb im Newsbeitrag
> news:[EMAIL PROTECTED]
> > FYI, I've since removed 4.3.3 and re-installed 4.3.2 and it worked
> > immediately. Only difference I noticed in install was 4.3.2 only
showed
> WWW
> > Service in list to add .php to, whereas 4.3.3 showed WWW Service and
all
> > sites with .php reference.
>
> Could you please explain this more detailed?
>
> Marc
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--- End Message ---
