Monthly Archives: May 2012

PHP

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
)

PHP

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);
?>

PHP

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);
?>

PHP

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

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);
?>