Which will be faster out of these two queries – one with OR or one with IN?
Where does MyISAM cache table records?
Which will be faster out of queries with explicit INNER JOIN and implicit one?
Is InnoDB faster/better than MyISAM?
Is CHAR faster than VARCHAR?
Is VARCHAR(80) faster than VARCHAR(255)?
Are there performance issues when joining tables from different storage engines?
If I see Using temporary; Using filesort” in the Extra column of EXPLAIN output, does that mean a temporary table is created on disk?
Is it possible to do a FULL OUTER JOIN in MySQL?
How do you show the currently running queries? – SHOW FULL PROCESSLIST;
How do you kill a MySQL query? – See the ID of it from the question above, then KILL id. You can separate multiple IDs by space.
I need to find out how many client connections were aborted by MySQL server. – It’s displayed in SHOW STATUS query, alternatively accessible via mysqladmin extended-status.
What does SET SQL_AUTO_IS_NULL =1 do? – you can find the last inserted row for a table that contains an AUTO_INCREMENT column by issuing WHERE auto_increment_column IS NULL
Would I use print “$a dollars” or “{$a} dollars” to print out the amount of dollars in this example? – In this example it wouldn’t matter, since the variable is all by itself, but if you were to print something like “{$a},000,000 mln dollars”, then you definitely need to use the braces.
How do you define a constant? – Via define() directive, like define (“MYCONSTANT”, 100);
How do you pass a variable by value? – Just like in C++, put an ampersand in front of it, like $a = &$b
Will comparison of string “10” and integer 11 work in PHP? – Yes, internally PHP will cast everything to the integer type, so numbers 10 and 11 will be compared.
When are you supposed to use endif to end the conditional statement? – When the original if was followed by : and then the code block without braces.
Explain the ternary conditional operator in PHP? – Expression preceding the ? is evaluated, if it’s true, then the expression preceding the : is executed, otherwise, the expression following : is executed.
How do I find out the number of parameters passed into function? – func_num_args() function returns the number of parameters passed in.
If the variable $a is equal to 5 and variable $b is equal to character a, what’s the value of $$b? – 100, it’s a reference to existing variable.
What’s the difference between accessing a class method via -> and via ::? – :: is allowed to access methods that can perform static operations, i.e. those, which do not require object initialization.
Are objects passed by value or by reference? – Everything is passed by value.
How do you call a constructor for a parent class? – parent::constructor($value)
What’s the special meaning of __sleep and __wakeup? – __sleep returns the array of all the variables than need to be saved, while __wakeup retrieves them.
Why doesn’t the following code print the newline properly?
<?php
$str = ‘Hello, there.\nHow are you?\nThanks for visiting’;
print $str;
?>
Because inside the single quotes the \n character is not interpreted as newline, just as a sequence of two characters – \ and n.
Would you initialize your strings with single quotes or double quotes? – Since the data inside the single-quoted string is not parsed for variable substitution, it’s always a better idea speed-wise to initialize a string with single quotes, unless you specifically need variable substitution.
How come the code <?php print “Contents: $arr[1]”; ?> works, but <?php print “Contents: $arr[1][2]”; ?> doesn’t for two-dimensional array of mine? – Any time you have an array with more than one dimension, complex parsing syntax is required. print “Contents: {$arr[1][2]}” would’ve worked.
What is the difference between characters \023 and \x23? – The first one is octal 23, the second is hex 23.
With a heredoc syntax, do I get variable substitution inside the heredoc contents? – Yes.
Both examples would provide the same result – $var3 equal to “Welcome to.com”. However, Code Sample 1 will work significantly faster. Try it out with large sets of data (or via concatenating small sets a million times or so), and you will see that concatenation works significantly faster than variable substitution.
For printing out strings, there are echo, print and printf. Explain the differences. – echo is the most primitive of them, and just outputs the contents following the construct to the screen. print is also a construct (so parentheses are optional when calling it), but it returns TRUE on successful output and FALSE if it was unable to print out the string. However, you can pass multiple parameters to echo, like:
<?php echo ‘Welcome ‘, ‘to’, ‘ ‘, ‘!’; ?>
and it will output the string “Welcome to!” print does not take multiple parameters. It is also generally argued that echo is faster, but usually the speed advantage is negligible, and might not be there for future versions of PHP. printf is a function, not a construct, and allows such advantages as formatted output, but it’s the slowest way to print out data out of echo, print and printf.
I am writing an application in PHP that outputs a printable version of driving directions. It contains some long sentences, and I am a neat freak, and would like to make sure that no line exceeds 50 characters. How do I accomplish that with PHP? – On large strings that need to be formatted according to some length specifications, use wordwrap() or chunk_split().
What’s the output of the ucwords function in this example?
$formatted = ucwords(” IS COLLECTION OF INTERVIEW QUESTIONS”);
print $formatted;
What will be printed is IS COLLECTION OF INTERVIEW QUESTIONS.
ucwords() makes every first letter of every word capital, but it does not lower-case anything else. To avoid this, and get a properly formatted string, it’s worth using strtolower() first.
What’s the difference between htmlentities() and htmlspecialchars()? – htmlspecialchars only takes care of <, >, single quote ‘, double quote ” and ampersand. htmlentities translates all occurrences of character sequences that have different meaning in HTML.
What’s the difference between md5(), crc32() and sha1() crypto on PHP? – The major difference is the length of the hash generated. CRC32 is, evidently, 32 bits, while sha1() returns a 128 bit value, and md5() returns a 160 bit value. This is important when avoiding collisions.
So if md5() generates the most secure hash, why would you ever use the less secure crc32() and sha1()? – Crypto usage in PHP is simple, but that doesn’t mean it’s free. First off, depending on the data that you’re encrypting, you might have reasons to store a 32-bit value in the database instead of the 160-bit value to save on space. Second, the more secure the crypto is, the longer is the computation time to deliver the hash value. A high volume site might be significantly slowed down, if frequent md5() generation is required.
How do you match the character ^ at the beginning of the string? – ^\^
i want to know answers of all this questions of hardware,network,php and sql,aptitude,ASP.net,C#.net and advance php questions..please send me the answers of above subjects.
these questions r very good and these will help any to improve their hold in php
please send the answers of these questions
thanks to provide such kind of question
i want to know answers of all this questions of hardware,network,php and sql,aptitude,ASP.net,C#.net and advance php questions..please send me the answers of above subjects.
hiii..
good morning
plz send me answar of these question…..
i want answer of all questions and more can i get on my mail
Awesome questions! Its really helpful for php interview. Plz send me answers.
plz send me answers of these questions
send the answers
plz send all answers
please send me ans of these question .
[email protected]
pls send me ans of these technia\cal questions
Hi,
Plz send me answer of these questions. Thanks
pls.. send me ans of these questions.. thank you
Please send me answers all these Questions
plz send me answers all of these answers
please send answers
i want to know the anwsers
I Want ans for these question,plz send
please send the answers,so that i can improve myself
These questions are very goodcan u plz send the answers.thank u.
Hi
Plz send me the answer of all these questions.
Hi,
I want answer for these questions please send me answers of above questions
plz send me ans of these questions..
thanx
Please send me the answers of all the above questions..
thanx
I want the answer of all these question please send me this to my id [email protected]
sir,please send me answers for these questions.
plz send these questions along wit their answers
plz send me answers all of these answers
please send me all the question and answers to this id:[email protected]
Can u send me the answers of all questions
i wanna know the answers for all the unix/linux, network,php,asp.net,c#.net and sql
Hi.
Can u plz send me the all questions and answers
Please send me the answers of all the above questions
Hi.
Can u send me the answers of all questions
I need to know answer to these questions.
please send me the answer of all the topics..
these are all very important questions.
your effort for freshers is appriciable. Please send me the
answers of above questions.
Hi all,
I want answer for these questions please send me answers of above questions
these questions are very goodcan u plz send the answers.thank u.
Please send me the answers of all the above questions.
Thanks
arshad
i will really appreciate if anyone help me .. my mail id is
[email protected]
Thanks
Prasad Oturkar
hello everyone
I want to know the answers of maximum questions . please send me the attached flyer if u have the answers.
Thanks& regards
Prasad Oturkar
I want Answers for these All Questions.
send me the ans
Sorry…i dont need the answers because i know all d answers…. :)
May I know the answers of all the questions above
Can I know all the answers of the questions ? Thanks
Please send me the answer of above all questions
plz send me yhe answers……
plz send me d answers, i really need it plz
i need the answers
Please send me the answers of all the above questions.
Thanks
Arun Singh
I will not provide answers! Go back to school and Learn yourself.
Hi all,
I want answer for these questions please send me answers of above questions
Hi..please send me the answer of all the topics..
these are all very important questions.
i want to know the answers of all of th above que related to php & mysql…i will be greatful if u send me the answers….
i want to know answers of all this questions of sql,aptitude,ASP.net and C#.net ..please send me the answers of above subjects.
Hi…….I wanna know the answer for all these questions………. For all the topics that are listed above……
contact
online railway reservation & computer sales & service contact in warangal 9849197256 kazipet
i want to know answers of all this questions of hardware,network,php and sql,aptitude,ASP.net,C#.net and advance php questions..please send me the answers of above subjects.
plz send me answers of these questions
i want to know the anwsers
these question are very useful so plz send me php nad sql answers .Thanks a lot.
these question are very useful so plz send me php nad sql .Thanks a lot.
send the interview questions regarding it
Hey guy can u fetch ans here?
these questions r very good and these will help any to improve their hold in php
please send the answers of these questions
thanks to provide such kind of question
i want to know answers of all this questions of hardware,network,php and sql,aptitude,ASP.net,C#.net and advance php questions..please send me the answers of above subjects.
i wanna to know awnser of all these question.Please send me the answer.
i wanna to know awnser of all these question