- 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.
- I want to combine two variables together:
$var1 = 'Welcome to ';
$var2 = '.com';
- What will work faster? Code sample 1:
$var 3 = $var1.$var2;
Or code sample 2:
$var3 = "$var1$var2";
- 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? – ^\^
