Library lending system
The source is phpchina interview question 1 1, and the time format of the previous day printed in PHP is 2006-5-10 22: 21:2, echo (), print (), print_r (. 3.5. What tools are used for version control? 6. How to realize string flipping? 7. The method of optimizing MYSQL database. 8, talk about transaction processing 9, apache+mysql+php method to achieve maximum load 10, method to achieve Chinese string interception without garbled code. Interview question 2 var $ empty = ""; var $ null = NULLvar $ bool = FALSEvar $ notSetvar $ array = array(); 1.$a = "Hello"; $ b = & amp$ a; Not set (b USD); $ b = "world what is $a? 2.$ a = 1; $ x = & amp$ a; $ b = $ a++; What is $b? 3.$ x = empty($ array); What is $x? True or false. Have you ever used version control software? If yes, what is the name of the version control software you use? 5. Have you ever used a template engine? If so, what is the name of the template engine you are using? 6. Please briefly describe your most proud development works. 7. What methods do you use to solve the traffic problem for websites with large traffic? 8. Use PHP: Interview 3 1 to write the code showing the client IP and server IP. PHP/MySQL programming 1) In a content management system, table messages have the following fields: id article id title article content article content category _id article classification id Click to create the above table and write MySQL statement 2) The same content management system as above: table comments record the user's reply content, and the fields are as follows: comment _id, reply id, article id, ID comment _ content reply content in the associated message table. Now you need to query the database to get a list of article titles in the following format, and sort them according to the number of replies. The most number of replies is the top article id. The number of replies to the title of the article is completed by SQL statements. If there is no reply to the article, the number of replies is displayed as 0.3) In the above content management system, the category table stores classification information with the following fields: category _ id int (4) not null auto _ increment; Categroy_name varchar(40) is not empty; When the user inputs an article, he chooses the article classification by selecting the drop-down menu, and writes out how to realize this drop-down menu. 2.PHP file operation 1) The above content management system: after the user submits the content, the system generates a static HTML page; Write the basic idea of implementation. 2) Briefly describe the implementation process and basic idea of user modifying published content. 3. PHP program 1) Write the output of the following program.