Re: [PHP-DB] Get Confused : Use Transaction or not

On Tuesday 26 April 2005 22:26, Bastien Koert wrote: Hi Phil 1. The InnoDB engine type (for mysql) uses row locking for its transactions by default. (http://dev.mysql.com/doc/mysql/en/innodb-transaction-model.html) 2. Transactions offer an all or nothing shot at entering data into

FW: [PHP-DB] mime-type related to extension?

Hi I sent this on 21st of april and got no answer... there is no way to check the real mime type of a file? even a file without extension? thanks, melanie From: mel list_php [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] mime-type related to extension? Date: Thu, 21 Apr 2005

Re: [PHP-DB] mime-type related to extension?

The beginning of the jpeg file in hex looks like this: FF D8 FF perhaps you could test for that occurrence. Be aware that the occurrence of FF D8 FF must be in each jpg file -- it does not mean that the occurrence of FF D8 FF is found only in a jpg file.

[PHP-DB] Transaction over persistent connection problem

Hello, I would like to create transaction that is commited/rolled back in the next step of the script. Example: ? if (isset($commit)): $connection=mysql_pconnect($server); mysql_query((($commit) ? commit : rollback));

Re: FW: [PHP-DB] mime-type related to extension?. .

meal list_php wrote: Hi I sent this on 21st of april and got no answer... there is no way to check the real mime type of a file? even a file without extension? thanks, You can call out to an external program called file (which is pretty much guaranteed to be there, on a Linux system) which uses

[PHP-DB] Memory

Hi, When I get something from database, using this function: pg_query (postgresql) or mysql_query and after put this result in somes variables, Am I using double memory to same data or this new variable point to variable with db result? Gustavo Paixão -- PHP Database Mailing List

[PHP-DB] Using Memory

Hi, When I get something from database, using this function: pg_query (postgresql) or mysql_query and after put this result in somes variables, Am I using double memory to same data or this new variable point to variable with db result? Gustavo Paixão -- PHP Database Mailing List

Re: [PHP-DB] Memory. .

[FOTOList.com] Suporte wrote: Hi, When I get something from database, using this function: pg_query (postgresql) or mysql_query and after put this result in somes variables, Am I using double memory to same data or this new variable point to variable with db result? The postgresql or mysql

Re: [PHP-DB] Transaction over persistent connection problem

Hello, on 04/27/2005 09:58 AM Oskar said the following: You see - tables are locked and the only way to fix it is restarting MySQL. Could you tell me what am I doing wrong, please? I suspect that your scripts may be exiting once in a while with unfinished transactions due to bugs or errors that

RE: [PHP-DB] Transaction over persistent connection problem

Ok. So the idea of splitting one transaction into two steps of a script is wrong? I wanted to use it in a script that is importing big amount of datas (about 200k rows). First step: mysql_pconnect() start transaction insert rows and test errors no errors =

Re: FW: [PHP-DB] mime-type related to extension?. .

* Martin Norland [EMAIL PROTECTED]: meal list_php wrote: Hi I sent this on 21st of april and got no answer... there is no way to check the real mime type of a file? even a file without extension? thanks, You can call out to an external program called file (which is pretty much

Re: [PHP-DB] Transaction over persistent connection problem

Hello, on 04/27/2005 11:49 AM Oskar said the following: Ok. So the idea of splitting one transaction into two steps of a script is wrong? Yes, it is not possible to achive that. What happens is that first access to script is handled by one Web server process or thread and you cannot assure that

Re: [PHP-DB] php4 can't find tnsnames.ora oracle9 but can connectif description

Without real information I can only wonder and guess. Is TNS_ADMIN set to a directory or a file? It should be a directory. Try renaming sqlnet.ora temporarily or set the alias in tnsnames.ora to something like testdb.boo.com = (DESCRIPTION = ... Chris neil smith wrote: Hello chris, I've modified

RE: [PHP-DB] Transaction over persistent connection problem

Thanks for your help, Manuel. Your advice saved me hours of searching the web. Regards, OKi98 -Original Message- From: Manuel Lemos [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 27, 2005 7:20 PM To: php-db@lists.php.net Subject: Re: [PHP-DB] Transaction over persistent

Re: [PHP-DB] Transaction over persistent connection problem

Manuel Lemos wrote: Hello, on 04/27/2005 11:49 AM Oskar said the following: Ok. So the idea of splitting one transaction into two steps of a script is wrong? Yes, it is not possible to achive that. What happens is that first access to script is handled by one Web server process or thread and

Re: [PHP-DB] Transaction over persistent connection problem

Hello, on 04/27/2005 08:13 PM Jochem Maas said the following: Ok. So the idea of splitting one transaction into two steps of a script is wrong? Yes, it is not possible to achive that. What happens is that first access to script is handled by one Web server process or thread and you cannot