php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Request #23541 ODBC: Support for picoSQL database
Submitted: 2003-05-08 03:01 UTC Modified: 2005-12-05 14:46 UTC
From: marco at picosoft dot it Assigned:
Status: Wont fix Package: Feature/Change Request
PHP Version: 4.3.1 OS: all
Private report: No CVE-ID: None
Have you experienced this issue?
Rate the importance of this bug to you:

 [2003-05-08 03:01 UTC] marco at picosoft dot it
I would like to propose the picoSQL db support in PHP.
picoSQL supports the ODBC APIs, so you need to change only
the following two files (you can get further informations
at www.picosoft.it/picosql or you can email me):

--- php-4.3.1/ext/odbc/php_odbc_includes.h      Wed Jul 31 15:51:20 2002
+++ php-4.3.1/ext/odbc/php_odbc_includes.h.new  Wed Apr 30 17:04:45 2003
@@ -179,6 +179,12 @@
 #include <LibraryManager.h>
 #endif

+#elif defined(HAVE_PICOSQL) /* PICOSQL */
+#define ODBC_TYPE "picoSQL"
+#define HAVE_SQL_EXTENDED_FETCH 1
+#include <odbcsql.h>
+# define SQL_MAX_MESSAGE_LENGTH 512
+
 #else /* MS ODBC */

 #define HAVE_SQL_EXTENDED_FETCH 1


--- php-4.3.1/ext/odbc/config.m4        Tue Nov 12 18:31:39 2002
+++ php-4.3.1/ext/odbc/config.m4.new    Wed Apr 30 16:50:00 2003
@@ -534,6 +534,36 @@
 ])
 fi

+if test -z "$ODBC_TYPE"; then
+AC_MSG_CHECKING(for picoSQL support)
+AC_ARG_WITH(picoSQL,
+[  --with-picoSQL[=DIR]   Include picoSQL support.  DIR is the
+                          picoSQL base install directory, defaults to
+                          /usr/local.],
+[
+  PHP_WITH_SHARED
+  if test "$withval" = "yes"; then
+    withval=/usr/local
+  fi
+  if test "$withval" != "no"; then
+    PHP_ADD_LIBRARY_WITH_PATH(picocpp, $withval/lib)
+    PHP_ADD_LIBRARY_WITH_PATH(picoiiop, $withval/lib)
+    PHP_ADD_LIBRARY_WITH_PATH(picosqlnet, $withval/lib)
+    PHP_ADD_INCLUDE($withval/inc, 1)
+    ODBC_TYPE=picoSQL
+    ODBC_INCLUDE=-I$withval/inc
+    ODBC_LFLAGS=-L$withval/lib
+    ODBC_LIBS=-lpicosqlnet -lpicoiiop -lpicocpp
+    AC_DEFINE(HAVE_PICOSQL,1,[ ])
+    AC_MSG_RESULT(yes)
+  else
+    AC_MSG_RESULT(no)
+  fi
+],[
+  AC_MSG_RESULT(no)
+])
+fi
+
 if test -n "$ODBC_TYPE"; then
   if test "$ODBC_TYPE" != "dbmaker"; then
     if test "$shared" != "yes"; then

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2003-05-08 11:00 UTC] wez@php.net
Patch needs some changes before applying to current CVS.

 [2003-05-14 06:44 UTC] marco at picosoft dot it
I tried to apply the patch to the current CVS (php5) and 
it seems working to me.
Must I do some other tests?
 [2005-12-05 14:46 UTC] wez@php.net
Use PDO_ODBC in PHP 5
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Mon May 27 08:01:33 2024 UTC