php-windows Digest 5 Mar 2004 21:14:04 -0000 Issue 2151
Topics (messages 23065 through 23074):
File Length
23065 by: dwight ian
Re: Sending arguments to a SP in PHP
23066 by: Svensson, B.A.T. (HKG)
23067 by: Luis Moreira
Problems with CONSTANTS that does not get defined
23068 by: Svensson, B.A.T. (HKG)
23069 by: Ignatius Reilly
23070 by: Svensson, B.A.T. (HKG)
Re: Problems with CONSTANTS that does not get defined - SOLVED
23071 by: Svensson, B.A.T. (HKG)
Re: PHP compiler
23072 by: Piotr Pluciennik
23073 by: William CANDILLON
extensieadons_dir= not being read and yes it is uncommented
23074 by: Rafi Sheikh
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 People...:)
Im a newbie so please be aptient and help me.
I have a script that will create a csv file and it works fine. The only problem is,
hen the csv file size gets over
230kb it will omit the last part of the file...
Where in php can be set to allow a bigger file size?
My csv is also dowloadadble.
Capital One Classic
Mastercard
60 second
response online. http://mocda.com/1/c/681064/117934/307081/307081
AOL users go here
http://mocda.com/1/c/681064/117934/307081/307081
--- End Message ---
--- Begin Message ---
Very is your problem located?
Is the string not properly built by php?
or is an error genereated when you try to execute the query?
-----Original Message-----
From: Harpreet K. Singh
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: 2004-03-04 21:55
Subject: [PHP-WIN] Sending arguments to a SP in PHP
I am using PHP and sql server 2000.
I have a stored procedure which takes 3 arguments. The first argument is
a
string and the rest 2 are integers.
For some reasons the call to the stored procedure is being trimmed.
My call is as follows
$oldquery="select var1,var2,var3,var4..... from table order by var1";
$query="exec limitselect '". $oldquery ."',". $limit .",". $offset;
i try to print the sql command
echo "<br>".$query;
It prints out a trimmed string
exec limitselect 'select origin
is theri a limit to what one can send to a sp call
Please help i am totally confused.
Thanks
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--- End Message ---
--- Begin Message ---
Is the echo you show after the string being generated or within the funcion
?
Try it (if you haven't already) immediately after the generation. Maybe
there is something wrong with the other strings envolved, or with the syntax
itself (you don't show the entire command).
If it is not, don't bother with the function...
Another thing :
> My call is as follows
> $oldquery="select var1,var2,var3,var4..... from table order by var1";
> $query="exec limitselect '". $oldquery ."',". $limit .",". $offset;
> i try to print the sql command
> echo "<br>".$query;
> It prints out a trimmed string
> exec limitselect 'select origin
What you say is echoed does not (apparently) correspond to the generation.
Were does the word "origin" come from ?
The string $oldquery does not contain it, as far as you show.
Luis
----- Original Message -----
From: "Svensson, B.A.T. (HKG)" <[EMAIL PROTECTED]>
To: "'Harpreet K. Singh '" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, March 05, 2004 8:48 AM
Subject: RE: [PHP-WIN] Sending arguments to a SP in PHP
> Very is your problem located?
>
> Is the string not properly built by php?
> or is an error genereated when you try to execute the query?
>
>
> -----Original Message-----
> From: Harpreet K. Singh
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Sent: 2004-03-04 21:55
> Subject: [PHP-WIN] Sending arguments to a SP in PHP
>
> I am using PHP and sql server 2000.
>
> I have a stored procedure which takes 3 arguments. The first argument is
> a
> string and the rest 2 are integers.
>
> For some reasons the call to the stored procedure is being trimmed.
>
> My call is as follows
> $oldquery="select var1,var2,var3,var4..... from table order by var1";
>
> $query="exec limitselect '". $oldquery ."',". $limit .",". $offset;
>
> i try to print the sql command
> echo "<br>".$query;
>
> It prints out a trimmed string
>
> exec limitselect 'select origin
>
> is theri a limit to what one can send to a sp call
>
> Please help i am totally confused.
>
> Thanks
>
> --
> 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 ---
Running this code:
[...]
// META DATA DEFINES
define("META_DATA", -1);
define("NUM_LINES", 0);
[...]
define("JOB_CMD", 5);
define("FIVE", 5); // DEBUG
[...]
function ...()
{
$atlist = at_job_list();
$UserJobNr = 0;
$UserJobList[META_DATA][NUM_LINES] = 0;
$numJobs = $atlist[META_DATA][NUM_LINES];
for ($i=1; $i<= $numJobs; $i++) {
// DEBUG START
$test_5 = $atlist[$i][5];
$test_FIVE = $atlist[$i][FIVE];
$test_JOB_CMD = $atlist[$i][JOB_CMD];
print "<pre>USER JOB LIST GET/JOB_CMD: /" . $atlist[$i][JOB_CMD] .
"/$test_5/$test_FIVE/$test_JOB_CMD</pre>\n";
// DEBUG END
if (user_own_this_job($User, $atlist[$i][JOB_CMD]) ) {
print "<pre>Has job $i</pre>\n"; // DEBUG
$UserJobNr++;
$UserJobList[$UserJobNr] = $atlist[$i];
$UserJobList[$UserJobNr][JOB_UID] = $UserJobNr;
}
}
[...]
}
gives this out put:
Warning: constant(): Couldn't find constant FIVE in [file] on line 238
FIVE: FIVE/
Warning: constant(): Couldn't find constant JOB_CMD in [file] on line 239
JOB_CMD: JOB_CMD/
USER JOB LIST GET/JOB_CMD: //job1 user1//
USER JOB LIST GET/JOB_CMD: //job2 user1//
USER JOB LIST GET/JOB_CMD: //job1 user2//
To say the less, I am a bit confused. Any hints or tips would be appreciated.
--- End Message ---
--- Begin Message ---
Beats me.
Ignatius
_________________________
----- Original Message -----
From: "Svensson, B.A.T. (HKG)" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, March 05, 2004 13:17
Subject: [PHP-WIN] Problems with CONSTANTS that does not get defined
> Running this code:
>
>
> [...]
> // META DATA DEFINES
> define("META_DATA", -1);
> define("NUM_LINES", 0);
> [...]
> define("JOB_CMD", 5);
> define("FIVE", 5); // DEBUG
> [...]
>
> function ...()
> {
>
> $atlist = at_job_list();
>
> $UserJobNr = 0;
> $UserJobList[META_DATA][NUM_LINES] = 0;
>
> $numJobs = $atlist[META_DATA][NUM_LINES];
>
> for ($i=1; $i<= $numJobs; $i++) {
>
> // DEBUG START
> $test_5 = $atlist[$i][5];
> $test_FIVE = $atlist[$i][FIVE];
> $test_JOB_CMD = $atlist[$i][JOB_CMD];
>
> print "<pre>USER JOB LIST GET/JOB_CMD: /" . $atlist[$i][JOB_CMD] .
> "/$test_5/$test_FIVE/$test_JOB_CMD</pre>\n";
> // DEBUG END
>
> if (user_own_this_job($User, $atlist[$i][JOB_CMD]) ) {
> print "<pre>Has job $i</pre>\n"; // DEBUG
> $UserJobNr++;
> $UserJobList[$UserJobNr] = $atlist[$i];
> $UserJobList[$UserJobNr][JOB_UID] = $UserJobNr;
> }
> }
>
> [...]
>
>
> }
>
> gives this out put:
>
>
>
> Warning: constant(): Couldn't find constant FIVE in [file] on line 238
>
> FIVE: FIVE/
>
> Warning: constant(): Couldn't find constant JOB_CMD in [file] on line 239
>
> JOB_CMD: JOB_CMD/
>
>
> USER JOB LIST GET/JOB_CMD: //job1 user1//
>
> USER JOB LIST GET/JOB_CMD: //job2 user1//
>
> USER JOB LIST GET/JOB_CMD: //job1 user2//
>
>
> To say the less, I am a bit confused. Any hints or tips would be
appreciated.
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--- End Message ---
--- Begin Message ---
On Fri, 2004-03-05 at 13:34, Sven Schnitzke wrote:
> Hi Anders,
>
> my first guess is that it might be an unfinished string ' problem starting
> _before_ and hiding the defines for JOB_CMD and FIVE.
Good guess (and you was almost right, right about the part of
hiding code).
I am using GNU Emacs 21.2.1 on redhat-linux which has syntax
highlights, and I can not spot any syntax problem. Secondly,
the PHP interpreter does not go wild about syntax errors.
But you made me think in other ways about my code. This is how it
looks in the start:
<?php
session_start();
require "inc-auth2.php";
if (connection_ok()) {
main();
} else {
exit();
}
define("JOB_NUM_COLS", 6);
[...]
And while I did paste this, I just realized that the call to main()
might/will skip the execution of the define()'s, so I put the if-else
construction after all the definition of constants and then it worked
just fine again.
I now got this output:
FIVE: 5/5
JOB_CMD: 5/5
USER JOB LIST GET/JOB_CMD: job1 pelle/job1 pelle/job1 pelle/job1 pelle
Has job
USER JOB LIST GET/JOB_CMD: job2 pelle/job2 pelle/job2 pelle/job2 pelle
Has job
USER JOB LIST GET/JOB_CMD: job1 kalle/job1 kalle/job1 kalle/job1 kalle
USER JOB LIST GET\NUM_LINES: 2.
The funny thing (which was a major contribution to my confusion)
is that some of the constants actually carried a value, like
META_DATA, NUM_LINES, plus a couple of others constants.... this
fouled me into believe that the parser had executed all of them.
So the mysterious that now remains to be explained is why the
heck some constants got defined at all?
--- End Message ---
--- Begin Message ---
Me too, until Sven induced me think in the right way about the problem.
I had a validation if-else construction before the execution of
the defines. I knew it had to be a stupid mistake made by me
/somewhere/ - since CONSTANT /should/ work.
But I were unable to track the devil down (been looking for
incorrect spelled variables names, incorrect constant name,
incorrect program logic etc, but got zero...)
The point was that I first wrote the program with hard coded
values in the array indexes - and I generally don't like to
do that - but then found out that PHP support CONSTANTS and
started to introduce them.
The code worked fine, until it suddenly added some new high
level construction. Of course I did first check the latest
added code, but found nothing, and became quite surprised
while I were nesting down in the call stack trying to locate
the fault - because this was low level function that had been
tested and confirmed to be correct.
What I knew at that point was that some constant had not been
defined, while other was, and I could not for my life understand
why this was the case. Hence I dumped a question to the PHP list
once I confirmed this was the case.
And as in 99,99% of all cases this it turned out to be a silly
mistake overseen by me...
So the reaming mystery for me is now why some constant actually
did work (as I wanted them to) while other did not?
//Anders - which only been /programing/ php for 2 weeks
On Fri, 2004-03-05 at 13:42, Ignatius Reilly wrote:
> Beats me.
>
> Ignatius
> _________________________
> ----- Original Message -----
> From: "Svensson, B.A.T. (HKG)" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Friday, March 05, 2004 13:17
> Subject: [PHP-WIN] Problems with CONSTANTS that does not get defined
>
>
> > Running this code:
> >
> >
> > [...]
> > // META DATA DEFINES
> > define("META_DATA", -1);
> > define("NUM_LINES", 0);
> > [...]
> > define("JOB_CMD", 5);
> > define("FIVE", 5); // DEBUG
> > [...]
> >
> > function ...()
> > {
> >
> > $atlist = at_job_list();
> >
> > $UserJobNr = 0;
> > $UserJobList[META_DATA][NUM_LINES] = 0;
> >
> > $numJobs = $atlist[META_DATA][NUM_LINES];
> >
> > for ($i=1; $i<= $numJobs; $i++) {
> >
> > // DEBUG START
> > $test_5 = $atlist[$i][5];
> > $test_FIVE = $atlist[$i][FIVE];
> > $test_JOB_CMD = $atlist[$i][JOB_CMD];
> >
> > print "<pre>USER JOB LIST GET/JOB_CMD: /" . $atlist[$i][JOB_CMD] .
> > "/$test_5/$test_FIVE/$test_JOB_CMD</pre>\n";
> > // DEBUG END
> >
> > if (user_own_this_job($User, $atlist[$i][JOB_CMD]) ) {
> > print "<pre>Has job $i</pre>\n"; // DEBUG
> > $UserJobNr++;
> > $UserJobList[$UserJobNr] = $atlist[$i];
> > $UserJobList[$UserJobNr][JOB_UID] = $UserJobNr;
> > }
> > }
> >
> > [...]
> >
> >
> > }
> >
> > gives this out put:
> >
> >
> >
> > Warning: constant(): Couldn't find constant FIVE in [file] on line 238
> >
> > FIVE: FIVE/
> >
> > Warning: constant(): Couldn't find constant JOB_CMD in [file] on line 239
> >
> > JOB_CMD: JOB_CMD/
> >
> >
> > USER JOB LIST GET/JOB_CMD: //job1 user1//
> >
> > USER JOB LIST GET/JOB_CMD: //job2 user1//
> >
> > USER JOB LIST GET/JOB_CMD: //job1 user2//
> >
> >
> > To say the less, I am a bit confused. Any hints or tips would be
> appreciated.
> >
> > --
> > PHP Windows Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
> >
--- End Message ---
--- Begin Message ---
Try:
http://www.ioncube.com/
HTH,
Piotr
--- William CANDILLON <[EMAIL PROTECTED]>
wrote:
> Heya ^^
> I wanna know if there are a way to "compile" our own
> php script ?
> Regards.
> StorM
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
__________________________________
Do you Yahoo!?
Yahoo! Search - Find what you’re looking for faster
http://search.yahoo.com
--- End Message ---
--- Begin Message ---
Thks a lot, it's work perfectly.
-----Message d'origine-----
De : Piotr Pluciennik [mailto:[EMAIL PROTECTED]
Envoyé : vendredi 5 mars 2004 14:32
À : [EMAIL PROTECTED]
Objet : Re: [PHP-WIN] PHP compiler
Try:
http://www.ioncube.com/
HTH,
Piotr
--- William CANDILLON <[EMAIL PROTECTED]>
wrote:
> Heya ^^
> I wanna know if there are a way to "compile" our own
> php script ?
> Regards.
> StorM
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
__________________________________
Do you Yahoo!?
Yahoo! Search - Find what youre looking for faster
http://search.yahoo.com
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--- End Message ---
--- Begin Message ---
Hello List. I uam using: apache 1.3.29, php 4.3.4, MySql 1.3 on WIN2K-Pro
My php install (and extensions dir) is under c:\php. However, in php.ini
(located under WINNT\php.ini) I point the extensions directory to
c:\php\extensions, the php_info() lists extensions_dir=c:\php4 (does not
read or accepts the change). If I leave it as default which is:
extensions_dir="./" this shows up under php_info() listing. I have tried:
/ and \ (slashes)
c:php or c:\php\extensions
With our without quotes
Result it doe snot accept. If I leave it at default, than the gd module
that is bundled with php does not get loaded (whihc I need), errors as :
module not found-I made sure that I uncommented that part.
Any suggestions?
TIA,
RAfi
This e-mail, including attachments, may include confidential and/or
proprietary information, and may be used only by the person or entity to
which it is addressed. If the reader of this e-mail is not the intended
recipient or his or her authorized agent, the reader is hereby notified that
any dissemination, distribution or copying of this e-mail is prohibited. If
you have received this e-mail in error, please notify the sender by replying
to this message and delete this e-mail immediately.
--- End Message ---
