Question { Oracle, 15656 }

How can we take a backup of a mysql table and how can we
restore it. ?

Answer

backup of a table:
click on phpmyadmin -> open the database -> click on the
table -> click on export button -> give the file name ->
click on go button -> after that select the table create
statement and insert statement after that save the matter as
a text file.

Restore of a table:
click on phpmyadmin -> open the database ->click on import
button -> and select the file location -> and click on go
button.

Question { Cap Gemini, 7316 }

what is local filter

Answer

Generally local filter would apply on a particular block.
(table, crosstab, )

Question { Google, 63291 }

what is the difference between mysql_fetch_array() and
mysql_fetch_row()?

Answer

mysql_fetch_array($resultset, [return type]);
return a row from the result set as an array
return type values:
MYSQL_NUM If return type is mysql_num, we have to use the
column position in the result set.
MYSQL_ASSOC: if return type is mysql_assoc, we have to fetch
the data by using column names in result set.
MYSQL_BOTH: if return type is mysql_both, we have to fetch
the data by using column index or column names in the result
set.

mysql_fetch_rows($resultset);
retrives the row from the result set and move the pointer to
the next record.
we have to retrive the data from the row by using the filed
position in the result set.

mysql_fetch_assoc($resultset);
retrives a row from the resultset as an associative array.
we have to retrive the data by using the columns name in the
result set.

mysql_fetch_object($resultset);
return the row as an object. we have to fetch the data in
the row fetch the column names in the result set as $row->
column name in the result set.

Question { 22447 }

What is the different between cookies and session in php?

Answer

both are used for session tracking.

but there is some difference between these two.

cookies are stored in client side (not secured)
sessions are stored in server side (secured)

Question { 22447 }

What is the different between cookies and session in php?

Answer

keeping track of client request to a webserver from a
browser instance with in a predefined time is called as
session tracking.
we can perform the session tracking in 4 ways.
1) Hidden fields
2) Url rewriting
3) Cookies
4) Session/Http server sessions