Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Get Some Basic Information Back from MySQL Servers
How To Get Some Basic Information Back from MySQL Servers? - MySQL FAQs - PHP Connections and Query Execution
✍: FYIcenter.com
Once you got a MySQL server connection object successfully, you can use mysql_get_server() and mysql_get_host_info() to get some basic information from your MySQL server. The tutorial exercise below is a good example:
<?php $con = mysql_connect('localhost:8888', 'dev', 'iyf'); if (!$con) { print("There is a problem with MySQL connection.\n"); } else { print("The MySQL connection object is ready.\n"); print(mysql_get_client_info()."\n"); print(mysql_get_server_info($con)."\n"); print(mysql_get_host_info($con)."\n"); mysql_close($con); } ?>
If you run this script, you will get something like this:
The MySQL connection object is ready. 4.1.7 5.0.24-community-log localhost via TCP/IP
2007-05-10, 5355👍, 0💬
Popular Posts:
How To Increment Dates by 1? - MySQL FAQs - Introduction to SQL Date and Time Handling If you have a...
How To Change System Global Area (SGA)? - Oracle DBA FAQ - Introduction to Oracle Database 10g Expre...
What does a well-written Object Oriented program look like? A well-written object oriented program e...
What is the significance of Finalize method in .NET? .NET Garbage collector does almost all clean up...
.NET INTERVIEW QUESTIONS - What are types of compatibility in VB6? There are three possible project ...