Re: php/mysql/unix-Linux hosting with major DBMS support>?

I think and hope it works like this the .so(unix) or .dll(win32) file is already a binary compiled executable (I know for a fact that the Win 32 dll's ARE) I looked at one with my file viewer quick view plus> I have php4/mysql/apache on my local host computer (Win95) I am typing into now. so the extension files are already compiled.(Win 32 definalty ARE.executable,,assuming Unix .so files are the same) they just have to be LINKED to the PHP binary by a ;linker like DL() so then PHP will ACT like it has been compiled with the extension.. Hence dynamically linking it. on win32 they are located (by default) in the C:/php/extensions dir under Unix they must be somewhere. phpinfo() has an entry for the php extensions dir my remote server shows: extension_dir ./ under the heading "Configuration PHP Core" in phpinfo() and the FAQ I showed you sort of substantiates that hypothesis.. Here it is again: I found this FAQ: http://www.alt-php-faq.org/#id7 When I try to connect to mysql from php I get this error: "Call to unsupported or undefined function mysql_connect();" Updated: 2001-06-01 Either you miss mysql support in the php module or you need to load mysql dynamicly in your scripts by inserting: dl("mysql.so"); (on unix) dl("mysql.dll"); (on windows); in the top of all the scripts that use mysql. --- end of FAQ notice the FAQ master tells the troubled soul to just dl() it ? no disturbing talk of compiling the "mysql.so" file first... Has anyone used the dl() function b4??? tell us how it works.. Ken ----- Original Message ----- From: "Matthew Loff" <matt@willetts.com> To: "'Ken Sommers'" <mrsql.php@worldnet.att.net>; "'PHP DB Mailing List'" <php-db@lists.php.net> Sent: Monday, July 16, 2001 9:18 PM Subject: RE: [PHP-DB] php/mysql/unix-Linux hosting with major DBMS support>? > > dl("mysql.so"); won't compile it... You need to provide the > "mysql.so" > file for it to link to, but I don't know where to obtain it... :( > > > -----Original Message----- > From: Ken Sommers [mailto:mrsql.php@worldnet.att.net] > Sent: Tuesday, July 17, 2001 12:12 AM > To: Matthew Loff; 'PHP DB Mailing List' > Subject: Re: [PHP-DB] php/mysql/unix-Linux hosting with major DBMS > support>? > > > I'm hoping the dl("mysql.so"); compiles it for you. > I found this FAQ: http://www.alt-php-faq.org/#id7 > > When I try to connect to mysql from php I get this error: "Call to > unsupported or undefined function mysql_connect();" > Updated: 2001-06-01 > Either you miss mysql support in the php module or you need to load > mysql dynamicly in your scripts by inserting: > > dl("mysql.so"); (on unix) > dl("mysql.dll"); (on windows); > > in the top of all the scripts that use mysql. > --- end of FAQ > > I hope it is that simple.. > > Ken > > ----- Original Message ----- > From: "Matthew Loff" <matt@willetts.com> > To: "'Ken Sommers'" <mrsql.php@worldnet.att.net>; "'PHP DB > Mailing > List'" <php-db@lists.php.net> > Sent: Monday, July 16, 2001 8:53 PM > Subject: RE: [PHP-DB] php/mysql/unix-Linux hosting with major DBMS > support>? > > > > > > That's all there is to it, I'm just not sure how to compile the > > mysql.so file! I looked through the PHP source tree, but the > > makefiles don't seem to be able to build the shared libs. > > > > Maybe it, along with others, can be downloaded from somewhere. > > > > > > -----Original Message----- > > From: Ken Sommers [mailto:mrsql.php@worldnet.att.net] > > Sent: Monday, July 16, 2001 11:45 PM > > To: Matthew Loff; 'PHP DB Mailing List' > > Subject: Re: [PHP-DB] php/mysql/unix-Linux hosting with major DBMS > > support>? > > > > > > thanks Mat, > > I found this FAQ: > > > > When I try to connect to mysql from php I get this error: "Call to > > unsupported or undefined function mysql_connect();" > > Updated: 2001-06-01 > > Either you miss mysql support in the php module or you need to load > > mysql dynamicly in your scripts by inserting: > > > > dl("mysql.so"); (on unix) > > dl("mysql.dll"); (on windows); > > > > in the top of all the scripts that use mysql. > > --- end of FAQ > > > > I am hoping it is that simple. > > the dl() does it all.. > > please say it does..:) > > > > ken > > > > > > > > ----- Original Message ----- > > From: "Matthew Loff" <matt@willetts.com> > > To: "'Ken Sommers'" <mrsql.php@worldnet.att.net>; > > "'PHP DB Mailing > > List'" <php-db@lists.php.net> > > Sent: Monday, July 16, 2001 8:13 PM > > Subject: RE: [PHP-DB] php/mysql/unix-Linux hosting with major DBMS > > support>? > > > > > > > > > > The ext/ directory under the PHP source tree contains the source to > > > the extensions... > > > > > > You're right about the dl() syntax, except the parameter would need > > > to > > > > > be in quotes, and dl() requires the full filename of the extension. > > > > > > For xml, it would be: > > > > > > dl("xml.so"); > > > > > > But compiling those shared modules is another story-- I'm not quite > > > sure how to. Can anyone else help? > > > > > > -----Original Message----- > > > From: Ken Sommers [mailto:mrsql.php@worldnet.att.net] > > > Sent: Monday, July 16, 2001 10:18 PM > > > To: Ken Sommers; Matthew Loff; 'PHP DB Mailing List' > > > Subject: Re: [PHP-DB] php/mysql/unix-Linux hosting with major DBMS > > > support>? > > > > > > > > > is this what some of them look like > > > is this the name that would go into the dl() function?? > > > > > > print_r (get_loaded_extensions()); > > > will print a list like: > > > Array > > > ( > > > [0] => xml > > > [1] => wddx > > > [2] => standard > > > [3] => session > > > [4] => posix > > > [5] => pgsql > > > [6] => pcre > > > [7] => gd > > > [8] => ftp > > > [9] => db > > > [10] => Calendar > > > [11] => bcmath > > > ) > > > > > > so would > > > > > > dl(posix); > > > dl(pgsql); > > > > > > work? > > > > > > Ken > > > ----- Original Message ----- > > > From: "Ken Sommers" <mrsql.php@worldnet.att.net> > > > To: "Matthew Loff" <matt@willetts.com>; "'PHP DB Mailing > > > List'" > > > <php-db@lists.php.net> > > > Sent: Monday, July 16, 2001 7:11 PM > > > Subject: Re: [PHP-DB] php/mysql/unix-Linux hosting with major DBMS > > > support>? > > > > > > > > > > Help. > > > > I just spent the last hour looking for the > > > > the PHP extension library to see what the > > > > the PHP extension defined in library is to put in > > > > dl (string library); > > > > to load an extension at run time. > > > > has someone seen the library door? > > > > I Keep missing it? > > > > > > > > Ken > > > > > > > > > > > > ----- Original Message ----- > > > > From: "Matthew Loff" <matt@willetts.com> > > > > To: "'Ken Sommers'" <sommersken@hotmail.com>; > > > > "'PHP DB Mailing > > > > List'" <php-db@lists.php.net> > > > > Sent: Monday, July 16, 2001 6:37 PM > > > > Subject: RE: [PHP-DB] php/mysql/unix-Linux hosting with major DBMS > > > support>? > > > > > > > > > > > > > > > > > > > > > > > I'm not sure if dl() can be restricted in php.ini-- Someone else > > > > > > will have to comment on that... > > > > > > > > > > I believe you'll have to dl() on every page you create... You > > > > > could always do the following for portability to other PHP > > > > > hosts, just in case they have the module already compiled in: > > > > > > > > > > if(!extension_loaded("mysql")) dl("mysql.so"); > > > > > > > > > > That's assuming that the mysql ext. is named "mysql.so" in a > > > > > compiled state, of course. > > > > > > > > > > > > > > > -----Original Message----- > > > > > From: Ken Sommers [mailto:sommersken@hotmail.com] > > > > > Sent: Monday, July 16, 2001 9:26 PM > > > > > To: Matthew Loff; 'PHP DB Mailing List' > > > > > Subject: Re: [PHP-DB] php/mysql/unix-Linux hosting with major > > > > > DBMS > > > > > support>? > > > > > > > > > > > > > > > Thanks for the HOT tip..on the dl() function. > > > > > > > > > > should the dl() function work an ANY PHP4 host? > > > > > or do restrictons apply? > > > > > > > > > > > > > > > would I put the dl() at the top of EVERY script page In which > > > > > > I > > > > > > > Need the functionality..? or just load it once per "session" and > > > > > > check and see if it';s already loaded before I Load it,each time > > > > > > because it might already be loaded,, like I Used to do when I > > > > > used > > > > > > > to get loaded? the documentation is kinda skimpy. here's what it > > > > > says: > > > > > --- > > > > > dl > > > > > (PHP 3, PHP 4 >= 4.0b1) > > > > > > > > > > dl -- load a PHP extension at runtime > > > > > Description > > > > > > > > > > int dl (string library) > > > > > > > > > > > > > > > Loads the PHP extension defined in library. See also the > > > > > extension_dir configuration directive. > > > > > --- > > > > > > > > > > thanks, > > > > > > > > > > Ken > > > > > > > > > > ----- Original Message ----- > > > > > From: "Matthew Loff" <matt@willetts.com> > > > > > To: "'Ken Sommers'" <sommersken@hotmail.com>; > > > > > "'PHP DB Mailing > > > > > List'" <php-db@lists.php.net> > > > > > Sent: Monday, July 16, 2001 6:01 PM > > > > > Subject: RE: [PHP-DB] php/mysql/unix-Linux hosting with major > > > > > DBMS > > > > > support>? > > > > > > > > > > > > > > > > > > > > > > Even if a PHP host doesn't have all the DBMS extensions you > > > > > > need, you could compile them and load them yourself with dl() > > > > > > > > > > > > > > > > > > http://www.php.net/manual/en/function.dl.php > > > > > > > > > > > > I thought you might want to keep that in mind, in case one > > > > > > particular host has a great price but not all the features you > > > > > > > need... > > > > > > > > > > > > > > > > > > -----Original Message----- > > > > > > From: Ken Sommers [mailto:sommersken@hotmail.com] > > > > > > Sent: Monday, July 16, 2001 8:53 PM > > > > > > To: PHP DB Mailing List > > > > > > Subject: [PHP-DB] php/mysql/unix-Linux hosting with major DBMS > > > > > > support>? > > > > > > > > > > > > > > > > > > Any one use or know of a php/mysql/unix-Linux hosting company > > > > > > with > > > > > > > > > PHP database support compiled with all the major DBMS's such > > > > > > as: > > > > > > > > > > > > mSQL > > > > > > MySQL > > > > > > PostgreSQL > > > > > > Sybase > > > > > > Oracle > > > > > > Informix > > > > > > MS-SQL > > > > > > Other ODBC Database > > > > > > > > > > > > I will need to use some or all of these DBMS PHP functions for > > > > > > > remote access. > > > > > > > > > > > > thanks,, > > > > > > Ken > > > > > > > > > > > > > > > > > > -- > > > > > > PHP Database Mailing List (http://www.php.net/) > > > > > > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net For > > > > > > additional commands, e-mail: php-db-help@lists.php.net To > > > > > > contact the list administrators, e-mail: > > > > > > php-list-admin@lists.php.net > > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > > PHP Database Mailing List (http://www.php.net/) > > > > > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net For > > > > > additional commands, e-mail: php-db-help@lists.php.net To > > > > > contact the list administrators, e-mail: > > > > > php-list-admin@lists.php.net > > > > > > > > > > > > > > > > > -- > > > > PHP Database Mailing List (http://www.php.net/) > > > > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net For > > > > additional commands, e-mail: php-db-help@lists.php.net To contact > > > > the list administrators, e-mail: php-list-admin@lists.php.net > > > > > > > > > > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > > For additional commands, e-mail: php-db-help@lists.php.net > > To contact the list administrators, e-mail: > > php-list-admin@lists.php.net > > >