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 wi
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:
ry 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)
>
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 Mail
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 funct
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 n
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
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
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?
Than
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 o
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 sa
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_que
ld 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] In
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);
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, ATT
This is a forwarded message
From: -=MikeP=- <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Date: Wednesday, December 19, 2001, 12:46:47 AM
Subject:
===8<==Original message text===
Hello all,
Can anybody help me...
I need to manage InterBase 5.6 using PHP... I'm a newcomer a
Hello :c)
I cant make this work together...
I have set up php (it works)
I have set up ib (it works)
but when i try to query ib using php i get :
Fatal error: Call to undefined function: ibase_connect() in
c:\inetpub\wwwroot\ib.php on line 10
I have set my extension_dir to (where the dll resid
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,
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 con
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 extrac
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?
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
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: conv
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."\" ";
My problem is that the images are too slow.
Solutions ?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
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 extrac
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 o
"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.
Greetings.
I have a data-entry web application that runs on:
PHP 4.0.5
Interbase 6.01 (open source)
Apache 1.3.19
Windows NT Server
The users report an unreproducible problem:
1. A record is entered.
2. Some time later (hours, days, weeks), user wished to update record.
Yet, record does no
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/)
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 Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:
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
Okay...
...I have been trying (and failing) to get Interbase to work with PHP, served up by
Apache on a
Win2K machine. Through a lot of headache and the process of elimination, I have
succeeded in
getting an SQL response from PHP, after eliminating any instructions for Apache to
load the PHP
m
>
> 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 NUL
Hi KM--
The general format for the INSERT goes something like this:
INSERT INTO anytable (columnname) VALUES (NULL);
You technically do not need the newlines ("\n") in your $stmt.
So I guess I'm saying that in the code if you change the $asinteger
assignment to:
$asinteger = "NULL"; /* notice
Hi!
I like to insert null values with placeholders in ibase_query. But it
doesn't work.
$stmt = "insert into category_prop \n".
"(id, category_id, category_prop_type_id, asinteger, asfloat,
ascurrency, asstring) \n".
"values (gen_id(gen_category_prop_id,1),1097,109,?,?,?,?)";
$asinteger
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 o
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 P
Hi there
I have a problem in that we run a production interbase server that I access
making use of PHP4.0.4pl1
and apache 1.3.19.
The interbase server is a separate machine to the webserver.
Now the site will be running fine and then something will just trigger the
ibase server and it will push
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
Somebody please tell me why the first statement works and the second doesn't.
1.
...
$dbh=ibase_connect("host","$user","$pass") or die("Connection Error");
$q="SELECT * FROM mytable";
$result=ibase_query($q) or die("SELECT Error");
...
2.
...
$dbh=ibase_connect("host","$user","$pass") or die(
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;
>
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;
Hi,
Let me help with this problem, please.
Have anyone any idea why the first statement works and the second not ?
1.
$dbh=ibase_connect($host, $user, $pass) or die("Connection error");
$result=ibase_query("select * from tablename");
...
ibase_close();
2.
$dbh=ibase_connect($host, $user, $p
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
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:/
On Sunday 29 April 2001 19:00, GMansky wrote:
> I followed the documentation on interbase. I have the following code:
>
> $rowcount = 0;$dbh = ibase_connect ($host, $username, $password);
> $stmt = 'SELECT * FROM contact';
> $sth = ibase_query ($dbh, $stmt);
> while ($row = i
I followed the documentation on interbase. I have the following code:
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
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 req
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/t
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 o
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
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))
{
it up and running for you.
HTH,
Cal
http://www.calevans.com
-Original Message-
From: Todd Cary [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 23, 2001 8:16 AM
To: [EMAIL PROTECTED]
Cc: Carlos Rosales
Subject: [PHP-DB] Interbase/Apache/Linux
I have Interbase working on my client's WIN 2
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!
Hi !
I solved this problem. The list, where persistent database
connections are cached, is thread local. Since the Win32 release of
Apache is muli-threading with a default parameter of 50 active threads
and the incoming requests are dispatched to the threads in alternating
order, it takes 50 requ
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
Hi there,
I would like to know if it is possible do develop a Interbase-driven web
site with PHP under Windows 98.
If it's possible, which web server do you recommend?
Any guidelines or on-line docs I should read?
Many thanks in advance,
Jorge Alvarez
--
PHP Database Mailing List (http://w
hey all..
I really don't get why I am getting this error.. Can somebody help me
out? what does a parse error mean?
Error:
Parse error: parse error in /home/httpd/html/test/php-test/CVzenden.php
on line 35
CVzenden.php:
$conn=ibase_connect("localhost:/home/httpd/html/test/php-test/CV.gdb",
"SY
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:
>
And which database will I open, using this? First prameter in ibase_connect
should be database file name, I think.
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 adminis
if you are running a local webserver, why not just use
$db=ibase_connect('localhost' , user, pass); ?
Chad
-Original Message-
From: Martin Meca [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 08, 2001 3:06 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Interbase
I am trying to
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\
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 (inte
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
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.. real
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.
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:
Can somebody help me out? I have some problems with connecting my gdb
file with PHP. it is giving me this error:
Fatal error: Call to undefined function: () in
/home/sites/site156/web/columbus/ibconnect.php on line 9
What can I do now?
Thnx,
Duky
--
PHP Database Mailing List (http://www.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
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:
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 p
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 pr
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 pr
73 matches
Mail list logo