2013 Shandong civil servant interview questions PHP interview question set, with my answers and analysis (1)

Interview question 1
1. Use PHP to print out the time of the previous day in the format of 2006-5-10 22:21:21
2. The difference between echo(), print() and print_r()
3. Able to separate HTML and PHP Open the template for use
4. How to realize PHP and JSP interaction?
5. What tools are used for version control?
6. How to implement string flipping?
7. Methods to optimize MYSQL database.
8. Let’s talk about transaction processing
9. How to achieve maximum load with apache+mysql+php
10. How to intercept Chinese strings without garbled characters.
Answer:
1.echo date('Y-m-d H:i:s', strtotime('-1 day'));
2.echo is a language structure with no return value; the print function is basically the same as echo, the difference is print is a function with a return value; print_r is recursive printing, used to output array objects
3.so much, in fact, PHP itself is a template engine, I have used smarty, common ones include PHPLib, FastTemplate, Savant here There is a list of template engines: http://www.sitepoint.com/forums/showthread.php?t=123769
4. The question is a bit vague. SOAP, XML_RPC, Socket function, and CURL can all implement these. If it is an exam Integration of PHP and Java, PHP has this built-in mechanism (if you are asked about the integration of PHP and .NET, you can also answer this), for example $foo = new Java('java.lang.System');
5.CVS and SVN , SVN is known as the next generation of CVS, with powerful functions, but CVS is an old brand with a high market share. I have always used SVN. The question is about what tool to use. Well, this may need to be answered like this: CVS Server on Apache as the server, WinCVS As the client; Subversion on Apache/DAV as the server, TortoiseSVN as the client, or Subclipse as the client.
6. Use the strrev function. Don’t use PHP’s built-in one, just write it yourself:
function strrev($str)
{
        $len=strlen($str);
         $newstr                                                                                                                        };
}
return $newstr;
}
7. For college entrance examination political questions, write down all the knowledge points you know. My answer:
(1). In terms of database design, this is the responsibility of the DBA and Architect. Design a well-structured database. When necessary, denormalize it (English is this: denormalize, I don’t know the Chinese translation), allow partial data redundancy, and avoid JOIN operations to improve query efficiency
(2). System architecture In terms of design, table hashing is used to hash massive data into several different tables. Fast and slow tables, the fast table only retains the latest data, and the slow table is a historical archive. Cluster, master server Read & write, slave server read only, or N servers, each machine is the master of each other
(3). (1) and (2) exceed the requirements of PHP Programmer, it will be better, it doesn’t matter. Check whether there are less indexes
(4). Write efficient SQL statements, see if there are any inefficient SQL statements written, such as full joins that generate Cartesian products, a large number of Group By and order by, no limit, etc. When necessary, encapsulate the database logic into stored procedures on the DBMS side. Inside. Cache the query results and explain each sql statement
(5). All the results are required. Only get the necessary data from the database, such as querying the number of comments on an article, select count(*) ... where article_id = ? Okay, don’t select * first... where article_id = ? and then msql_num_rows.
Only send the necessary SQL statements. For example, when modifying an article, if the user only modifies the title, then update... set title = ? where article_id = ?Don’t set content = ?(Large text)
(6). Use different storage engines when necessary. For example, InnoDB can reduce deadlocks. HEAP can increase the query speed by an order of magnitude.
8. It is like a programming language. The same as the example of "Hello World". The textbooks in this database will all talk about the example of A transferring $50 to B's account. Just answer this. But as far as I know, companies that use MySQL rarely use MySQL to implement transaction processing. .What’s more, now Oracle has acquired the InnoDB company.
9. See the answer to question 7. Once that place is done, this problem will be solved.
10. Hahaha, I guess the person who asked the question was processed by the Chinese of substr. This problem has been bothering me for a long time. Do you still use the function that is circulated on the Internet and uses regular expressions to match Chinese characters and then intercept them? In fact, there is a very simple solution: mb_substr()
Interview question 2
var $empty = '';
var $ null = NULL;
var $bool = FALSE;
var $notSet;
var $array = array();
1.
$a = "hello";
$b = &$a;
unset($b) ;
$b = "world";
what is $a?
2.
$a = 1;
$x = &$a;
$b = $a++;
what is $b?
3.
$ x = empty($array);
what is $x? true or false
4. Have you ever used version control software? If so, what is the name of the version control software you use?
5. Have you ever used a template engine? If there is a template engine you use, what is the name?
6. Please briefly describe your most proud development work.
7. For high-traffic websites, what method do you use to solve the traffic problem?
8. Use Write the code to display the client IP and server IP in PHP:
The answer will be written once the blog is updated.

The above introduces the 2013 Shandong Civil Servant Interview Questions PHP interview question set, with my answers and analysis (1), including the 2013 Shandong Civil Servant Interview Questions, I hope it will be helpful to friends who are interested in PHP tutorials.