RE: [PHP] MySQL version & O.S. info???
| From: | Ozemail ) | Date: | Thu, 26 Oct 2000 06:15:03 +0000 |
| Subject: | RE: [PHP] MySQL version & O.S. info??? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-22064@lists.php.net to get a copy of this message | ||
To get MySQL version
SELECT VERSION() AS version
Of course you must be connected to the MySQL first :) but you don't need to use any DB in order
to run this SQL.
> -----Original Message-----
> From: dread@texas.net [mailto:dread@texas.net]
> Sent: Thursday, October 26, 2000 2:48 PM
> To: Kraa de Simon
> Cc: PHP
> Subject: RE: [PHP] MySQL version & O.S. info???
>
>
>
> On 25-Oct-00 Kraa de Simon wrote:
> > Hello,
> >
> > I'm still missing the environment vars (or other method) for retrieving the
> > MySQL version and Operating System info...
> >
> > Any idea?
> >
> > Info Var/Function/Other Example output
> > -----------------------------------------------------------------------
> > Webserver: $SERVER_SOFTWARE Apache/1.3.12
> > PHP version: phpversion() 4.0.2
> > MySQL version: select ... from ...??? 3.22.32
>
> show variables like 'version';
>
> > Operating System: ??? Windows NT 5.0 build 2195
> >
>
> echo $OSTYPE ."<BR>\n";
> echo $MACHTYPE ."<BR>\n";
>
> Regards,
> --
> Don Read dread@texas.net
> There are old sailors, and there are foolish
> sailors; but damn few old foolish sailors.
> ---------------------------------------------
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net
> For additional commands, e-mail: php-general-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
>