Freshers PHP/MySQL Technical Interview Questions & Answers

Q : In how many ways we can retrieve the data in the result set of
MySQL using PHP?

Answer : You can do it by 4 Ways

1. mysql_fetch_row.
2. mysql_fetch_array
3. mysql_fetch_object
4. mysql_fetch_assoc

Q : How can we create a database using PHP and MySQL?

Answer : We can create MySQL Database with the use of mysql_create_db(“Database Name”).

Q : How can we submit a form without a submit button?

Answer : The main idea behind this is to use Java script submit() function in order to submit the form without explicitly clicking any submit button. You can attach the document.formname.submit() method to onclick, onchange events of different inputs and perform the form submission. you
can even built a timer function where you can automatically submit the form after xx seconds once the loading is done (can be seen in online test sites).

Q : Can we use include (”abc.PHP”) two times in a PHP page “makeit.PHP”?

Answer : Yes we can use include() more than one time in any page though it is not a very good practice.

Q : Functions in IMAP, POP3 AND LDAP?

Q : How can we encrypt and decrypt a data present in a MySQL table using MySQL?

Answer : AES_ENCRYPT () and AES_DECRYPT ()

Q : What is the use of friend function?

Q : What are the differences between public, private, protected,static, transient, final and volatile?

 Q : What are the different types of errors in PHP?

Q : What is the functionality of the function strstr and stristr?

Q : How can we get second of the current time using date function?

Answer : $second = date(”s”);