It returns information about the last query
Example
<?php
mysql_connect(“localhost”, “root”, “phpcode”) or die( mysql_error());
mysql_select_db(“database_name”);
mysql_query(“INSERT INTO users (name) VALUES (‘PHP’)”);
echo mysql_info();
mysql_close();
?>
It returns server info
Example
<?php
mysql_connect(“localhost”, “root”, “phpcode”) or die(mysql_error());
echo mysql_get_server_info();
?>
Output
5.1.61-0ubuntu0.10.10.1
It returns protocol info
Example
<?php
mysql_connect(“localhost”, “root”, “phpcode”) or die(mysql_error());
echo mysql_get_proto_info();
?>
Output
10
It returns MySQL host info
Example
<?php
mysql_connect(“localhost”, “root”, “phpcode”) or die(mysql_error());
echo mysql_get_host_info();
?>
Output
Localhost via UNIX socket
It returns MySQL client info
Example
<?php
echo mysql_get_client_info();
?>
Output
5.1.61
Free result memory
Example
<?php
mysql_connect(“localhost”, “root”, “phpcode”) or die(mysql_error());
mysql_select_db(“database_name”);
echo “<pre>”;
$userQry = mysql_query(“SELECT * FROM users”);
mysql_free_result($userQry);
mysql_close();
?>
It returns the type of a field in a recordset
Example
<?php
mysql_connect(“localhost”, “root”, “phpcode”) or die(mysql_error());
mysql_select_db(“database_name”);
echo “<pre>”;
echo mysql_field_type($userQry=mysql_query(“SELECT * FROM users”),1);
?>
Output
string
It returns the name of the table the specified field is in
Example
<?php
mysql_connect(“localhost”, “root”, “phpcode”) or die(mysql_error());
mysql_select_db(“database_name”);
echo “<pre>”;
echo mysql_field_table($userQry=mysql_query(“SELECT * FROM users”),1);
Output
users
It moves the result pointer to a specified field
Example
<?php
mysql_connect(“localhost”, “root”, “phpcode”) or die(mysql_error());
mysql_select_db(“database_name”);
echo “<pre>”;
mysql_field_seek($userQry=mysql_query(“SELECT * FROM users”),1);
print_r(mysql_fetch_field($userQry));
mysql_close();
?>
Output
stdClass Object
(
[name] => name
[table] => users
[def] =>
[max_length] => 4
[not_null] => 1
[primary_key] => 0
[multiple_key] => 0
[unique_key] => 0
[numeric] => 0
[blob] => 0
[type] => string
[unsigned] => 0
[zerofill] => 0
)
It returns the name of a field in a recordset
Example
<?php
mysql_connect(“localhost”, “root”, “phpcode”) or die(mysql_error());
mysql_select_db(“database_name”);
echo “<pre>”;
echo mysql_field_name(mysql_query(“SELECT * FROM users”),1);
?>
Output
name