Php Senior Programmer Interview questions (recommended)

1. which speed is the difference between single quotes and double quotes in php faster? Why? (Test basic php skills) 1. which speed is the difference between single quotes and double quotes in php faster? Why? (Test basic php skills)

2. directly exchange the existing two rational values without using new variables. (test basic php skills)

3. convert the PHP numeric amount to the size format and describe the ideas (test the array)

4. the SQL query statement is as follows:
Select * from table where (ID = 10) or (ID = 32) or (ID = 22) or (ID = 76) or (ID = 13) or (ID = 44)
Let the results be retrieved in the order of 10, 32,. how can I write it? (SQL capability)

5. a simple file upload program requires that the number of files uploaded at the same time be manually controlled (logical capability)

6. php simultaneously calls the information of one table in three databases (set up. a. aid = B. b. bid = C. c. cid). describe your ideas and write some code.

7. an IM software is available. the id and email are used as registration conditions. assume that 1040 people have been registered, there is a zh_cn Forum, and id and email are used as registration conditions. assume that 200 people have been registered, there is an en_us forum where id and email are used as registration conditions. assume that you have registered 150 people.
Requirement: synchronize the three, use the unified registration process, and write the design ideas

8. a. write a script, analyze apache access. log, and obtain the top five files with the highest access volume (Unix/Apache)
B. create a database with a table (see the following figure) and authorize it to all users in the 192.168.1. * network segment.
Table requirements: Daily file access, including file name, access IP address, access time, client browser name, consider
How to efficiently find the maximum traffic volume during each day
C. configure the operating system (FreeBSD/Linux) so that it can execute the script to start apache and mysql after it is started into the operating system. 1. which speed is the difference between single quotes and double quotes in php faster? Why? (Test basic php skills)

2. directly exchange the existing two rational values without using new variables. (test basic php skills)

3. convert the PHP numeric amount to the size format and describe the ideas (test the array)

4. the SQL query statement is as follows:
Select * from table where (ID = 10) or (ID = 32) or (ID = 22) or (ID = 76) or (ID = 13) or (ID = 44)
Let the results be retrieved in the order of 10, 32,. how can I write it? (SQL capability)

5. a simple file upload program requires that the number of files uploaded at the same time be manually controlled (logical capability)

6. php simultaneously calls the information of one table in three databases (set up. a. aid = B. b. bid = C. c. cid). describe your ideas and write some code.

7. an IM software is available. the id and email are used as registration conditions. assume that 1040 people have been registered, there is a zh_cn Forum, and id and email are used as registration conditions. assume that 200 people have been registered, there is an en_us forum where id and email are used as registration conditions. assume that you have registered 150 people.
Requirement: synchronize the three, use the unified registration process, and write the design ideas

8. a. write a script, analyze apache access. log, and obtain the top five files with the highest access volume (Unix/Apache)
B. create a database with a table (see the following figure) and authorize it to all users in the 192.168.1. * network segment.
Table requirements: Daily file access, including file name, access IP address, access time, client browser name, consider
How to efficiently find the maximum traffic volume during each day
C. configure the operating system (FreeBSD/Linux) so that it can execute the script to start apache and mysql after it is started into the operating system.