Re: 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 > > >