php-windows Digest 29 Oct 2003 14:44:02 -0000 Issue 1977
Topics (messages 21916 through 21921):
Re: Run php file every day?
21916 by: Nick H -- Network Operations
Re: PEAR and PHP 4.3.3 installer
21917 by: Frank M. Kromann
extensions
21918 by: Shmuel
Re: Help with COM
21919 by: N.A.Morgan.bton.ac.uk
Re: Speeding up PHP?
21920 by: George Pitcher
recommendations - php/mysql discussion board / forum
21921 by: Croskerry, Dan
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 ---
see microsoft's 'at' utility. from command line type: at /?
it'll explain what to do.
Regards,
Nick H.
Network Operations Center
[EMAIL PROTECTED]
Please rate my performance! http://www.supportteam.net/rate.php3
Please submit all new support requests to
http://ticketmonster.hostingsupport.com/
-------------------------------------------
Privileged/Confidential Information may be contained in this message. If
you are not the addressee indicated in this message (or responsible for
delivery of the message to such person), you may not copy or deliver this
message to anyone. In such case, you should destroy this message and kindly
notify the sender by reply email. Please advise immediately if you or your
employer do not consent to Internet email for messages of this kind.
Opinions, conclusions and other information in this message that do not
relate to the official business of my firm shall be understood as neither
given nor endorsed by it.
----- Original Message -----
From: "Luis Moreira" <[EMAIL PROTECTED]>
To: "Disko_kex" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Tuesday, October 28, 2003 2:54 AM
Subject: Re: [PHP-WIN] Run php file every day?
> Try MS Task scheduling
>
>
> ----- Original Message -----
> From: "Disko_kex" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Monday, October 27, 2003 5:06 PM
> Subject: [PHP-WIN] Run php file every day?
>
>
> > Hi,
> >
> > Is there an easy way to run a php file same time every day? Im running
> > IIS5 and PHP4.3.3.
> >
> > Thx
> >
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
--- End Message ---
--- Begin Message ---
Hi,
Take a look at http://go-pear.org/
- Frank
> 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
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--- End Message ---
--- Begin Message ---
Hi,
Is there any manual about the php extension programming ?
What does a dll need to work as a php module ? (PHP_MINIT_FUNCTION and
so on).
Shmuel.
--- End Message ---
--- Begin Message ---
Why not try to execute the macro,
$Excel->application->run("book.xls!macro");
but if this is not possible / desirable, the with statement:
With Selection.Borders(xlEdgeBottom)
.LineStyle = xlContinuous
.Weight = xlThin
.ColorIndex = xlAutomatic
End With
is only a shorthand way of specifying
Selection.Borders(xlEdgeBottom).LineStyle = xlContinuous
Selection.Borders(xlEdgeBottom).Weight = xlThin
Selection.Borders(xlEdgeBottom).ColorIndex = xlAutomatic
Hope this helps,
Regards,
Neil Morgan
-----Original Message-----
From: Ethan Nelson [mailto:[EMAIL PROTECTED]
Sent: 28 October 2003 22:13
To: [EMAIL PROTECTED]
Subject: [PHP-WIN] Help with COM
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
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--- End Message ---
--- Begin Message ---
Andrei,
Thanks for the tip. I've now 'paged' it and the results are fine.
Cheers
George
> -----Original Message-----
> From: Andrei BEJENARU [mailto:[EMAIL PROTECTED]
> Sent: 28 October 2003 4:52 pm
> To: [EMAIL PROTECTED]
> Subject: [PHP-WIN] Re: Speeding up PHP?
>
>
> 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
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--- End Message ---
--- Begin Message ---
Hi List,
Can anyone recommend a good, free php/mysql discussion board / message board
/ forum, whatever you want to call it? I'm just looking for a simple one
that is easy to configure and even modify slightly. I know there are loads
out there but I just wanted to know if any of you like one in particular.
Thanks in advance,
_____
Dan
--- End Message ---
