php-windows Digest 22 May 2001 07:52:20 -0000 Issue 611
Topics (messages 7789 through 7802):
OK, I'm officially screwed if I can't get some suggestions
7789 by: Asendorf, John
7790 by: Asendorf, John
7791 by: Tim Uckun
7792 by: Asendorf, John
Question about TRUE and FALSE
7793 by: andrew morton
7794 by: andrew morton
sybase_ct module
7795 by: Steve Meyers
Re: DNS/WEB SERVER WITH APACHE/PHP/WIN98
7796 by: Calvin Chang
7797 by: Mike Kelley
7798 by: andrew morton
7799 by: Ignatius Teo
7801 by: OoCobra97.aol.com
escape loop on timeout
7800 by: Brendan Gogarty
Variable in the statement
7802 by: Pepijn Minderhoud
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]
----------------------------------------------------------------------
OK...
PHP 4.0.4. IIS 4, Oracle 8 client, Oracle 7.3.4 backend, webserver in DMZ
I'm having some speed problems with a data entry front end that is being
used in house.
The queries sometimes (most times) take upwards of 13-17 seconds to run.
I've put a timer which starts at the beginning of the script and doesn't end
until the very end. It usually registers 2-3 seconds. I'm using sessions
via files.
I've tried making the code as clean as possible, and the scripts themselves
seem to be running very fast. Would sessions be the most likely culprit for
my speed loss? It's (the slowness) threatening to kill the whole project...
We have a similar ASP/M$SQL server application (vendor product) which
blazes... and it's driving me nuts...
Thanks in advance if you have some clues for me...
John
---------------------
John Asendorf - [EMAIL PROTECTED]
Web Applications Developer
http://www.lcounty.com - NEW FEATURES ADDED DAILY!
Licking County, Ohio, USA
740-349-3631
Aliquando et insanire iucundum est
I don't think that it's an SQL issue. Searches on the customer "Smith" run
through and back (including formating the data) in about 3.5 seconds (per
the timer in the script) but take about 15 seconds to see a response on the
client. The whole building is base-T and fiber....
---------------------
John Asendorf - [EMAIL PROTECTED]
Web Applications Developer
http://www.lcounty.com - NEW FEATURES ADDED DAILY!
Licking County, Ohio, USA
740-349-3631
Aliquando et insanire iucundum est
> -----Original Message-----
> From: Dan Cleveland [mailto:[EMAIL PROTECTED]]
> Sent: Monday, May 21, 2001 3:37 PM
> To: Asendorf, John
> Subject: Re: [PHP-WIN] OK, I'm officially screwed if I can't get some
> suggestions
>
>
> have you also tried cleaning up your sql table joins?
> Depending on the
> order of your where clause can increase or decrease speed.
>
> select * from table_1 T1, table_2 T2 where T1.id = 5 and T2.id = 6 and
> T1.t2_id = T2.id
>
> that select will run slower then
>
> select * from table_1 T1, table_2 T2 where T1.ts_id = T2.id
> and T1.id = 5
> and T2.id = 6
>
> the reason is because in the second one the table are joined
> right away
> and in the first a cartisean (sp) product is first made of table_1 and
> table_2 and then the rows are eleminated. So depeding on your tables
> sizes, the selects could be dragging the overall time down.
>
> Just a thought.
>
> Dan
>
> +-------------------------------------------------------------------+
> | |
> | If Yoda so strong in force is, |
> | why words in proper order he cannot put? |
> | |
> +-------------------------------------------------------------------+
> | |
> +-------------------------------------------------------------------+
> | Daniel J. Cleveland |
> | e-mail: [EMAIL PROTECTED]|
> +-------------------------------------------------------------------+
>
>
At 03:24 PM 5/21/2001 -0400, Asendorf, John wrote:
>OK...
>
>PHP 4.0.4. IIS 4, Oracle 8 client, Oracle 7.3.4 backend, webserver in DMZ
How are you connecting to the database? Are you using persistent
connections?Have tried to run the same code on linux to see if it runs faster?
:wq
Tim Uckun
Due Diligence Inc. http://www.diligence.com/ Americas Background
Investigation Expert.
If your company isn't doing background checks, maybe you haven't considered
the risks of a bad hire.
I'm afraid I don't even have a Linux box I can even run it on... I'm using
the OCI calls with OCIPLogon
---------------------
John Asendorf - [EMAIL PROTECTED]
Web Applications Developer
http://www.lcounty.com - NEW FEATURES ADDED DAILY!
Licking County, Ohio, USA
740-349-3631
Aliquando et insanire iucundum est
> -----Original Message-----
> From: Tim Uckun [mailto:[EMAIL PROTECTED]]
> Sent: Monday, May 21, 2001 3:49 PM
> To: Asendorf, John; Php-Windows (E-mail)
> Subject: Re: [PHP-WIN] OK, I'm officially screwed if I can't get some
> suggestions
>
>
> At 03:24 PM 5/21/2001 -0400, Asendorf, John wrote:
> >OK...
> >
> >PHP 4.0.4. IIS 4, Oracle 8 client, Oracle 7.3.4 backend,
> webserver in DMZ
>
> How are you connecting to the database? Are you using persistent
> connections?Have tried to run the same code on linux to see
> if it runs faster?
>
> :wq
>
> Tim Uckun
> Due Diligence Inc. http://www.diligence.com/ Americas Background
> Investigation Expert.
> If your company isn't doing background checks, maybe you
> haven't considered
> the risks of a bad hire.
>
>
> --
> 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]
>
Anyone have any idea why the constant TRUE evaluates to 1 but FALSE
evaluates to "" and not 0?
The fragment
if (!"") print "true";
else print "false";
works the same as
if (!FALSE) print "true";
else print "false";
I'm used to the Cish behavior of false=0 and true!=0, is this something
that was inherited from Perl?
andrew
Err never mind it's there in the manual under expressions, I expected it
to be in the constants section.
sorry,
andrew
-----Original Message-----
From: andrew morton
Sent: Monday, May 21, 2001 13:21
To: Php-Windows (E-mail)
Subject: [PHP-WIN] Question about TRUE and FALSE
Anyone have any idea why the constant TRUE evaluates to 1 but FALSE
evaluates to "" and not 0?
The fragment
if (!"") print "true";
else print "false";
works the same as
if (!FALSE) print "true";
else print "false";
I'm used to the Cish behavior of false=0 and true!=0, is this something
that was inherited from Perl?
andrew
--
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]
Has anybody successfully used the sybase_ct.dll? It is linking in fine, but
I don't think it's finding the interfaces file.
Thanks!
Steve Meyers
Thank you for your reply.
Probably I can explain more detail to you the configuration:
I want to install one web server in the main office and 3 pcs at different branches.
The main purpose is to online the transactions at branches with main office.
The web server is connected to internet using ISDN line with one fixed IP address. I
understand that one DNS server needs to be set up in order to allow the branches to
get connect with web server. For instance, when someone at branch connect to internet
and type www.abc.com.my and this will normally connect to the web server in the main
office. How possible this can be done ?
> Well, that depends on what you wanna do?
>
> >
> > Is it possible to set up a DNS server in a web server ?
>
> A server acting as web server can also host a DNS server. It's just 2
> different services/deamons running on different IP ports (http/web
> commonly uses port 80 and DNS querys uses port 53).
> If you want the Apache web server service to act as a DNS server, it's
> not possible as far as I know.
>
> > For your information, I intend also to develope in Apache/PHP/win98 environment.
>
> I don't know of any DNS server software for W98. Since DNS is quite a
> important service I wouldn't recoment running it on Win9X platform. In
> tesing/development environments you could replace DNS functionallity
> with the hosts-file.
>
> /Johan
>
> --
> 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 don't need the DNS Unless you want to pay for the www.abc.com.my domain. All your
remote offices need to do to connect to the server is type in the IP of the server.
The remote boxes will be directed into the web root directory. Give it a try, you
already have what you want. The only plus to a domain name instead of an IP is
remeberability. Since your are setting up the remote boxes (I assume) all you need to
do is bookmark your server and teach the end users how to access the bookmark.
MK
Calvin Chang wrote:
> Thank you for your reply.
>
> Probably I can explain more detail to you the configuration:
>
> I want to install one web server in the main office and 3 pcs at different branches.
> The main purpose is to online the transactions at branches with main office.
>
> The web server is connected to internet using ISDN line with one fixed IP address. I
> understand that one DNS server needs to be set up in order to allow the branches to
> get connect with web server. For instance, when someone at branch connect to internet
> and type www.abc.com.my and this will normally connect to the web server in the main
> office. How possible this can be done ?
>
>
>
>
>
>> Well, that depends on what you wanna do?
>>
>>> Is it possible to set up a DNS server in a web server ?
>>
>> A server acting as web server can also host a DNS server. It's just 2
>> different services/deamons running on different IP ports (http/web
>> commonly uses port 80 and DNS querys uses port 53).
>> If you want the Apache web server service to act as a DNS server, it's
>> not possible as far as I know.
>>
>>> For your information, I intend also to develope in Apache/PHP/win98 environment.
>>
>> I don't know of any DNS server software for W98. Since DNS is quite a
>> important service I wouldn't recoment running it on Win9X platform. In
>> tesing/development environments you could replace DNS functionallity
>> with the hosts-file.
>>
>> /Johan
>>
>> --
>> 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]
>
--
"There is a principle which is a bar against all information, which is proof against
all arguments and which cannot fail to keep a man in everlasting ignorance - that
principle is contempt prior to investigation." - Herbert Spencer
Michael Kelley
[EMAIL PROTECTED]
Programmer/Systems Analyst I
New Mexico State University
Information and Communication Technologies
Work # (505)-646-1374
P.O. Box 30001
MSC: 3AT
Las Cruces, NM 88003
If you do want a DNS name you might want to check out
http://www.dyndns.org/ they'll give you yourname.dyndns.org or
yourname.dnsalias.com etc. It's a free service that accepts donations.
andrew
-----Original Message-----
From: Mike Kelley [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 21, 2001 20:08
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-WIN] DNS/WEB SERVER WITH APACHE/PHP/WIN98
You don't need the DNS Unless you want to pay for the www.abc.com.my
domain. All your remote offices need to do to connect to the server is
type in the IP of the server. The remote boxes will be directed into the
web root directory. Give it a try, you already have what you want. The
only plus to a domain name instead of an IP is remeberability. Since
your are setting up the remote boxes (I assume) all you need to do is
bookmark your server and teach the end users how to access the bookmark.
MK
Calvin Chang wrote:
> Thank you for your reply.
>
> Probably I can explain more detail to you the configuration:
>
> I want to install one web server in the main office and 3 pcs at
different branches.
> The main purpose is to online the transactions at branches with main
office.
>
> The web server is connected to internet using ISDN line with one fixed
IP address. I
> understand that one DNS server needs to be set up in order to allow
the branches to
> get connect with web server. For instance, when someone at branch
connect to internet
> and type www.abc.com.my and this will normally connect to the web
server in the main
> office. How possible this can be done ?
>
>
>
>
>
>> Well, that depends on what you wanna do?
>>
>>> Is it possible to set up a DNS server in a web server ?
>>
>> A server acting as web server can also host a DNS server. It's just 2
>> different services/deamons running on different IP ports (http/web
>> commonly uses port 80 and DNS querys uses port 53).
>> If you want the Apache web server service to act as a DNS server,
it's
>> not possible as far as I know.
>>
>>> For your information, I intend also to develope in Apache/PHP/win98
environment.
>>
>> I don't know of any DNS server software for W98. Since DNS is quite a
>> important service I wouldn't recoment running it on Win9X platform.
In
>> tesing/development environments you could replace DNS functionallity
>> with the hosts-file.
>>
>> /Johan
>>
>> --
>> 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]
>
--
"There is a principle which is a bar against all information, which is
proof against all arguments and which cannot fail to keep a man in
everlasting ignorance - that principle is contempt prior to
investigation." - Herbert Spencer
Michael Kelley
[EMAIL PROTECTED]
Programmer/Systems Analyst I
New Mexico State University
Information and Communication Technologies
Work # (505)-646-1374
P.O. Box 30001
MSC: 3AT
Las Cruces, NM 88003
--
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]
1. I'm not so sure you should be running a production web server using
Win98. If you must use Windows, why not Win2K?
2. Perhaps you really mean to connect the 3 branches via an intranet, rather
than the internet? In which case, you SHOULD be using NT/Win2K AS and use
LMHOSTS to do the resolution.
3. Perhaps you should ask your networking people to do this - unless you ARE
the networking person???
4. How is this PHP related?
Ignatius Teo
Project Manager, Internet Access Services
Information Technology Directorate
Southern Cross University
PO Box 157, Lismore NSW 2480
Email: iteo_at_scu_edu_au
Phone: +61 2 6620-3221
Fax : +61 2 6620-3033
-----BEGIN GEEK CODE BLOCK-----
Version: 3.1
GB/IT$ d++(-)@ s++:++@ a>? C++++ UL !P$ L+
!E W+$ N- o? !K w O---- M- V PS PE++ Y+(--)
PGP- t++@ 5-- X++@ R* tv- b+ DI++ D++@ G
e++ h---- r+++ y++++**
------END GEEK CODE BLOCK------
-----Original Message-----
From: Mike Kelley [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 22 May 2001 13:08
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-WIN] DNS/WEB SERVER WITH APACHE/PHP/WIN98
You don't need the DNS Unless you want to pay for the www.abc.com.my domain.
All your remote offices need to do to connect to the server is type in the
IP of the server. The remote boxes will be directed into the web root
directory. Give it a try, you already have what you want. The only plus to a
domain name instead of an IP is remeberability. Since your are setting up
the remote boxes (I assume) all you need to do is bookmark your server and
teach the end users how to access the bookmark.
MK
Calvin Chang wrote:
> Thank you for your reply.
>
> Probably I can explain more detail to you the configuration:
>
> I want to install one web server in the main office and 3 pcs at different
branches.
> The main purpose is to online the transactions at branches with main
office.
>
> The web server is connected to internet using ISDN line with one fixed IP
address. I
> understand that one DNS server needs to be set up in order to allow the
branches to
> get connect with web server. For instance, when someone at branch connect
to internet
> and type www.abc.com.my and this will normally connect to the web server
in the main
> office. How possible this can be done ?
>
>
>
>
>
>> Well, that depends on what you wanna do?
>>
>>> Is it possible to set up a DNS server in a web server ?
>>
>> A server acting as web server can also host a DNS server. It's just 2
>> different services/deamons running on different IP ports (http/web
>> commonly uses port 80 and DNS querys uses port 53).
>> If you want the Apache web server service to act as a DNS server, it's
>> not possible as far as I know.
>>
>>> For your information, I intend also to develope in Apache/PHP/win98
environment.
>>
>> I don't know of any DNS server software for W98. Since DNS is quite a
>> important service I wouldn't recoment running it on Win9X platform. In
>> tesing/development environments you could replace DNS functionallity
>> with the hosts-file.
>>
>> /Johan
>>
>> --
>> 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]
>
--
"There is a principle which is a bar against all information, which is proof
against all arguments and which cannot fail to keep a man in everlasting
ignorance - that principle is contempt prior to investigation." - Herbert
Spencer
Michael Kelley
[EMAIL PROTECTED]
Programmer/Systems Analyst I
New Mexico State University
Information and Communication Technologies
Work # (505)-646-1374
P.O. Box 30001
MSC: 3AT
Las Cruces, NM 88003
--
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]
Hello, you can also use mydomain.com...its your own domain www.abc.com you
have full control of how to set it up, plus its free.
~Jeff
hi,
just wondering if there was any easy way to break/escape from a loop
(for loop) if the loop exceeds a maximum time.
I realise that set_timeout applies to the whole script but i am just
interested in a sub function of the script.
cheers!
brendan.
Hi, I've got a problem with variables.
I am trying to make a select staement for mysql using a variable in the
where clause. If i don't use the variable the result comes out fine but
with it there are parser errors on other lines. Can anybody tell me how
to insert a variable in such a script.
<html>
<body>
<?php
global $titel;
$titel='html'
$db = mysql_connect("localhost", "root") or die ("Kan geen connectie
maken met het database programma. De Database server kan uit staan.");;
mysql_select_db("setf",$db) or die ("Kan geen connectie maken met de
database");
$result = mysql_query("SELECT titel FROM onderwerpen where
titel=$titel")
or die ("kan niks uit de database lezen. Reload en probeer het nog een
keer.");
// the other select i used:
$result = mysql_query("SELECT titel FROM onderwerpen where
titel='$titel'")
//The working select without a variable
$result = mysql_query("SELECT titel FROM onderwerpen where
titel='html'")
printf("titel: %s<br>\n", mysql_result($result,0,"titel"));
?>
</body>
</html>
If anybody can help me Thanx in advance
Pepijn
