PHP junior programmer ability test questions are relatively comprehensive. Experts can reply to the answers one after another~_PHP tutorial

PHP entry-level CODER self-test questions

Note: This test has a full score of 100 points and involves comprehensive knowledge of WEB (Php direction). A passing score of 90 points is required.

BY：PIG 2009.07.14

This question has been posted once. Now I will sort it out and post it again.

----------------------------------------

1. Basic PHP
1. Try to explain the difference between echo and print, require and include. (3 points)
2. Use at least two methods to remove duplicate elements from an array. (3 points)

3. Briefly describe the usage and differences of $_GET and $_POST. (4 points)

4. Describe the usage and difference between COOKIE and SESSION, as well as the connection between them. (6 points)

5. Exchange the values ​​of two variables without using intermediate variables. (3 points)

6. What is escaping? Why escape? (3 points)

7. Construct an array from a to z. (2 points)

8. Try to explain the usage of symbols ->, =>, and the usage of $this, $that. (3 points)

9. Define an abstract class student, and then inherit it from the subclass cs and implement one of its abstract methods do_homework(). (5 points)

2. Front desk WEB basics

10. Try to explain the difference between class and id. (2 points)

11. Get the content in a DIV with ID KEY, and add a LI tag in this DIV, where the text node content is
"I'm a liar". (4 points)

12. Use CSS technology to implement horizontal menu. (5 points)

13. How to refresh the parent frame by the child window. (2 points)

3. Database Basics

14. The code implements changing the table names of all data tables in the MUSIC database. (5 points)

15. There is a data table containing 5 fields (cid, ctitle, cbody, cauthor, ctime). It is now required to extract all the fields of the 40 records after the 800000th record. (4 points)

16. How to store an array object into a field in a data table. (2 points)

17. Try to compare the advantages, disadvantages and usage scenarios of the two storage modes MYISAM and INNODB in MYSQL. (3 points)

18. Let’s talk about some MYSQL optimization methods. (4 points)

4. Algorithms and others.

19. Is md5() an encryption algorithm? How to protect the password from being easily cracked during membership registration? (3 points)

20. Try to describe the idea and code implementation of the "Password Retrieval" function. (5 points)

21. Sort a basically ordered small-scale array. (4 points)

22. Now to establish a city bus query site, please implement its database structure design. (5 points)

23. Construct a regular pattern that matches all current mobile phones, including China Mobile, China Unicom, and China Telecom. (3 points)

24. Use regular expressions or other methods to add commas to numbers, such as 32, 995, 145. (4 points)
25. It is known that the UPC code, which is what we often call the product barcode, has a total of 13 digits, of which the first three digits are the country code (691, 692, 693 for China), and the last digit is the check digit. The check rules are as follows

Sum=(a1+3a2+a3+3a4+…+an-1)

Sum+check=0 mod 10, use code to implement its verification process. (3 points)

26. Find the number of prime numbers less than 10 billion, and the number of 9-digit prime numbers among them. (4 points)

27. Understand MVC and its implementation of static directories. (6 points)