php-windows Digest 1 Feb 2001 05:16:53 -0000 Issue 422

Thu, 01 Feb 2001 01:27:51 -0800 


php-windows Digest 1 Feb 2001 05:16:53 -0000 Issue 422

Topics (messages 5282 through 5298):

Re: Problem with Oracle
        5282 by: Asendorf, John
        5283 by: Gonzalo Vera

Re: How  can I make PHP  to work on Win98 ?
        5284 by: Gonzalo Vera
        5285 by: Richard
        5286 by: Simon Willison
        5287 by: Michael S. Norum
        5288 by: Gonzalo Vera
        5289 by: Neil Galvin

php install bundles and tutorials
        5290 by: Paul Trapnell
        5291 by: Yoann Chevalier

Re: A device attached to the system is not functioning
        5292 by: clayton collie

connecting to AS400 DB2
        5293 by: Conover, Ryan

Building JavaScript source via PHP
        5294 by: Jan Walter

Re: links to php install bundles and tutorials
        5295 by: Paul Trapnell

server error: authenticate
        5296 by: Nicholas_Chen.compal.com
        5297 by: Ignatius Teo

Re: [PHP] connecting to AS400 DB2
        5298 by: szii.sziisoft.com

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]


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


Since the list was down yesterday, I figured it out before I got some help
(Thanks Jean-Christophe).  I did it a little differently and thought I'd
post it here.

$sql_getID = "SELECT max(CUSTID_NUM) from cfull2.tbl_dl_customers";
$stmt_getID = OCIParse ( $connection , $sql_getID );
OCIExecute ( $stmt_getID );
OCIFetch ( $stmt_getID );
$Max_ID = OCIResult($stmt_getID,1);
OCIFreeStatement ( $stmt_getID );
$Max_ID++;

I was able to echo the result but was unable to put it in to a variable
until I did the above.
        

---------------------
John Asendorf - [EMAIL PROTECTED]
Web Applications Developer
http://www.lcounty.com - NEW FEATURES ADDED DAILY!
Licking County, Ohio, USA
740-349-3631

The benefit to the government of replacing all $1 Federal Reserve notes with
$1 coins would be $522.2 million per year, according to estimates of the
General Accouting Office released on April 7, 2000.


> -----Original Message-----
> From: Jean-Christophe Le Brun [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, January 31, 2001 2:19 AM
> To: Asendorf, John; [EMAIL PROTECTED]
> Subject: Re: [PHP-WIN] Problem with Oracle 
> 
> 
> Hi !
> 
> > I'm trying to run some SQL in Oracle that returns a single value...
> >
> > $sql_getID = "SELECT max(CUSTID_NUM) from cfull2.tbl_dl_customers";
> >
> > how the hell do I get that number into a variable?
> >
> > I've tried a dozen different things, but the documentation 
> is so sparse
> and
> > it's all about getting rows of data...
> 
> Do this :
> 
> $Requete = "SELECT max(CUSTID_NUM) MAX_ID from 
> cfull2.tbl_dl_customers";
> OCIDefineByName($Requete, "MAX_ID", &$Max_Id);
> OCIExecute($Requete, OCI_DEFAULT);
> while (OCIFetch($Requete))
> {
>   echo $Max_Id;
> }
> 
> the While is not necessary here cause your query send only one row...
> 
> if (OCIFetch($Requete))
> {
>   echo Max_Id;
> }
> 
> is better !
> 
> JCLB Soft
> Jean-Christophe Le Brun
> [EMAIL PROTECTED]
> http://www.multimania.com/jclb
> 




> $sql_getID = "SELECT max(CUSTID_NUM) from cfull2.tbl_dl_customers";
> how the hell do I get that number into a variable?

Wouldn't changing your SQL statement to this do the trick?:

"SELECT max(CUSTID_NUM) as max_cust_id from cfull2.tbl_dl_customers"
                        ^^^^^^^^^^^^^^

And just retrieve the value of max_cust_id as any other row of data. I
don't use Oracle, but that's how I would do it in ODBC or MySQL.

Gonzalo.





>    Hi,
>  I work with Winows98  , and I want to make my system 
> a really server.I have two questions :
 
> 1}What component  I should install on my system to 
>   make it a really server ? IIS3 ? or IIS4 ?
> 2)Where can I get this component (IIS3 or IIS4
>   for Windows98) ?

A REAL server? Don't use Win98  ;)

But if you're stuck with it, and are still not tied to any web server
in particular, use apache (www.apache.org). I run it on Win 95 and it
works great. Sorry, but I wouldn't know the answer to neither of your
questions: I've never had to install IIS, I know it has some
advantages, maybe one of the IIS users on the list can answer.

Gonzalo.





>    Hi,
>  I work with Winows98  , and I want to make my system
> a really server.I have two questions :

> 1}What component  I should install on my system to
>   make it a really server ? IIS3 ? or IIS4 ?
> 2)Where can I get this component (IIS3 or IIS4
>   for Windows98) ?

I don't think IIS comes in a flavor for Win98 does it?  I think the closest
thing to IIS you can get on win98 is PWS.  But I would agree with Gonzalo
when he says to use apache.

Rick




You could always use Apache - it's free, works fine on Windows 98 and is
easier to set up than you might think.

Try this tutorial:

"Setup and Install Apache + PHP4 on Windows" :
http://www.thickbook.com/extra/php_apachephp4_win.phtml

Cheers,

Simon

-----Original Message-----
From: Leon Santos Filho [mailto:[EMAIL PROTECTED]]
Sent: 31 January 2001 12:08
To: nastaran kashani; [EMAIL PROTECTED]
Subject: Re: [PHP-WIN] How can I make PHP to work on Win98 ?


To use IIS you need NT or windows 2000. If you really want to use win98, use
Personal Web Server instead.

----- Original Message -----
From: nastaran kashani <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, January 30, 2001 4:13 PM
Subject: [PHP-WIN] How can I make PHP to work on Win98 ?


>
>
>    Hi,
>  I work with Winows98  , and I want to make my system
> a really server.I have two questions :
>
> 1}What component  I should install on my system to
>   make it a really server ? IIS3 ? or IIS4 ?
> 2)Where can I get this component (IIS3 or IIS4
>   for Windows98) ?
>
>
>     Thanks a lot
>      Atieh Kashani
>
> __________________________________________________
> Get personalized email addresses from Yahoo! Mail - only $35
> a year!  http://personal.mail.yahoo.com/
>
> --
> 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]




Do not install PWS on your system. I would strongly recomend against it. If
you put it on, and the regret it, it's a real pain in the behind do get rid
of...

Trust me, I've learned from my mistakes. Use Apache instead. Search download
com for PHP triad, they have a great developer package that installs PHP and
apache on a windows pc.

Michael

"Gud kaster ikke terning med universet"
-Albert Einstein

http://denandresiden.cjb.net
http://bookmarks4all.cjb.net
http://www.geocities.com/zymosis2000

-----Original Message-----
From: Richard [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 31, 2001 4:33 PM
To: [EMAIL PROTECTED]
Subject: RE: [PHP-WIN] How can I make PHP to work on Win98 ?


>    Hi,
>  I work with Winows98  , and I want to make my system
> a really server.I have two questions :

> 1}What component  I should install on my system to
>   make it a really server ? IIS3 ? or IIS4 ?
> 2)Where can I get this component (IIS3 or IIS4
>   for Windows98) ?

I don't think IIS comes in a flavor for Win98 does it?  I think the closest
thing to IIS you can get on win98 is PWS.  But I would agree with Gonzalo
when he says to use apache.

Rick


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





You can also try AbriaSoft lite (free for non-commercial, check the
license), which installs PHP, apache and Mysql from one package.

 Gonzalo.

> Do not install PWS on your system. I would strongly recomend against it. If
> you put it on, and the regret it, it's a real pain in the behind do get rid
> of...

> Trust me, I've learned from my mistakes. Use Apache instead. Search download
> com for PHP triad, they have a great developer package that installs PHP and
> apache on a windows pc.

> Michael

> "Gud kaster ikke terning med universet"
> -Albert Einstein

> http://denandresiden.cjb.net
> http://bookmarks4all.cjb.net
> http://www.geocities.com/zymosis2000

> -----Original Message-----
> From: Richard [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, January 31, 2001 4:33 PM
> To: [EMAIL PROTECTED]
> Subject: RE: [PHP-WIN] How can I make PHP to work on Win98 ?


>>    Hi,
>>  I work with Winows98  , and I want to make my system
>> a really server.I have two questions :

>> 1}What component  I should install on my system to
>>   make it a really server ? IIS3 ? or IIS4 ?
>> 2)Where can I get this component (IIS3 or IIS4
>>   for Windows98) ?

> I don't think IIS comes in a flavor for Win98 does it?  I think the closest
> thing to IIS you can get on win98 is PWS.  But I would agree with Gonzalo
> when he says to use apache.

> Rick


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





or http://www.nusphere.com
Install's apache, php, mysl, perl all under one dir.

----- Original Message -----
From: "Gonzalo Vera" <[EMAIL PROTECTED]>
To: "Michael S. Norum" <[EMAIL PROTECTED]>
Cc: "PHP Windows List" <[EMAIL PROTECTED]>
Sent: Wednesday, January 31, 2001 4:06 PM
Subject: Re[2]: [PHP-WIN] How can I make PHP to work on Win98 ?


> You can also try AbriaSoft lite (free for non-commercial, check the
> license), which installs PHP, apache and Mysql from one package.
>
>  Gonzalo.
>
> > Do not install PWS on your system. I would strongly recomend against it.
If
> > you put it on, and the regret it, it's a real pain in the behind do get
rid
> > of...
>
> > Trust me, I've learned from my mistakes. Use Apache instead. Search
download
> > com for PHP triad, they have a great developer package that installs PHP
and
> > apache on a windows pc.
>
> > Michael
>
> > "Gud kaster ikke terning med universet"
> > -Albert Einstein
>
> > http://denandresiden.cjb.net
> > http://bookmarks4all.cjb.net
> > http://www.geocities.com/zymosis2000
>
> > -----Original Message-----
> > From: Richard [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, January 31, 2001 4:33 PM
> > To: [EMAIL PROTECTED]
> > Subject: RE: [PHP-WIN] How can I make PHP to work on Win98 ?
>
>
> >>    Hi,
> >>  I work with Winows98  , and I want to make my system
> >> a really server.I have two questions :
>
> >> 1}What component  I should install on my system to
> >>   make it a really server ? IIS3 ? or IIS4 ?
> >> 2)Where can I get this component (IIS3 or IIS4
> >>   for Windows98) ?
>
> > I don't think IIS comes in a flavor for Win98 does it?  I think the
closest
> > thing to IIS you can get on win98 is PWS.  But I would agree with
Gonzalo
> > when he says to use apache.
>
> > Rick
>
>
> > --
> > 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]
>




PHP FOR WINDOWS  
       (LATEST PHP RELEASE, PRECOMPILED BINARIES)  
 http://www.php.net/downloads.php  (free)
 http://php4win.de/   (free) (has pre-release dev versions of php also)
 
 
PHP FOR WINDOWS INSTALL BUNDLES 
       (PHP4x PRECOMPILED BINARIES + APACHE + MYSQL)
 http://www.firepages.com.au/phpdev.htm  (free)
 http://www.phpgeek.com/   (free) 
 http://php.weblogs.com/easywindows  (free) (GD gif dll is here too)
 http://www.abriasoft.com/   (free and fee versions)
 http://www.nusphere.com/products/index.htm
         (the latter supplies manuals and tech support, and 
          costs $79)

     
PHP INSTALLATION TUTORIALS 
 http://212.223.75.38/workshops/   (Edward's Online Workshops)
 http://www.thickbook.com/extra/php_apachephp4_win.phtml
 http://www.devshed.com/Server_Side/PHP/SoothinglySeamless/
 http://www.php.net/manual/en/install-windows95-nt.php
 IMPORTANT: Read the "readme" files accompanying each install
 

PHP TUTORIALS
 http://perl.about.com/compute/perl/cs/beginningphp/
 http://www.phphelp.com/tutorial/index.html
 http://support.pair.com/tutorials/php.html
 http://www.devshed.com/Server_Side/PHP/PHP101_5/
 http://www.echoecho.com/links/Tutorials/ServerProgramming/Php/
 http://cthulhu.ale.org/ale-archive/ale-1999-10/msg00248.html
 http://hotwired.lycos.com/webmonkey/databases/tutorials/tutorial4.html
 http://www.useractive.com/  (see their free "sandbox", with PHP tutorials)



There is another good tutorial for beginners at this adress.
It's PHP4 for Windows and Unix

http://hotwired.lycos.com/webmonkey/00/44/index4a.html?tw=programming

Yoann.

----- Original Message ----- 
From: Paul Trapnell <[EMAIL PROTECTED]>
To: php <[EMAIL PROTECTED]>
Sent: Wednesday, January 31, 2001 8:38 PM
Subject: [PHP-WIN] php install bundles and tutorials


PHP FOR WINDOWS  
       (LATEST PHP RELEASE, PRECOMPILED BINARIES)  
 http://www.php.net/downloads.php  (free)
 http://php4win.de/   (free) (has pre-release dev versions of php also)
 
 
PHP FOR WINDOWS INSTALL BUNDLES 
       (PHP4x PRECOMPILED BINARIES + APACHE + MYSQL)
 http://www.firepages.com.au/phpdev.htm  (free)
 http://www.phpgeek.com/   (free) 
 http://php.weblogs.com/easywindows  (free) (GD gif dll is here too)
 http://www.abriasoft.com/   (free and fee versions)
 http://www.nusphere.com/products/index.htm
         (the latter supplies manuals and tech support, and 
          costs $79)

     
PHP INSTALLATION TUTORIALS 
 http://212.223.75.38/workshops/   (Edward's Online Workshops)
 http://www.thickbook.com/extra/php_apachephp4_win.phtml
 http://www.devshed.com/Server_Side/PHP/SoothinglySeamless/
 http://www.php.net/manual/en/install-windows95-nt.php
 IMPORTANT: Read the "readme" files accompanying each install
 

PHP TUTORIALS
 http://perl.about.com/compute/perl/cs/beginningphp/
 http://www.phphelp.com/tutorial/index.html
 http://support.pair.com/tutorials/php.html
 http://www.devshed.com/Server_Side/PHP/PHP101_5/
 http://www.echoecho.com/links/Tutorials/ServerProgramming/Php/
 http://cthulhu.ale.org/ale-archive/ale-1999-10/msg00248.html
 http://hotwired.lycos.com/webmonkey/databases/tutorials/tutorial4.html
 http://www.useractive.com/  (see their free "sandbox", with PHP tutorials)





Ari,
  that message generally means that a program is linked to a DLL which it
cannot find in the search path. Make sure you follow instructions regarding
the placement of DLL files in the package. in particular they should be
somewhere Windows can find them (like Windows/System)


""Ari Pramono (HRM-HO)"" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Hello,
> I've already installed PHP 4.0.4 on my PWS 4.0
> But when I ran my homepage (default.php) on IE 4.0, it said "A device
> attached to the system is not functioning"
> Anybody know how to fix it ?
>
> Trims
> Ary
> [EMAIL PROTECTED] <mailto:[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]
>





I was wondering if anyone as successfully pulled info from a DB2 Database on
As400. My enviroment is
Win2K server/php4.0.4/ZendOptimizer/IIS5. I was wondering how I could
directly query the AS400. Or would it be wiser to pull the info from the
AS400 into MSSQL Server.  I was wondering how I would do either of these
options.


Ryan Conover



Dear PHP devoteees,

I have the following, very strange problem:

I use PHP to generate JavaScript source for

<script language="JavaScript" src="http://host/script.php"
type="text/javascript"></script>

but anytime an error in Netscape Navigator occurs (IE works properly):
--------------------
illegal character.

9
.^
--------------------
Even if script contains only:

document.write('Some text');

If I rename script.php to script.js, everything is OK. And the last
strange thing: this happens only on my web host's server, when I write
the code at home, everything is ok. Do you thing, apache+php send some
weird characters at the beginning of the page Netscape does not
recognize?

Thanx for any hint
--
__________________________________________________________________________________________

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

Jan Walter, called John
LERACH, s.r.o.
phone nr. work: +420-2-78 22 619, home: +420-2-35 35 27 61
on emergency call cell phone: +420-602-385 760
work e-mail mailto:[EMAIL PROTECTED]
private e-mail mailto:[EMAIL PROTECTED]
ICQ#: 28353428
__________________________________________________________________________________________

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


Title: Blank
 
--thanks for the additional tutorial link (the Meloni one at WebMonkey). 
 
If anyone wishes to add any additional links to install bundles and
tutorials, post them here and I'll add them to this list.  An updated 
list can then be reposted (either by me or anyone who saves a copy)
each time a new reader requests the locations of install bundles or tutorials. 
 
 
To post a reply to the list, click here:    [EMAIL PROTECTED]
 
 

 



Dear All, 

I don't think there is something wrong with the following piece of script,
but it does make Apache send a 500-server-internal-error. The error.log of
Apache indicates 

"malformed header from script. Bad header=HTTP/1.0 401 Unauthorized ...". 

Would you please give me a hand? Thank you very much! 

Best regards, 

Nicholas Chen 
PS. Error occurred on Abria SQL Lite with Windows 98

The script is: 
<?php 
  if (!isset( $PHP_AUTH_USER )) 
  { 
    Header( "WWW-Authenticate: Basic realm=\"member\"" ); 
    Header( "HTTP/1.0 401 Unauthorized" ); 
    exit; 
  } 
  else 
  { 
    echo "Hello, $PHP_AUTH_USER<p>"; 
  }
?>



ciB1IHJ1bm5pbmcgcGhwIGFzIGEgbW9kdWxlIG9yIENHST8NCg0KSWduYXRpdXMNCg0KPiAtLS0t
LU9yaWdpbmFsIE1lc3NhZ2UtLS0tLQ0KPiBGcm9tOiBOaWNob2xhc19DaGVuQGNvbXBhbC5jb20g
W21haWx0bzpOaWNob2xhc19DaGVuQGNvbXBhbC5jb21dDQo+IFNlbnQ6IFRodXJzZGF5LCAxIEZl
YnJ1YXJ5IDIwMDEgMTE6NTgNCj4gVG86IHBocC13aW5kb3dzQGxpc3RzLnBocC5uZXQNCj4gU3Vi
amVjdDogW1BIUC1XSU5dIHNlcnZlciBlcnJvcjogYXV0aGVudGljYXRlDQo+IA0KPiANCj4gRGVh
ciBBbGwsIA0KPiANCj4gSSBkb24ndCB0aGluayB0aGVyZSBpcyBzb21ldGhpbmcgd3Jvbmcgd2l0
aCB0aGUgZm9sbG93aW5nIA0KPiBwaWVjZSBvZiBzY3JpcHQsDQo+IGJ1dCBpdCBkb2VzIG1ha2Ug
QXBhY2hlIHNlbmQgYSA1MDAtc2VydmVyLWludGVybmFsLWVycm9yLiBUaGUgDQo+IGVycm9yLmxv
ZyBvZg0KPiBBcGFjaGUgaW5kaWNhdGVzIA0KPiANCj4gIm1hbGZvcm1lZCBoZWFkZXIgZnJvbSBz
Y3JpcHQuIEJhZCBoZWFkZXI9SFRUUC8xLjAgNDAxIA0KPiBVbmF1dGhvcml6ZWQgLi4uIi4gDQo+
IA0KPiBXb3VsZCB5b3UgcGxlYXNlIGdpdmUgbWUgYSBoYW5kPyBUaGFuayB5b3UgdmVyeSBtdWNo
ISANCj4gDQo+IEJlc3QgcmVnYXJkcywgDQo+IA0KPiBOaWNob2xhcyBDaGVuIA0KPiBQUy4gRXJy
b3Igb2NjdXJyZWQgb24gQWJyaWEgU1FMIExpdGUgd2l0aCBXaW5kb3dzIDk4DQo+IA0KPiBUaGUg
c2NyaXB0IGlzOiANCj4gPD9waHAgDQo+ICAgaWYgKCFpc3NldCggJFBIUF9BVVRIX1VTRVIgKSkg
DQo+ICAgeyANCj4gICAgIEhlYWRlciggIldXVy1BdXRoZW50aWNhdGU6IEJhc2ljIHJlYWxtPVwi
bWVtYmVyXCIiICk7IA0KPiAgICAgSGVhZGVyKCAiSFRUUC8xLjAgNDAxIFVuYXV0aG9yaXplZCIg
KTsgDQo+ICAgICBleGl0OyANCj4gICB9IA0KPiAgIGVsc2UgDQo+ICAgeyANCj4gICAgIGVjaG8g
IkhlbGxvLCAkUEhQX0FVVEhfVVNFUjxwPiI7IA0KPiAgIH0NCj4gPz4NCj4g




To connect to an AS400, you MUST HAVE THE DRDA package installed.
Then you just run the Unified ODBC as usual (which still don't use ODBC but
translate to DB2 CLI under the covers.)

Look for the DRDA stuff in the DB2 Connect area/CD-ROM.

There's stuff on phpbuilder.com about it too.

-Szii


At 01:33 PM 1/31/2001 -0500, Conover, Ryan wrote:
>I was wondering if anyone as successfully pulled info from a DB2 Database on
>As400. My enviroment is
>Win2K server/php4.0.4/ZendOptimizer/IIS5. I was wondering how I could
>directly query the AS400. Or would it be wiser to pull the info from the
>AS400 into MSSQL Server.  I was wondering how I would do either of these
>options.
>
>
>Ryan Conover
>
>-- 
>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