Re: [PHP-DB] Passing Objects

2001-05-10 Thread Joe Brown
Nope. something like this may get you where you want to go though include(myObjectClassDeclaration); $myInstance=new myObject; echo http://blahblah.com/?passedClass=.urlencode(serialize($myInstance)); Then in subsequent pages this should work: include(myObjectClassDeclaration);

Re: [PHP-DB] Sessions ???

2001-05-02 Thread Joe Brown
Doh! I meant there is NO dire need Joe Brown [EMAIL PROTECTED] wrote in message 9cp3kv$3hj$[EMAIL PROTECTED]">news:9cp3kv$3hj$[EMAIL PROTECTED]... For this operation there is dire need for session management. And remember the default variable order EGPCS may cause you trouble if

Re: [PHP-DB] undefined index

2001-05-01 Thread Joe Brown
I don't think dropping the quotes is the best solution. One might consider dropping the warning level in php.ini, if it is a problem, or use numbered array like mysql_fetch_row() returns. -Joe Henning Kilset Pedersen [EMAIL PROTECTED] wrote in message

Re: [PHP-DB] Intialize PHP Module on Windows98

2001-04-30 Thread Joe Brown
Looks like you've got different versions for php and your modules. Since php is the oldest, make sure you have the newer php4isapi.dll and php4ts.dll in the system directory, or wherever you installed them. Benny [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I

Re: [PHP-DB] Executing a PL/SQL Function

2001-04-30 Thread Joe Brown
Does the database user your logging in as have execute permissions for that procedure? Marcelo Dias de Toledo [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Here is the code: $stmt = OCIParse($conn,BEGIN prontolog.pc_int.pedido(:p_cgc_lweb, :p_id_cliente,

Re: [PHP-DB] Advice On Building Dynamic MySQL Queries

2001-04-19 Thread Joe Brown
My solution was almost as elegent... $query="select * from customers"; $queryand=false; if(!empty($f_Account)) { $query.=" WHERE upper(P.Account) like upper('$f_Account')"; $queryand=true; } if(!empty($f_First_Name)) { $query.=($queryand?" AND ":" WHERE

Re: [PHP-DB] date_format for Oracle

2001-04-11 Thread Joe Brown
Also consider the oracle sql ALTER SESSION SET NLS_DATE_FORMAT='-MM-DD HH24:MI:SS' or whichever format you prefer. This sets the default format returned when selecting a date column. -Joe "Steve Farmer" [EMAIL PROTECTED] wrote in message news:p04320402b6fa8a7ffc70@[203.28.219.179]... Hi

Re: [PHP-DB] Still not - Display data begin with A

2001-04-07 Thread Joe Brown
Put the percent symbol inside of the single quotes: $result = mysql_query("SELECT * FROM mydata WHERE name like '$begin%' ",$db); "Naga Sean" [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... It still not working I want to get the result of people with the first

Re: [PHP-DB] ocibindbyname: ORA-01008: not all variables bound

2001-04-05 Thread Joe Brown
Don't have a whole lot of practice with the OCIBindByName function, but I seem to be having success within a recursive select statement. I'm not useing the operator in my implementation. Don't know if that's a good or a bad thing (yet), but it seems to be functioning properly. The third

Re: [PHP-DB] Validating forms

2001-04-03 Thread Joe Brown
Do both, javascript and server side validation. Javascript can cut down on unnessary page refreshes. Serverside is the only way to guarentee the results, because of the reasons outlined here. Yes, it's more work, but it will provide a better experience for the end surfer. No? -Joe ""B. van

Re: [PHP-DB] metabase support

2001-04-02 Thread Joe Brown
I am a little less biased ;-) I think Manuel's Metabase is the bomb. Unfortunatly, so does Windows... Metabase provides some truely wonderful features. On Windows, Metabase with OCI8 my server keep performing illegeal instructions. I think this is a lack of PHP's maturity on Win32, not

Re: [PHP-DB] Indexing help

2001-03-27 Thread Joe Brown
Columns used in the WHERE clause is the good identifier for which columns to index. You don't want to index every column you select. Typically adding indexes decreases insert performance. The more indexes the slower inserts operate, because the indexes also must be updated. Adding an index to

Re: [PHP-DB] get_browser()

2001-03-27 Thread Joe Brown
Is it easier to update every web page you code with get_env("HTTP_USER_AGENT") ; or easier to grab a new browser.ini file? ""Simon R Jones"" [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... hi all how does everyone feel about the get_browser function?? Is the

Re: [PHP-DB] Transmitting Arrays

2001-03-21 Thread Joe Brown
hmm... looks like you're trying to use seralize(var_name); with out assigning a value to a holder variable. $holder=seralize($var_name); will probably get you further along. also, try: $var_name=unseralize($holder); for the return trip. same goes for urlencode/decode; though you can do two

Re: [PHP-DB] How to display HTML code?

2001-03-19 Thread Joe Brown
try: ?php echo htmlentities("A HREF=home.phpHome/A"); ? ""Osman Omar"" [EMAIL PROTECTED] wrote in message 00f901c0b0cf$c99e7da0$da604a2b@sony">news:00f901c0b0cf$c99e7da0$da604a2b@sony... Hi, Suppose I want to display HTML code eg "A HREF=home.phpHome/A" How can I do that in php? -- PHP

Re: [PHP-DB] Line breaks in output

2001-03-19 Thread Joe Brown
Better yet, use "br" for browsers. Or use Jeff's method but use nl2br function to convert new line to br echo nl2br($result); ""JJeffman"" [EMAIL PROTECTED] wrote in message 007f01c0b0d8$212e97a0$5bd4d7c8@jjeffman">news:007f01c0b0d8$212e97a0$5bd4d7c8@jjeffman... Create a variable to

Re: [PHP-DB] mail() headers

2001-03-19 Thread Joe Brown
I believe mail works completely different on unix. It probably doesn't suffer the same problems, because it's a direct call to an external process. Lookup "sendmail" ""Free Beachler"" [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Someone else has tested this

Re: [PHP-DB] metabase documentation or samples

2001-03-17 Thread Joe Brown
http://phpclasses.upperdesign.com/browse.html/package/20 To my knowledge, this is the home page for metabase. Manuel has done a wonderful job putting together a documentation and a tutorial. ""Dean Hall"" [EMAIL PROTECTED] wrote in message 98usbh$li8$[EMAIL PROTECTED]">news:98usbh$li8$[EMAIL

Re: [PHP-DB] PHP how to compare?

2001-03-15 Thread Joe Brown
No, two is a more accurate comparison. !== Although for most cases != is sufficient. ""Richard S. Crawford"" [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... use just one = sign. So, if ($PASS != $PASSNOG) {... At 01:41 AM 3/15/01 +0100, Duky wrote: Hmm..

Re: [PHP-DB] Javascript and PHP

2001-03-14 Thread Joe Brown
Well, No and Yes. If the form is posted, whichever page that it was posted too will have $HTTP_POST_VARS["text1"] set to whatever was in the textbox. $text1 may also be a global variable, depending on your php.ini settings for register_globals and also variable_order. It took me a while to feel

Re: [PHP-DB] Connecting to Oracle

2001-03-13 Thread Joe Brown
I'm not looking forward to this... Due to circumstances beyond my control, I will be forced into a similar configuration soon. Try putenv("ORACLE_SID=WKDS.world"); If your sqlnet.ora does does not specify .world as the default domain, then that may be the problem. Was your TNSNAMES.ORA file

Re: [PHP-DB] Re: Connecting to Oracle

2001-03-13 Thread Joe Brown
Brian, Thanks for the solution, that is a good one. I imagine you can set the environment variable oracle_sid this way also. ORACLE_SID=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.68.10.1)(PORT=1521) )(CONNECT_DATA=(SID=TEST))) re: TNSNAMES.ORA It seems to be a fairly common occurence where

Re: [PHP-DB] Oracle Function Calls

2001-03-07 Thread Joe Brown
this chunk of code comes out of http://www.php.net/manual/en/function.ocinewcursor.php ?php // suppose your stored procedure info.output returns a ref cursor in :data $conn = OCILogon("scott","tiger"); $curs = OCINewCursor($conn); $stmt = OCIParse($conn,"begin info.output(:data); end;");

Re: [PHP-DB] php 3 vs. 4

2001-03-02 Thread Joe Brown
Nope, session management was added in php4. The phplib project among other things, provides a session management mechanisim. ""Free Beachler"" [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... is there any support for session mgmt in php3? my client is trying to

[PHP-DB] Javascript diabled? (was Re: [PHP-DB] onMouseOver onMouseOut)

2001-03-02 Thread Joe Brown
Curious. I disabled javascript in IE 5.5 Out of the limited scripting I use on my site, the navigate to first entry field nolonger works, but the onchange() event seems to be firing still... Go figure. "Ron Brogden" [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL

Re: [PHP-DB] md5

2001-02-27 Thread Joe Brown
You are aware that md5() generates a 32 byte character string? Working on the 10 digit password request, have you alotted enough space in your database columns to cater to a 32 byte string (64 for multibyte)? BTW: md5 has eaten everything I've thrown at it ;-) ""bryan"" [EMAIL PROTECTED] wrote

Re: [PHP-DB] Resolution detect and redirect

2001-02-27 Thread Joe Brown
This feat will require a java script (not appropriate for php/db). I saw something on a javascript site, perhaps www.webreference.com gl ""Matthew Cothier"" [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Why not just create a table that will resize to any

Re: [PHP-DB] MySQL join problem

2001-02-27 Thread Joe Brown
I doubt that a few thousand records would be more than mysql is capable of handeling. However my ignorance of Mysql is abundant. Does it use the /tmp directory and is your /tmp or root partition small? (guessing linux here). Does mysql use the /tmp directory for temporary tables? (Answer in

Re: [PHP-DB] Can't connect to local MySQL server error

2001-02-27 Thread Joe Brown
Heh, hate this gotcha... The file permissions are good... ok, now check each directory up to mysql.loc /var /var/lib /var/lib/mysql Does the world have read and execute perms on all of the above (hehe made a funny)? Without read and execute perms on the parent directories, the world cannot see

Re: [PHP-DB] Oracle 8i questions

2001-02-26 Thread Joe Brown
":body" in sql isn't the same as ":bodytext" in the bindbyname statement, after that, you're in deeper than myself... HTH, -Joe ""Chris Murtland"" [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I apologize for my cross-post, but since I received no response on

Re: [PHP-DB] Fatal error: Call to undefined function: () in add2.php on line 11

2001-02-26 Thread Joe Brown
back to the drawing board... Re-compile php --with-mysql ""jim and lois flaherty"" [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... help , I have this problem I have redhat 7.0 mysql 3.23 and php-mysql rpm installed my code html head

Re: [PHP-DB] OCI 8 and rowid cause SIGSEGV

2001-02-24 Thread Joe Brown
The the colon has special meaning. Look up the OCI man page, specifically - look up the OCIBindByName function. http://www.php.net/manual/en/ref.oci8.php It may give you a hint for the use of the colon and it's use in positioning bound variables. -- Without knowing your table structure and

Re: [PHP-DB] deleting carts

2001-02-24 Thread Joe Brown
Although it is probably easiest for you to manage this with php, It makes more sense to me to write a script that is managed by cron (php if you really want) that is executed on a regular basis w/out affecting any users browser latency. If each customer has to wait a little longer, you're going

Re: [PHP-DB] Server side or client side?

2001-02-24 Thread Joe Brown
Don't complicate it... Just enclose your list entries in a href=another.html?id=${entry}${entry}/a and use another page if you want... Or loop back to the same page and check if(empty($id)) {show the first list... a href=${PHP_SELF}?id=${entry}${entry}/a ...} else { show the second list}

Re: [PHP-DB] OCI 8 and rowid cause SIGSEGV

2001-02-23 Thread Joe Brown
I suppose the authors never concieved a replacement parameter for select specification. try: $sql = "select foo, bar, rid from masterdata WHERE rid=:rid" You need to loose the colon ":" or place it to the right of a where clause. [EMAIL PROTECTED] wrote in message

Re: [PHP-DB] ORA-12154: TNS:could not resolve service name in XXX

2001-02-22 Thread Joe Brown
I had a similar problem. Worked up a tnsnames.ora file on windoz machines. Thought it would be no big deal if it was copied over to linux and used. But there is a big deal.. Oracle can't handle the CRNL character sequence, in a unix environment. Go figure... There used to be a dos2unix

Re: [PHP-DB] problems with require...

2001-02-15 Thread Joe Brown
Try using the full path to your include or require file... see if that works. inlude("D:\Inetpub\paulberry\press.inc"); The include_path is a list of directories where php should expect to find files. Yours appears to be empty. Edit your php.ini to change this. I don't remember if the