php-windows Digest 29 Oct 2003 01:48:34 -0000 Issue 1976
Topics (messages 21908 through 21915):
Re: Problems with TCP/IP and PHP
21908 by: Robert Duda
Speeding up PHP?
21909 by: George Pitcher
21911 by: Andrei BEJENARU
Re: Error connecting to MySQL Database
21910 by: Roderick Martin
help!
21912 by: Patrick Roane
21913 by: Piotr Pluciennik
Help with COM
21914 by: Ethan Nelson
PEAR and PHP 4.3.3 installer
21915 by: Brandon
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 ---
And on Home edition you have been able to setup groups and policies? I don't
think so. While what's under the hood is based on the same code base there
are significant differences between the two. Going into them really isn't
going to solve my problem so I'm not going to waste my time. Besides this is
a news group for PHP not Windows XP. I'm going to get the source code
compile it and step through it with the debugger. If I find something I'll
let you know.
Thanks for trying at least.
Rob
"Dvdmandt" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Ok, can you give me one difference? I have setup servers and PHP on both
> home and professional, as well as connections and firewalls and I haven't
> noticed any difference.. :s
>
> --
> // DvDmanDT
> MSN: dvdmandt€hotmail.com
> Mail: dvdmandt€telia.com
> ##########################
> Please, if you are using windows, you may be infected by Swen. Please go
> here to find out more:
> http://us.mcafee.com/virusInfo/default.asp?id=helpCenter&hcName=swen
> http://securityresponse.symantec.com/avcenter/venc/data/[EMAIL PROTECTED]
> ##########################
> "Robert Duda" <[EMAIL PROTECTED]> skrev i meddelandet
> news:[EMAIL PROTECTED]
> > Networking and security are slightly different. I have both and believe
me
> > there is a big difference between the two.
> >
> > Rob
> >
> > "Dvdmandt" <[EMAIL PROTECTED]> wrote in message
> > news:[EMAIL PROTECTED]
> > > XP home.. :p
> > >
> > > Should be same thing though...
> > >
> > > --
> > > // DvDmanDT
> > > MSN: dvdmandt€hotmail.com
> > > Mail: dvdmandt€telia.com
> > > ##########################
> > > Please, if you are using windows, you may be infected by Swen. Please
go
> > > here to find out more:
> > > http://us.mcafee.com/virusInfo/default.asp?id=helpCenter&hcName=swen
> > >
> http://securityresponse.symantec.com/avcenter/venc/data/[EMAIL PROTECTED]
> > > ##########################
> > > "Robert Duda" <[EMAIL PROTECTED]> skrev i meddelandet
> > > news:[EMAIL PROTECTED]
> > > > I am using the compiled versions and have tried using ip addresses
> > instead
> > > > of host names with the same results. I don't think it's my host
file.
> > > > Besides, why would pike be able to reach the same hosts?
> > > >
> > > > Are you using XP pro?
> > > >
> > > > Rob
> > > >
> > > > "Dvdmandt" <[EMAIL PROTECTED]> wrote in message
> > > > news:[EMAIL PROTECTED]
> > > > > I have been using every version and RC of PHP since 4.2.1 days,
and
> I
> > > have
> > > > > never had any problems, using sockets, mysql_connect,
> > > > > fopen("http://blalbla";) or anything...
> > > > >
> > > > > Did you compile yourself or did you download precompiled ones...
If
> > you
> > > > > compiled yourself, try the precompiled one... Check your hosts
file
> > > > > (C:\windows\system32\drivers\etc) and see if something is wrong
with
> > > it...
> > > > >
> > > > > --
> > > > > // DvDmanDT
> > > > > MSN: dvdmandt€hotmail.com
> > > > > Mail: dvdmandt€telia.com
> > > > > ##########################
> > > > > Please, if you are using windows, you may be infected by Swen.
> Please
> > go
> > > > > here to find out more:
> > > > >
http://us.mcafee.com/virusInfo/default.asp?id=helpCenter&hcName=swen
> > > > >
> > >
> http://securityresponse.symantec.com/avcenter/venc/data/[EMAIL PROTECTED]
> > > > > ##########################
> > > > > "Robert Duda" <[EMAIL PROTECTED]> skrev i meddelandet
> > > > > news:[EMAIL PROTECTED]
> > > > > > I am running the following:
> > > > > >
> > > > > > PHP Version 4.3.4RC2, I tried 4.3.3 with the same results.
> > > > > > MySql Version 4.0.16-nt
> > > > > > Windows XP Professional
> > > > > >
> > > > > > Using PHP as cgi with Roxen.
> > > > > >
> > > > > > Anytime I try to connect to anything over TCP/IP I get an error.
> > Below
> > > > is
> > > > > > the error that I get if I try to connect to an IMAP source:
> > > > > >
> > > > > > Warning: imap_open(): Couldn't open stream
{mydomain.com:143}INBOX
> > in
> > > > > > F:\projects\phpgroupware\email\inc\class.mail_dcom_imap.inc.php
on
> > > line
> > > > > 214
> > > > > >
> > > > > > Warning: imap_open(): Couldn't open stream
> > > > > > {mydomain.com:143/imap/notls}INBOX in
> > > > > > F:\projects\phpgroupware\email\inc\class.mail_dcom_imap.inc.php
on
> > > line
> > > > > 214
> > > > > > (the code comes from phpgroupware version 0.9.14.007)
> > > > > >
> > > > > > And if I try to connect to Mysql I get the following error
unless
> I
> > > use
> > > > > > named-pipes:
> > > > > >
> > > > > > #2004 - Can't create TCP/IP socket (10106)
> > > > > > (This error comes from phpmyadmin during log in, if I change the
> > host
> > > > > entry
> > > > > > to '.' instead of 'localhost' the login succeeds.)
> > > > > >
> > > > > > I have the IMAP extension uncommented and the path to the
> extensions
> > > > > > directory is correct. I can get to the IMAP server from Pike
> running
> > > on
> > > > > the
> > > > > > same box so the proble is not the IMAP server. In fact when I
look
> > at
> > > > the
> > > > > > IMAP logs the connection never gets to the server. This appears
to
> > be
> > > > some
> > > > > > disconnect between the C-client library and the windows TCP/IP
> > library
> > > > > under
> > > > > > XP. Has anyone else had the same problem and if so how did you
fix
> > it?
> > > > > >
> > > > > > Any help with this would be greatly appreciated.
> > > > > >
> > > > > > Thanks,
> > > > > >
> > > > > > Rob
--- End Message ---
--- Begin Message ---
Hi,
I've started redesigning a website that is currently running using
Filemaker/Lasso. The new site will by PHP/MySQL.
I'm in the early stages but I've been doing some basic tests and I'm
disappointed with the speed of PHP in building the web-page. I've set up a
SQL query which takes 0.89 secs to complete in MySQL (using MySQLFront) but
the same query takes 15 seconds to build the page (1275 results out of 2
tables, the largest of which containns 62000 records).
This particular search is concerned with bibliographical data.
After PHP processes the query, I do the following:
- mysql_num_rows - to show how many hits there were
- For each row,
- - read field data into variables
- - perform a function to build a pagerange string for display
- - build the table row to contain the data
I've preset the widths of the columns to a percentage of the page width the
reduce the amount of calculating required by the browser (IE 5.5 in my
case).
Does anyone have any tips to help speed this up for me please.
By the way, the same search on the current web-site took 63 seconds to
produce the web-page.
George in Oxford
--- End Message ---
--- Begin Message ---
First of all, you should break the results into chunks getting 20-30 results
at a time.
A page displaying 1275 result is anything but readable.
Use LIMIT in your SQL query and create a navigation bar.
Also use indexing of the columns and filtering (WHERE conditions).
---
Andrei BEJENARU - Developer
InterAKT Online
http://www.interakt.ro/
Tel: +4021 312.53.12
Tel/Fax: +4021 312.51.91
"George Pitcher" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hi,
>
> I've started redesigning a website that is currently running using
> Filemaker/Lasso. The new site will by PHP/MySQL.
>
> I'm in the early stages but I've been doing some basic tests and I'm
> disappointed with the speed of PHP in building the web-page. I've set up a
> SQL query which takes 0.89 secs to complete in MySQL (using MySQLFront)
but
> the same query takes 15 seconds to build the page (1275 results out of 2
> tables, the largest of which containns 62000 records).
>
> This particular search is concerned with bibliographical data.
>
> After PHP processes the query, I do the following:
>
> - mysql_num_rows - to show how many hits there were
>
> - For each row,
>
> - - read field data into variables
>
> - - perform a function to build a pagerange string for display
>
> - - build the table row to contain the data
>
> I've preset the widths of the columns to a percentage of the page width
the
> reduce the amount of calculating required by the browser (IE 5.5 in my
> case).
>
> Does anyone have any tips to help speed this up for me please.
>
> By the way, the same search on the current web-site took 63 seconds to
> produce the web-page.
>
>
> George in Oxford
--- End Message ---
--- Begin Message ---
Michael Hollmann,
We tried deleting all the keys (some LEGACY-MYSQL would not delete no
matter what we tried), deinstalling, trying to delete the keys that
wouldn't delete before again, and reinstalling.
Same error.
We can run it using "mysqld --console", and it SAYS it's installed as a
service, but it won't run. We've tried searching through the registry
for all mysql instances and making sure the path is correct. Still no
go.
Other items that might help... PHP was installed on this machine before
(3.23.48, I think), but we removed all traces of it before installing
PHP4. We are also trying to install it on our D: drive, rather than our
C: drive.
Shadow,
What do you mean try it from root? And if I want to uninstall the
driver, what file is that exactly? Thanks!
On Oct 27, 2003, at 1:09 PM, Shadow wrote:
Did you try from the root? Is the driver in services? Check and
see....if
you can't start if from services... Go to /mysql/bin and uninstall the
driver then reinstall it. http://www.mysql.com/doc/en/Installing.html
Shadow
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--- End Message ---
--- Begin Message ---
I have been away from my computer for many months and thus, have forgotten many of the
php basics.
I'm trying to get "back into the swing of things" and the problem I'm having is that
my php code is not being parsed. Instead, its being treated like HTML and the code
just shows up on the screen.
I installed SWAMP, so everything works together and should be working fine- tests do
confirm this. Here is my code:
<html>
<head>
<title>S2Design - Order Results</title>
</head>
<body>
<h1>S2Design</h1>
<h2>Order Results</h2>
<h2>Order processed.</h2>
<?
echo "<p>Order processed at ";
echo date("H:i, jS F");
echo "<br>";
echo "<p>Your order is as follows:";
echo "<br>";
echo $_POST["luminaireqty"]." Luminair light<br>";
echo $_POST["coffeeqty"]." coffee tables<br>";
echo $_POST["hallqty"]." hall table<br>";
?>
</body>
</html>
----------------
"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,
check in your php.ini if you've got option "short_open_tag" set to On or try to use
full php open tag - "<?php". Check also extension of your php file or if php is
properly configured - try to display
only phpinfo()... sometimes so simple things can help.
HTH
Piotr
Patrick Roane wrote:
> I have been away from my computer for many months and thus, have forgotten many of
> the php basics.
>
> I'm trying to get "back into the swing of things" and the problem I'm having is that
> my php code is not being parsed. Instead, its being treated like HTML and the code
> just shows up on the screen.
>
> I installed SWAMP, so everything works together and should be working fine- tests do
> confirm this. Here is my code:
>
> <html>
> <head>
> <title>S2Design - Order Results</title>
> </head>
> <body>
> <h1>S2Design</h1>
> <h2>Order Results</h2>
> <h2>Order processed.</h2>
> <?
> echo "<p>Order processed at ";
> echo date("H:i, jS F");
> echo "<br>";
> echo "<p>Your order is as follows:";
> echo "<br>";
> echo $_POST["luminaireqty"]." Luminair light<br>";
> echo $_POST["coffeeqty"]." coffee tables<br>";
> echo $_POST["hallqty"]." hall table<br>";
> ?>
> </body>
> </html>
>
>
> ----------------
> "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 ---
Hello,
I am trying to write some excel functions in PHP 4.3.3 using the COM interface. The
objective it to create a "BottomEdge" border with regular line styles etc... The
actual visual basic code that the macro recorder in excel writes goes as follows:
Range("A13:E13").Select
Selection.Borders(xlDiagonalDown).LineStyle = xlNone
With Selection.Borders(xlEdgeBottom)
.LineStyle = xlContinuous
.Weight = xlThin
.ColorIndex = xlAutomatic
End With
Now my code is in object and looks something like:
$this->sheet->column->EntireColumn->Font->Bold=true;
That would be an example of how I would make an entire column bold (I think).
Anyway... how the heck do I do a "with" statement using this PHP syntax? I tried
separating each line into objects but tells me it can't find function "Border":
$range = $this->sheet->Range("A13:E13");
$selection = $range->Select;
$diagdown = $selection->Borders(xlDiagonalDown);
$diagdown->LineStyle = xlNone;
...
with?
Thanks for the help... I'm pretty new at trying to translate VB syntax into a
compatible PHP code.
-Ethan Nelson,
Modulus, LLC
--- End Message ---
--- Begin Message ---
Hello
I installed PHP 4.3.3 on Windows 200 server. I opted to install PHP via the
installer.
I noticed I have no support for PEAR. Is it possible to add PEAR support, or
am I going to have ot uninstall, and go with the .ZIP package instead of the
installer?
Brandon
--- End Message ---
