note 83258 modified in function.mysql-get-server-info by felipe
| From: | felipe@php.net | Date: | Fri, 23 May 2008 23:53:12 +0000 |
| Subject: | note 83258 modified in function.mysql-get-server-info by felipe | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-139673@lists.php.net to get a copy of this message | ||
Here is something I put together because I needed a way to pull the MySQL version number from the
server without actually having a connection. This was due to being part of a server info screen
prior to installation of a cms. Users need to know if their MySQL is supported or not prior to
installation right? :)
This will scrape the phpinfo page looking for the MySQL row that says Client API version and return
the version number after it. This could also be used to scrape just about anything from the phpinfo
page. :)
ob_start();
phpinfo(INFO_MODULES);
$info = ob_get_contents();
ob_end_clean();
$info = stristr($info, 'Client API version');
preg_match('/[1-9].[0-9].[1-9][0-9]/', $info, $match);
$gd = $match[0];
echo 'MySQL: '.$gd.' <br />';
This will output:
MySQL: 4.1.22 (which is the version on my server)
I know this is crude but it's the only thing I could come up with and there isn't anything
like this info available online so here it is. I suck at preg_match and it would be helpful if
someone could modify the string here to stand the test of time.
--was--
Here is something I put together because I needed a way to pull the MySQL version number from the
server without actually having a connection. This was due to being part of a server info screen
prior to installation of a cms. Users need to know if their MySQL is supported or not prior to
installation right? :)
This will scrape the phpinfo page looking for the MySQL row that says Client API version and return
the version number after it. This could also be used to scrape just about anything from the phpinfo
page. :)
ob_start();
phpinfo(INFO_MODULES);
$info = ob_get_contents();
ob_end_clean();
$info = stristr($info, 'Client API version');
preg_match('/[1-9].[1-9].[1-9][1-9]/', $info, $match);
$gd = $match[0];
echo 'MySQL: '.$gd.' <br />';
This will output:
MySQL: 4.1.22 (which is the version on my server)
I know this is crude but it's the only thing I could come up with and there isn't anything
like this info available online so here it is. I suck at preg_match and it would be helpful if
someone could modify the string here to stand the test of time.
http://php.net/manual/en/function.mysql-get-server-info.php