php-windows Digest 18 Aug 2007 01:39:14 -0000 Issue 3312
Topics (messages 28371 through 28382):
PHP Windows Installer maintainer finally joins the list
28371 by: John Mertic
28372 by: Murphy, Matt
28373 by: Niel Archer
28374 by: John Mertic
28377 by: Niel Archer
28381 by: Jürgen Wind
28382 by: John Mertic
Array Question
28375 by: Daniel Kaliel
28376 by: Vandegrift, Ken
28378 by: tg-php.gryffyndevelopment.com
strange mktime
28379 by: Peter Wechtersbach
28380 by: Michael Southworth
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 ---
Hi everyone,
My name is John Mertic, and I created and maintain the PHP Windows
installer. I'd like to make myself available to the list as a both a
resource for people using the installer as well as working on PHP
under Windows in general.
In searching the archives, I see that there seems to be general
recommendation *against* using the installer. Why is this? Is there
something that the installer doesn't do correctly or lacks that makes
it unsuitable?
I'm open to any and all suggestions/comments.
--
--
John Mertic "Explaining a joke
is like dissecting a frog: you
[EMAIL PROTECTED] understand it better,
but the frog dies in the
process."
-Mark Twain
--- End Message ---
--- Begin Message ---
I use and like the installer, but I really wish it were easier to set up
SSL support.
Matt
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John
Mertic
Sent: Friday, August 17, 2007 6:58 AM
To: [EMAIL PROTECTED]
Subject: [PHP-WIN] PHP Windows Installer maintainer finally joins the
list
Hi everyone,
My name is John Mertic, and I created and maintain the PHP Windows
installer. I'd like to make myself available to the list as a both a
resource for people using the installer as well as working on PHP under
Windows in general.
In searching the archives, I see that there seems to be general
recommendation *against* using the installer. Why is this? Is there
something that the installer doesn't do correctly or lacks that makes it
unsuitable?
I'm open to any and all suggestions/comments.
--
--
John Mertic "Explaining a joke
is like dissecting a frog: you
[EMAIL PROTECTED] understand it better,
but the frog dies in the
process."
-Mark Twain
--
PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit:
http://www.php.net/unsub.php
--- End Message ---
--- Begin Message ---
Hi John
> In searching the archives, I see that there seems to be general
> recommendation *against* using the installer. Why is this? Is there
> something that the installer doesn't do correctly or lacks that makes
> it unsuitable?
My own recommendation is based on the manual, and no reflection of the
installer
"There are several all-in-one installers over the Internet, but none of
those are endorsed by PHP.net, as we believe that the manual
installation is the best choice to have your system secure and optimised."
My only pet hate is probably out of your control. I would like PEAR to
respect my directory choices, instead of using C:\php5 for downloads, no
matter what I set.
--
Niel Archer
--- End Message ---
--- Begin Message ---
On 8/17/07, Niel Archer <[EMAIL PROTECTED]> wrote:
> My own recommendation is based on the manual, and no reflection of the
> installer
>
> "There are several all-in-one installers over the Internet, but none of
> those are endorsed by PHP.net, as we believe that the manual
> installation is the best choice to have your system secure and optimised."
Let me look into having that changed; I could just do it, but I'd like
a consensus on what the appropriate wording should be.
> My only pet hate is probably out of your control. I would like PEAR to
> respect my directory choices, instead of using C:\php5 for downloads, no
> matter what I set.
It should pick the installation directory of PHP by default from my
experience; but you might want to ask the PEAR folks about that one.
--
--
John Mertic "Explaining a joke
is like dissecting a frog: you
[EMAIL PROTECTED] understand it better,
but the frog dies in the
process."
-Mark Twain
--- End Message ---
--- Begin Message ---
> > My only pet hate is probably out of your control. I would like PEAR to
> > respect my directory choices, instead of using C:\php5 for downloads, no
> > matter what I set.
>
> It should pick the installation directory of PHP by default from my
> experience; but you might want to ask the PEAR folks about that one.
It should, but it doesn't. It's fine for installing PEAR itself (using
($default as the directory), but it puts downloaded files in the default
location of "C:\php5" It might only be support files (docs, etc), it's
been a while since I had to install and correct it.
--
Niel Archer
--- End Message ---
--- Begin Message ---
>In searching the archives, I see that there seems to be general
>recommendation *against* using the installer.
>Why is this?
how can one recommend an installer that messes up session.save_path and
upload_tmp_dir ?
(unfixed for months, dunno if fixed meanwhile)
--
View this message in context:
http://www.nabble.com/PHP-Windows-Installer-maintainer-finally-joins-the-list-tf4285285.html#a12207057
Sent from the Php - Windows mailing list archive at Nabble.com.
--- End Message ---
--- Begin Message ---
On 8/17/07, Jürgen Wind <[EMAIL PROTECTED]> wrote
> how can one recommend an installer that messes up session.save_path and
> upload_tmp_dir ?
> (unfixed for months, dunno if fixed meanwhile)
>
This has been fixed for nearly 9 months now.
http://bugs.php.net/bug.php?id=39842
--
--
John Mertic "Explaining a joke
is like dissecting a frog: you
[EMAIL PROTECTED] understand it better,
but the frog dies in the
process."
-Mark Twain
--- End Message ---
--- Begin Message ---
I have pull a bunch of data from an SQL database through a query. The problem
I am running into is I pull two fields with the exact same name. How do I grab
the right info? I have been using mydata ß the array name.
mydata['contactID'] Should I instead use the array value so mydata[8]?
--- End Message ---
--- Begin Message ---
Just use a column alias in your sql query and reference the alias in your array.
SELECT t1.contactID as 'contactID_1', t2.contactID AS 'contactID_2'
FROM table1 t1, table2 t2 ...rest of query
Then your results data array can be referenced like so:
mydata['contactID_1']
mydata['contactID_2']
Ken Vandegrift
Shari's Management Corporation
Web Developer/Administrator
[EMAIL PROTECTED]
-----Original Message-----
From: Daniel Kaliel [mailto:[EMAIL PROTECTED]
Sent: Friday, August 17, 2007 9:40 AM
To: [EMAIL PROTECTED]
Subject: [PHP-WIN] Array Question
I have pull a bunch of data from an SQL database through a query. The problem
I am running into is I pull two fields with the exact same name. How do I grab
the right info? I have been using mydata ß the array name.
mydata['contactID'] Should I instead use the array value so mydata[8]?
--- End Message ---
--- Begin Message ---
I assume you're getting fields with the same name from pulling data from two or
more tables. Something like "SELECT * FROM TABLE1, TABLE2 WHERE TABLE1.id =
TABLE2.id" or something like that.
At any rate, if you can.. it's always good to name the fields you want to pull
instead of using "SELECT *". I know it's a pain sometimes, but in this case it
may be somewhat necessary.
What you can do is use an alias for the duplicate field name. Something like
this:
"SELECT TABLE1.id as id1, TABLE2.id as id2 FROM...."
Then in your array, it'll be $mydata['id1'] and $mydata['id2']
Works the same with a single table pull and I usually alias the table names too:
SELECT t1.id id1, t2.id id2 FROM TABLE1 t1, TABLE2 t2 WHERE t1.id = t2.id
(can't remember if you can use the alias in the WHERE to make it "id1 = id2" or
not)
The "as" is usually optional, but sometimes nice to keep things clear. In some
flavors of SQL it's required.
-TG
= = = Original message = = =
I have pull a bunch of data from an SQL database through a query. The problem
I am running into is I pull two fields with the exact same name. How do I grab
the right info? I have been using mydata ~ the array name.
mydata['contactID'] Should I instead use the array value so mydata[8]?
___________________________________________________________
Sent by ePrompter, the premier email notification software.
Free download at http://www.ePrompter.com.
--- End Message ---
--- Begin Message ---
Hello, im found some strange behaviour. Someone knows whats is going on or
it is a bug?:
lets do like this:
three dates in timestamp:
27.10.2007: 1193436000
28.10.2007: 1193522400
29.10.2007: 1193612400
convert back:
1193436000: 27.10.2007 00:00:00
1193522400: 28.10.2007 00:00:00
1193612400: 29.10.2007 00:00:00
And one day is always 24 hours * 60 minutes * 60 secondes = 86400. So the
difference between these three dates in timestamp should also be the
same.But:
day2-day1 = 86400
day3-day2 = 90000
Here is my code, im using PHP Version 5.1.6:
echo ' three dates in timestamp: <br>';
$day1 = mktime(0, 0, 0, 10, 27, 2007);
$day2 = mktime(0, 0, 0, 10, 28, 2007);
$day3 = mktime(0, 0, 0, 10, 29, 2007);
echo '27.10.2007: '.$day1.'<br>';
echo '28.10.2007: '.$day2.'<br>';
echo '29.10.2007: '.$day3.'<br><br>';
echo 'convert back: <br>';
echo $day1.': '.date('d.m.Y H:i:s',$day1).'<br>';
echo $day2.': '.date('d.m.Y H:i:s',$day2).'<br>';
echo $day3.': '.date('d.m.Y H:i:s',$day3).'<br><br><br>';
echo 'And one day is always 24 hours * 60 minutes * 60 secondes =
86400. So the difference between these three dates in timestamp should also
be the same.But: <br>';
echo 'day2-day1 = '.($day2-$day1).'<br>';
echo 'day3-day2 = '.($day3-$day2).'<br>';
--- End Message ---
--- Begin Message ---
Hello,
Perhaps this has something to do with the daylight savings time calculations
being handled by the underlying system, since the difference is 1 hour;
60*60 = 3600. This could be checked to make sure that the total time
difference from one year remains the same, or that the first 6 months has 1
hour less and the second 6 months have one hour more.
see
http://en.wikipedia.org/wiki/Daylight_saving_time_around_the_world
for details. Apparently 29.10 is a common daylight savings date, here in the
states the actual date can change.
-Michael
On 8/16/07, Peter Wechtersbach <[EMAIL PROTECTED]> wrote:
>
> Hello, im found some strange behaviour. Someone knows whats is going on or
> it is a bug?:
>
> lets do like this:
>
> three dates in timestamp:
> 27.10.2007: 1193436000
> 28.10.2007: 1193522400
> 29.10.2007: 1193612400
>
> convert back:
> 1193436000: 27.10.2007 00:00:00
> 1193522400: 28.10.2007 00:00:00
> 1193612400: 29.10.2007 00:00:00
>
> And one day is always 24 hours * 60 minutes * 60 secondes = 86400. So the
> difference between these three dates in timestamp should also be the
> same.But:
> day2-day1 = 86400
> day3-day2 = 90000
>
> Here is my code, im using PHP Version 5.1.6:
>
> echo ' three dates in timestamp: <br>';
> $day1 = mktime(0, 0, 0, 10, 27, 2007);
> $day2 = mktime(0, 0, 0, 10, 28, 2007);
> $day3 = mktime(0, 0, 0, 10, 29, 2007);
>
> echo '27.10.2007: '.$day1.'<br>';
> echo '28.10.2007: '.$day2.'<br>';
> echo '29.10.2007: '.$day3.'<br><br>';
>
> echo 'convert back: <br>';
> echo $day1.': '.date('d.m.Y H:i:s',$day1).'<br>';
> echo $day2.': '.date('d.m.Y H:i:s',$day2).'<br>';
> echo $day3.': '.date('d.m.Y H:i:s',$day3).'<br><br><br>';
>
> echo 'And one day is always 24 hours * 60 minutes * 60 secondes =
> 86400. So the difference between these three dates in timestamp should
> also
> be the same.But: <br>';
>
> echo 'day2-day1 = '.($day2-$day1).'<br>';
> echo 'day3-day2 = '.($day3-$day2).'<br>';
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--- End Message ---
