June 2010 PHP Face Test

June 2010 PHP Face Test

June 2010 PHP Face Test
June 26, 2010
June 2010 PHP Face Test
Interview 1 1 Print the previous day in PHP the time format is 2006-5-10 22:21:21
Print, 2 echo. Print_r differences
3 templates that allow HTML and PHP to be separated from use
4 How to implement PHP JSP interaction?
5 which tools are used for version control?
6 How do I implement string flipping?
7 How to optimize MYSQL database.
8 Talking about transaction processing
9 apache+mysql+php method to achieve maximum load
10 implementation of the text string interception without garbled method.
Interview Question 2
var $empty = ';
var $null = null;
var $bool = FA LSE;
var $notSet;
var $array = Arrai;
1.
$a = "Hello";
$b = & $a;
Unset $b;
$b = "World";
What is $a?
2.
$a = 1;
$x = & $a;
$b = $a + +;
What is $b?
3.
$x = Empti $arrai;
What is $x? True or False
4. Have you ever used version control software? If you have the name of the version control software you are using?
5. Have you ever used a template engine? If you have the name of the template engine you are using?
6. Please give a brief description of your most proud development.
What method do you use to solve the traffic problem 7. For large traffic sites.?
8. Write out the client IP and server IP code in PHP:
Interview Question 3
First, Php/mysql programming
Table Messag has the following field 1 in a content management system.
ID Article ID
Titl article title
Content article contents
CATEGORY_ID article Category ID
Hit hits
Write the MySQL statement to create the previous table.
The fields are as follows 2 the same above Content management system: Table comment Records user reply content.
comment_id Reply ID
ID Article ID associated with ID in MESSAG table
Comment_cont Reply Content
The top of the list is the first to query the database needs to get the following format of the article title lists, and according to the number of replies sorted.
Article ID article title click Reply Quantity
If the article does not reply, the reply quantity is displayed as 0 complete the above query with an SQL statement.
Table Categori Storage Classification information, 3 above content management system. fields are as follows
category_id int 4 NOT NULL auto_increment;
Categroy_nam varchar NOT NULL;
Select the article category by selecting the drop-down menu when the user enters the article.
Write how to implement this drop-down menu
Second, PHP file operation
1
The system generates static HTML pages, and writes out the basic idea of implementing the above Content management system: After the user submits the content.
2 Simple description of user modification to publish content implementation process and basic ideas
Third, PHP Order 1 write out the following program output results
$c? 4:5;
echo $a;
?>
2 Write out the results of the following program
　　
Interview Question 4
One. Brief answer
1. Please indicate the difference between the value of the transfer and the reference in PHP. When is the value passed?
2. What is the function of Error_report in PHP?
3. Please write a function to verify that the e-mail message is properly formatted
Include the obtained parameters. 4. Describe how to get the current execution script path.
Pass it to him. Parameter 1 parameter 2 parameter 3. Description: For example, there is a script www.domain.com.
So now it's possible to write a method similar to the transfer parameter, possibly a GET or POST.
Http://www.domain.com/script.php? Parameter 1= value 1& parameter 2= value 2 ..... Results
5. How to modify the SESSION survival time.
How do I get content? 6: There is a web address http://www.domain.com/xxx.php.
Inside store shaping data, 7. Has a one-dimensional array. Please write a function that arranges him in the order of the big to the small. Requires high efficiency of execution. and explain how to improve the efficiency of execution. This function must be implemented by itself and cannot be used with PHP functions)
8. Please give an example of how to speed up the loading of pages during the development process.
Two. Database Design Questions:
Please design a library Management system database table structure, you can record basic user information, book information, borrowing and returning information; the number of data tables is not more than 6; Please draw a table description table structure (need to explain the field name of each field, field type, field meaning description)
The database design should:
1. Ensure the uniqueness of each user;
2. To ensure the uniqueness of each book; Each book corresponds to a number of books that are not equal to each book; guarantee the uniqueness of each book;
Borrowing behavior and book return should be considered at the same time, 3. The Library information sheet. Consider the borrowing period;
4. Ensure the reference integrity between the Library information table and the user table and the book information table;
5. Limit the maximum number of books that can be borrowed per user
Guaranteed to automatically generate its uniqueness Identification 6. If there is a new user registration or book storage.
7. Support for the following series of reporting requirements:
There is no need to write implementation statements, no specific instructions. It is necessary to ensure that these reports can be implemented with up to one SQL statement in the database design
A daily statistical report: the same day the number of books, the same day the number of books report;
b Real-time reporting:
I. The number of loans and the number of loans available for each of the current books;
Ii. List of all overdue books and users in the current system and their extended days
List of users (including those who do not have a borrowing behavior), write the SQL statement that implements this requirement: Iii. The number of books borrowed by all users in the current system.
Database application:
Describe the complete borrowing behavior and book return behavior respectively; and ensure the integrity of the execution of this series of SQL statements compose a series of SQL statements.
I will not be able to give a verdict if I can't finish it! So please write a detailed answer, the next question is the most important test ability. and ensure that the answer is the order in which it can be executed. e-Mail the results to [email protected] email within two days
With a database implementation, combined with the second problem you design. Requires the use of three-layer structure or multi-layer structure, requires the application of object-oriented thinking programming, if possible, design a set of template mechanism to achieve.
Arrange By Date function: Lists the current loan books.
Numbered User name Title Book Number Loan date
1. Zhang Jin da dyeing workshop 12576587 2004-9-1
2. Liu Xing Journey to the 32131098 2004-9-2
Interview Question 5
The name of the current script (not including the path and query string) is recorded in the predefined variable (1), while the URL linked to the current page is recorded in the predefined variable (2). 1. In PHP.
2. The execution sequence segment outputs (3
Status Code 401 means 4 if the "File not found" Prompt is returned, 3. In HTTP 1.0. The header function is available with the statement (5
4. Array function Arsort function is 6 statement error_report 2047 effect is 7
The database connection string format in 5.PEA R is 8
All Js/vbs scripts on the Web page (that is, remove the script flag and its contents) 9 6. Write a regular expression.
Then use the statement (11 to make apach all extension php files as php script disposition. 7. Use the Apach module to set up the PHP file http.conf first with the statement (10 Dynamic loading PHP module.
The difference is 12 in order to prevent the inclusion of the same file several times, 8. Statements Includ and Requir can include another file in the current file. You can use the statement (13来 instead of it
Thereby the entire class can be resumed later, 9. The properties of the class can be serialized and saved to the session. This uses the function to be 14 unless the (15) is set to on in the php.ini. 10. A parameter of a function cannot be a reference to a variable.
You can use the SQL statement (11.SQL in the left JOIN meaning 16 if Tbl_user records the student's name (name and school number (ID Tbl_score records the student (some students have been expelled after the exam without their records) number (ID and Exam results (score and exam subjects (subject) to print out the names of each student and the corresponding scores of each section.
Heredoc a special kind of string, 12. In PHP. End Flag Required (18
Ability to traverse all files and subfolders under a folder. 13. Write a function.
14. Briefly describe the implementation principle of infinite classification in the forum.
Causes a full-screen window to pop up when it opens, 15. Design a Web page. There is a text box and a button in the window. The user clicks the button to close the window while entering the information in the text box, and the input information is displayed on the main page.
Interview Question 6
List all the menu. There is a Table menu Mainmenu,submenu,url, please use recursive method to write a tree-shaped menu.
Interview question 7
Write the order to find its maximum value. 1-give you three numbers.
php,2-Talk about asp.jsp pros and cons
3-Talk about MVC knowledge
The following table is used to write the 10-digit name of the number of people who have posted the most posts:
Username, member Id.posts,pass,email
Interview Question 8
1-How to tell if a window has been masked by JavaScript.
2-write session running mechanism
Listed in order from small to large. 3-There is an array $a =arrai 4,3,8,9,2; Please reorder them.
4-Prevent SQL injection vulnerability generally with the _____ function.
And can dispose of the abnormal drop line sq5-query online number of people. L
.... WHERE ________

