Linux and UNIX Man Pages

Linux & Unix Commands - Search Man Pages

mysql_get_server_info(3) [php man page]

MYSQL_GET_SERVER_INFO(3)						 1						  MYSQL_GET_SERVER_INFO(3)

mysql_get_server_info - Get MySQL server info

SYNOPSIS
Warning This extension is deprecated as of PHP 5.5.0, and will be removed in the future. Instead, the MySQLi or PDO_MySQL extension should be used. See also MySQL: choosing an API guide and related FAQ for more information. Alternatives to this function include: omysqli_get_server_info(3) o PDO::getAttribute string mysql_get_server_info ([resource $link_identifier = NULL]) DESCRIPTION
Retrieves the MySQL server version. o $ link_identifier -The MySQL connection. If the link identifier is not specified, the last link opened by mysql_connect(3) is assumed. If no such link is found, it will try to create one as if mysql_connect(3) was called with no arguments. If no connection is found or established, an E_WARNING level error is generated. Returns the MySQL server version on success or FALSE on failure. Example #1 mysql_get_server_info(3) example <?php $link = mysql_connect('localhost', 'mysql_user', 'mysql_password'); if (!$link) { die('Could not connect: ' . mysql_error()); } printf("MySQL server version: %s ", mysql_get_server_info()); ?> The above example will output something similar to: MySQL server version: 4.0.1-alpha mysql_get_client_info(3), mysql_get_host_info(3), mysql_get_proto_info(3), phpversion(3). PHP Documentation Group MYSQL_GET_SERVER_INFO(3)

Check Out this Related Man Page

MYSQL_CLOSE(3)								 1							    MYSQL_CLOSE(3)

mysql_close - Close MySQL connection

SYNOPSIS
Warning This extension is deprecated as of PHP 5.5.0, and will be removed in the future. Instead, the MySQLi or PDO_MySQL extension should be used. See also MySQL: choosing an API guide and related FAQ for more information. Alternatives to this function include: omysqli_close(3) oPDO: Assign the value of NULL to the PDO object bool mysql_close ([resource $link_identifier = NULL]) DESCRIPTION
mysql_close(3) closes the non-persistent connection to the MySQL server that's associated with the specified link identifier. If $link_identifier isn't specified, the last opened link is used. Using mysql_close(3) isn't usually necessary, as non-persistent open links are automatically closed at the end of the script's execution. See also freeing resources. o $ link_identifier -The MySQL connection. If the link identifier is not specified, the last link opened by mysql_connect(3) is assumed. If no connection is found or established, an E_WARNING level error is generated. Returns TRUE on success or FALSE on failure. Example #1 mysql_close(3) example <?php $link = mysql_connect('localhost', 'mysql_user', 'mysql_password'); if (!$link) { die('Could not connect: ' . mysql_error()); } echo 'Connected successfully'; mysql_close($link); ?> The above example will output: Connected successfully Note mysql_close(3) will not close persistent links created by mysql_pconnect(3). mysql_connect(3), mysql_free_result(3). PHP Documentation Group MYSQL_CLOSE(3)

13 More Discussions You Might Find Interesting

1. Cybersecurity

Open Port 3306 for MySQL connection

I am needing to "un-block" port 3306 so that I can access MySQL from another PC. When I installed Mandrake 8.1, I set the security level to high because it is going to be a web server. I believe I have to allow access to my ports now and I do not know the commands to do that. If anyone... (4 Replies)
Discussion started by: gdboling
4 Replies

2. Programming

Howto convert Ascii -> UTF-8 & back C++

While working with russian text under FreeBSD&MySQL I need to convert a string from MySQL to the Unicode format. I've just started my way in C++ under FreeBSD , so please explain me how can I get ascii code of Char variable and also how can i get a character into variable with the specified ascii... (3 Replies)
Discussion started by: macron
3 Replies

3. Shell Programming and Scripting

Problem with PHP and MySQL

Okay, I'm new to this PHP and MySQL stuff, so help would be VERY much appreciated. :) On my iMac runnning Panther, it has MySQL and PHP installed. Yet when I view a PHP file from the iMac or another computer at my house, I get the source code. What's wrong? (11 Replies)
Discussion started by: Danny_10
11 Replies

4. Linux

MySQL server connetction problem

Hello,thanks for your help. I can't connect my MYSQLserver , the note from my Linux System is 'Error 1130 (00000): Host 'my ip address' is not allowed to connect to this MySQL server. What could I do on this? Thanks again! (4 Replies)
Discussion started by: lancepanda
4 Replies

5. Shell Programming and Scripting

Problem with looping construct

Hi all I have tried to search for this, but keep getting a MySQL db connect error, so am posing the question here, and taking a risk of incurring the wrath of the mods with my first post... I have the following test script: #!/bin/bash HTTPD=`/bin/ps -axcu | /usr/bin/grep httpd... (6 Replies)
Discussion started by: mikie
6 Replies

6. Shell Programming and Scripting

Something went awfully wrong in PHP+MySQL :(

When I'm running a few statements through mysql console, they are working just fine but when I'm trying to write some logic in php and trying to execute it, its awfully slow.. Its perhaps performing, 10 queries in 20 seconds... :( Why is this happening? My table structures are: Name:... (23 Replies)
Discussion started by: Legend986
23 Replies

7. UNIX for Advanced & Expert Users

Linux server locking up

I've been running Django on MySQL on a Linux server for about 3 months w/o any problem. Suddenly a couple days ago, the server Django began throwing errors about not being able to connect to MySQL, at which point the entire server seizes up. The Apache Web server stops serving pages and SSH seizes... (3 Replies)
Discussion started by: mongoose1
3 Replies

8. Programming

C Beginner Looking For Suggestions

A few weeks ago at the recommendation of people I trust, I bought and started reading Kernighan and Ritchie's (K&R) C Programming Language. For one thing, it's damn thin compared to the O'Reilly Practical C I just finished last month. It covers generally the same stuff but in a much more... (9 Replies)
Discussion started by: deckard
9 Replies

9. Web Development

Unkown table Engine 'InnoDB' on a RedHat server with MySQL v5!

hi all, After installing MySQL Source Code on my RedHat machine and compiling it, i no longer have access to some of my DBs having this error message. Unkown table Engine 'InnoDB' Before this step, i used to have another MySQL instance that used to work properly with all the DBs i do have,... (7 Replies)
Discussion started by: mehdi1973
7 Replies

10. Programming

Access denied for user at localhost

Hi guys. We can can connect to mysql server from command line with some user. but when using mysql_connect() it says: access is denied for user 'someuser'@'localhost' (using password: YES) what should i do? (6 Replies)
Discussion started by: majid.merkava
6 Replies

11. Homework & Coursework Questions

C/C++ program that connects to a MySQLserver

Hi Programming Geeks, I got an interesting C++ and MySQL problem to solve. I was unable to do this as I am not much confident on MySQL DB. Please have a go at it if possible. Write a C/C++ program that connects to a MySQLserver and checks if the InnoDB plug-in is installed on it. If so,... (5 Replies)
Discussion started by: vivek.goel.piet
5 Replies

12. Cybersecurity

Server has been compromised

Hi, I want to ask something about server that has been compromised. Recently, one of my VPS server has been hacked and the attacker install somekind like "IRC" script. Everytime I killed the process or close the port, it can open again .. and again ..I'm sure the attacker has installed... (14 Replies)
Discussion started by: franx47
14 Replies

13. HP-UX

Scbackup

Hi guys i am new for hp-ux. any one guide me how to take online scbackup in hp-ux server version 11.11 (4 Replies)
Discussion started by: siva3492
4 Replies

Featured Tech Videos