It creates a MySQL database
Example
<?php
$conn = mysql_connect(‘localhost’, ‘root’, ‘passowrd’);
mysql_query(“CREATE DATABASE database_name”, $conn) or die(“Failed”);
?>
Daily Archives: May 24, 2012
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);
?>
zip_open()
It opens a ZIP file
Example
<?php
$zp = zip_open(“test.zip”);
zip_close($zp);
?>
zip_entry_read()
It reads from an open entry in the 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);
?>
Output
Actuall file name -test.php
zip_entry_open()
It opens an entry in the ZIP file for reading
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);
?>
zip_entry_name()
It returns the name of an entry in the 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);
?>
Output
Actuall file name -test.php
Pramod T P 