Description:
------------
If I go through the usual steps to build sqlite via pear install on mac 
os x 10.2.8, it ends up creating a .so that will not load via the php 
dl() or automatically via the php.ini. A dynamic library is created 
instead of a bundle.

This causes an error when you try to load the library:

cat example <<END
sh-2.05a# php sqlite.php

Warning: dl(): Unable to load dynamic library '/usr/local/lib/php/
extensions/sqlite.so' - not a Mach-O MH_BUNDLE file type in /
private/tmp/tmp9GcwuC/SQLite-1.0/sqlite.php on line 3

Fatal error: Call to undefined function: sqlite_libversion() in /
private/tmp/tmp9GcwuC/SQLite-1.0/sqlite.php on line 6 
END

There is a /usr/local/lib/php/extensions/sqlite.so file with proper 
permissions, it is merely linked incorrectly.

I was able to work around the problem by halting a pear install 
during mid build, running configure myself and relinking the binary 
with the correct options. Instead of -dynamiclib, use -bundle, and 
remove the -install_name option:

sh-2.05a# gcc -bundle -flat_namespace -undefined suppress -o 
.libs/sqlite.so sqlite.lo libsqlite/src/opcodes.lo libsqlite/src/parse.lo 
libsqlite/src/encode.lo libsqlite/src/auth.lo libsqlite/src/btree.lo 
libsqlite/src/build.lo libsqlite/src/delete.lo libsqlite/src/expr.lo 
libsqlite/src/func.lo libsqlite/src/hash.lo libsqlite/src/insert.lo 
libsqlite/src/main.lo libsqlite/src/os.lo libsqlite/src/pager.lo libsqlite/
src/printf.lo libsqlite/src/random.lo libsqlite/src/select.lo libsqlite/
src/table.lo libsqlite/src/tokenize.lo libsqlite/src/update.lo libsqlite/
src/util.lo libsqlite/src/vdbe.lo libsqlite/src/attach.lo libsqlite/src/
btree_rb.lo libsqlite/src/pragma.lo libsqlite/src/vacuum.lo libsqlite/
src/copy.lo libsqlite/src/where.lo libsqlite/src/trigger.lo -lc

This worked for me and everything was happy once I copied it into 
place. As a side note, the dynamic libs are what you want to do for 
a library that compiled code will link against, just apparently not the 
mechanism php is/was set up to use (php could have used the 
equivalent to dlopen, but they apparently favored using bundles 
instead). Hope this helps someone. :)

Cheers!
Sean

p.s. I submitted this as a bug to the sqlite folks, and they said it's a 
php folk problem.  It is recorded under sqlite ticket #487.