Re: [PHP-DB] how to get ERROR message
Hi, dud you try to use something like this $result=mssql_query(exec x) or die(mssql_get_last_message()); instead of $result=mssql_query(exec x) or die(query failed); Removing the or die part must display an error message too, but it won't end the script execution. Dobromir Velev -Original Message- From: jong jong [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Thursday, July 05, 2001 7:38 PM Subject: [PHP-DB] how to get ERROR message Hi, How can I see the error message from browser? My code is like this: htmlbody ? $conn=mssql_connect(xxx,,); mssql_select_db(xxx,$conn); $result=mssql_query(exec x) or die(query failed); mssql_free_result($result); ? /body/html I got query failed on the browser screen and nothing else. Here is some value I got from phpinfo(): Configuration PHP Core Directive Local value Master value display_errors On On display_startup_errors Off Off doc_root no value no value enable_dlOn On error_append_string Off Off error_log no value no value error_prepend_string OffOff error_reporting 2039 2039 Are they enough to display the error messages? Please help! I really do need to trace the errors. Thanks, jongjong __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- PHP Database 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 Database 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-DB] SQL error:
hello!!! i'm getting this error. what does this mean? hope someone can help. i'm using sql7 in NT4 server Warning: SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'TBL_DEPT'., SQL state S0002 in SQLExecDirect in F:\Web
[PHP-DB] UPLOAD
My problem is to browse a local pc (win) and upload a file in a remote database. There is a simple solution (js ie)? Thanks, Enrico
Re: [PHP-DB] SQL error:
Which user are you connected as? Who owns the table? unless you connected as the user who owns the table or table is owned by dbo you have to specify username.TBL_DEPT (where username is the name of the user who owns the table) At 16:47 06.07.2001 +0800, you wrote: [EMAIL PROTECTED] -- PHP Database 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]
RE: [PHP-DB] Newbie:Backend scripts
windows 2000 has a command called 'at' .. which is somewhat like crontab. and there is no reason to run lynx and whatever. php for windows has an exe for a reason 'php.exe c:\path\to\phpfile.php' schedule that every two hours. Mats Remman PHP Developer/Mysql DBA Coretrek, Norway +47 51978597 / +47 916 23566 -Original Message- From: PHPFAN [mailto:[EMAIL PROTECTED]] Sent: Friday, July 06, 2001 4:53 AM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Newbie:Backend scripts Thank you very much for your help Beau!!! Sagil. Beau Lebens [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... // OK, i just checked and tested (jeez i'm a nice guy.. :P) and // dodgy Windoze // schedule doesn't allow you to do it by the hour, so if you // want it every 2 // hours, you'll have to set one, daily at 2am, one daily at // 4am etc etc, all // doing the same thing. change this, under the Schedule Advanced settings for the scheduled event you can Repeat Task every x minutes/hours etc, so only need one scheduled event for it all :) beau -- PHP Database 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 Database 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-DB] Re: Cookie is set?
Here's the way I check: -Set a cookie on the user's machine. I name mine sessionid. -Redirect to a new page using header(location: acceptcookies.php); -On the new page, check to see if the variable has a value. For example, I would check to see if $sessionid== and if it's true then their machine didn't accept the cookie (or the cookie was set with a blank value). If it's false then the cookie was set correctly. Hope this helps. -Angela anyone have a good method or code snippet to check if the user is accepting cookies? Thanks luis __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- PHP Database 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-DB] TEXT fields without line breaks
Hi all, (I'm not sure if this is the right place to submit this but I'm having problems with the php.general group) I am in desperate need for a solution to HTML text fields not storing new lines. I'm storing news articles in a database but all the text just ends up in a big block because it ignores line breaks. Is there a way around this without having to upload text files? Thanks, Mat -- PHP Database 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]
Re: [PHP-DB] TEXT fields without line breaks
The line breaks may be there, but HTML will not render them. Try this: $outputstring = nl2br($stringfromDB); print(p$outputstring/p); or something like this to see if the newlines will convert to br and render correctly. John On Fri, 6 Jul 2001, Mat Marlow wrote: -Hi all, -(I'm not sure if this is the right place to submit this but I'm having -problems with the php.general group) - -I am in desperate need for a solution to HTML text fields not storing new -lines. I'm storing news articles in a database but all the text just ends up -in a big block because it ignores line breaks. Is there a way around this -without having to upload text files? - -Thanks, - -Mat - - - - - --- -PHP Database 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] - ** John Huggins Virginia Net Corporation 7101 Oriole Avenue Springfield, VA 22150 703-912-6214 703-912-4831 fax [EMAIL PROTECTED] http://www.va.net/ ** -- PHP Database 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]
RE: [PHP-DB] TEXT fields without line breaks
Ive encountered this at my last job and we were using perl as our backend. Before inserting into the database, check for \n or \r and replace with a combo of chars that are mostly likely not to be typed into the text field. Examples: ][, or |43; or whatever... Then when you reread back from the database and output the data, swap your special newline chars with \n. A bit of a pain, but it works. Kevin Johnson KJ -Original Message- From: Mat Marlow [mailto:[EMAIL PROTECTED]] Sent: Friday, July 06, 2001 8:42 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] TEXT fields without line breaks Hi all, (I'm not sure if this is the right place to submit this but I'm having problems with the php.general group) I am in desperate need for a solution to HTML text fields not storing new lines. I'm storing news articles in a database but all the text just ends up in a big block because it ignores line breaks. Is there a way around this without having to upload text files? Thanks, Mat -- PHP Database 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 Database 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-DB] front end for mysql for use on my website
I am looking for a front end for mysql for use on my website. What I want is something that I can run, from the server (my webhost will not allow remote connections to the mysql server), that allows me to insert, delete, and modify records into a mySql database. Requirements are that it be free, preferrably written in PHP and not require a knowledge of SQL. Anything out there that can do this? -- PHP Database 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]
Re: [PHP-DB] front end for mysql for use on my website
Try phpMyAdmin. On Fri, 6 Jul 2001, Ed Peddycoart wrote: -I am looking for a front end for mysql for use on my website. What I want -is something that I can run, from the server (my webhost will not allow -remote connections to the mysql server), that allows me to insert, delete, -and modify records into a mySql database. Requirements are that it be -free, preferrably written in PHP and not require a knowledge of SQL. -Anything out there that can do this? - - - --- -PHP Database 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] - ** John Huggins Virginia Net Corporation 7101 Oriole Avenue Springfield, VA 22150 703-912-6214 703-912-4831 fax [EMAIL PROTECTED] http://www.va.net/ ** -- PHP Database 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]
Re: [PHP-DB] PHP MSSQL, IIS Question -- Size Question
What version of php are you using ? Handling of binary data from MSSQL Server was changed from php4.0.5 to php4.0.6. As far as I can tell You should not have any problems with php4.0.6 - Frank I am preparing a report for a database at my company that will be shown on the web. It has several nested tables and such in it. One of the fields to show is a blob field. If the blob field is too long, IIS will hang, and not be able to render the table. If the blob field is less than 2K it is fine. Sometimes it is bigger. If I remove the blob field from showing it always works fine, on every record. If I put the blob field in, it will hang on certain records but not all. How can I increase IIS's or PHP's buffer size so that it will render the entire page correctly everytime? Joshua -- PHP Database 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 Database 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-DB] Stress tesing a DB
I'm gathering data on open-source databases... is there a program that can provide comparisons between databases, such as MySQL and PostgreSQL? -- PHP Database 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-DB] Re: Interbase: how can I insert null values with placeholders?
I found this bug and fixed it but my patch has not been included in the cvs source yet. (Note, someone should give me cvs access to the interbase source.) The problem is that the interbase extension has been pretty much untouched since php3 and I don't think that the null value was added until php4. I have attached the patch, it also changes blobs so that no special processing is necessary to use them. -- Jeremy Bettis [EMAIL PROTECTED] Kiss Marton [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Hi! I like to insert null values with placeholders in ibase_query. But it doesn't work. $stmt = insert into category_prop \n. (id, category_id, category_prop_type_id, asinteger, asfloat, ascurrency, asstring) \n. values (gen_id(gen_category_prop_id,1),1097,109,?,?,?,?); $asinteger = null; $asfloat = 2.5; $ascurrency = 3; $asstring = apple; $sth = ibase_query($dbh, $stmt, $asinteger, $asfloat, $ascurrency, $asstring); This statement insert '0' instead null. Why? Best Regards, Kiss Marton [EMAIL PROTECTED] begin 666 php.diff.txt M26YD97@Z(5X=]I;G1EF)AV4O:6YT97)B87-E+F,-CT]/3T]/3T]/3T] M/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T] M/3T]/3T]/3T]/3T-E)#4R!F:6QE.B OF5P;W-I=]R2]P:' T+V5X=]I M;G1EF)AV4O:6YT97)B87-E+F,L=@T*F5TFEE=FEN9R!R979IVEO;B Q M+C4X#0ID:69F(UU(UR,2XU.!I;G1EF)AV4N8PT*+2TM(5X=]I;G1E MF)AV4O:6YT97)B87-E+F,),C P,2\P-B\P.2 P.3HS,#HT,@DQ+C4X#0HK M*RL@97AT+VEN=5R8F%S92]I;G1EF)AV4N8PDR,# Q+S W+S V(#$T.C4Y M.C Q#0I 0 M,C4L-B K,C4L,34@0$ -B -B O*@T*( E#:%N9V5S.@T* M*PD@( @,C P,2TP-BTQ,SH@2F5R96UY($)E='1IR \:F5R96UY01E861B M965F+F-O;3X-BL)( @( @( M(%)E='5R;B!T:4@=5X=!O9B!B;]B MR!I;B!?AP7VEB87-E7V9E=-H7VAAV@L(YO=!T:4@8FQO8@T**PD@ M( @( @( @:%N9QERP@979E;B!I9B!T:4@0DQ/0B!IR!N;W0@;V8@ M5$585!T7!E#0HK0DR,# Q+3 U+3,Q.B!*97)E;7D@0F5T=ES(#QJ97)E M;7E 95A9)E968N8V]M/@T**PD)2T@268@82!B;]B(AA;F1L92!W87,@ M97AP96-T960@86YD('-O;65T:EN9R!E;'-E('=APT**PD)2 @F5C96EV M960@8W)E871E($@8FQO8B!A;F0@861D('1H92!V86QU92!T;R!I=X-BL) M0DM($EF('1H92!I;F-O;6EN9R!AF=U;65N=!T;R!A()I;F0@%R86UE M=5R(ES($Y53$P-BL)0D@('1H96X@W1OF4@82!.54Q,(EN('1H92!D M871A8F%S92X-BL)0DM($UOF4@=F5R8F]S92!D871E(5RF]RRX-B ) M3$Y.3DM,#DM,C$Z4EV;R!086YA8V5K(#QI=F]P0')E9VEO;F5T+F-Z/@T* M( D)2T@861D960@0T]-4$E,15]$3!S96-T:6]N#0H@0D)+2!M;W)E('9E MF)OV4@AP7VEN9F]?:6)AV4@9G5N8W1I;VX-D! (TQ,3,P+#@*S$Q M,SDL-R! 0 T*( T*(\J('M[R!?AP7VEB87-E7V)I;F0H*0T*( @($)I M;F0@%R86UE=5R('!L86-E:]L95RR!I;B!A('!R979I;W5S;'D@')E M%R960@75EGD@*B\-BUS=%T:6,@:6YT(%]P:'!?:6)AV5?8FEN9A8 M4U%,1$$@*G-Q;1A+!P=F%L(HJ8E]V87)S+!24Y$7T)51B J8G5F*0T* M*W-T871I8R!I;G0@7W!H%]I8F%S95]B:6YD*%A344Q$02 JW%L9$L('!V M86P@*BIB7W9AG,L($))3D1?0E5(IB=68L(EB87-E7W%U97)Y(II8E]Q M=65R2D-B![#0H@5A344Q605(@*G9ACL-B )'9A; J8E]V87([#0I M0 M,3$T,RPV(LQ,34R+#$U($! #0H@0EV87(M/G-Q;EN9 D@/2 F8G5F M6VE=+G-Q;EN9#L-B )6)?=F%R(#T@8E]V87)S6VE=.PT*( D)#0HK0EI M9B H8E]V87(M/G1Y4@/3T@25-?3E5,3D@PT**PD)7-T871I8R!C:%R M(YO=AI;F=;-C1=.PT**PD)7-T871I8R!S:]R=!N=6QL7V9L86@/2 M M,3L-BL)0EV87(M/G-Q;1A=$@/2!N;W1H:6YG.PT**PD)79ABT^W%L M='EP92!\/2 Q.PT**PD)79ABT^W%L:6YD(#T@)FYU;Q?9FQA9SL-BL) M0EI9B H=F%R+3YS6QL96X@/B V-D-BL)0D)=F%R+3YS6QL96X@/2 V M-#L-BL)7T@96QS90T*( D)W=I=-H*'9ABT^W%L='EP92 F('XQ*2![ M#0H@0D)8V%S92!344Q?5$585#H)0D@( O*B!D:7)E8W0@=\@=F%R:6%B M;4@*B\-B )0EC87-E(%-13%]605)924Y'.@T*0$ @+3$R,C L-R K,3(S M.PW($! #0H@0D)0EN(#T@W-C86YF*)?=F%R+3YV86QU92YS='(N=F%L M+(E94J6R]=)60E*ELO725D(5D)2I;.ETE94J6SI=)60B+ T*( D)0D) M2 @(9T+G1M7VUO;BP@)G0N=U?;61A2P@)G0N=U?65ABP@(9T+G1M M7VAO=7(L(9T+G1M7VUI;BP@)G0N=U?V5C*3L-B )0D)6EF*X@(3T@ M,R F)B!N($](#8IPT*+0D)0D)5]P:'!?:6)AV5?;6]D=6QE7V5RF]R M*)I;G9A;ED(1A=4O=EM92!F;W)M870B*3L-BL)0D)0E?AP7VEB M87-E7VUO9'5L95]EG)OB@B:6YV86QI9!D871E+W1I;64@9F]R;6%T.B!% M'!E8W1E9 S(]R(#8@9FEE;1S+!G;W0@)60N(%5S92!F;W)M870@;2]D M+UD@2#II.G,N(%EO=2!G879E(ERB+!N+!B7W9ABT^=F%L=64NW1R M+G9A;D[#0H@0D)0D)F5T=7)N($9!24Q54D4[#0H@0D)0E]#0H@0D) M0ET+G1M7WEE87(@+3T@,3DP,#L-D! (TQ,CX+#$R(LQ,CDV+#,V($! M#0H@0D)0EI9B H8E]V87(M/G1Y4@(3T@25-?4U1224Y'#0H@0D)0D) M?'P@8E]V87(M/G9A;'5E+G-TBYL96X@(3T@VEZ96]F*EB87-E7V)L;V)? M:%N9QE*0T*( D)0D)7Q\(@H:6)AV5?8FQO8E]H86YD;4@*BDH8E]V M87(M/G9A;'5E+G-TBYV86PI*2T^8FQ?:%N9QE($](# I('L-BL)0D) M0E)0DQ37T9%5$-(*D[#0HK0D)0D):6)AV5?8FQO8E]H86YD;4@*FEB M7V)L;V([#0HK0D)0D):6)?8FQO8B ](AI8F%S95]B;]B7VAA;F1L92 J M*2!E;6%L;]C*'-IF5O9BAI8F%S95]B;]B7VAA;F1L92DI.PT**PD)0D) M6EB7V)L;V(M/G1R86YS7VAA;F1L92 ](EB7W%U97)Y+3YTF%NSL-BL) M0D)0EI8E]B;]B+3YL:6YK(#T@:6)?75EGDM/FQI;FL[#0HK0D)0D) M:6)?8FQO8BT^8FQ?:%N9QE(#T@3E5,3#L-BL)0D)0EI9B H:7-C7V-R M96%T95]B;]B*$E7U-405154RP@)FEB7V)L;V(M/FQI;FLL(9I8E]B;]B M+3YTF%NU]H86YD;4L(9I8E]B;]B+3YB;%]H86YD;4L(9I8E]B;]B M+3YB;%]Q9DI('L-BL)0D)0D)969R964H:6)?8FQO8BD[#0HK0D)0D) M5]P:'!?:6)AV5?97)R;W(H*3L-BL)0D)0D)F5T=7)N($9!24Q54D4[ M#0HK0D)0D)?0T**PD)0D)6-O;G9EG1?=]?W1R:6YG*)?=F%R*3L- MBL)0D)0EI9B H:7-C7W!U=%]S96=M96YT*$E7U-405154RP@)FEB7V)L M;V(M/F)L7VAA;F1L92P@*'5NVEG;F5D('-H;W)T*2!B7W9ABT^=F%L=64N MW1R+FQE;BP@8E]V87(M/G9A;'5E+G-TBYV86PI*2![#0HK0D)0D)5]P
[PHP-DB] Distributed Tables vs. fewer Monster Tables
I am putting the finishing touches on a forum program which has a direct lineage (look and feel at least) to Matt Wright's WWWBoard perl script. Remember that? Today I have one table per forum. The forums on my live test site are huge. http://www.astronomy.net/forums/ I have long dreamed of combining all the messages into one big honking table in MySQL and parse accordingly. I already know how to do this, but wonder the following: - Will MySQL lookup performance suffer... much? - Is this just not a good idea? - Will this make MySQL just flat out quit? I have heard the hype behind MySQL being able to handle incredible amounts of data with relative ease. I hear that MySQL does a good job when you are doing mostly reads as is the case here. So far, I have had absolutly no issues with MySQL and just love it. Thus, I am automatically biased. So what say you non-biased folks about data management for a multi-topic forum where each forum has identical structure, but differ only in topic? Combine and simplify? or Divide and conquer? John ** John Huggins Virginia Net Corporation 7101 Oriole Avenue Springfield, VA 22150 703-912-6214 703-912-4831 fax [EMAIL PROTECTED] http://www.va.net/ ** -- PHP Database 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-DB] Redhat TUX
I have heard about a new server developed by Redhat called TUX. Is php supported in this? -Thanks -- Donot rely on the Operating System which don't have any sources for. -Seen somewhere on the Net ___ _ _ _ |_|_||_||_||\/||_|| \ _|| || || \| || ||_/ -- PHP Database 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]