Php Interview Questions and Answers
How can we know that a session is started
A session starts by session_start() function.
This session_start() is always declared in header portion. it always
declares first. then we write session_register().
What are the differences between mysql_fetch_array(),
mysql_fetch_array() -> Fetch a result row as a combination of
associative array and regular array.
mysql_fetch_object() -> Fetch a result row as an object.
mysql_fetch_row() -> Fetch a result set as a regular array().
The difference between mysql_fetch_row() and mysql_fetch_array() is that
the first returns the results in a numeric array ($row, $row,
etc.), while the latter returns a the results an array containing both
numeric and associative keys ($row['name'], $row['email'], etc.).
mysql_fetch_object() returns an object ($row->name, $row->email, etc.).
If we login more than one browser windows at the same time with same
user and after that we close one window, then is the session is exist to
other windows or not? And if yes then why? If no then why?
Session depends on browser. If browser is closed then session is lost.
The session data will be deleted after session time out. If connection
is lost and you recreate connection, then session will continue in the
What are the MySQL database files stored in system ?
Data is stored in name.myd
Table structure is stored in name.frm
Index is stored in name.myi
What is the difference between PHP4 and PHP5?
PHP4 cannot support oops concepts and Zend engine 1 is used.
PHP5 supports oops concepts and Zend engine 2 is used.
Error supporting is increased in PHP5.
XML and SQLLite will is increased in PHP5.
Can we use include(abc.PHP) two times in a PHP page makeit.PHP”?
Yes we can include that many times we want, but here are some things to
make sure of:
(including abc.PHP, the file names are case-sensitive)
there shouldn't be any duplicate function names, means there should not
be functions or classes or variables with the same name in abc.PHP and
What are the differences between mysql_fetch_array(), mysql_fetch_object(),
mysql_fetch_array - Fetch a result row as an associative array and a
mysql_fetch_object - Returns an object with properties that correspond
to the fetched row and moves the internal data pointer ahead. Returns an
object with properties that correspond to the fetched row, or FALSE if
there are no more rows
mysql_fetch_row() - Fetches one row of data from the result associated
with the specified result identifier. The row is returned as an array.
Each result column is stored in an array offset, starting at offset 0.
What is meant by nl2br()?
nl2br() inserts a HTML tag <br> before all new line characters \n in a
echo nl2br("god bless \n you");
How can we encrypt and decrypt a data presented in a table using MySQL?
You can use functions: AES_ENCRYPT() and AES_DECRYPT() like:
How can I retrieve values from one database server and store them in
other database server using PHP?
For this purpose, you can first read the data from one server into
session variables. Then connect to other server and simply insert the
data into the database.
Page Numbers :