One PHP interview question-it is said that it was from a large company

One PHP interview question-it is said that it was from a large company

$ Arr1 = array ( '0' => array ('fid' => 1, 'tid' => 1, 'name' => 'name1 '), '1' => array ('fid' => 1, 'tid' => 2, 'name' => 'name2 '), '2' => array ('fid' => 1, 'tid' => 5, 'name' => 'name3 '), '3' => array ('fid' => 1, 'tid' => 7, 'name' => 'name4 '), '4' => array ('fid' => 3, 'tid' => 9, 'name' => 'name5 ') ); $ Arr2 = array ( '0' => array ( '0' => array ('tid' => 1, 'name' => 'name1 '), '1' => array ('tid' => 2, 'name' => 'name2 '), '2' => array ('tid' => 5, 'name' => 'name3 '), '3' => array ('tid' => 7, 'name' => 'name4 ') ), '1' => array ( '0' => array ('tid' => 9, 'name' => 'name5 ') ) ); 5. briefly describe the database design paradigm and application. Generally, the 3rd paradigm is enough to optimize the table structure. This can avoid the complexity of applications and the low system efficiency caused by too large SQL statements. 6. the Id in a table has multiple records. check all records of this id and display the total number of records. these records are implemented using SQL statements, views, and stored procedures. DELIMITER // Create procedure ProcGet ( IN ID_a INT (11) ) BEGIN Declare exit handler for sqlexception begin end; Select count (*) AS Sum FROM News Where ID = ID_a; END ;// CALL ProcGet (88 )// 7. The table contains three columns a B c, which are implemented using SQL statements: Select Column A if Column A is greater than Column B; otherwise, select column B, if Column B is greater than column C, column B is selected; otherwise, column C is selected. DELIMITER // Create procedure ProcOut () BEGIN Declare exit handler for sqlexception begin end; DECLARE Sum_a INT (11 ); DECLARE Sum_ B INT (11 ); DECLARE Sum_c INT (11 ); -- Obtain the total value of column A <-- DECLARE cur_1 cursor for select sum (A) FROM table_name; OPEN cur_1; FETCH cur _ 1 INTO Sum_a; CLOSE cur_1; -- Obtain the total value in column B <-- DECLARE cur_2 cursor for select sum (B) FROM table_name; OPEN cur_2; FETCH cur _ 2 INTO Sum_ B; CLOSE cur_2; -- Obtain the total value in column C <-- DECLARE cur_3 cursor for select sum (C) FROM table_name; OPEN cur_3; FETCH cur _ 3 INTO Sum_c; CLOSE cur_3; IF Sum_a> Sum_ B THEN Select a from table_name; ELSEIF Sum_ B> Sum_c THEN Select B FROM table_name; ELSE Select c from table_name; End if ;; END ;// CALL ProcOut ()// 8. briefly describe how to optimize the SQL statement execution efficiency in the project. In what ways can we analyze the SQL statement performance? 9. if the template is a smarty template. How to use the section Statement to display an array named $ data. For example: $ Data = array ( [0] => array ([id] = 8 [name] = 'name1 ') [1] => array ([id] = 10 [name] = 'name2 ') [2] => array ([id] = 15 [name] = 'name3 ') ...... ) Write the code on the template page? How can I display it with the foreach statement? 10. write a function to traverse all files and subfolders in a folder. (Directory Operations) 11. two city and province tables. These are the relationship tables between cities and provinces. City: id City Provinceid1 Guangzhou 12 Shenzhen 13 Huizhou 14 Changsha 25 Wuhan 3 .......... Guangzhou province: id Province1 Guangdong 2 Hunan 3 Hubei .......... (1) Write an SQL statement to link two tables. implementation: display the basic information of the city .? (2) display field: City id, city name, and province. For example, Id (City id) Cityname (city name) Privence (province ).... (2) If you want to count the number of cities in each province, use group by to query them .? Display field: province id, province name, and number of cities. 12. based on your experience, briefly describe the steps for software development in software engineering. What are the disadvantages of the following tools used by Rational Rose, PowerDesigner, Project, VSS, CVS, and TestDirector? 13. briefly describe the difference between the operating system thread and process. List the software you have used in LINUX? 14. Use a pseudo-language combined with the data structure bubble sorting method to sort the following data groups 10 2 36 14 10 25 23 85 99 45.