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

Do you mean the hosting company would have compiled PHP with all the extenions available at compile time? I have looked at two different hosting company's phpinfo() the only dbms they build PHP with is mysql..or its' already built in I think the resoning is: IF you want other dbms PHP functions,,just dl() it . 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:56 PM Subject: RE: [PHP-DB] php/mysql/unix-Linux hosting with major DBMS support>? > > > You're correct that .so files are like Windows' .dll files... However, > if the library were already available on the PHP host, it most likely > would already be included in the PHP binary... > > Perhaps (as you suggested) you need to find binary distributions of each > individual library (e.g. mysql.so) that you need... I'd check for .rpm > files... > > > -----Original Message----- > From: Ken Sommers [mailto:mrsql.php@worldnet.att.net] > Sent: Tuesday, July 17, 2001 12:43 AM > To: Matthew Loff; 'PHP DB Mailing List' > Subject: Re: [PHP-DB] 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 > > > > > > > > -- > 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 >