[PHP-DB] INTERBASE & PHP

2001-07-23 Thread Enrico Comini

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]




Odp: [PHP-DB] Interbase/PHP/Apache implimentation

2001-07-13 Thread Jarek Zgoda

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]




[PHP-DB] Interbase/PHP/Apache implimentation

2001-07-13 Thread Jordan

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
module - using only the CGI interface.

So, if I understand things, my problem has been that I've been attempting to get 
Interbase support
from the PHP module for Apache, which won't work for one reason or another.
If true, this comes as great relief, because I was beating my head against the wall 
trying to figure
out where my php.ini file was misconfigured

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

Thanks in advance,

--Jordan


-- 
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

2001-03-01 Thread Meir kriheli

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:
>
>  
>   
>   InterBase ISQL
>   
>  $ibdir="/home/http/html/test/php-test/";
>   ?>
>face="arial,verdana,helvetica" size=3>
>   InterBase Connect
>   
>  $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);
>   }
>   ?>
>
>   
>   
>   
>   Enter your
> query:
>   
>   
>   
>
>   "; ?>
>
>   ";
> ?> >
>   ";
> ?> >
>   
>   
>   
>   
>   
>   
>
>
> 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]




[PHP-DB] Interbase + PHP Error

2001-03-01 Thread W. Yuen

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:

 
  
  InterBase ISQL
  
  
  
  InterBase Connect
  
  

  
  
  
  Enter your
query:
  
  
  
   
  "; ?>
>
  ";
?> >
  ";
?> >
  
  
  
  
  
  


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

2001-02-26 Thread Meir kriheli

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

2001-02-25 Thread Duky

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 + PHP

2001-02-25 Thread Duky

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]