Php Interview Question for Job

Ques : How can we know the count/number of elements of an array? 

2 ways-
(a) sizeof($urarray) This function is an alias of count()
(b) count($urarray)  

Ques : What is the PHP predefined variable

that tells the What types of images that PHP supports?

Though i am not sure if this is wrong or not, With the exif extension you are able to work with image meta data. 

 

 

Ques : How can I know that a variable is a number or not using a JavaScript?

bool is_numeric ( mixed var) Returns TRUE if var is a number or a numeric string, FALSE otherwise.or use isNaN(mixed var)The isNaN() function is used to check if a value is not a number. 

 

Ques : List out some tools through which we can draw E-R diagrams formysql.

Case StudioSmart Draw

 

Ques : List out the predefined classes in PHP?

DirectorystdClass__PHP_Incomplete_Classexceptionphp_user_filter

Ques : How can I make a script that can be bi-language (supportsEnglish, German)?

You can maintain two separate language file for each of thelanguage. all the labels are putted in both language files as variablesand assign those variables in the PHP source. on runtime choose therequired language option. 

Ques : What are the difference between abstract class and interface?

Abstract class: abstract classes are the class where one or moremethods are abstract but not necessarily all method has to be abstract.Abstract methods are the methods, which are declare in its class but notdefine. The definition of those methods must be in its extending class.Interface: Interfaces are one type of class where all the methods areabstract. That means all the methods only declared but not defined. Allthe methods must be define by its implemented class.

Ques : How can we send mail using JavaScript?

JavaScript does not have any networking capabilities as it isdesigned to work on client site. As a result we can not send mails usingJavaScript. But we can call the client side mail protocol mailtovia JavaScript to prompt for an email to send. this requires the clientto approve it.

Ques : How can we repair a MySQL table?

The syntex for repairing a MySQL table isREPAIR TABLENAME, [TABLENAME, ], [Quick],[Extended]This command will repair the table specified if the quick is given theMySQL will do a repair of only the index tree if the extended is givenit will create index row by row

Ques : How many values can the SET function of MySQL take?

MySQL set can take zero or more values but at the maximum it cantake 64 values

Ques : What are the other commands to know the structure of table usingMySQL commands except explain command?

describe Table-Name; 

Ques : What are the advantages and disadvantages of Cascading StyleSheets?

External Style SheetsAdvantagesCan control styles for multiple documents at once. Classes can becreated for use on multiple HTML element types in many documents.Selector and grouping methods can be used to apply styles under complexcontextsDisadvantagesAn extra download is required to import style information for eachdocument The rendering of the document may be delayed until the externalstyle sheet is loaded Becomes slightly unwieldy for small quantities ofstyle definitionsEmbedded Style SheetsAdvantagesClasses can be created for use on multiple tag types in the document.Selector and grouping methods can be used to apply styles under complexcontexts. No additional downloads necessary to receive style informationDisadvantagesThis method can not control styles for multiple documents at onceInline StylesAdvantagesUseful for small quantities of style definitions. Can override otherstyle specification methods at the local level so only exceptions needto be listed in conjunction with other style methodsDisadvantagesDoes not distance style information from content (a main goal ofSGML/HTML). Can not control styles for multiple documents at once.Author can not create or control classes of elements to control multipleelement types within the document. Selector grouping methods can not beused to create complex element addressing scenarios

Ques : What are the advantages/disadvantages of MySQL and PHP?

Both of them are open source software (so free of cost), supportcross platform. php is faster then ASP and JSP.

Ques : What is the functionality of md5 function in PHP?

Calculate the md5 hash of a string. The hash is a 32-characterhexadecimal number. I use it to generate keys which I use to identifyusers etc. If I add random no techniques to it the md5 generated nowwill be totally different for the same string I am using.

Ques : How can I load data from a text file into a table?

you can use LOAD DATA INFILE file_name; syntax to load datafrom a text file. but you have to make sure thata) data is delimitedb) columns and data matched correctly