php-windows Digest 7 Nov 2003 09:14:54 -0000 Issue 1988
Topics (messages 22025 through 22032):
Re: Why is phpinfo giving me these version numbers?
22025 by: Roderick Martin
22028 by: DvDmanDT
Sending Mail with Outlook express
22026 by: Sukanthi Ganesh
Re: Help with COM
22027 by: Ethan Nelson
include() problem
22029 by: Trystano.aol.com
Re: talking to flash
22030 by: toby z
Re: Two Dimm. Arrays
22031 by: Muhammad Imran
22032 by: Svensson, B.A.T. (HKG)
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 ---
Which log should I be looking at? MySQL appears to maintain several
logs.
On Nov 5, 2003, at 11:59 AM, Eric COLINET wrote:
Hi !
I'm not familiar with the services of windows but for:
- The first question: The version number shown is the version
number of the client API ie the part of the code that was compiled
with PHP (ext/mysql).
under windows the mysql librairy that is bundled with the
PHP distribution is always compiled in.
I don't now if it's an issue with MySQL 4 but i don't think
so and PHP itself can't stop your MySQL4 service
- The second question: The directives are set in your php.ini
file that is somewhere on your system, check the PHP documentation but
it's safe to let the default values (ie: no value).
For the problem that MySQL won't run as a service you should check the
log of your MySQL server, the reason could be trivial.
Good luck ;)
Eric
At 16:40 05/11/2003, Roderick Martin wrote:
I had PHP 4 and MySQL 3 installed on a Windows NT4 server running
Netscape Enterprise. Two weeks ago, I went in, wiped out all traces I
could find of MySQL and installed MySQL 4. Everything went okay
except it refuses to run as a service.
Today I ran phpinfo and under mysql, I have these values...
MySQL Support: enabled
Active Persistent Links: 0
Active Links: 0
Client API version: 3.23.32
Directive Local Value
Master Value
mysql.allow_persistent On
On
mysql.default_host no value
no value
mysql.default_password no value
no value
mysql.default_port no value
no value
mysql.default_socket no value
no value
mysql.default_user no value
no value
mysql.max_links Unlimited Unlimited
mysql.max_persistent Unlimited Unlimited
My first question is; shouldn't the Client API version show me the
4.x.x of MySQL that I installed?
My second question is why are almost all the other directives have no
value?
And might this indicate why it won't run as a service?
--- End Message ---
--- Begin Message ---
I could not find a single log.. :s Anyway, if you solve it, please let me
know.. If you didn't install using an installer, chances are the 'mysql' db
isn't setup, causing mysql to crash...
--
// 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]
##########################
"Roderick Martin" <[EMAIL PROTECTED]> skrev i meddelandet
news:[EMAIL PROTECTED]
> Which log should I be looking at? MySQL appears to maintain several
> logs.
>
>
> On Nov 5, 2003, at 11:59 AM, Eric COLINET wrote:
>
> > Hi !
> >
> > I'm not familiar with the services of windows but for:
> >
> > - The first question: The version number shown is the version
> > number of the client API ie the part of the code that was compiled
> > with PHP (ext/mysql).
> > under windows the mysql librairy that is bundled with the
> > PHP distribution is always compiled in.
> > I don't now if it's an issue with MySQL 4 but i don't think
> > so and PHP itself can't stop your MySQL4 service
> >
> > - The second question: The directives are set in your php.ini
> > file that is somewhere on your system, check the PHP documentation but
> > it's safe to let the default values (ie: no value).
> >
> > For the problem that MySQL won't run as a service you should check the
> > log of your MySQL server, the reason could be trivial.
> >
> > Good luck ;)
> >
> > Eric
> >
> >
> > At 16:40 05/11/2003, Roderick Martin wrote:
> >> I had PHP 4 and MySQL 3 installed on a Windows NT4 server running
> >> Netscape Enterprise. Two weeks ago, I went in, wiped out all traces I
> >> could find of MySQL and installed MySQL 4. Everything went okay
> >> except it refuses to run as a service.
> >>
> >> Today I ran phpinfo and under mysql, I have these values...
> >>
> >> MySQL Support: enabled
> >> Active Persistent Links: 0
> >> Active Links: 0
> >> Client API version: 3.23.32
> >>
> >> Directive Local Value
> >> Master Value
> >>
> >> mysql.allow_persistent On
> >> On
> >> mysql.default_host no value
> >> no value
> >> mysql.default_password no value
> >> no value
> >> mysql.default_port no value
> >> no value
> >> mysql.default_socket no value
> >> no value
> >> mysql.default_user no value
> >> no value
> >> mysql.max_links Unlimited Unlimited
> >> mysql.max_persistent Unlimited Unlimited
> >>
> >> My first question is; shouldn't the Client API version show me the
> >> 4.x.x of MySQL that I installed?
> >>
> >> My second question is why are almost all the other directives have no
> >> value?
> >>
> >> And might this indicate why it won't run as a service?
> >
> >
--- End Message ---
--- Begin Message ---
Is there a way I can send email from my local machine (having no domain) to some email
id. For instance, if you try to send a mail thro' html using <a href mailto:> it will
send the mail thro' the default E-mail program specified in Internet Options. I don't
need any domain or something here. Is this possible in PHP - Win 2k client?
--- End Message ---
--- Begin Message ---
First I would like to reply to this with an update on how I got it to work. Learned
some very interesting things. Second, I have another question.
1)---------
I did not end up using a macro, but instead translated the statements to the following
based on your help Neil:
(example)
$this->xlEdgeBottom = 9;
$this->xlContinuous = 1;
$range = $sheet->Range("A5:E5");
com_propput($range->Borders($this->xlEdgeBottom),LineStyle,$this->xlContinuous);
Notice that I defined the variables for xlEdgeBottom and xlContinuous. The reason is
that these are constants in excel and if you use the constant names, everything freaks
out. I actually had to lookup the constants by name and get their values in excel.
Running the values through the PHP COM functions did the trick. If there is a shorter
way to do this, please let me know.
The other thing is that the "Borders" property in excel does not appear to return an
object. Therefore, given the syntax limitations, I could not do the following:
$range->Borders($this->xlEdgeBottom)->LineStyle = $this->xlContinous;
or
$border = $range->Borders($this->xlEdgeBottom);
$border->LineStyle = $this->xlContinous;
I therefore had to use the com_propput function as stated above.
2)---------
Now, I have the following syntax in VB that I need to convert to PHP:
Range("A7:E20").Select
Selection.Sort Key1:=Range("A7"), Order1:=xlAscending, Header:=xlGuess,
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
It looks you can specify multiple key paramaters as you can sort by more than one
column. I think you might be able to see my difficulty here... some of that syntax is
pretty weird.
-Ethan Nelson,
Modulus, LLC
-----Original 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
--- End Message ---
--- Begin Message ---
Hi all,
I'm having a problem with my scripts in that I'm having the follwoing error
message when I try to include a file into a script...
Warning: Failed opening 'C:\Program Files\Apache Group\Apache\htdocs\mymarket
emplates\header.php' for inclusion (include_path='.;c:\php4\pear') in
C:\Program Files\Apache Group\Apache\htdocs\mymarket\index.php on line 22
why is this showing up within my error message,
(include_path='.;c:\php4\pear')?
Within the php.ini file the inlcude_path directive is commented out, so I
doubt thats the cause.
Cheers guys
Trystan Hughes
[EMAIL PROTECTED]
--- End Message ---
--- Begin Message ---
hay
i generated a pie graph in flash passing it a string of vales from a
php script which ofcourse got those from a table query
i did this with bar graphs and jp-graphs too
all u have to do is make proper strings of values and pass them to a
page which would generate a graph for u based on the values passed
but then, all this is to generate a graph
n i dont know what u are actually at there ....
if u'r tryin it for graphs ill be able to help u out :)
good luck
toby
--- Bobo Wieland <[EMAIL PROTECTED]> wrote: > Hi!
>
> How do I set up a php-script so that it can communicate with Flash
> MX?
>
> I send a querystring to the php-script - but I don't know how to
> return
> anything from that function or how to check if it works...
>
> Anyone? I guess it would be the same principles as to communicate
> with some
> other program, so if you know how to communicate with something
> other then
> Flash that would be great too...
>
> thanks!
>
> .bobo
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
________________________________________________________________________
Want to chat instantly with your online friends? Get the FREE Yahoo!
Messenger http://mail.messenger.yahoo.co.uk
--- End Message ---
--- Begin Message ---
Just assigning/retriving the values?
Imran
----- Original Message -----
From: Muhammad Imran <[EMAIL PROTECTED]>
To: Svensson, B.A.T. (HKG) <[EMAIL PROTECTED]>
Sent: Friday, November 07, 2003 11:53 AM
Subject: Re: [PHP-WIN] Two Dimm. Arrays
> assigning/retriving the values?
> ----- Original Message -----
> From: Svensson, B.A.T. (HKG) <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Thursday, November 06, 2003 12:56 PM
> Subject: RE: [PHP-WIN] Two Dimm. Arrays
>
>
> > What's your problem?
> >
> > Creating a FOR-loop or assigning/retriving the values?
> >
> > -----Original Message-----
> > From: Muhammad Imran
> > To: [EMAIL PROTECTED]
> > Sent: 11/6/2003 3:35 AM
> > Subject: [PHP-WIN] Two Dimm. Arrays
> >
> > How I can populate and restore the two dimensional array dynamically i.e
> > under for/while loop. This is used in pear db but not directly link to
> > just pear. Below is the code in which array is build manually.
> >
> > array( array(1, 'one', 'en'),
> > array(2, 'two', 'to'),
> > array(3, 'three', 'tre'),
> > array(4, 'four', 'fire'));
> >
> > Thank you,
> > Imran
> >
> > > From: "Muhammad Imran" <[EMAIL PROTECTED]>
> > > To: <[EMAIL PROTECTED]>
> > > Sent: Wednesday, November 05, 2003 1:24 PM
> > > Subject: [PHP-WIN] Pear ::DB
> > >
> > >
> > > I am using Pear::DB package, Can anybody help me if I have array of
> > values
> > > and I want to prepare the insert statements through those arrays.
> > >
> > > Below is the example which I find on every site but not found what I
> > need,
> > > please help me.
> > >
> > > Thank you,
> > > Imran
> > >
> > > $alldata = array( array(1, 'one', 'en'),
> > > array(2, 'two', 'to'),
> > > array(3, 'three', 'tre'),
> > > array(4, 'four', 'fire'));
> > > $sth = $dbh->prepare("INSERT INTO numbers VALUES(?,?,?)");
> > >
> > > $dbh->executeMultiple($sth, $alldata);
> > > }
> > >
> > >
> > >
> >
> > --
> > PHP Windows Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
> > --
> > PHP Windows Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
> >
>
--- End Message ---
--- Begin Message ---
Is this what you need to know(?):
http://www.php.net/language.variables
If not let me know, and I'll guide you elsewhere.
-----Original Message-----
From: Muhammad Imran
To: [EMAIL PROTECTED]
Sent: 11/7/2003 7:54 AM
Subject: Fw: [PHP-WIN] Two Dimm. Arrays
Just assigning/retriving the values?
Imran
----- Original Message -----
From: Muhammad Imran <[EMAIL PROTECTED]>
To: Svensson, B.A.T. (HKG) <[EMAIL PROTECTED]>
Sent: Friday, November 07, 2003 11:53 AM
Subject: Re: [PHP-WIN] Two Dimm. Arrays
> assigning/retriving the values?
> ----- Original Message -----
> From: Svensson, B.A.T. (HKG) <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Thursday, November 06, 2003 12:56 PM
> Subject: RE: [PHP-WIN] Two Dimm. Arrays
>
>
> > What's your problem?
> >
> > Creating a FOR-loop or assigning/retriving the values?
> >
> > -----Original Message-----
> > From: Muhammad Imran
> > To: [EMAIL PROTECTED]
> > Sent: 11/6/2003 3:35 AM
> > Subject: [PHP-WIN] Two Dimm. Arrays
> >
> > How I can populate and restore the two dimensional array dynamically
i.e
> > under for/while loop. This is used in pear db but not directly link
to
> > just pear. Below is the code in which array is build manually.
> >
> > array( array(1, 'one', 'en'),
> > array(2, 'two', 'to'),
> > array(3, 'three', 'tre'),
> > array(4, 'four', 'fire'));
> >
> > Thank you,
> > Imran
> >
> > > From: "Muhammad Imran" <[EMAIL PROTECTED]>
> > > To: <[EMAIL PROTECTED]>
> > > Sent: Wednesday, November 05, 2003 1:24 PM
> > > Subject: [PHP-WIN] Pear ::DB
> > >
> > >
> > > I am using Pear::DB package, Can anybody help me if I have array
of
> > values
> > > and I want to prepare the insert statements through those arrays.
> > >
> > > Below is the example which I find on every site but not found what
I
> > need,
> > > please help me.
> > >
> > > Thank you,
> > > Imran
> > >
> > > $alldata = array( array(1, 'one', 'en'),
> > > array(2, 'two', 'to'),
> > > array(3, 'three', 'tre'),
> > > array(4, 'four', 'fire'));
> > > $sth = $dbh->prepare("INSERT INTO numbers VALUES(?,?,?)");
> > >
> > > $dbh->executeMultiple($sth, $alldata);
> > > }
> > >
> > >
> > >
> >
> > --
> > PHP Windows Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
> > --
> > PHP Windows Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
> >
>
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--- End Message ---
