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

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
)