php-install Digest 28 Jul 2001 23:10:18 -0000 Issue 385
Topics (messages 3736 through 3742):
Re: PHP datatype vs Oracle Varchar2
3736 by: Victoria Zhou
why is compile from cvs no longer working?
3737 by: Jens Ansorg
Re: MIME types
3738 by: Maiquel Rinco
3739 by: Maiquel Rinco
3741 by: Maiquel Rinco
Test
3740 by: Maiquel Rinco
Re: Installing PHP on WinNT and Apache 1.3
3742 by: Almagedon
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]
----------------------------------------------------------------------
Sorry, it was a mistake on my side. I just figure out why the string
comparisons between CHAR and VARCHAR2 didn't work for me. When I first
inserted data to Mytable, I had CHAR(20) defined for all columns. Later I
alter it to VARCHAR2(20), but the original 20 characters were already in the
database. Therefore I was using the 20 character string for the comparison.
Sorry for the confusion.
Victoria
> -----Original Message-----
> From: Thies C. Arntzen [mailto:[EMAIL PROTECTED]]
> Sent: Friday, July 27, 2001 1:09 PM
> To: Victoria Zhou
> Cc: Thies C. Arntzen; [EMAIL PROTECTED]
> Subject: Re: [PHP-INST] PHP datatype vs Oracle Varchar2
>
>
> On Thu, Jul 26, 2001 at 07:27:07PM -0500, Victoria Zhou wrote:
> > Here is a description of the testcase for the problem:
> >
> > Oracle:
> > Create table Mytable (
> > Username varchar2(20),
> > Passwd varchar2(20),
> > Usertype varchar2(50))
> >
> > Insert into Mytable (Username, Passwd, Usertype)
> > values('tester1','tester1','Operator');
> >
> > PHP:
> > $sql = "select * from Mytable where Username='tester1'";
> > $sql_statement = OCIParse($conn, $sql) or die ("Couldn't parse
> statement");
> > OCIExecute($sql_statement) or die ("Couldn't execute query");
> >
> >
> > Problem:
> > The string comaparison in the $sql (Username='tester1') is never true,
> > because Username is a variable length string and 'tester1' is
> considered as
> > a fixed length string.
>
> wrong - that should not be the case.
>
> >
> > I don't have the flexibility to change VARCHAR2 to CHAR in order to make
> > this work, because a fixed length string will cause a lot of trouble for
> > string comparisons for other code in the program.
> >
> > Thanks for your help!
>
> i did the same thing (i hope) and it woorsk for me. i see no
> reason why it shouldn't work. there is _no_ reason to switch
> to from varchar to char!
>
> please try to do the _same_ select-statement in sqlplus -
>
> tc
>
> >
> > Victoria
> >
> >
> >
> >
> > > -----Original Message-----
> > > From: Thies C. Arntzen [mailto:[EMAIL PROTECTED]]
> > > Sent: Thursday, July 26, 2001 6:10 PM
> > > To: Victoria Zhou
> > > Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> > > Subject: Re: [PHP-INST] PHP datatype vs Oracle Varchar2
> > >
> > >
> > > On Thu, Jul 26, 2001 at 05:08:42PM -0500, Victoria Zhou wrote:
> > > >
> > > > Hi,
> > > >
> > > > The comparison between Oracle VARCHAR2 and a PHP string
> doesn't seems to
> > > > work. Detail as follows:
> > > >
> > > > I have one PHP variable and one Oracle column:
> > > > . $form_user_id: a PHP string obtained from web form input,
> > > such as 'user1'.
> > > > . Username: an oracle table column of type VARCHAR2(20).
> > > >
> > > > The following sql statement failed:
> > > > "select * from mytable where Username='$form_user_id'"
> > > >
> > > > It failed because Username has a strlen of 20, where
> $form_user_id has a
> > > > strlen of 5. If I changed the Username from VARCHAR2(20) to
> > > CHAR(20), then
> > > > this sql worked fine. But I think with Oracle VARCHAR2, the
> strlen of
> > > > Username in this case should be 5 instead of 20.
> > >
> > > you must be doing something wrong here;-)
> > >
> > > please try to create a _tiny_ testcase (< 20 lines) and post
> > > it to the list, i'm sure you're overseeing something
> > > important.
> > >
> > > tc
> > >
> > >
> >
>
>
hi,
for quite a while now I compiled fresh apacke PHP modules right from the
cvs source. Worked very well most of the time.
But now I get strange error, even after completely removing the php4
under cvsroot and downloading the whole source (php and zend) again.
any help?
thanks
Jens
this is the error:
/bin/sh ../libtool --silent --mode=compile gcc -DHAVE_CONFIG_H -I. -I. -I../main
-DLINUX=2 -DNO_DBM_REWRITEMAP -DUSE_HSREGEX -DUSE_EXPAT -g -O2 -prefer-pic -c
zend_language_scanner.c
In file included from zend_language_scanner.l:42:
zend.h:200: parse error before `TSRMLS_DC'
zend.h:234: parse error before `TSRMLS_DC'
In file included from zend_language_scanner.l:45:
zend_compile.h:122: parse error before `TSRMLS_DC'
In file included from zend_language_scanner.l:45:
zend_compile.h:199: warning: parameter has incomplete type
zend_compile.h:205: warning: parameter has incomplete type
zend_compile.h:206: warning: parameter has incomplete type
zend_compile.h:368: parse error before `TSRMLS_DC'
zend_compile.h:369: parse error before `TSRMLS_DC'
In file included from zend_language_scanner.l:48:
zend_constants.h:49: warning: parameter names (without types) in function declaration
zend_constants.h:50: warning: parameter names (without types) in function declaration
zend_constants.h:51: warning: parameter names (without types) in function declaration
zend_constants.h:54: parse error before `TSRMLS_DC'
zend_constants.h:55: parse error before `TSRMLS_DC'
zend_constants.h:56: parse error before `TSRMLS_DC'
zend_constants.h:57: parse error before `TSRMLS_DC'
zend_constants.h:58: parse error before `TSRMLS_DC'
zend_language_scanner.l:383: parse error before `TSRMLS_DC'
zend_language_scanner.l: In function `compile_filename':
zend_language_scanner.l:389: `filename' undeclared (first use in this function)
zend_language_scanner.l:389: (Each undeclared identifier is reported only once
zend_language_scanner.l:389: for each function it appears in.)
zend_language_scanner.l:401: `type' undeclared (first use in this function)
make[1]: *** [zend_language_scanner.lo] Error 1
make[1]: Leaving directory `/storage/cvs-root/php4/Zend'
make: *** [all-recursive] Error 1
Hi Guys
I have the same problem, my httpd.conf is configured with this lines under,
but when I try to open .php files in my netscape browser it don�t execute
and ask me to save.
??weird?
>Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm
>list-help: <mailto:[EMAIL PROTECTED]>
>list-unsubscribe: <mailto:[EMAIL PROTECTED]>
>list-post: <mailto: >
>Delivered-To: mailing list [EMAIL PROTECTED]
>Reply-To: "Steve Brazill" <[EMAIL PROTECTED]>
>From: "Steve Brazill" <[EMAIL PROTECTED]>
>To: "Jan-Erik Bullett" <[EMAIL PROTECTED]>
>Cc: <[EMAIL PROTECTED]>
>Date: Mon, 23 Jul 2001 20:38:38 -0700
>X-Mailer: Microsoft Outlook Express 5.50.4522.1200
>Subject: Re: [PHP-INST] MIME types
>
>Do you mean the 2 lines that should be in your "httpd.conf" file ??
>
> AddType application/x-httpd-php .php .php3 .php4 .htm
> AddType application/x-httpd-php-source .phps
>
>----- Original Message -----
>From: "Jan-Erik Bullett" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Sent: Monday, July 23, 2001 11:32 PM
>Subject: [PHP-INST] MIME types
>
>
> > Help again.
> >
> > (Thanks Steve), I downloaded the MySQL-devel and then I had the headers in
>/usr
> >
> > the thing built ok
> >
> > Now I need to set up the MIME type to include the application/x-httpd-php
> >
> > What is the best way to do this in Mandrake 8? I've seen a graphical
>interface,
> > but could I just edit a text file?
> >
> > Again, many thanks.
> >
> > Jan
> >
> >
> > --
> > PHP Install Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> > To contact the list administrators, e-mail: [EMAIL PROTECTED]
> >
>
>
>--
>PHP Install Mailing List (http://www.php.net/)
>To unsubscribe, e-mail: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>To contact the list administrators, e-mail: [EMAIL PROTECTED]
Maiquel Alexsandro Goelzer Rinco
e-mails: [EMAIL PROTECTED]
UIN# 6264631 [EMAIL PROTECTED]
Grupo Trabalho em Software Livre
Centro Universitario La Salle
" In a World Without Fences Who Needs Gates?"
" Geek by nature, linux by choice "
Hi Guys
I have the same problem, my httpd.conf is configured with this lines under,
but when I try to open .php files in my netscape browser it don�t execute
and ask me to save.
??weird?
>>Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm
>>list-help: <mailto:[EMAIL PROTECTED]>
>>list-unsubscribe: <mailto:[EMAIL PROTECTED]>
>>list-post: <mailto: >
>>Delivered-To: mailing list [EMAIL PROTECTED]
>>Reply-To: "Steve Brazill" <[EMAIL PROTECTED]>
>>From: "Steve Brazill" <[EMAIL PROTECTED]>
>>To: "Jan-Erik Bullett" <[EMAIL PROTECTED]>
>>Cc: <[EMAIL PROTECTED]>
>>Date: Mon, 23 Jul 2001 20:38:38 -0700
>>X-Mailer: Microsoft Outlook Express 5.50.4522.1200
>>Subject: Re: [PHP-INST] MIME types
>>
>>Do you mean the 2 lines that should be in your "httpd.conf" file ??
>>
>> AddType application/x-httpd-php .php .php3 .php4 .htm
>> AddType application/x-httpd-php-source .phps
>>
>>----- Original Message -----
>>From: "Jan-Erik Bullett" <[EMAIL PROTECTED]>
>>To: <[EMAIL PROTECTED]>
>>Sent: Monday, July 23, 2001 11:32 PM
>>Subject: [PHP-INST] MIME types
>>
>>
>> > Help again.
>> >
>> > (Thanks Steve), I downloaded the MySQL-devel and then I had the headers in
>>/usr
>> >
>> > the thing built ok
>> >
>> > Now I need to set up the MIME type to include the application/x-httpd-php
>> >
>> > What is the best way to do this in Mandrake 8? I've seen a graphical
>>interface,
>> > but could I just edit a text file?
>> >
>> > Again, many thanks.
>> >
>> > Jan
>> >
>> >
>> > --
>> > PHP Install Mailing List (http://www.php.net/)
>> > To unsubscribe, e-mail: [EMAIL PROTECTED]
>> > For additional commands, e-mail: [EMAIL PROTECTED]
>> > To contact the list administrators, e-mail: [EMAIL PROTECTED]
>> >
>>
>>
>>--
>>PHP Install Mailing List (http://www.php.net/)
>>To unsubscribe, e-mail: [EMAIL PROTECTED]
>>For additional commands, e-mail: [EMAIL PROTECTED]
>>To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
> Maiquel Alexsandro Goelzer Rinco
>e-mails: [EMAIL PROTECTED]
>UIN# 6264631 [EMAIL PROTECTED]
> Grupo Trabalho em Software Livre
> Centro Universitario La Salle
>
>" In a World Without Fences Who Needs Gates?"
> " Geek by nature, linux by choice "
>
>
>
>
>--
>PHP Install Mailing List (http://www.php.net/)
>To unsubscribe, e-mail: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
Maiquel Alexsandro Goelzer Rinco
e-mails: [EMAIL PROTECTED]
UIN# 6264631 [EMAIL PROTECTED]
Grupo Trabalho em Software Livre
Centro Universitario La Salle
" In a World Without Fences Who Needs Gates?"
" Geek by nature, linux by choice "
Hi Guys
I have the same problem, my httpd.conf is configured with this lines under,
but when I try to open .php files in my netscape browser it don�t execute
and ask me to save.
??weird?
At 20:38 23/07/2001 -0700, you wrote:
>Do you mean the 2 lines that should be in your "httpd.conf" file ??
>
> AddType application/x-httpd-php .php .php3 .php4 .htm
> AddType application/x-httpd-php-source .phps
>
>----- Original Message -----
>From: "Jan-Erik Bullett" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Sent: Monday, July 23, 2001 11:32 PM
>Subject: [PHP-INST] MIME types
>
>
> > Help again.
> >
> > (Thanks Steve), I downloaded the MySQL-devel and then I had the headers in
>/usr
> >
> > the thing built ok
> >
> > Now I need to set up the MIME type to include the application/x-httpd-php
> >
> > What is the best way to do this in Mandrake 8? I've seen a graphical
>interface,
> > but could I just edit a text file?
> >
> > Again, many thanks.
> >
> > Jan
> >
> >
> > --
> > PHP Install Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> > To contact the list administrators, e-mail: [EMAIL PROTECTED]
> >
>
>
>--
>PHP Install Mailing List (http://www.php.net/)
>To unsubscribe, e-mail: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>To contact the list administrators, e-mail: [EMAIL PROTECTED]
Maiquel Alexsandro Goelzer Rinco
e-mails: [EMAIL PROTECTED]
UIN# 6264631 [EMAIL PROTECTED]
Grupo Trabalho em Software Livre
Centro Universitario La Salle
" In a World Without Fences Who Needs Gates?"
" Geek by nature, linux by choice "
Maiquel Alexsandro Goelzer Rinco
e-mails: [EMAIL PROTECTED]
UIN# 6264631 [EMAIL PROTECTED]
Grupo Trabalho em Software Livre
Centro Universitario La Salle
" In a World Without Fences Who Needs Gates?"
" Geek by nature, linux by choice "
Hi again...
THAT'S FOR SOMEBODY THAT HAS MY PROBLEM...
The file i mentioned in my last post, is an Apache-MySQL-PHP combo that
includes phpMyAdmin (everything is configured and it works... even in NT)
The problem (It seems only happens in NT) is the next:
in the httpd.conf file you need to set up (in directories you want to run
PHP)
<Directory "c:/apache/htdocs">
Options ExecCGI
</Directory>
and
ScriptAlias /php/ "c:/php/"
C:/PHP must be the folder in your PC where php.exe is
And with these changes in httpd.conf...
IT WORKS!!!!!!!!!!!!!!!!!!!
