note 83258 added to function.mysql-get-server-info
| From: | cmscoder at seasamecreek dot info | Date: | Fri, 16 May 2008 23:55:28 +0000 |
| Subject: | note 83258 added to function.mysql-get-server-info | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-139462@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].[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.
----
Server IP: 208.69.120.35
Probable Submitter: 66.177.221.36
----
Manual Page -- http://www.php.net/manual/en/function.mysql-get-server-info.php
Edit -- https://master.php.net/note/edit/83258
Del: integrated -- https://master.php.net/note/delete/83258/integrated
Del: useless -- https://master.php.net/note/delete/83258/useless
Del: bad code -- https://master.php.net/note/delete/83258/bad+code
Del: spam -- https://master.php.net/note/delete/83258/spam
Del: non-english -- https://master.php.net/note/delete/83258/non-english
Del: in docs -- https://master.php.net/note/delete/83258/in+docs
Del: other reasons-- https://master.php.net/note/delete/83258
Reject -- https://master.php.net/note/reject/83258
Search -- https://master.php.net/manage/user-notes.php