[PHP-DB] Session Cache Limiter
Hi, has anyone used session_cache_limiter('must-revalidate') before to solve the problem on "Warning: Page Expire.."? i saw it on some websites, tried it and it worked for me.. but i never come across this word officially in any books or sites.. Can someone kindly direct me to something that provides me with more information on this? thank you so much!! hwee PS: i'm not sure if this is appropriate for this list.. sorry, if it is not!!! =(
[PHP-DB] Socket Errors
Can anyone shed any light on this error, i have googled and found out it is a winsock error but i havent a clue why i am getting it, one minute this worked the next it didnt. Warning: fsockopen() [function.fsockopen]: unable to connect to news.php.net:119 (A non-blocking socket operation could not be completed immediately. ) in D:\htdocs\WebReader\System\NET\Sockets\Socket.php on line 25 -- Joseph Crawford Jr. Codebowl Solutions [EMAIL PROTECTED] 802-558-5247 For a GMail account contact me OFF-LIST -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Re: Accessing Matisse DB
On Thu, 16 Sep 2004, Petrus Ali Saputra wrote: > John Holmes wrote: > > > Petrus Ali Saputra wrote: > > > >> Petrus Ali Saputra wrote: > >> > >>> Is there anyone here can tell me how to access Matisse DB? Thank you. > >> > >> > >> Isn't there anyone can help me? > > > > > > ODBC? > > > Yes, but it will lower the ability of Matisse. > Please elaborate on how the use of ODBC will lower the ability of Matisse. Are there aspects of Matisse that can't be done with SQL? Unless you can find a PHP extension for Matisse, then your only alternative is ODBC. -- bob > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re :Re: [PHP-DB] How use select for update
Escuse me i forgot the "t" > Is row-level locking happening? > I think that the lock doesn t work > > When are you checking the locks? > I am checking the lock with an SQLPLUS session > > If i lock my table with SQLPLUS, PHP can make an select for update > But if i try to lock with PHP i can make an other select for update with > sqlplus > So my lock doesn t work > If i lock my table with SQLPLUS, PHP can T make an select for update I have the same code $query = 'select * from emp for update nowait'; $stid = OCIParse($conn, $query); $r = OCIExecute($stid, OCI_DEFAULT); But my problem, it s that i can t lock my table with PHP I haven t problem with SQLPLUS -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] How use select for update
Chris wrote: Is row-level locking happening? I think that the lock doesn t work When are you checking the locks? I am checking the lock with an SQLPLUS session If i lock my table with SQLPLUS, PHP can make an select for update But if i try to lock with PHP i can make an other select for update with sqlplus So my lock doesn t work My locks work. In SQL*Plus: select * from emp for update; In a PHP script: $query = 'select * from emp for update nowait'; $stid = OCIParse($conn, $query); $r = OCIExecute($stid, OCI_DEFAULT); The output of the PHP script is: Warning: ociexecute(): OCIStmtExecute: ORA-00054: resource busy and acquire with NOWAIT specified in c:\cj\test.php on line 25 This shows that the rows were locked and not available. Calling the PHP script before the SQL*Plus script has different behaviour. See http://www.orafaq.com/faqphp.htm#TRANS : "If one doesn't commit or rollback at the end of a script, PHP will do an implicit commit" Chris -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: Re: [PHP-DB] How use select for update
Is row-level locking happening? I think that the lock doesn t work When are you checking the locks? I am checking the lock with an SQLPLUS session If i lock my table with SQLPLUS, PHP can make an select for update But if i try to lock with PHP i can make an other select for update with sqlplus So my lock doesn t work -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] How use select for update
Chris wrote: I m trying to make a program with PHP and Oracle I want to use an "Select for upate" But when i send the command, it doesn t lock my "table" If someone can help me Is row-level locking happening? When are you checking the locks? A couple of references (free reg required): http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10743/toc.htm http://download-west.oracle.com/docs/cd/B14117_01/appdev.101/b10795/toc.htm Also see http://asktom.oracle.com/ Chris -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php