Its Deprecated. .Sends a MySQL query
Category Archives: PHP
mysql_drop_db()
It delete the databse . Its depricated
mysql_db_name()
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 />”;
}
?>
mysql_data_seek()
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
)
mysql_create_db()
It creates a MySQL database
Example
<?php
$conn = mysql_connect(‘localhost’, ‘root’, ‘passowrd’);
mysql_query(“CREATE DATABASE database_name”, $conn) or die(“Failed”);
?>
mysql_connect()
It open a connection to a MySQL Server
Example
<?php
$conn = mysql_connect(‘localhost’, ‘root’, ‘password’);
echo mysql_client_encoding($conn);
mysql_close($conn);
?>
mysql_close()
It closes MySQL connection
Example
<?php
$conn = mysql_connect(‘localhost’, ‘root’, ‘password’);
echo mysql_client_encoding($conn);
mysql_close($conn);
?>
mysql_client_encoding()
It returns the name of the character set for the current connection
Example
<?php
$conn = mysql_connect(‘localhost’, ‘root’, ‘password’);
echo mysql_client_encoding($conn);
?>
mysql_affected_rows()
It returns the number of affected rows in the previous MySQL operation.
Example
<?php
$con = mysql_connect(“localhost”,”root”,”password”) or die( mysql_error());
mysql_select_db(“databse_name”);
mysql_query(“DELETE FROM table_name WHERE id = 1”);
echo mysql_affected_rows();
mysql_close($con);
?>
zip_read()
It reads the next entry in a ZIP file
Example
<?php
$zp = zip_open(“test.zip”);
while ($zipEntry = zip_read($zp)){
echo “Actuall file name -” . zip_entry_name($zipEntry);
if (zip_entry_open($zp, $zipEntry)){
zip_entry_close($zipEntry);
}
}
zip_close($zp);
?>
Pramod T P 