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.