[PHP-DB] Interbase: How to get table structure via SQL ?
Hi, does anyone know how to get the Structure of a table using SQL. (ex.: SELECT ?RELATION_SOURCE?, RDB$RELATION_NAME FROM RDB$RELATIONS) Isn't there any table containing the CREATE STATEMENT for a table? Maybe I have to use another command? Please help ! Thx, DiZEM -- GMX ProMail (250 MB Mailbox, 50 FreeSMS, Virenschutz, 2,99 EUR/Monat...) jetzt 3 Monate GRATIS + 3x DER SPIEGEL +++ http://www.gmx.net/derspiegel +++ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Interbase: How to get table structure via SQL ?
If you're using MySQL, you can use the DESCRIBE tablename command. There's a pretty straightforward (and easy to find) section on the DESCRIBE command in the MySQL documentation. -Original Message- From: DiZEM PGC [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 18, 2004 8:11 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Interbase: How to get table structure via SQL ? Hi, does anyone know how to get the Structure of a table using SQL. (ex.: SELECT ?RELATION_SOURCE?, RDB$RELATION_NAME FROM RDB$RELATIONS) Isn't there any table containing the CREATE STATEMENT for a table? Maybe I have to use another command? Please help ! Thx, DiZEM -- GMX ProMail (250 MB Mailbox, 50 FreeSMS, Virenschutz, 2,99 EUR/Monat...) jetzt 3 Monate GRATIS + 3x DER SPIEGEL +++ http://www.gmx.net/derspiegel +++ -- 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
RE: [PHP-DB] Interbase: How to get table structure via SQL ?
Sorry...just re-read the subject and realized you're using Interbase. Need coffee. ;) -Original Message- From: Hutchins, Richard [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 18, 2004 8:24 AM To: 'DiZEM PGC'; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Interbase: How to get table structure via SQL ? If you're using MySQL, you can use the DESCRIBE tablename command. There's a pretty straightforward (and easy to find) section on the DESCRIBE command in the MySQL documentation. -Original Message- From: DiZEM PGC [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 18, 2004 8:11 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Interbase: How to get table structure via SQL ? Hi, does anyone know how to get the Structure of a table using SQL. (ex.: SELECT ?RELATION_SOURCE?, RDB$RELATION_NAME FROM RDB$RELATIONS) Isn't there any table containing the CREATE STATEMENT for a table? Maybe I have to use another command? Please help ! Thx, DiZEM -- GMX ProMail (250 MB Mailbox, 50 FreeSMS, Virenschutz, 2,99 EUR/Monat...) jetzt 3 Monate GRATIS + 3x DER SPIEGEL +++ http://www.gmx.net/derspiegel +++ -- 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 Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Interbase: How to get table structure via SQL ?
Hi, ...table structure without PEAR ? Is it possible to accomplish this by a sql-statement or do I really HAVE TO install this xtension (PEAR) ? Cuz I've already written a few scripts containing many function calls (self written classes, too). I read the PEAR extension organizes everything with packages. So, if I install PEAR, do I have to change all my function calls? I'd like to find a more 'simple' solution for my problem. (P.S.: Thx to R.Hutchins 4 answering quickly!) Bye, DiZEM -- GMX ProMail (250 MB Mailbox, 50 FreeSMS, Virenschutz, 2,99 EUR/Monat...) jetzt 3 Monate GRATIS + 3x DER SPIEGEL +++ http://www.gmx.net/derspiegel +++ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Interbase and PHP- SHOW TABLE sql command
Hello, I do not know how to get the list of tables in an Interbase databse. When I tried to use the sql command SHOW TABLE; in the php function ibase_query(); I got Dynamic SQL Error SQL error code = -104 Token unknown - line 1, Select commands work well but this not. SHOW TABLE is a regular Interbase SQL command. I've tried this command with the command line Interbase client and it works well. Does anybody know where is the problem? Thanks Ge0rge Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://mail.messenger.yahoo.co.uk -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Interbase and PHP- SHOW TABLE sql command
I haven't used Interbase but could it be show tables;. Just a thought... On Fri, 10 Oct 2003 09:34:49 +0100 (BST) George Georgeus [EMAIL PROTECTED] wrote: Hello, I do not know how to get the list of tables in an Interbase databse. When I tried to use the sql command SHOW TABLE; in the php function ibase_query(); I got Dynamic SQL Error SQL error code = -104 Token unknown - line 1, Select commands work well but this not. SHOW TABLE is a regular Interbase SQL command. I've tried this command with the command line Interbase client and it works well. Does anybody know where is the problem? Thanks Ge0rge _ ___ Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://mail.messenger.yahoo.co.uk -- 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
Re: [PHP-DB] Interbase and PHP- SHOW TABLE sql command
George Georgeus wrote: Hello, I do not know how to get the list of tables in an Interbase databse. When I tried to use the sql command SHOW TABLE; in the php function ibase_query(); I got Dynamic SQL Error SQL error code = -104 Token unknown - line 1, Select commands work well but this not. SHOW TABLE is a regular Interbase SQL command. I've tried this command with the command line Interbase client and it works well. Does anybody know where is the problem? Thanks Ge0rge SHOW TABLE and other SHOW* are not DSQL statements, they are just isql commands. You may simulate this behaviour making the following request: select RDB$RELATION_NAME from RDB$RELATIONS where RDB$FLAGS = 1 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Interbase and PHP- SHOW TABLE sql command
Thank very much for your help. :o) That's what I need. Ge0rge --- Alexey Trunyov [EMAIL PROTECTED] wrote: George Georgeus wrote: Hello, I do not know how to get the list of tables in an Interbase databse. When I tried to use the sql command SHOW TABLE; in the php function ibase_query(); I got Dynamic SQL Error SQL error code = -104 Token unknown - line 1, Select commands work well but this not. SHOW TABLE is a regular Interbase SQL command. I've tried this command with the command line Interbase client and it works well. Does anybody know where is the problem? Thanks Ge0rge SHOW TABLE and other SHOW* are not DSQL statements, they are just isql commands. You may simulate this behaviour making the following request: select RDB$RELATION_NAME from RDB$RELATIONS where RDB$FLAGS = 1 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://mail.messenger.yahoo.co.uk -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Interbase queries
Hi I am new to using PHP with Interbase. If I want to issue a query, I use: $sth = ibase_query ($dbh, $sqlstmt); I am assuming this issues the query to the database, and commits at the same time? Do I need to release anything after having done this, or does it take care of that by itself? Thanks Evan Morris [EMAIL PROTECTED] Tel: +27 11 792 2777 Fax: +27 11 792 2711 Cell: +27 82 926 3630 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] interbase/firebird - There was a time with multiple conections
Hello, I have been using php --with-interbase for some time and I enjoy using php scripts to everything so I did some small scripts to use as a datapump to the interbase. My scripts relay on the fact that I can have two simultaneos connections to the different databases in order to pump data from one to another. Since I allways update my CGI version of php e also I am using the latest stable version of firebird, I believe that something has happend that changed the behavior of my php scrips. Now, when I do the second connection, everything looks like the second one takes command over the first one. I could verify this with some changes in my script. Does anyone knows about such behavior? I may post my script if anyone is interested, but there is nothing really special about it besides two connections to the interbase. By the way, I am using persistent connections. Thank you! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Interbase and PHP locking (was: Interbase locking)
Hello everybody,
Some days ago I've posted a question about interbase locking. I've solved
the problem after searching at interbase developers network and php manuals.
Let me drop some line about my experiences...
Deadlock is when two (or more) transactions want update or delete a field
in the same table at the same time.
For cause a deadlock in Interbase do the following:
$tr_id1 = ibase_trans();
$tr_id2 = ibase_trans();
$result = ibase_query($tr_id1, UPDATE TEST SET FIELD_A=FIELD_C);
echo First result: $resultbr;
ibase_commit($tr_id1);
$result = ibase_query($tr_id2, UPDATE TEST SET FIELD_A=FIELD_C);
echo Second result: $resultbr;
If you run this you can see that the second result will be false and you'll
get
an error about interbase deadlock. Thats all right about interbase his do
its best when doing this. This error must be handled by the application.
So simple complete the code above with some check and rollback, like this:
$tr_id1 = ibase_trans();
$tr_id2 = ibase_trans();
$result = ibase_query($tr_id1, UPDATE TEST SET FIELD_A=FIELD_C);
echo First result: $resultbr;
ibase_commit($tr_id1);
$result = 0;
while (!$result) {
$result = ibase_query($tr_id2, UPDATE TEST SET FIELD_A=FIELD_C);
echo Second result: $resultbr;
if (!$result) {
ibase_rollback($tr_id2);
$tr_id2 = ibase_trans();
}
}
ibase_commit($tr_id2);
This will works nicely, and you will see that the first query will fail but
the second
query (in another one transaction!) will be correct. The complete solution
is when you
write a function for the queries to runs in a transaction and its check.
Regards,
Tibor
--
Integranet Internet Service Provider Co. - www.integranet.hu
GnuPG fingerprint: 189C B343 71A8 C25F 7456 F46F D522 C34C ED7F A574
Koleszr Tibor, Director and Senior System Engineer, Debian Developer
[EMAIL PROTECTED], [EMAIL PROTECTED], http://www.oldw.net
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Interbase locking
Hello, I've an interbase locking question. Sometime i got interbase deadlock from php scripts at updates and at inserts. I'm using simple ibase_query, and as i've read the manual of the interbase, it should handle the locking with the default transaction WAIT option. Is it enoug to using ibase_query(); or I have to use ibase_trans();? Interbase (PHP's interbase function) wont lock with a simple query? Can someone help me its getting dangerous, and I've found nothing usefull at google or at borland. Thanks Tibor -- Integranet Internet Service Provider Co. - www.integranet.hu GnuPG fingerprint: 189C B343 71A8 C25F 7456 F46F D522 C34C ED7F A574 Koleszr Tibor, Director and Senior System Engineer, Debian Developer [EMAIL PROTECTED], [EMAIL PROTECTED], http://www.oldw.net -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Interbase BLOB problem
Hi Peter, Thanks for this. I have been waiting for the PHP Manuals to include documentation on the interbase BLOB functions. I need to find a real connection and download it grin Actually my problem was that I have 2 machines - Windows (development and testing) and Linux (Server). The site was initially made in an all Linux environment. Now I am maintaining and expanding on my Windows box. The problem was with the fopen(file r) which on Windows needs to be fopen(file, rb) for binary files. It is all working now. Thanks again to all. David Russell IT Support Manager Barloworld Optimus (Pty) Ltd Tel: +2711 444-7250 Fax: +2711 444-7256 e-mail: [EMAIL PROTECTED] web: www.BarloworldOptimus.com -Original Message- From: Peter Beckman [mailto:beckman;purplecow.com] Sent: 29 October 2002 05:47 PM To: David Russell Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Interbase BLOB problem Your SQL query doesn't need that semicolon at the end of the query -- lose it. I never used ibase, so here's what I found from the PHP Manual page for ibase_query: Using BLOB Insert BLOB: /* create blob */ $blob_id = ibase_blob_create(); /* fill blob */ ibase_blob_add($blob_id, $var_datablob); /* close new blob */ $blob_id_str = ibase_blob_close($blob_id); /* insert into table */ ibase_query(INSERT INTO BLOB_TABLE (ID, BLOB) VALUES (1, ?),$blob_id_str); Open BLOB: /* query */ $set = ibase_query(SELECT BLOB FROM BLOB_TABLE WHERE ID = 1); /* fetche a row */ $row = ibase_fetch_object($set); /* open BLOB for read */ $blob_id = ibase_blob_open($row-BLOB); /* get BLOB data */ $stringBLOB = ibase_blob_get($blob_id); /* print BLOB */ echo $stringBLOB; /* close new blob */ ibase_blob_close($blob_id); /* free result */ ibase_free_result($set); Peter On Tue, 29 Oct 2002, David Russell wrote: Hi all, I have a file I need to insert into a blob in a interbase table. Code as follows: $filehandle = fopen($file, r); $blob_id = ibase_blob_import($filehandle); $qry = INSERT INTO BPFATTACHMENTS ; $qry = $qry . (BPFATTACHMENTNO, BPF, ATTACHMENTTYPE, FILENAME, FILESIZE, ATTACHMENT); $qry = $qry . VALUES; $qry = $qry . ($bpfAttNo, $BPFNo, $AttachmentType, '$file_name', $file_size, ?);; $res = ibase_query($qry, $blob_id); I have a ibase_pconnect prior to this. The problem is that is only adds a tiny part of the file (ie 5k of the 200k file) What should I be looking for? Thanks David Russell IT Support Manager Barloworld Optimus (Pty) Ltd Tel: +2711 444-7250 Fax: +2711 444-7256 e-mail: [EMAIL PROTECTED] web: www.BarloworldOptimus.com --- Peter BeckmanSystems Engineer, Fairfax Cable Access Corporation [EMAIL PROTECTED] http://www.purplecow.com/ --- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php smime.p7s Description: application/pkcs7-signature
[PHP-DB] Interbase BLOB problem
Hi all, I have a file I need to insert into a blob in a interbase table. Code as follows: $filehandle = fopen($file, r); $blob_id = ibase_blob_import($filehandle); $qry = INSERT INTO BPFATTACHMENTS ; $qry = $qry . (BPFATTACHMENTNO, BPF, ATTACHMENTTYPE, FILENAME, FILESIZE, ATTACHMENT); $qry = $qry . VALUES; $qry = $qry . ($bpfAttNo, $BPFNo, $AttachmentType, '$file_name', $file_size, ?);; $res = ibase_query($qry, $blob_id); I have a ibase_pconnect prior to this. The problem is that is only adds a tiny part of the file (ie 5k of the 200k file) What should I be looking for? Thanks David Russell IT Support Manager Barloworld Optimus (Pty) Ltd Tel: +2711 444-7250 Fax: +2711 444-7256 e-mail: [EMAIL PROTECTED] web: www.BarloworldOptimus.com smime.p7s Description: application/pkcs7-signature
Re: [PHP-DB] Interbase BLOB problem
Your SQL query doesn't need that semicolon at the end of the query -- lose it. I never used ibase, so here's what I found from the PHP Manual page for ibase_query: Using BLOB Insert BLOB: /* create blob */ $blob_id = ibase_blob_create(); /* fill blob */ ibase_blob_add($blob_id, $var_datablob); /* close new blob */ $blob_id_str = ibase_blob_close($blob_id); /* insert into table */ ibase_query(INSERT INTO BLOB_TABLE (ID, BLOB) VALUES (1, ?),$blob_id_str); Open BLOB: /* query */ $set = ibase_query(SELECT BLOB FROM BLOB_TABLE WHERE ID = 1); /* fetche a row */ $row = ibase_fetch_object($set); /* open BLOB for read */ $blob_id = ibase_blob_open($row-BLOB); /* get BLOB data */ $stringBLOB = ibase_blob_get($blob_id); /* print BLOB */ echo $stringBLOB; /* close new blob */ ibase_blob_close($blob_id); /* free result */ ibase_free_result($set); Peter On Tue, 29 Oct 2002, David Russell wrote: Hi all, I have a file I need to insert into a blob in a interbase table. Code as follows: $filehandle = fopen($file, r); $blob_id = ibase_blob_import($filehandle); $qry = INSERT INTO BPFATTACHMENTS ; $qry = $qry . (BPFATTACHMENTNO, BPF, ATTACHMENTTYPE, FILENAME, FILESIZE, ATTACHMENT); $qry = $qry . VALUES; $qry = $qry . ($bpfAttNo, $BPFNo, $AttachmentType, '$file_name', $file_size, ?);; $res = ibase_query($qry, $blob_id); I have a ibase_pconnect prior to this. The problem is that is only adds a tiny part of the file (ie 5k of the 200k file) What should I be looking for? Thanks David Russell IT Support Manager Barloworld Optimus (Pty) Ltd Tel: +2711 444-7250 Fax: +2711 444-7256 e-mail: [EMAIL PROTECTED] web: www.BarloworldOptimus.com --- Peter BeckmanSystems Engineer, Fairfax Cable Access Corporation [EMAIL PROTECTED] http://www.purplecow.com/ --- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Interbase transaction question
On Friday 24 August 2001 16:55, Balak, Frank wrote:
yves,
Start the transaction with ibase_trans() before you call
ibase_execute.
As to how is it possible, I don't really know for sure. I would
presume it has to do with how Interbase handles transactions.
Frank
Frank,
thank you, I've tried it, and even found something similar in the
phpbuilder.com mailing list archives, but it sill doesn't work
This is my new code:
$dbh = connectdb();
$sth = ibase_prepare('INSERT INTO LOG
(DATETIME,REMOTE_ADDR,HTTP_HOST,REQUEST_URI,HTTP_REFERER,HTTP_USER_AGENT)
VALUES (?,?,?,?,?,?)');
$trans=ibase_trans();
ibase_execute($sth,
$now,
substr(get_var('REMOTE_ADDR','nbsp;'),0,24),
substr(get_var('HTTP_HOST','nbsp;'),0,24),
substr(get_var('REQUEST_URI','nbsp;'),0,99),
substr(get_var('HTTP_REFERER','nbsp;'),0,99),
substr(get_var('HTTP_USER_AGENT','nbsp;'),0,99));
ibase_commit($trans);
ibase_close($dbh);
The code I found on phpbuilder.com said the following:
$trans = ibase_trans();
ibase_query ($c, $sql);
ibase_commit( $trans);
heck, what do I do wrong?
--
Franklin J. Balak Jr.
Quality Assurance Data Analyst
Brown Printing Company
Waseca Division
Waseca, MN. 56093
Voice: 507-835-0253
Fax: 507-835-0293
--
-Original Message-
From: Yves Glodt [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 23, 2001 14:11
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Another Interbase question
Look at this:
?php
include('include.php');
$dbh = connectdb();
$sth = ibase_prepare('INSERT INTO LOG
(DATETIME,REMOTE_ADDR,HTTP_HOST,QUERY_STRING,HTTP_USER_AGENT,REQUEST_
URI,HTT P_REFERER)
VALUES (?,?,?,?,?,?,?)');
ibase_execute($sth,
$now,
$HTTP_SERVER_VARS['REMOTE_ADDR'],
$HTTP_SERVER_VARS['HTTP_HOST'],
$HTTP_SERVER_VARS['QUERY_STRING'],
$HTTP_SERVER_VARS['HTTP_USER_AGENT'],
$HTTP_SERVER_VARS['REQUEST_URI'],
$HTTP_SERVER_VARS['HTTP_REFERER']);
ibase_commit();
ibase_close($dbh);
?
when it gets called, and I do a select in isql, I do not see any of
the records. Only after doing a manual commit in isql, I can see
the new data.
How is that possible?
yves
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Interbase : Double SELECT
With Interbase functions I have to make 2 select. SELECT count(*).. to count valid record and SELECT * .. to extract the records There is a simple solutions to have unique Select ? I use Pgsql too but here I Have the pg_numrows variable. Someone sau to me: just make the SELECT * .. to extract the records and then get the rownumber by $number_of_rows=count($selected_array); Yes, BUT I use get_object ! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Interbase blob question
Hi, is there a way to treat the output of ibase_blob_echo? I want to do some str_replace with its content before displaying it. thank you, yves -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] interbase or postgres
just want to here comments from you guys. i will be doing a shopping cart and i'm still looking for the best database which i could use aside from Oracle.i'm still thingking which is better. interbase or postgres?
[PHP-DB] Interbase lob field on the web
Hi i have a problem printing a lob field containing an image. The database i use is Interbase 6.0 I have a blob/lob field with a gif image inside an i like to print this image on the web. Can you help me? Bye Alessandro
[PHP-DB] Interbase double select
With Interbase functions I have to make 2 select. SELECT count(*).. to count valid record and SELECT * .. to extract the records There is a simple solutions to have unique Select ? I use Pgsql too but here I Have the pg_numrows variable. Someone sau to me: just make the SELECT * .. to extract the records and then get the rownumber by $number_of_rows=count($selected_array); Yes, BUT I use get_object ! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Interbase Blob
This is my page to extract image (from blob) in a interbase table. I call it with :echo src=\blob2img.php?id_product=.$id_product.\ ; ?php //BLOB2JPG $conn = ibase_connect($host,$user,$pass,$charset,$buffers,$dialect,$rules) $set = ibase_query(SELECT IMAGE from products where (id_product = $id_product)); $row = ibase_fetch_row($set); ibase_blob_echo($row[0]); header(Content-type: image/jpeg); ibase_close($conn); ? My problem is that the images are too slow. Solutions ? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] InterBase - selecting from a non existing id value?
Hello, is it possible with InterBase to fire a select statement against an empty table witout getting in trouble. if the table X looks like this: id - integer dummy - varchar and if I do now a select like select * from x where id='$id'; I will get the error Warning: InterBase: conversion error from string I have heard that other RDBMs don't run into trouble if you do this? What could I do? Remember $id is an empty value! thx Henning -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Odp: [PHP-DB] InterBase
Od: "Sergey Larionov" [EMAIL PROTECTED] Temat: [PHP-DB] InterBase "Warning: InterBase: arithmetic exception, numeric overflow, or string truncation Cannot transliterate character between character sets in /home/larionov/public_html/base.php on line 6" How I can turn off tranliteration? You cann't just "turn it off" - this message means that client charset is different than db charset. If you have database created with default character set, say, WIN1252, you will get this message when you try to retrieve row using, say, WIN1250 and the row contains characters from outside of WIN1250 character set. This also happens when you do not specify character set when creating columns in tables then connect specifying character set - all characters above #127 will be trated as illegal and raise this error. That's why the best approach is to specify default character set when creating database - all character and text blob columns will use this character set and no special processing will be nacessary during connecting, just set the appropriate lc_ctype variable in database parameter buffer (i.e. in ibase_connect parameters). Cheers Jarek Zgoda -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] InterBase
Warning: InterBase: arithmetic exception, numeric overflow, or string truncation Cannot transliterate character between character sets in /home/larionov/public_html/base.php on line 6 How I can turn off tranliteration? ···· Sergey Larionov-[EMAIL PROTECTED], http://larionov.akl.ru -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] INTERBASE PHP
With Interbase functions I have to make 2 select. SELECT count(*).. to count valid record and SELECT * .. to extract the records There is a simple solutions to have unique Select ? I use Pgsql too but here I Have the pg_numrows variable. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Interbase BLOB
This is my page to extract image (as blob) in a interbase table. I call it with :echo src=\blob2img.php?id_product=.$id_product.\ ; but i don't see the image ?php //BLOB2JPG // in = id_product $host = 10.10.0.200:/home/interbase/WEB02/WEBG02; $user = TEST_USER; $pass = PassUser; $charset=; $buffers=10; $dialect=3; $rules = CLIENT; $conn = ibase_connect($host,$user,$pass,$charset,$buffers,$dialect,$rules) $set = ibase_query(SELECT IMAGE from products where (id_product = $id_product)); $row = ibase_fetch_row($set); ibase_blob_echo($row[0]); header(Content-type: image/jpeg); ibase_close($conn); ? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Odp: [PHP-DB] Interbase/PHP/Apache implimentation
Od: "Jordan" [EMAIL PROTECTED] Temat: [PHP-DB] Interbase/PHP/Apache implimentation So my question is this: Can DBMS support be enabled using the extension=php_interbase.dll directive in the php.ini file (as opposed to MySQL, where support is built in) ONLY while in CGI mode? Will the distribution version of php4apache.dll not look at the php.ini file, to enable Interbase support? If that is the case, is there anywhere one might find a version of the php4apache.dll file which enables Interbase support? I will use CGI if I must, but my preference is to use the Apache Module I have 2 installations: on NT4 at work and W98 at home, both working as a module. Except of OS the configuration is same: Apache 1.3.19, PHP 4.0.5, Borland's IB 6.0.1. If you are interested, i can send you my php.ini files privately, although this one from my work in tuesday. Cheers Jarek Zgoda -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Interbase: how can I insert null values with placeholders?
So I guess I'm saying that in the code if you change the $asinteger assignment to: $asinteger = NULL; /* notice the quotes */ it may work. This would make the $asinteger PHP variable a string, but since the SQL would either like to have a numeric value there or the keyword NULL, that is probably what you want. It doesn't work. I think that I need to modify interbase.c in php source code. See Jeremy Bettis's code below! Thanx for your answer, Marton -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Interbase Problem
What OS is running in the InterBase machine? Are you running IB Classic or SuperServer? I haven't seen this error but have read about it a few times, in those cases the machine was running Windows NT and IB SS. -Jorge Niel Zeeman [EMAIL PROTECTED] escribió en el mensaje 9h76jh$ik6$[EMAIL PROTECTED]">news:9h76jh$ik6$[EMAIL PROTECTED]... Now the site will be running fine and then something will just trigger the ibase server and it will push it into a flatline for anything between 1 to 10 minutes. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Interbase Problem
Hi We are running Firebird 0.94 SS on RedHat 7.1 Compaq Server Hope this rings a bell?? Niel Jorge Alvarez [EMAIL PROTECTED] wrote in message 9h90ja$1a8$[EMAIL PROTECTED]">news:9h90ja$1a8$[EMAIL PROTECTED]... What OS is running in the InterBase machine? Are you running IB Classic or SuperServer? I haven't seen this error but have read about it a few times, in those cases the machine was running Windows NT and IB SS. -Jorge Niel Zeeman [EMAIL PROTECTED] escribió en el mensaje 9h76jh$ik6$[EMAIL PROTECTED]">news:9h76jh$ik6$[EMAIL PROTECTED]... Now the site will be running fine and then something will just trigger the ibase server and it will push it into a flatline for anything between 1 to 10 minutes. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Interbase blob
I have many problem to view image stored like blob in interbase6. Is impossible. I Use ibase_blob_echo(). my php is 4.0.5
[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;
end declare section;
declare CursorV1 cursor for insert blob v1 into test;
open CursorV1 into :document;
sprintf(BlobV1Buffer, 'First blob tekst');
BlobV1Len = strlen(BlobV1Buffer);
insert cursor CursorV1 values (:BlobV1Buffer:BlobV1Len);
close CursorV1;
insert into test (state,v1) values ('CA',:document);
an error message pops up:
error:
Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 0
begin
Statement: begin declare section
How do I solve this problem?
Thanks.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
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 statement, you cann't use it in ISQL! For detailed description of IB BLOB hadling in PHP go to www.open-database.de Cheers Jarek Zgoda -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] interbase (?) field contents does not show
Meir, Thanks for the response. I believe I tried it with caps but did not get any message. Anyway, I tried it again, and it's now working. Why does $row-LASTNAME give me a result on an ibase_fetch_object() and not on ibase_fetch_row()? Thanks, George -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] interbase (?) field contents does not show
Beacuse u are using an object structure, Check OOP in PHP, the pointer $variable-name is for objects that why its used in the fetch object and not fetch row fetch row would be $rs[rowname] or $rs[0]. Check the documentation for more detailed info -Original Message- From: GMansky [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 03, 2001 10:40 AM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] interbase (?) field contents does not show Meir, Thanks for the response. I believe I tried it with caps but did not get any message. Anyway, I tried it again, and it's now working. Why does $row-LASTNAME give me a result on an ibase_fetch_object() and not on ibase_fetch_row()? Thanks, George -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] interbase (?) field contents does not show
I followed the documentation on interbase. I have the following code:
?php
$rowcount = 0;$dbh = ibase_connect ($host, $username, $password);
$stmt = 'SELECT * FROM contact';
$sth = ibase_query ($dbh, $stmt);
while ($row = ibase_fetch_object ($sth)) {
print $row-lastname . \n;$rowcount = $rowcount+1;
}
echo $rowcount;ibase_close ($dbh);
?
$rowcount gave me the correct number of rows but referenceto any field name
does not show anything. I tried uppercaseand it still does not show
anything. Anything that I am missing?
Thanks in advance,
George
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] interbase (?) field contents does not show
On Sunday 29 April 2001 19:00, GMansky wrote:
I followed the documentation on interbase. I have the following code:
?php
$rowcount = 0;$dbh = ibase_connect ($host, $username, $password);
$stmt = 'SELECT * FROM contact';
$sth = ibase_query ($dbh, $stmt);
while ($row = ibase_fetch_object ($sth)) {
print $row-lastname . \n;$rowcount = $rowcount+1;
}
echo $rowcount;ibase_close ($dbh);
?
$rowcount gave me the correct number of rows but referenceto any field name
does not show anything. I tried uppercaseand it still does not show
anything. Anything that I am missing?
Thanks in advance,
George
Hi George
Try using uppercase, ibase_fetch_object will return fields as uppercase.
So:
print $row-LASTNAME;
You can see this info in the user contributed notes in the on line manual.
goto:
http://www.php.net/manual/en/function.ibase-fetch-object.php
--
Meir Kriheli
There's someone in my head, but it's not me - Pink Floyd
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] interbase
Hi, I tried to connect to remote Interbase server. There is a result below: Warning: InterBase: Unable to complete network request to host "192.168.1.10". Failed to locate host machine. Undefined service gds_db/tcp. in ... File services on remote Interbase server contains: gds_db3050/tcp Could you help me to resolve this problem? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] interbase
Can you get to the Database / Interbase server using an interbase client, like Ibconsole? man [EMAIL PROTECTED] schrieb in im Newsbeitrag: [EMAIL PROTECTED] Hi, I tried to connect to remote Interbase server. There is a result below: Warning: InterBase: Unable to complete network request to host 192.168.1.10. Failed to locate host machine. Undefined service gds_db/tcp. in ... File services on remote Interbase server contains: gds_db3050/tcp Could you help me to resolve this problem? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Odp: [PHP-DB] ? interbase ?
Od: "Bart A. Verbeek" [EMAIL PROTECTED] Temat: [PHP-DB] ? interbase ? 1. Can interbase be installed and run on every Unix-type (BSD)? I've taken a look on the borland site but they only speak of Linux and windows. Official Borland builds run only on Win32 and Linux. There are several other platforms supported by Firebird Project (firebird.sourceforge.net). 3. Is it possible to run MySQL and Interbase on the same server? Yes, they use different ports (MySQL 3360, IB 3050). 5. Does PHP have the same capabilities for Interbase as for MySQL? Bit less, but Interbase has bit more capabilities than MySQL. 6. How difficult is it to install a binary (not found on Borland site) or to compile it from source for a BSD-server? You can find binaries at firebird.sourceforge.net and www.ibphoenix.com. 9. Why would anyone choose Interbase when they can use MySQL on the same server? IB is best used when you don't want separate data accessible from www and your corporate data or your site data will be often updated concurrently by many users. Cheers Jarek Zgoda -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] ? interbase ?
Hello, I'm internet-databasing for over a year now and only used MySQL up untill now. Last week I spoke with a guy that was interested in running Interbase on a Unix-webserver, so I've got a couple of questions... 1. Can interbase be installed and run on every Unix-type (BSD)? I've taken a look on the borland site but they only speak of Linux and windows. 2. How stable is it comparing to MySQL when running on Unix (bsd)? 3. Is it possible to run MySQL and Interbase on the same server? 4. What are the differences between Interbase and MySQL? 5. Does PHP have the same capabilities for Interbase as for MySQL? 6. How difficult is it to install a binary (not found on Borland site) or to compile it from source for a BSD-server? 7. What's the difference between managing Interbase and managing MySQL on a Internetserver? 8. Does anyone know hostingproviders that support Interbase? 9. Why would anyone choose Interbase when they can use MySQL on the same server? I hope anyone can help me! Thanks in advance... Regards, Bart Verbeek -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Interbase 6.01 (dialect 3), PHP4 and DATE
How can I manage DATE fieldtype in PHP4 with Interbase?
The problem is that i manage DATEs in format DDMM (spain) but Interbase
manage it in MMDD format; so queries expected data in that format while
i need it in other format.
%
if(isset($action))
{
ibase_timefmt("%d/%m/%Y",IBASE_DATE);
$ibh=ibase_pconnect("localhost:/usr/interbase/databases/dbsite.gdb","SYSDBA"
,"masterkey");
if($action=="edit" isset($CONTEXT) isset($DATE))
{
$sth=ibase_query($ibh,"SELECT newstext FROM news WHERE
context='$CONTEXT' AND newsdate='$DATE';");
if(($row=ibase_fetch_row($sth)))
{
}
}
}
%
Would you send me examples (small smart) of that?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Interbase/Apache/Linux
I have Interbase working on my client's WIN 2K platform with IIS as well as on mine; however, I do not have any experience with Linux/Apache (other than Apache running in DOS on my notebook for "on-the-road" programming). The client would now like to move over to a more stable environment: Linux!! Is there a version of PHP that has Interbase integrated with Apache for Linux? Or do I or my client have to "roll our own"? Many thanks.. Todd -- Todd Cary Ariste Software [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Interbase: ibase_pconnect() problem
Hi ! I have following problem when connecting to Interbase: When trying to establish a persistent connection using 'ibase_pconnect()', a new connection is created each time. The database connection remains open, but it will not be re-used later. So I have loads of database connections and a huge performance problem. My environment: - WinNT 4.0 SP5 - Apache 1.3.19 - PHP/4.0.4pl1 ( loaded as module ) - Interbase 6.0 Does anybody know some help ? Thank you very much. Wolfgang. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Interbase
On Thursday 08 March 2001 23:05, you wrote:
I am trying to connect to local Interbase server, folowing exactly PHP
online documentation. But I always get a warning:
"InterBase: unavailable database in d:\program files\apache
group\apache\htdocs\\tabulka.php on line 22"
my script is:
$db=ibase_connect('D:\Program
Files\Borland\Interbase\Examples\Databse\employee.gdb', $username,
$password);
and I am using Apache under Windows NT 4.
Does anybody see a mistake? Thank you for your help
Martin
You've misspelled your db path, you've wrote ...\Examples\Databse
instead of ...\Examples\Database
BTW, the coreect connection string for interbase (using tcp/ip) is
hostname:path\to\your\db\including\filename
HTH
--
Meir Kriheli
There's someone in my head, but it's not me - Pink Floyd
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Interbase
I am trying to connect to local Interbase server, folowing exactly PHP
online documentation. But I always get a warning:
"InterBase: unavailable database in d:\program files\apache
group\apache\htdocs\\tabulka.php on line 22"
my script is:
$db=ibase_connect('D:\Program
Files\Borland\Interbase\Examples\Databse\employee.gdb', $username,
$password);
and I am using Apache under Windows NT 4.
Does anybody see a mistake? Thank you for your help
Martin
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Interbase + PHP Error
I am getting this error, but I don't know what the reason is for this
error. can somebody help me out?
Warning: InterBase: Unable to complete network request to host
"localhost". Failed to establish a connection. Connection refused in
/home/httpd/html/test/php-test/ibconnect.php on line 12
Can't connect to CV.gdb with SYSDBA user.
Ibconnect.php look likes this:
html
head
titleInterBase ISQL/title
/head
?
$ibdir="/home/http/html/test/php-test/";
?
BODY bgcolor="#ff" text="black"font
face="arial,verdana,helvetica" size=3
bInterBase Connect/b/font
p
?
$ibfullname="localhost:" . $ibdir . $ibname;
$conn=ibase_connect($ibfullname,$login,$password);
if (!$conn) {
echo "Can't connect to $ibname with $login user.";
} else {
echo "$ibname connected by $login user.";
ibase_close($conn);
}
?
FORM ACTION="ibquery.php" METHOD="POST"
table border=0 cellpadding=15 cellspacing=0 bgcolor="#6699cc"
tr
tdfont face='arial, helvetica' size=2Enter your
query:/fontbr
TEXTAREA NAME="query" ROWS="8" COLS="50"/textarea/td
/trtr
td
INPUT TYPE=submit VALUE="Send" INPUT VALUE="Clear" TYPE=reset
INPUT TYPE='HIDDEN' NAME='login'? echo "VALUE='$login'"; ?
INPUT TYPE='HIDDEN' NAME='password' ? echo "VALUE='$password'";
?
INPUT TYPE='HIDDEN' NAME='ibname' ? echo "VALUE='$ibname'";
?
/td
/tr
/table
/form
/body
/html
Thnx for the help.
Wicky
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Interbase + PHP Error
On Thursday 01 March 2001 16:19, W. Yuen wrote:
Hi Wicky
To start with, never store the database file under your http document root,
it is a big security risk.
Can you connect to the databse with isql, using the same connection string ?
If so, examine the log file to see what's going on (interbase.log in
interbase's installation directory).
If you're using the superserver version you shuold add localhost to
/etc/hosts.equiv.
p.s
$ibname in your script seems to be CV.gdb (it's not set in the script
you've posted). if the file is name cv.gdb it will not work.
HTH
--
Meir Kriheli
There's someone in my head, but it's not me - Pink Floyd
I am getting this error, but I don't know what the reason is for this
error. can somebody help me out?
Warning: InterBase: Unable to complete network request to host
"localhost". Failed to establish a connection. Connection refused in
/home/httpd/html/test/php-test/ibconnect.php on line 12
Can't connect to CV.gdb with SYSDBA user.
Ibconnect.php look likes this:
html
head
titleInterBase ISQL/title
/head
?
$ibdir="/home/http/html/test/php-test/";
?
BODY bgcolor="#ff" text="black"font
face="arial,verdana,helvetica" size=3
bInterBase Connect/b/font
p
?
$ibfullname="localhost:" . $ibdir . $ibname;
$conn=ibase_connect($ibfullname,$login,$password);
if (!$conn) {
echo "Can't connect to $ibname with $login user.";
} else {
echo "$ibname connected by $login user.";
ibase_close($conn);
}
?
FORM ACTION="ibquery.php" METHOD="POST"
table border=0 cellpadding=15 cellspacing=0 bgcolor="#6699cc"
tr
tdfont face='arial, helvetica' size=2Enter your
query:/fontbr
TEXTAREA NAME="query" ROWS="8" COLS="50"/textarea/td
/trtr
td
INPUT TYPE=submit VALUE="Send" INPUT VALUE="Clear" TYPE=reset
INPUT TYPE='HIDDEN' NAME='login'? echo "VALUE='$login'"; ?
INPUT TYPE='HIDDEN' NAME='password' ? echo "VALUE='$password'";
?
INPUT TYPE='HIDDEN' NAME='ibname' ? echo "VALUE='$ibname'";
?
/td
/tr
/table
/form
/body
/html
Thnx for the help.
Wicky
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Interbase + PHP
On Monday 26 February 2001 04:08, Duky wrote: I am using a Unix/Linux server. How can I recompile my php to use interbase?? Where can I find that, to recompile? what do I need to recompile and what do I have to include into that file? I am new to this. so if somebody can help me out.. really thanks. Duky If you're on linux you should configure php with --with-interbase=/path/to/your/interbase/install.dir and then compile it. -- Meir Kriheli There's someone in my head, but it's not me - Pink Floyd -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Interbase + PHP
my own OS is win98. Duky wrote: I am using a Unix/Linux server. How can I recompile my php to use interbase?? Where can I find that, to recompile? what do I need to recompile and what do I have to include into that file? I am new to this. so if somebody can help me out.. really thanks. Duky -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Interbase and php
Hi, I use Interbase 6.01 in a Linux system and i want use php for my server side language for accessing the Interbase database. When i start to use php for accessing database i seen that i can't move my row pointer (cursor) into a quey after i use ibase_query() function. Only traverse one row at a time. I can't repositioning to the first row, for example. How i can point to the first row of a query in php with Interbase without requery the data ? Thank. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Interbase help
Hello! I have just installed the Interbase 6.01 on a debian server. I compiled he php with: "/configure --with-mysql=/usr/local/mysql --with-apache=../apache_1.3.14 --enable-track -vars --with-interbase=/opt/interbase" but I get this error message: "Fatal error: Call to undefined function: ibase_connect() in ..." Can anyone help me to make the interbase functions work? Mage -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Interbase and PHP support.
On Thu, 5 Oct 2000, Johan Hanson wrote: On Wed, 04 Oct 2000, Giovanni Tummarello wrote: Hello all, i am about to start a large project that has some heavy requirements and are evaluating the use of Interbase. The BLOB functionality in the PHP interface is unstable. The process running the blob function crashes when trying to insert a blob ID into a table. That is a pretty large flakiness. There was one quite critical bug related to this that I fixed on July 9th and it appeared in 4.0.2. If you are using that version, please file a bug report with an example. BLOB functionality in this module isn't well tested, and without some help/testing from users, could remain flaky forever. -- Jouni Ahto -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Interbase and PHP support.
On Thu, 5 Oct 2000, Johan Hanson wrote: On Wed, 04 Oct 2000, Giovanni Tummarello wrote: Hello all, i am about to start a large project that has some heavy requirements and are evaluating the use of Interbase. The BLOB functionality in the PHP interface is unstable. The process running the blob function crashes when trying to insert a blob ID into a table. That is a pretty large flakiness. There was one quite critical bug related to this that I fixed on July 9th and it appeared in 4.0.2. If you are using that version, please file a bug report with an example. BLOB functionality in this module isn't well tested, and without some help/testing from users, could remain flaky forever. -- Jouni Ahto -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Odp: [PHP-DB] Interbase and PHP support.
Od: "Mike" [EMAIL PROTECTED] Temat: Re: [PHP-DB] Interbase and PHP support. The BLOB functionality in the PHP interface is unstable. The process running the blob function crashes when trying to insert a blob ID into a table. That is a pretty large flakiness. There was one quite critical bug related to this that I fixed on July 9th and it appeared in 4.0.2. If you are using that version, please file a bug report with an example. BLOB functionality in this module isn't well tested, and without some help/testing from users, could remain flaky forever. I think that it has been finally adressed in 4.04 with php_ibase.dll version 1.48 - i had similar problems. Cheers Jarek Zgoda -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
