[PHP-DB] delay on insert into database

2003-06-24 Thread julian
data, it is being inserted into the database. Any ideas? Packages: Apache 1.3.27 MySQL 3.23.56 PHP Version 4.3.2 Thanks Julian -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] passing a mysqli object via globals

2007-12-03 Thread julian
warn: already posted in general with no response... maybe is too basic.. but I RTFM and still is not clear to me what I am doing wrong I want to open a database connection at program initialization and use that very same connection via globals initilizating ( loading from db) other o

[PHP-DB] Re: passing a mysqli object via globals

2007-12-03 Thread julian
however this will work... p1.inc 1 var;; 9} 10 } 11 12 class obj { 13var $obj2=20; 14 15function f1(){ 16 global $db; 17 18 echo "\n".$db->fun2()*$this->obj2."\n"; 19} 20 } 21 ?> 1 #!/usr/bin/php -q 2 3 f1(); 13 14 ?> -- PHP Database Mailing

Re: [PHP-DB] Re: passing a mysqli object via globals

2007-12-03 Thread julian
Dee Ayy wrote: Hopefully your only issue is the keyword global versus globals ? Not sure what you mean. global $db should bring to local scope a reference to the object that has the data base connection. PHP complaints that it cannot access properties or methods of that object in the obj/f

Re: [PHP-DB] Re: passing a mysqli object via globals

2007-12-03 Thread julian
Dee Ayy wrote: On Dec 3, 2007 10:26 AM, julian <[EMAIL PROTECTED]> wrote: Dee Ayy wrote: Hopefully your only issue is the keyword global versus globals ? Not sure what you mean. global $db should bring to local scope a reference to the object that has the data base connection

Re: [PHP-DB] passing a mysqli object via globals

2007-12-04 Thread julian
Chris wrote: julian wrote: warn: already posted in general with no response... maybe is too basic.. but I RTFM and still is not clear to me what I am doing wrong I want to open a database connection at program initialization and use that very same connection via globals

Re: [PHP-DB] Re: passing a mysqli object via globals

2007-12-04 Thread julian
Dee Ayy wrote: no worries I give up. It is really weird I know Hope some day I will get enlighted. In one file, any method within a class is happy with the global $db...on a different (same file !!!) class no method is happy with accessing $db via global... So you confirmed that you

[PHP-DB] I am a bloody idiot

2007-12-04 Thread julian
Dee Ayy wrote: no worries I give up. It is really weird I know Hope some day I will get enlighted. In one file, any method within a class is happy with the global $db...on a different (same file !!!) class no method is happy with accessing $db via global... So you confirmed that you

Re: [PHP-DB] Manipulating Blob Fields

2008-02-14 Thread julian
Hi Alan, Sorry not writing to help you out. I am trying to do something like you, but with pdf files. I am no expert on mysql but I just can't manage to store a pdf file in a blob field. Any hints or experiences to share ?? I use a sequence of prepared statements, no rocket science precisel

Re: [PHP-DB] Manipulating Blob Fields

2008-02-14 Thread julian
After some research I found a workaround, not a solution. Diggin in www.php.net I found the following (potential) bug apparently resolved time ago http://bugs.php.net/bug.php?id=35155 in relation to Bug #35155 prepared statement with blob field does not work Which is exactly what it is

[PHP-DB] INNO tables - will I have problems?

2004-10-13 Thread Julian Madle
) are installed. The manual says that these are built-in on version 4.0 and above - I just need real-world confirmation from people with more experience in this area than me. Cheers Julian -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] postgresql, pg_pconnect issues, how to close connection properly

2006-09-08 Thread Julian Tree
I have a pretty complex data base that runs a lot of aggreated function (sum, count in addtion to joins) constantly. If I turn off pg_pconnect, the connection takes too long, if I turn on the pg_pconnect, the connection eventually max out. My current solution is to have cron job to restart apac