php-windows Digest 28 Jun 2001 02:38:50 -0000 Issue 631

Topics (messages 8080 through 8085):

Re: 500 error
        8080 by: Johan Lundqvist

Re: system(), Access is denied
        8081 by: Delbono

help connecting to MS SQL 7.0 dbase
        8082 by: Joann Coffey

notify user of duplicate entry
        8083 by: Pete Kuczynski

Re: Exec command still doesn't on Win2K and IIS
        8084 by: choiks

PHP / Win98 se / other programs ... they hang
        8085 by: Paul Warren

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]


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


Tjena Martin,

How did you set it up?
Where's the PHP doc that generates the error located?
What's in the script?

Did you check user rights?

/Johan

"Martin Skjöldebrand" wrote:
> 
> I've installed PHP and MySQL on my Win2K Pro box according to
> a doc I got (thanks).
> Accessing a php-doc results in
> 
> The page cannot be displayed
> There is a problem with the page you are trying to reach and it cannot
> be displayed.
> 
> Any ideas?
> 
> M.
>




> >   system("e:\\tmp\file.bat")
> > but it gives me "Access is denied

try please:
> >   system("e:\\tmp\\file.bat")

furthermore:
if you call the script from the server way..

"http://localhost/executeme.php";

you have to either

1. Login to the machine as a user with "execute" Permission
on the directory 
e:\tmp\file.bat

or 

2. Give IUSR_WEB  (the "internet user" of NT) the "Execute" permission 
on the directory 
e:\tmp\file.bat







I am pretty new to PHP and currently using PHP 4.0.1 running on windows 98 -
PWS 4.0 - I cannot connect to SQL Server - is there anything I need to
configure separetely to connect?

I can connect using ODBC but not the mssql functions 

Thank you.

Joann Coffey
[EMAIL PROTECTED]




I want to prevent duplicate entries in by database in the hostname
field.

So far, I have modified my hostname column as such to prevent duplicate
entries into it, it works:

alter table <table> modify <column> varchar(15) null unique;

Now I need to notify the user that enters a duplicate hostname of their
error, the database prevents the entry, but  the user dosn't know it.

Here's my PHP script, any thought how best to modify it?

THX!

Pete
<html>
     <body>
     <?php

     require("fedb.inc");

     mysql_connect(localhost,$user,$password);

     @mysql_select_db($db) or die( "Unable to select database");

     /*Insert into database */
     

     mysql_query ("INSERT INTO asset (site_id, hostname, device, model,
serial, ip,
                   dept, mhz, ram, hd_size, os_ver, status, data_port,
pp_port, hub_port,
                   digi_port, csmim_port, tprmim_port, xyplex_port,
comments, fe) 
                    VALUES ('$site_id', '$hostname', '$device',
'$model', '$serial', '$ip', 
                             '$dept', '$mhz', '$ram', '$hd_size',
'$os_ver', '$status', 
                             '$data_port', '$pp_port', '$hub_port',
'$digi_port',
                             '$csmim_port', '$tprmim_port',
'$xyplex_port', 
                             '$comments', '$fe')
                  ");



 
     print ($site_id);
     print (" ");



     print ($hostname);
     print (" ");



     print ($device);
     print (" ");
   

     print ($model);

     print (" ");

     print ($serial);

     print (" ");

     print ($ip);

     print (" ");

     print ($dept);

     print (" ");

     print ($mhz);

     print (" ");

     print ($ram);

     print (" ");

     print ($hd_size);

     print (" ");

     print ($os_ver);

     print (" ");

     print ($status);

     print (" ");

     print ($data_port);

     print (" ");

     print ($pp_port);

     print (" ");

     print ($hub_port);

     print (" ");

     print ($digi_port);

     print (" ");

     print ($csmim_port);

     print (" ");

     print ($tprmim_port);

     print (" ");

     print ($xyplex_port);

     print (" ");

     print ($comments);

     print (" ");

     print ($fe);

     print (" ");

     print ("<p>");

     print ("<p>");

     print ("Thanks for submitting your device.");

     print ("<p>");

     print ("Please do not reload this page, it will produce a duplicate
record");


      

     ?>
     
     <a href='index.html'><b>Home</b></a> 
     
     
     </body>
     </html>




-- 
_______________________________________
Pete Kuczynski
Principal Field Engineer
DHL Airways Inc.
Infrastructure Technology & Services
(773)-462-9758
24/7 Helpdesk 1-800-434-5767




[EMAIL PROTECTED] (BAMHA Mostafa Ftmms) wrote in
6F80F42D4777D4119359001083FCBB9E138CF0@ISSYNTSF02:">news:6F80F42D4777D4119359001083FCBB9E138CF0@ISSYNTSF02: 

> Hi all,
> I'm using the ISAPI version of PHP-4.0.6 on Win2K but the Exec command
> still doesn't
> work  on Win2K and IIS.
> 
> However, it has been mentionned in  the ChangeLog of  PHP-4.0.6  that
> popen and exec
>  problems on Win2k were fixed in this version.
> 
> Is there any change in the configuration? or What i'm missing !!!
> 
> Thanks in advance for your help.
> 
> M. Bamha
> 
> 

exec(), system(), ... work well in isapi mode in php 4.0.6.
check your code!!
then post your code!!




I'm having serious problems with getting PHP to run quietly on my system.
I'm not sure if it's just because i have windows 98 but I was wondering if
this problem can be reproduced on other OS's. PHP 4.0.6 does this too. This
only happens when I have PHP installed. If i start Apache without PHP, it's
fine. the programs don't hang. More explaination is below.


Here's a copy of the bug i reported in the php bug database (#11225)

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

This problem can be reproduced. (At least on my system)


The server seems to run fine. The problem arrises when I try to launch other
applications
such as a PHP editor or other various apps. A few applications that will
freeze up when
Apache and PHP are running are: PHPEd by Soysal; ICQ's URL feature; First
Class Email Client;
1st Page by Evrsoft.


How-To-Repeat:
I have the binary install of Apache 1.3.19, PHP 4.0.5 and Windows 98 SE


Using any part of the URL messaging in ICQ will freeze up ICQ until Apache
is stopped.
(This is not the case if Apache is not running PHP.)

The First class client will not work unless Apache and PHP are stopped. The
client I use
is from my school ( http://fred.mohawkc.on.ca )
http://www.firstclass.com/downloads/client.html

Trying to run a PHP editor found either at http://www.evrsoft.com/1stpage/
or http://www.soysal.com/PHPEd

When I disable PHP everything seems to run fine.





Reply via email to