Its deprecated . It lists MySQL table fields
Example
<?php
mysql_connect(“localhost”, “root”, “phpcode”) or die( mysql_error());
echo “<pre>”;
$fields = mysql_list_fields(“database_name”,”users”);
for ($i=0; $i < mysql_num_fields($fields); ++$i)
echo mysql_field_name ($fields, $i), ‘<br />’;
?>
>
Output
id
name
It list databases available on a MySQL server
Example
<?php
$conn = mysql_connect(“localhost”, “root”, “password”) or die(mysql_error());
$db_list = mysql_list_dbs($conn);
$db_count = mysql_num_rows($db_list);
for($i=0;$i<$db_count;$i++){
echo mysql_db_name($db_list, $i) . “<br />”;
}
?>
Return the id generated the previous 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_close();
?>
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
Pramod T P 