It returns column info from a recordset as an object

MySQL table – Users

+—-+——+
| id | name |
+—-+——+
|  1 | PHP  |
|  2 | JS   |
|  3 | HTML |
|  4 | AS   |
+—-+——+

Example

<?php
mysql_connect(“localhost”, “root”, “password”) or die(mysql_error());
mysql_select_db(“database_name”);
echo “<pre>”;
$userQry = mysql_query(“SELECT * FROM users”);
while($userInfo = mysql_fetch_field($userQry)){
print_r($userInfo);
}
?>

Output

stdClass Object
(
[name] => id
[table] => users
[def] =>
[max_length] => 1
[not_null] => 1
[primary_key] => 1
[multiple_key] => 0
[unique_key] => 0
[numeric] => 1
[blob] => 0
[type] => int
[unsigned] => 0
[zerofill] => 0
)
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 a row from a recordset as an associative array

MySQL table – Users

+—-+——+
| id | name |
+—-+——+
|  1 | PHP  |
|  2 | JS   |
|  3 | HTML |
|  4 | AS   |
+—-+——+

Example

<?php
mysql_connect(“localhost”, “root”, “password”) or die(mysql_error());
mysql_select_db(“database_name”);
echo “<pre>”;
$userQry = mysql_query(“SELECT * FROM users”);
while($userInfo = mysql_fetch_assoc($userQry)){
print_r($userInfo);
}
?>

Output

Array
(
[id] => 1
[name] => PHP
)
Array
(
[id] => 2
[name] => JS
)
Array
(
[id] => 3
[name] => HTML
)
Array
(
[id] => 4
[name] => AS
)

It returns a row from a recordset as an associative array and/or a numeric array

MySQL table – Users

+—-+——+
| id | name |
+—-+——+
|  1 | PHP  |
|  2 | JS   |
|  3 | HTML |
|  4 | AS   |
+—-+——+

Example

<?php
mysql_connect(“localhost”, “root”, “password”) or die(mysql_error());
mysql_select_db(“database_name”);
echo “<pre>”;
$userQry = mysql_query(“SELECT * FROM users”);
while($userInfo = mysql_fetch_array($userQry)){
print_r($userInfo);
}
?>

Output

Array
(
[0] => 1
[id] => 1
[1] => PHP
[name] => PHP
)
Array
(
[0] => 2
[id] => 2
[1] => JS
[name] => JS
)
Array
(
[0] => 3
[id] => 3
[1] => HTML
[name] => HTML
)
Array
(
[0] => 4
[id] => 4
[1] => AS
[name] => AS
)

It’s deprecated .Escapes a string for use in a mysql_query

It returns the error description of the last MySQL operation

Example

<?php
$conn = mysql_connect(“localhost”, “root”, “password”) or die(mysql_error());
?>

It returns the error number of the last MySQL operation

Example

<?php
$conn = mysql_connect(“localhost”, “root”, “password”) or die(mysql_errno());
?>

Its Deprecated. .Sends a MySQL query

It  delete the databse . Its depricated

It returns database name from the call to mysql_list_dbs()

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 />”;
}
?>

It moves the record pointer

MySQL Table – Users

+—-+——+
| id | name |
+—-+——+
|  1 | PHP  |
|  2 | JS   |
|  3 | HTML |
|  4 | AS   |
+—-+——+

Example

<?php
$conn = mysql_connect(“localhost”, “root”, “password”) or die(mysql_error());
mysql_select_db(“database_name”,$conn);
$userInfo = mysql_query(“SELECT * from users”);
echo “<pre>”;
print_r(mysql_fetch_row($userInfo));
mysql_data_seek($userInfo,3);
print_r(mysql_fetch_row($userInfo));
mysql_close($conn);
?>

Output

Array
(
[0] => 1
[1] => PHP
)
Array
(
[0] => 4
[1] => AS
)