php-windows Digest 22 Apr 2001 05:28:08 -0000 Issue 557

Topics (messages 6947 through 6959):

MS SQL 2000
        6947 by: Jan Walter
        6948 by: Frank M. Kromann

HELP!!! php4ts.dll
        6949 by: Neil

apache/php help!!!!!
        6950 by: Neil
        6955 by: Arthur Melkonyan
        6958 by: Ermanno Iannacci

ImageCreatFromString
        6951 by: kRuK

PHPEd and phpMyAdmin
        6952 by: r.gelstharp

Images In MySql
        6953 by: Sean
        6954 by: PHPWIN

Re: Poll
        6956 by: Johannes Janson

HTML -> PHP -> HTML calling sequence
        6957 by: Bob Sears
        6959 by: Chris Adams

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]


----------------------------------------------------------------------


Hi all,

I have the following problem with PHP using MS SQL 2000. The connection
seems to be opened properly, but any usage of returned value from
mssql_query() does not work as a parameter for functions like
mssql_fetch_array, mssql_num_rows, etc., although it is printed as '1'.

--
This piece of code:
--
****************************
<?
$connection = mssql_connect("ATHLON\LOCALHOST") or die("No connection");

mssql_select_db("db", $connection);

echo "Query answer: ".($answer = mssql_query("SELECT * FROM
table"))."<br>";
echo mssql_num_rows($answer);
?>
****************************
--
produces this page:
--
****************************
Query answer: 1

Warning: Supplied argument is not a valid MS SQL-result resource in
c:/users/john/php/mr/mssql.php on line 6
****************************


Thank you for any hint
--
__________________________________________________________________________________________

==========================================================================================

Jan Walter, called John
LERACH, s.r.o.
phone nr. work: +420-2-78 22 619, home: +420-2-35 35 27 61
on emergency call cell phone: +420-602-385 760
work e-mail mailto:[EMAIL PROTECTED]
private e-mail mailto:[EMAIL PROTECTED]
ICQ#: 28353428
__________________________________________________________________________________________

==========================================================================================








What version of the php_mssql.dll are you using ? 
We had an error a while back where mssql_query returned a wrong value (true instead of 
a ressource).

You could also add an extra parameter to the query function

$answer = mssql_query("SELECT * FROM table", $connection);

- Frank

P.S. If you are using an old version you should be able to download a new from 
www.php4win.de.

> Hi all,
> 
> I have the following problem with PHP using MS SQL 2000. The connection
> seems to be opened properly, but any usage of returned value from
> mssql_query() does not work as a parameter for functions like
> mssql_fetch_array, mssql_num_rows, etc., although it is printed as '1'.
> 
> --
> This piece of code:
> --
> ****************************
> <?
> $connection = mssql_connect("ATHLON\LOCALHOST") or die("No connection");
> 
> mssql_select_db("db", $connection);
> 
> echo "Query answer: ".($answer = mssql_query("SELECT * FROM
> table"))."<br>";
> echo mssql_num_rows($answer);
> ?>
> ****************************
> --
> produces this page:
> --
> ****************************
> Query answer: 1
> 
> Warning: Supplied argument is not a valid MS SQL-result resource in
> c:/users/john/php/mr/mssql.php on line 6
> ****************************
> 
> 
> Thank you for any hint
> --
> 
>__________________________________________________________________________________________
> 
> 
>==========================================================================================
> 
> Jan Walter, called John
> LERACH, s.r.o.
> phone nr. work: +420-2-78 22 619, home: +420-2-35 35 27 61
> on emergency call cell phone: +420-602-385 760
> work e-mail mailto:[EMAIL PROTECTED]
> private e-mail mailto:[EMAIL PROTECTED]
> ICQ#: 28353428
> 
>__________________________________________________________________________________________
> 
> 
>==========================================================================================
> 
> 
> 
> 
> -- 
> PHP Windows 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]
> 
> 
> 







i just installed apache web server and php4.0 on WINDOWS 98 platform

and moved php4ts.dll into my c:\windows\system folder.
now every time i run a php page, I get a crash saying:

APACHE caused an invalid page fault in
module PHP4TS.DLL at 016f:008e4aca.
Registers:
EAX=00000000 CS=016f EIP=008e4aca EFLGS=00010246
EBX=00000008 SS=0177 ESP=014afe84 EBP=008ed7c0
ECX=00000002 DS=0177 ESI=00769be0 FS=18bf
EDX=00000000 ES=0177 EDI=006fde84 GS=0000
Bytes at CS:EIP:
89 02 8b 06 85 c0 74 06 8b 4e 04 89 48 04 a1 28
Stack dump:
0094c9f0 00768430 008ed7fb 00769bf0 00768470 008ebe72 00768430 00000008
014afedc 00000000 007a26b4 00000174 008ed7b1 0094c9f0 008ed7c0 00000008
however, it still takes the information the user enters on my form and dumps
it into mySQL database. then I hit "close" on this error screen and then it
automatically restarts apache/php and works again.


Please help!,
Email me please! [EMAIL PROTECTED]

-Neil







i just installed apache web server and php4.0 on WINDOWS 98 platform

and moved php4ts.dll into my c:\windows\system folder.
now every time i run a php page, I get a crash saying:

APACHE caused an invalid page fault in
module PHP4TS.DLL at 016f:008e4aca.
Registers:
EAX=00000000 CS=016f EIP=008e4aca EFLGS=00010246
EBX=00000008 SS=0177 ESP=014afe84 EBP=008ed7c0
ECX=00000002 DS=0177 ESI=00769be0 FS=18bf
EDX=00000000 ES=0177 EDI=006fde84 GS=0000
Bytes at CS:EIP:
89 02 8b 06 85 c0 74 06 8b 4e 04 89 48 04 a1 28
Stack dump:
0094c9f0 00768430 008ed7fb 00769bf0 00768470 008ebe72 00768430 00000008
014afedc 00000000 007a26b4 00000174 008ed7b1 0094c9f0 008ed7c0 00000008
however, it still takes the information the user enters on my form and dumps
it into mySQL database. then I hit "close" on this error screen and then it
automatically restarts apache/php and works again.


Please help!,
Email me please! [EMAIL PROTECTED]

-Neil







you should copy PHP4TS.DLL file into c:\windows\system32 not system folder
try that. good luck

-art

Neil wrote:

> i just installed apache web server and php4.0 on WINDOWS 98 platform
>
> and moved php4ts.dll into my c:\windows\system folder.
> now every time i run a php page, I get a crash saying:
>
> APACHE caused an invalid page fault in
> module PHP4TS.DLL at 016f:008e4aca.
> Registers:
> EAX=00000000 CS=016f EIP=008e4aca EFLGS=00010246
> EBX=00000008 SS=0177 ESP=014afe84 EBP=008ed7c0
> ECX=00000002 DS=0177 ESI=00769be0 FS=18bf
> EDX=00000000 ES=0177 EDI=006fde84 GS=0000
> Bytes at CS:EIP:
> 89 02 8b 06 85 c0 74 06 8b 4e 04 89 48 04 a1 28
> Stack dump:
> 0094c9f0 00768430 008ed7fb 00769bf0 00768470 008ebe72 00768430 00000008
> 014afedc 00000000 007a26b4 00000174 008ed7b1 0094c9f0 008ed7c0 00000008
> however, it still takes the information the user enters on my form and dumps
> it into mySQL database. then I hit "close" on this error screen and then it
> automatically restarts apache/php and works again.
>
> Please help!,
> Email me please! [EMAIL PROTECTED]
>
> -Neil
>
> --
> PHP Windows 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]





I don't think there's a system32 folder in win98. I got these chashes when
some extension is misconfigured.

----- Original Message -----
From: "Arthur Melkonyan" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, April 21, 2001 9:28 PM
Subject: Re: [PHP-WIN] apache/php help!!!!!


> you should copy PHP4TS.DLL file into c:\windows\system32 not system folder
> try that. good luck
>
> -art
>
> Neil wrote:
>
> > i just installed apache web server and php4.0 on WINDOWS 98 platform
> >
> > and moved php4ts.dll into my c:\windows\system folder.
> > now every time i run a php page, I get a crash saying:
> >
> > APACHE caused an invalid page fault in
> > module PHP4TS.DLL at 016f:008e4aca.
> > Registers:
> > EAX=00000000 CS=016f EIP=008e4aca EFLGS=00010246
> > EBX=00000008 SS=0177 ESP=014afe84 EBP=008ed7c0
> > ECX=00000002 DS=0177 ESI=00769be0 FS=18bf
> > EDX=00000000 ES=0177 EDI=006fde84 GS=0000
> > Bytes at CS:EIP:
> > 89 02 8b 06 85 c0 74 06 8b 4e 04 89 48 04 a1 28
> > Stack dump:
> > 0094c9f0 00768430 008ed7fb 00769bf0 00768470 008ebe72 00768430 00000008
> > 014afedc 00000000 007a26b4 00000174 008ed7b1 0094c9f0 008ed7c0 00000008
> > however, it still takes the information the user enters on my form and
dumps
> > it into mySQL database. then I hit "close" on this error screen and then
it
> > automatically restarts apache/php and works again.
> >
> > Please help!,
> > Email me please! [EMAIL PROTECTED]
> >
> > -Neil
> >
> > --
> > PHP Windows 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 Windows 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]
>
>





Hi!
Did anyone try to use this function. I've got some blob objects in mysql
base and try to export them to images on HTML site (for now I use temporary
created image files)

Adrian K.






I'm having problems with getting PHPEd, and through that phpMyAdmin, to
work.

I've downloaded both the latest version and the preview and neither work.
What's more both report the same error when I try and use them.

When I try and run PHPEd.exe it reports that the program "Has performed an
illegal operation and must be shutdown", etc and then proceeds to tell me
that it tried to access some module inside of PHPEd.exe that isn't there.

What's going on and does this have anything to do with the thing it mentions
about needing dcom98 or whatever, even though it's the same error for the
preview?






Hi there
  I was wondering if anyone knew if it is a good idea to store gifs, jpegs or swfs in 
MySql.
The problem is that the server I host my site on doesn't give HTTP write permissions 
and has disabled FTP functions in php. I would like to allow users to upload images 
and store them locally on the server.

Any ideas?

Thanks 
Xon




Hi there
  I was wondering if anyone knew if it is a good idea to store gifs, jpegs or swfs in 
MySql.
The problem is that the server I host my site on doesn't give HTTP write permissions 
and has disabled FTP functions in php. I would like to allow users to upload images 
and store them locally on the server.

Any ideas?

Thanks 
Xon




it is helpful to start a seperate thread for a question
not as a reply to an existing one. furthermore is it
helpful to cut down the code to the relevant pieces
in this case line 44 and 74 and maybe one or two
line above and below if they are neccesary. or at
least mark the lines vrey good. counitg the line is very
annoying.

change if ($submit) to if(isset($submit).

in line 74 is something wrong with the query.
J








I'm stuck. Module A is a HTML program with a FORM/ACTION/GET that xctls to 
a PHP module. I have no problem getting to
the PHP module, displaying a dummy screen, and returning to the HTML 
program. In a PHP text I perused through at Border's,
the text said to access STDIN via:

$fh = open("PHP://stdin","r")

to get the stuff that is being passed via the method=get from the HTML 
module. However, when I issue that command
and look at the contents of stdin, it's nothing. No data is being retrieved.

What am I doing wrong?



Bob Sears
Application Developer/Programmer
Internet --> Mainframe, Unix/Aix, OS/JCL
HTML, PHP, Perl, Javascript, VBScript, VB, C, COBOL, C++, Fortran, RPG and 
21 more
Informix, MySQL, Total
317-882-8056
[EMAIL PROTECTED]
Resume on-line: <http://www.on-net.net/~rsears/resumes/bob/bob.html>
Site samples    : <http://www.on-net.net/~rsears/webwyshez/webwyshez.html>





On 21 Apr 2001 17:06:05 -0700, Bob Sears <[EMAIL PROTECTED]> wrote:
>
>I'm stuck. Module A is a HTML program with a FORM/ACTION/GET that xctls to 
>a PHP module. I have no problem getting to
>the PHP module, displaying a dummy screen, and returning to the HTML 
>program. In a PHP text I perused through at Border's,
>the text said to access STDIN via:
>
>$fh = open("PHP://stdin","r")
>
>to get the stuff that is being passed via the method=get from the HTML 
>module. However, when I issue that command
>and look at the contents of stdin, it's nothing. No data is being retrieved.

Did that work without error? I thought that the php: urls needed to be lower
case.

In any case, is there any reason why you can't iterate through the
$HTTP_GET_VARS array? IIRC, the stdin method only works with CGI programs.


Reply via email to