RE: [PHP-DB] sybase with php4.1 and apache 13.20 problem
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
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.
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
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
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 @@
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]