[PHP-DB] about "PHP Warning: failed to rollback outstanding transactions!"

Hi; Linux 2.2.18 + oracle 8.1.7i + php 4.0.5 + oci8 I got a warning in log file. "PHP Warning: failed to rollback outstanding transactions!" I have simplify the script. it will cause the warning. function ShowError($errormsg,$dbh=false) { if($dbh!=false) OCILogOff($dbh); exit()

Re: [PHP-DB] Merge two arrays into associative arrays?

With the risk of being wrong, I will try again... I just did a test with your data, "); print_r($c); print (""); ?> which should produce an associative array with keys from $a and values from $b. The result of this "operation" is Array ( [id] => ID [svrname] => Server Name [ipadd]

[PHP-DB] checking mechanism

Hi all: I have a simple checking mechanism: $num = mysql_num_rows($result); if($num == 0) { $display_news = "Sorry, no news items."; } else { while(this, that and the other) { } } What's the difference between: if($num == 0) { $display_news = "Sorry, no news items.";

[PHP-DB] Inserting Blob Data

Hi, I want to insert data in to a blob. So I followed the steps in de docs, but when I try to execute this script in the IBConsole: begin declare section; based on test.v1 document; based on test.v1.segment BlobV1Buffer; based on test.state CA; unsigned short BlobV1Len;

[PHP-DB] Interbase BLOB Insertion Problem

Hi, I want to insert data in to a blob. So I followed the steps in de docs, but when I try to execute this script in the IBConsole: begin declare section; based on test.v1 document; based on test.v1.segment BlobV1Buffer; based on test.state CA; unsigned short BlobV1Len;

Odp: [PHP-DB] Interbase BLOB Insertion Problem

Od: "Xanir" <[EMAIL PROTECTED]> Temat: [PHP-DB] Interbase BLOB Insertion Problem > begin declare section; > based on test.v1 document; > based on test.v1.segment BlobV1Buffer; > based on test.state CA; > unsigned short BlobV1Len; > end declare section; This is DSQL state

[PHP-DB] web to access/excel

*Apologies for cross-postings** Hi there all: Does anyone know of a product - preferably free, that once installed, can take info from an ordinary HTML web based form and drop it into an access/excel database/spreadsheet?? or a pre-defined/written script or class written for Apache/ph

[PHP-DB] odbc with ms access

hi, Access to data with ms access via odbc is kinda slow . I would like to know if it is normal and what can i do to make it faster Thanks Dalyyla -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] T

[PHP-DB] Error MSG -410 while executing a select with ifx_query on a informix database on linux

Hi! We use a informix IDS2000 server on a linux machine together with php 4.05 on Apache. As a test we wrote the following script: The connect seems to work, because we get a syntax error if we use a wrong field-name in the select. We receive the following error when executing this script: W

Re: [PHP-DB] Error MSG -410 while executing a select with ifx_query on a informix database on linux

Hi Robert, Your test code is correct although you could do with an ifx_close($conn_id); at the end. Have you tried running isql(assuming you've got it) and just trying to run the query from there? Regards, - Paul - "Robert Hennig" <[EMAIL PROTECTED]> wrote in message 9ednu0$p93$[EMAIL PROTECT

Re: [PHP-DB] Error MSG -410 while executing a select with ifx_query on a informix database on linux

Hi Paul, thanks for your fast reply. Maybe you could help me again :-) We are working a lot with informix, so we thought to know every Programm, but isql is completely unknown. Is this a special programm? We have executed this select with a sql-editor on the server also as with dbaccess, on both

[PHP-DB] Can't open dbm files with mod_php4-4.0.5_1

Hi, I upgraded my server to Apache 1.3.19/mod-PHP4-4.0.5_1, but now I can not open my 'older' dbm database files any more. When I try to configure --with-dbm , I am not able to compile. Thanks in advance, Eric Pot -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [E

RE: [PHP-DB] web to access/excel

Hi Russ, Try this package: http://phpclasses.upperdesign.com/browse.html/package/237 You need to register for free to gain access, but this package is supposed to write Excel binary files. Jonathan -Original Message- From: Russ Michell [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 22,

Re: [PHP-DB] question about OCIBindByName(add some comment)

On Tue, May 22, 2001 at 09:41:25AM +0900, Michael Cheung wrote: > > On Mon, 21 May 2001 16:39:05 +0200 > "Thies C. Arntzen" <[EMAIL PROTECTED]> wrote: > > > On Mon, May 21, 2001 at 11:35:36PM +0900, Michael Cheung wrote: > > > Hi; > > > Linux 2.2.18 + oracle 8.1.7i + php-4.0.5 + oci8 interface

Re: [PHP-DB] Error MSG -410 while executing a select with ifx_query on a informix database on linux

Hi Robert, isql comes from (I)nformix (S)trutured (Q)uery (L)anguage. It's similar to your sql-editor. I use the SE Database engine and not the Dynamic Server like yourself. Whether this has anything to do with it I don't know but I did run your code on my server just to make sure it ran properly

[PHP-DB] (PROBLEM) Warning: MySQL: Unable to save result set in

Hi i have this problem when php is writing to mysql database on the top of the page it shows this error Warning: MySQL: Unable to save result set in But it still writes to the database , IT jsut shows that warning , How can i get rid of it I have php4 installed and mysql 3.23.38 I configured p

[PHP-DB] OCIFetch performance problem with more rows

Hello, I have performance problem with OCIFetch (and OCIFetchInto, too) when query return more rows.Same query from sqlplus is more fastest (more rows is worse then less rows) I assume that is array proccessing - is there array proccessing in php ? Regards Haris Peco [EMAIL PROTE

Re: [PHP-DB] PHP accessing MySQL

That is what I thought, so I set $db_num to another number and still came up with the same error. jkd ""Darren"" <[EMAIL PROTECTED]> wrote in message 9e42lj$s7b$[EMAIL PROTECTED]">news:9e42lj$s7b$[EMAIL PROTECTED]... > I think the 0 is referring to your $db_num > "Jonathan Duncan" <[EMAIL PROTE

Re: [PHP-DB] OCIFetch performance problem with more rows

At 08:49 PM 5/22/01 +0200, snpe wrote: >Hello, > I have performance problem with OCIFetch (and OCIFetchInto, too) > when query return more rows.Same query from sqlplus is more fastest (more > rows is worse then less rows) Are the columns you're fetching included in an Oracle index?

Fwd: Re: [PHP-DB] OCIFetch performance problem with more rows

-- Forwarded Message -- Subject: Re: [PHP-DB] OCIFetch performance problem with more rows Date: Tue, 22 May 2001 21:02:42 +0200 From: snpe <[EMAIL PROTECTED]> To: "Brian S. Dunworth" <[EMAIL PROTECTED]> On Tuesday 22 May 2001 20:59, you wrote: > At 08:49 PM 5/22/01 +0200, snp

[PHP-DB] error

every time i get this error: Warning: MySQL Connection Failed: Unknown MySQL Server Host '0f2scom' (2) in /web/sites/139/gamie/www.game-boy-advance.f2s.com/addartikel.php on line 22 Unable toconnect to database this is de code(ther are dutch line's in it because this code is for an dutch site):

RE: [PHP-DB] odbc with ms access

http://www.microsoft.com/KB/Articles/Q128/8/08.HTM -Original Message- From: Dalyyla [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 22, 2001 7:32 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] odbc with ms access hi, Access to data with ms access via odbc is kinda slow . I would like to kn

Re: [PHP-DB] PHP accessing MySQL

"Miles Thompson" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Jonathan .. see below. > At 08:38 PM 5/18/01 +, Jonathan Duncan wrote: > >Miles > > > >Thank you for the response. I did some debugging and the value of $dbs is 2. > > > >I am not sure of wha

Re: [PHP-DB] PHP accessing MySQL

I believe you want to look at this page: http://www.thickbook.com/books/phpfe_errata.phtml -- ++ | Julie Meloni ([EMAIL PROTECTED]) | || | "PHP Essentials" and "PHP Fast & Easy" | | http://www.thickbook.c

Re: [PHP-DB] PHP accessing MySQL

YES!! I just had a feeling the book was wrong. That did get rid of the error. However, it did not completely solve my issue. Now when I run the script I just get the message "Couldn't list databases." This just happens to be the die message for the same line of code that I have been looking a

[PHP-DB] Limiting # of connections to remote Oracle

Greetings all, We are having serious issues with PHP4.0.5 using OCI8 and Apache 1.3.17. We have 4 webservers that handle our various needs for oracle. Each server has its MaxSpareServers in the httpd.conf set to 100. So that turns out to be 400 connections to the Oracle database. We are not usin

Re: [PHP-DB] pulling images from a database

If you want to be efficient, store only the image metadata in the database (path, filename, creator, date, dimentions, format, etc) in the database. Keep the actual data as a file. -- Regards, Gary "SuperID" Huntress === FreeSQL.org offering fr

[PHP-DB] Cookie Crumbs....

Leftovers as in. Forward: Set up a system that logs a user in using cookies, and based on thier access level they can view 1.php, 2.php or 1 and 2.php. IT works: Yes it does work, and seems to do nicely. Grabs info from DB and applies it to the cookie..lots of fun :) Main File: A go.php sc

[PHP-DB] php 4.0/win 2000/sql server

When ever I am trying to access a php file with an error,my system is overwelmingly slowing down and restarting is the only solution. Previously I worked on linux/apache/php 4.0/mysql ,I never had such problem.I used to get some errors and I used to correct them but working in this environment is

Re: [PHP-DB] php 4.0/win 2000/sql server

Hi, I'm using PHP 4 and MySql Server under Windows 2000 and I don't have any problem ! I'm actually using the Nusphere integrated solution which includes PHP4, MySql, Apache, Perl, ... . Try this distribution ! You can find it at : http://www.nusphere.com/cgi-bin/nsp.cgi/custsrvc/utils/downlo

[PHP-DB] PLEASE HELP !!!

I am running PHP 4.0.5 on Windows 2000 with SQL server databases. If there is an error with my PHP code, my computer becomes very very slow and nothing works. The PHP process is using 99 % of the CPU. So I have to restart the computer. This happens everytime there is an error in my PHP code. For

Re: [PHP-DB] PLEASE HELP !!!

when you say an error - do you mean any error? or specific errors? ie., you're not getting it stuck in an infinite loop? (cpu time flips up to that when you stick in a loop) or is it all errors? ""PHPFAN"" <[EMAIL PROTECTED]> wrote in message 9eetk0$92d$[EMAIL PROTECTED]">news:9eetk0$92d$[EMAI

Re[2]: [PHP-DB] question about OCIBindByName(Resolved)

Thanks for all the reply. I have resolve the problem by specified the bind type to 96(SLQT_AFC). By explore the source, the default has been set to (SQLT_CHR). as my data type is char(64), so I have to set it to 96, to get the correct result. modified source: $sql="Select count(*) From member wh

Re[2]: [PHP-DB] PLEASE HELP !!!

I bet, there is something logic error in your program.. PHP+apache is such a small program with low resources that cannot harm your system .. mk> ""PHPFAN"" <[EMAIL PROTECTED]> wrote in message mk> 9eetk0$92d$[EMAIL PROTECTED]">news:9eetk0$92d$[EMAIL PROTECTED]... >> I am running PHP 4.0.5 on Wi

[PHP-DB] Find - n - replace

Hello all. I'm trying to set up a quick find and replace script. It's finding, and it's pasting what I want, but on the following line, I can't get it to replace. Can anyone help? #!/usr/local/bin/php -q Can anyone tell me how I can back the fput up one line so it overwrites the result of the

[PHP-DB] Return Row count with OCI

To all PHP-db guruz! I'm novice on Oracle(OCI).In mysql has mysql_num_rows(). When i try to find OCI function about num rows i see OCIRowCount(). But in the manual told me that it cannot use with select statement. How can i know the number of selected row? Thanks in advance -Worawisut -

Re: [PHP-DB] web to access/excel

You can write "excel" files (ie files that excel associates with, if you have it) very easily by just using a .csv extension, and the following type format: "field1", "field2", "field3" (ie print "\"field1\",\"field2\",\"field3\""; ) Excel will display this as if it were a "spreadsheet". If y

Re: [PHP-DB] Find - n - replace

try looking at the fseek function, i think that does what you want: http://uk.php.net/manual/en/function.fseek.php "John Starkey" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hello all. > > I'm trying to set up a quick find and replace script. It's finding,

Re: [PHP-DB] Limiting # of connections to remote Oracle

Hi Larry, See http://marc.theaimsgroup.com/?l=php-dev&m=98193543028899&w=2 I would create a special web server listening at port 81 to perform Oracle queries. Your main web servers call the port 81 server using fopen("http://proxyserver:81/updatemail.php?params=...";); to update the Oracle datab

Re: [PHP-DB] Return Row count with OCI

ocifetchstatement() should do the trick. It returns the number of rows. See example at : http://dev.nexen.net/docs/php/annotee/manuel_function.ocifetchstatement.php Best regards, Philippe "Worawisut Pinyoyang" <[EMAIL PROTECTED]> a écrit dans le message news: [EMAIL PROTECTED] > To all PHP-db gu

[PHP-DB] Need a help

I am trying to install Php3.0,Apache_1.3.19,Apache-SSL(Open 0.9.6a) on Linux Server. But after installing OpenSSL,Php,Apache,when I give command - /usr/local/apachessl/bin/httpsd , I am suddenly informed by the folllowing error: <>. Nearly giving up . . . . . Could anyone help me? P.S: (My Ap