PHP Pen question 1

PHP Basic Knowledge Section

1. Ask the value of $ A to copy the Code code as follows: $a = "Hello"; $b = & $a; Unset ($b); $b = "World"; echo $a;

2. Ask for the value of the $b copy code code as follows: $a = 1; $x = & $a; $b = $a + +; Echo $b;

3. Write out a function implementation to delete all subdirectories and files under the specified directory, including

4. Write a function that calculates the relative path of two files, such as: $a = '/a/b/c/d/e.php '; $b = '/a/b/12/34/c.php ';

JavaScript Basics Section

1. Talk about JS implementation of several ways to inherit, and write the demo

2. Talk about your familiar JS framework, and implement the following DOM element acquisition

<div drag= "true" index= "1" ></div> <div drag= "true" index= "2" ></div> <div drag= "true" > </div>

Required to find drag= "true" and div with index= "1" or no index attribute

Tip: If you can't write it out at once, please complete step 1. Find drag= "true" and index= "1"

2. Find drag= "true" and no index attribute

3. Linking the two together to obtain

3. Implement a mask layer effect that requires the displayed elements to be centered on the page

4. Closure knowledge Review the copy code code is as follows: Function Step (a) {return function (x) {return x+a++;}}

var a = step (10); var B = Step (20); Alert (A (10)); Alert (b (20)); var a= "123ABC"; Alert (typeof (a++)); alert (a);

MySQL Knowledge Section

1. In a content management system, the table message has the following field ID article ID title article title content article contents category_id article category ID hits click

Create the table above and write out the MySQL statement

2. The same above Content management system: Table comment Record user reply content, fields as follows comment_id Reply ID ID Article ID, associated message table ID comment_content reply content

Now by querying the database need to get the following format of the article title list, and according to the number of replies sorted, reply to the highest ranked in the front

Article ID article title click Reply Quantity

Use an SQL statement to complete the above query, if the article does not reply to the number of replies displayed as 0

3. The above Content management system, table category to save the classification information, the fields are as follows

category_id Int (4) not NULL auto_increment; Categroy_name varchar (+) not null;

When a user enters an article, select the article category by selecting the drop-down menu

Write how to implement this drop-down menu [can use php,javascript,html]

Mysql Knowledge Extension Section

4. The system needs to expand the classification table so that it can support unlimited levels of classification, please design this table structure, and according to your design to complete the following scenarios

1. Find all articles under the specified category (including all articles under subcategories) 2. Find the classification of the specified article to the level of the root classification, for example: The article "Mysql optimization Experience" It corresponds to "program design/mysql/operation/" 3. Deleting a category requires you to delete all sub-categories below it.

5. The system needs to add a label function to the article (the label and the article are many-to-many relationships), for the implementation of the "related article" function. Please design this table structure and complete the following scenarios according to your design.

1. Find five articles closest to the specified article (similarity algorithms are based on the number of identical labels, and the larger the number, the more similar)

Integrated Knowledge Section:

1. Talk about your understanding of cookies and sessions, what their application scenarios are, and how they might be able to explain how the session can be shared under a variety of applications.

2. Talk about your understanding of single sign-on, such as the principle and implementation, as well as the problems in the implementation process to be aware of

3. Talk about your understanding of MVC, what are the drawbacks of MVC, and how do you want to implement an MVC framework if you implement it?

4. How do you understand and implement the Rights Management section that you use in your normal work?