php-windows Digest 24 Apr 2002 14:11:33 -0000 Issue 1109
Topics (messages 13261 through 13273):
setting php variables from the client side
13261 by: RS Herhuth
Authentication
13262 by: Nik Alleyne
Re: COM vs. ODBC
13263 by: Ray Hunter
Getting Apache 2.0.35 and PHP 4.2 to work on Win2k
13264 by: David
Re: Excel not closing after using it via COM
13265 by: Helphand
Re: [PHP-DB] Re: [PHP-WIN] Update 4.1.2 > 4.2 : MSSQL Error S1000 (Parallel Requests)
13266 by: Lars Schwarz
Re: Update 4.1.2 > 4.2 : MSSQL Error S1000 (Parallel Requests)
13267 by: Svensson, B.A.T. (HKG)
Can't import CSV data to Mysql
13268 by: Jack
Can't load CSV file into Mysql Table using "LOAD Data"
13269 by: Jack
I want to learn more COM for my php script
13270 by: Jack
php_imap extension in PHP 4.2.0
13271 by: Ulf Haueisen
13272 by: Lars Schwarz
Re: $POST vars
13273 by: Matt Babineau
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 ---
I'm still struggling a bit with sessions and state.
What I think I'm trying to do is use a Javascript onclick to call a created
function that will set session variables and then load a new page. Is it
possible to set php variables from the client side with out passing them in
the "url.html?var1=value&var2=value" format?
I'm also getting killed because form variables don't change session
variables with the same name (it took many hours to figure this out!).
Am I going about this the wrong way...is there an easier method?
Thanks,
Ron
--- End Message ---
--- Begin Message ---
Hi All,
Can anyone tell me how to ensure that all my pages are secure. I know in asp
i could have used session("authenticated").
What I wish to do is to ensure when the user views a secure page that he/she
has been logged in before. IF they have now, i wish to redirect them to the
login.php
thankx
nik
--- End Message ---
--- Begin Message ---
I would suggest to use the COM interface or move your excel file to a
database and use ODBC connections if you are using a microsoft db.
~~ BigDog ~~
"Angie Tollerson" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> I'm going to be reading only some data from an excel file. Is there any
> benefit to COM or ODBC? I tried the COM route but my scripts always
> timed out. Any opinions one way or the other?
>
> Angie Tollerson
> Alliance Technologies
> Web Programmer
> (515)245-7628
> [EMAIL PROTECTED]
>
--- End Message ---
--- Begin Message ---
I've been running apache 2 as my server for a while, and have been
running php as a cgi (I know not the best idea). I saw that 4.2 offered
experimental support, so I tried upgrading to that. Install.txt only
includes instructions for 1.3.x, but I tried adjusting it to 2.x I
couldn't get them to work. I then reverted to 4.1.2, but this had the
following odd behavior: whenever I have a page request such as
"file.php?foo=bar" it would never acknowledge it (load the page as
though foo=bar wasn't there." I haven't had this problem before. I then
tried running 4.2 as a cgi. It causes a message "The procedure entry
point php_output_activate could not be located in the dynamic link
library php4ts.dll" to pop up. Any help with apache 2 and php 4.2 would
be a great help.
David Tucci
--- End Message ---
--- Begin Message ---
Not sure if this will help or not, but I had a similar issue using Perl.
Turns out that it was popping up a dialog box on the server when
I did a save or saveas and there was a pre-existing file with that
same name. I solved it by first deleting the file, then doing a
saveas and the problem went away.
Scott
At 06:17 PM 4/23/02 -0500, Neil Lincoln wrote:
>I spent many hours on this and gave up and added a process kill for the
>EXCEL "zombie" after exiting the COM code.
>There must be a better way..
>
>-----Original Message-----
>From: Scott Hurring [mailto:[EMAIL PROTECTED]]
>Sent: Tuesday, April 23, 2002 4:40 PM
>To: Php-Win (E-mail)
>Subject: [PHP-WIN] Excel not closing after using it via COM
>
>After working with Excel via COM, i cannot seem to get
>the instance of Excel to quit (CTL+ALT+DEL shows an
>'EXCEL.EXE' in my process list). The script opens up
>a file, puts some numbers in, adds some numbers up, then
>closes the sheet and tells excel to exit. I've been
>trying for a few hours now to get Excel to actually
>*quit* when i call $excel->Quit(); unset($excel);
>
>I have made sure to save the book ($book->Save()),
>have set DisplayAlerts="FALSE" (which, on the MS
>website, says that Excel will force excel to exit
>even if there are unsaved changes).
>
>I've been trying various ways of calling Quit,
>Release and unset($excel)... all of them failing
>miserably to get excel to quit (I even adapted
>sample VB script to loop through all open books
>and save them... to be doubly-sure that all changes
>are saved).
>
>For example, the following code always fails and
>leaves an excel instance in memory.
>
> if (!$excel->Quit())
> die("Cannot call excel->quit");
>
>Can enyone help me out here? Can anyone tell me how
>to get at any errors that Excel might be returning
>(so i can figure out *why* it won't go away)
>
>I'm using Win2k, Office 2k, PHP 4.2.0.
>
>Thanks in advance.
>
>
>--
>PHP Windows Mailing List (http://www.php.net/)
>To unsubscribe, visit: http://www.php.net/unsub.php
>---
>Incoming mail is certified Virus Free.
>Checked by AVG anti-virus system (http://www.grisoft.com).
>Version: 6.0.351 / Virus Database: 197 - Release Date: 4/19/2002
>
>---
>Outgoing mail is certified Virus Free.
>Checked by AVG anti-virus system (http://www.grisoft.com).
>Version: 6.0.351 / Virus Database: 197 - Release Date: 4/19/2002
>
>
>
>--
>PHP Windows Mailing List (http://www.php.net/)
>To unsubscribe, visit: http://www.php.net/unsub.php
--
http://www.geocities.com/Helphand1/
Helphand's Not So FAQ's for the Palm
http://www.geocities.com/helphand1/palmprobs.htm
--- End Message ---
--- Begin Message ---
well, so anyone has a solution, except downgrading to 4.1.2 ?
what i can say is, that it's definitately the 4.2, not the mdac version,
because thats what i tried, 4.1.2 even runs fine with the latest mdac
vesion (2.7). i'm on win2k prof and apache 2.0 if this helps anyway.
thanks: lars
"Alan Popow" <[EMAIL PROTECTED]> schrieb im Newsbeitrag
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
On Wed, 24 Apr 2002 03:22:38 +0800, you wrote:
Glad to hear that. I thought it was something stupid that I was doing.
Alan
>I am having problems too.
>
>My ADOdb regression tests for msaccess/odbc and vfp/odbc fail every time.
>
>No data is being retrieved :-(
>
>Uggh.
>
>
>"Christoph Grottolo" <[EMAIL PROTECTED]> wrote in message
>[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
>>
>> "Lars Schwarz" <[EMAIL PROTECTED]> schrieb im Newsbeitrag
>> [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
>> | this has nothing to do with the odbc driver i think, because i already
>> tried
>> | different mdac versions, without success. it's simply like this:
>> | switching between the two php version (without touching the mdac, odbc,
>> | sqlsrv32.dll or anything) 4.1.2 works, 4.2 doesnt, so it must be the
>odbc
>> | implementation within php 4.2 ....
>>
>> I also think so. I'm getting some strange odbc errors (missing resultsets
>> etc.) with 4.2.0, same query is working perfectly in 4.1.2. Some queries
>> work perfectly as before, some don't. Until now i didn't find any
pattern.
>>
>> I'll try to set up some test scripts, but i don't have any experience in
>> doing that, so, if somebody could help me i wouldn't refuse.
>>
>> Christoph
>>
>>
--- End Message ---
--- Begin Message ---
Hey guys. Go to google, type in "SQL State S1000", there will
be some hundred or thousand hits. There is a documented bug in
thew ODBC driver it self related to this issue.
> -----Original Message-----
> From: John Lim [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, April 23, 2002 9:23 PM
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: Re: [PHP-WIN] Update 4.1.2 > 4.2 : MSSQL Error S1000 (Parallel
> Requests)
>
>
> I am having problems too.
>
> My ADOdb regression tests for msaccess/odbc and vfp/odbc fail every time.
>
> No data is being retrieved :-(
>
> Uggh.
>
>
> "Christoph Grottolo" <[EMAIL PROTECTED]> wrote in message
> [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> >
> > "Lars Schwarz" <[EMAIL PROTECTED]> schrieb im Newsbeitrag
> > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > | this has nothing to do with the odbc driver i think, because i already
> > tried
> > | different mdac versions, without success. it's simply like this:
> > | switching between the two php version (without touching the mdac, odbc,
> > | sqlsrv32.dll or anything) 4.1.2 works, 4.2 doesnt, so it must be the
> odbc
> > | implementation within php 4.2 ....
> >
> > I also think so. I'm getting some strange odbc errors (missing resultsets
> > etc.) with 4.2.0, same query is working perfectly in 4.1.2. Some queries
> > work perfectly as before, some don't. Until now i didn't find any pattern.
> >
> > I'll try to set up some test scripts, but i don't have any experience in
> > doing that, so, if somebody could help me i wouldn't refuse.
> >
> > Christoph
> >
> >
>
>
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--- End Message ---
--- Begin Message ---
Dear all
i had posted this question to mysql@list, but got no reponse, therefore i
think this group might help!
I had made a TXT file from XLS, the field is seperate by comma, there are 4
fields in mysql table (hkd_rate), then i tried this command on mysql:
"LOAD DATA LOCAL INFILE 'c:\hkd_rate.txt' into table hkd_deposit field
seperated by "," " then my GUI mysql client program shows that the command
had execute successfully, but when i type the " select * from hkd_deposit",
it says it return no record. which i believe the data from the hkd_rate.txt
did not load into the table.
Could anyone pls help me why this is happening?
--- End Message ---
--- Begin Message ---
Dear all
i had posted this question to mysql@list, but got no reponse, therefore i
think this group might help!
I had made a TXT file from XLS, the field is seperate by comma, there are 4
fields in mysql table (hkd_rate), then i tried this command on mysql:
"LOAD DATA LOCAL INFILE 'c:\hkd_rate.txt' into table hkd_deposit field
seperated by "," " then my GUI mysql client program shows that the command
had execute successfully, but when i type the " select * from hkd_deposit",
it says it return no record. which i believe the data from the hkd_rate.txt
did not load into the table.
Could anyone pls help me why this is happening?
--- End Message ---
--- Begin Message ---
Dear all
i know if i want the php script to access data from MS Word or Excel, i got
to know about COM, but i don't know where to start on COM, so is there any
Recommendation on books which i can learn about COM from the Beginning!
--
Thx a lot!
Jack
[EMAIL PROTECTED]
--- End Message ---
--- Begin Message ---
Hi,
Why is the php_imap extension missing from the windows distribution of PHP
4.2.0?
Ulf.
--- End Message ---
--- Begin Message ---
good question, also the php.exe isnt in the root directory any more
which caused me some trouble, when just copying the new version
over the old one, without the old php.exe being overwritten.
no mention in the changelog about any imap changes ... hmmm
"Ulf Haueisen" <[EMAIL PROTECTED]> schrieb im Newsbeitrag
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Hi,
>
> Why is the php_imap extension missing from the windows distribution of PHP
> 4.2.0?
>
> Ulf.
>
>
>
--- End Message ---
--- Begin Message ---
I am merely trying to see whether a page was posted to or not, and
perform an action from the result.
Matt Babineau
Freelance Internet Developer
e: [EMAIL PROTECTED]
p: 603.943.4237
w: http://www.illuminatistudios.com
-----Original Message-----
From: Scott Hurring [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 23, 2002 6:10 PM
To: Php-Win (E-mail)
Subject: RE: [PHP-WIN] re: $POST vars
merely checking a variable is safe (for ex:)
if (empty($X)) or if (defined($X)) or if ($X)
I just hope you don't check for them and go
on to use the dirty values w/o any sanity
or bounds checking on them. :)
> -----Original Message-----
> From: Ross Fleming [mailto:[EMAIL PROTECTED]]
> Subject: Re: [PHP-WIN] re: $POST vars
>
>
> If by "safe" you mean physically safe, then yes, I can
> confirm that you
> will be in no physical danger if you make this assumption,
> neither the web
> server nor the browser will explode if you try this, thereby
> leaving you
> rather safe...
>
> ;-)
>
> Ross
>
> Matt Babineau wrote:
>
> > When submitting a page to itself, is it safe to check for
> the existance
> > of the $POST variable to tell whether the form was
> submitted and if it
> > was to perform and action utilizing the post variables?
> >
> > Matt Babineau
> > Freelance Internet Developer
> > e: <mailto:[EMAIL PROTECTED]>
> > [EMAIL PROTECTED]
> > p: 603.943.4237
> > w: <http://www.illuminatistudios.com/>
http://www.illuminatistudios.com
>
>
--
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 ---
