RE: [PHP-DB] sybase with php4.1 and apache 13.20 problem

2002-01-08 Thread Richard Hillström (GIS)

So if I understand you correct you can call Sybase from php on commandline but not via 
apache?
You should compile --with-sybase-ct but that is probably not causing your problem.

Sounds strange, never had that problem, if it worked on cli it worked in Apache.

What errormessage are you getting from Apache when trying to connect to Sybase?

Regards

Richard Hillström

-Original Message-
From: Denis GALINSH [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 03, 2002 4:23 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] sybase with php4.1 and apache 13.20 problem


Hello,
I've got problem with working  php 4.1.0 under apache 13.20  with Sybase
SQL.
I installed Sybase ASE 11.0.3 with Open Client Lib and developt part and
compiled php 4.1. with sybase support ( FreeBSD 4.4) as a apache module and
usual executable file.
# ./configure --with-sybase=/usr/home/sybase --with-apxs
php works with sybase  greatfully if  I execute ordinary php file with
sybase_connect(..)

 etc.
But then I execute test php page - I've got error - just the same if I lose
sybase interfaces file or use wrong line in php.ini. But really - it's OK.
I've got in my php.ini
sybase.interface=/usr/home/sybase
and php works - then executs not from apache.

apache  is located in /usr/local.

?phpinfo()?ph
shows sybase support in php module( libphp4.so).

So, I've got serious problem!!

If someone can help me,  please, write me without
any hesitate.

Denis GALINSH
[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 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] php-apache-sybase install problems

2001-12-27 Thread Richard Hillström (GIS)

Maybe wrong mailing-list, but anyway, here it goes..

Trying to install Apache 1.3.22, PHP 4.0.6 and Sybase 11.0.3 on a Mandrake 8.1 box.
Sybase installs fine in /opt/sybase.

Apache install fine with  ./configure --prefix=/usr/local/apache --enable-module=so
make  make install
Boot apache, no problems.

PHP ./configure --with-apxs=/usr/local/apache/bin/apxs --with-sybase-ct=/opt/sybase
make  make install gives no errors
Boot apache, PROBLEMS!!
Cannot load /usr/local/apache/libexec/libphp4.so into server: 
/opt/sybase/lib/libcs.so: undefined symbol: intl_cstrbuild

What is the problem, does anyone know?

Running the above programs with php installad as a static module instead of a dynamic 
one works fine so why doesn't this?

Best regards
Richard 


-- 
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] Converting MySOL query results into form elements.

2001-11-29 Thread Richard Hillström (GIS)

I solved it like this:

echo SELECT NAME='databasename';
while($row = sybase_fetch_array($dbresult)) {
$r0 = $row[0];
echo OPTION VALUE='$r0'$r0/OPTION;
}
echo /SELECTBR;


//Richard

-Original Message-
From: Mark C. Farrington [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 29, 2001 3:25 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Converting MySOL query results into form elements.


What I need to do is query a MySQL db and turn the results into a dropdown box on a 
form. 

I've been paging through my books and I've come accross the command writeOptionList 
which seems to be what I'm looking for but I'm not sure how to use it.

Self taught programming is a joy eh?

Mark C. Farrington

-- 
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] MS SQL Server support

2001-11-19 Thread Richard Hillström (GIS)

You need to recompile PHP with --enable-mssql=path/to/some/files   or something like 
that as php does not come with support for mssql default. 
Read the INSTALL file that came with the sources or run, in the php source directory, 
./configure -help for all the switches.

//Richard 

-Original Message-
From: Daniel Persson [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 19, 2001 2:35 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] MS SQL Server support 


I got this error message when using PHP 4.06 with MSSQL.

PHP ERROR: PHP build incomplete: the prerequisite MS SQL Server support
required to read the alert database
was not built into PHP. Please recompile PHP with the necessary library
(--enable-mssql).

Is there anyone who knows what's wrong?

/Daniel






-- 
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] Why use MySQL with PHP

2001-11-15 Thread Richard Hillström (GIS)

Personally I prefer Sybase on Linux, version 11_0_3 is free for production use and 
easy to install.
Sybase 11_0_3 is still a very powerful DBMS although a bit dated by now, Sybase just 
released version 12.5. Why everyone is using MySQL I don't know, could it be that 
mod_php is compiled with MySQL support? MySQL is free and there is a lot of support 
from the community since so many are using it.

How would one go about making a mod_php with Sybase support also?

Regards
//Richard

-Original Message-
From: søren eriksen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 15, 2001 9:34 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Why use MySQL with PHP


Hi everybody
I'm writing a synopsis about PHP and mySQL.
I'm hoping someone can help me, and tell me why
the combination og PHP and MySQL is so common.
What makes MySQL such a good choice when using PHP?
What seperates MySQL from others dbms?
-Søren Eriksen-


-- 
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] Sql with Sybase variables @@

2001-11-01 Thread Richard Hillström (GIS)

Hi,

Is the following possible:

$conn = sybase_connect(SERVER,login,passwd);
$sql = select @@version;
$result = sybase_query($sql,$conn);
while($row = sybase_query($result)) {
   $r = $row[0];
   echo $r;
}

I tried but get a strange error message that I dont understand, what would be the 
correct syntax?

Regards
Richard Hillström


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