Linux and UNIX Man Pages

Linux & Unix Commands - Search Man Pages

mysql_get_host_info(3) [php man page]

MYSQL_GET_HOST_INFO(3)							 1						    MYSQL_GET_HOST_INFO(3)

mysql_get_host_info - Get MySQL host 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_host_info(3) o PDO::getAttribute string mysql_get_host_info ([resource $link_identifier = NULL]) DESCRIPTION
Describes the type of connection in use for the connection, including the server host name. 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 a string describing the type of MySQL connection in use for the connection or FALSE on failure. Example #1 mysql_get_host_info(3) example <?php $link = mysql_connect('localhost', 'mysql_user', 'mysql_password'); if (!$link) { die('Could not connect: ' . mysql_error()); } printf("MySQL host info: %s ", mysql_get_host_info()); ?> The above example will output something similar to: MySQL host info: Localhost via UNIX socket mysql_get_client_info(3), mysql_get_proto_info(3), mysql_get_server_info(3). PHP Documentation Group MYSQL_GET_HOST_INFO(3)

Check Out this Related 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)

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. UNIX for Dummies Questions & Answers

PHP and MySQL

I want to design a database, using mysql as a backend, and PHP as the frontend, I wanna be able to easily build forms in PHP to communicate with MySQL, is there any programs that will allow this, I really dont want to program all the forms by hand.. thankyou (2 Replies)
Discussion started by: kwalick
2 Replies

4. 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

5. 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

6. 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

7. UNIX for Dummies Questions & Answers

Horde Installation Woes for Centos 5.x

I am trying to learn how to install HORDE for work and I found this link: Installing Horde on Centos 5.x - William Lindley - wlindley.com I am at this step now: You'll need to use the MySQL root password. Then, in your database administration screen for MySQL, set the password for the new... (2 Replies)
Discussion started by: mojoman
2 Replies

8. Shell Programming and Scripting

Sending info to a webservice

Hello, I am new to UNIX and this is my first project with it. I am trying to determine the best way to send information from a UNIX PHP website into a webservice. I will have 4 variables to pass to it in an XML format. I am not sure what exactly this would entail. If you could point me... (5 Replies)
Discussion started by: EddiRae
5 Replies

9. Ubuntu

Database Connection

Hi, How to creating connection to mysql.I try to connect but the following error coming .How to solve it. Could not connect to New MySQL. Error creating SQL Model Connection connection to New MySQL. (Error: com.mysql.jdbc.Driver) com.mysql.jdbc.Driver Error creating JDBC Connection... (2 Replies)
Discussion started by: snallusami
2 Replies

10. Programming

PHP and MySQL

Hello, While I was interpretation the PHP manual on database security the recent past, it said that you should by no means connect to the database as the super user but rather as one more user with more limited options. My question is: How do you generate new users and set access... (2 Replies)
Discussion started by: AimyThomas
2 Replies

11. Web Development

Can't Install MySQL with PHP

Hi, I'm on a Raspberry Pi with Raspbian Wheezy. I urgently need to get MySQL running with PHP, but I get an error. For example: $con=mysql_connect("127.0.0.1","root","******","ids"); gives PHP Fatal error: Call to undefined function mysql_connect() So, I found I needed to install some... (2 Replies)
Discussion started by: FreddoT
2 Replies

12. Web Development

$_SERVER['DOCUMENT_ROOT'] directs to /var/www not ~/public_html

Hi all, Exactly like my title says. I am learning PHP and MySQL and I used to use /var/www/ to host (contain or store) my files (.htm/.php) for testing. I could configure, finally, apache2 to use ~/public_html instead. Now I when I tried to use $_SERVER it still directs (I used echo to show... (7 Replies)
Discussion started by: faizlo
7 Replies

13. UNIX for Dummies Questions & Answers

UNIX Folder Recovery

I had a data folder in MySQL that has simply disappeared. Something about a compromised server and MySQL crashing. This happened a few days ago. Although there has been one reboot, nothing new has been written to the server, so I'm thinking in theory it might still be there. Has anyone had... (2 Replies)
Discussion started by: SurfMe69
2 Replies

Featured Tech Videos