A PHP interview question - said to be 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. Please briefly describe the paradigm and application of database design. Generally, the 3rd normal form is sufficient for optimizing the table structure. This can not only avoid the application being too complex, but also avoid the inefficiency of the system caused by too large SQL statements.

6. There are multiple records of Id in a table. Find out all the records of this id and display the total number of records. Use SQL statements, views, and stored procedures to implement this.

DELIMITER //
CREATE PROCEDURE ProcGet
(
IN ID_a INT(11)
)
BEGIN
DECLARE EXIT HANDLER FOR SQLEXCEP TION BEGIN END;
 SELECT COUNT(*) AS Sum FROM News Where ID = ID_a;
END;//
CALL ProcGet(88)//

7. There are three columns A, B, and C in the table. Use SQL statements to implement this: when column A is greater than column B, select column A; otherwise, select column B; when column B is greater than column C, select column B; otherwise, select column C.

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);
--Get the total value in 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;
--Get 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;
--Get 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. Please briefly describe the method to optimize the execution efficiency of SQL statements in the project. From what aspects, how to analyze the performance of SQL statements? 9. If the template is a smart template. How to use 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 to display it if using foreach statement?

10. Write a function that can traverse all files and subfolders in a folder. (Directory operation)

11, two tables, city table and province table. They are the relationship tables between cities and provinces respectively.

city: id City Provinceid 1 Guangzhou 1 2 Shenzhen 1 3 Huizhou 1 4 Changsha 2 5 Wuhan 3 ………. Guangzhou province: id Province 1 Guangdong 2 Hunan 3 Hubei ……….

(1) Write a SQL statement to relate two tables to achieve: display the basic information of the city. ? (2) Display fields: city id, city name, province. like: Id (city id) Cityname (city name) Privence (province) . . . .

(2) If you want to count how many cities there are in each province, please use group by to query it. ? Display fields: province id, province name, how many cities it contains.

12. Based on your experience, please briefly describe the steps of software development for software engineering. Which of the following tools have you used: Rational Rose, PowerDesigner, Project, VSS or CVS, and TestDirector? What are the disadvantages? 13. Please briefly describe the difference between threads and processes in the operating system. List the software you have used under LINUX? 14. Please use pseudo language combined with data structure bubble sorting method to sort the following set of data 10 2 36 14 10 25 23 85 99 45.