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