PHP Basic Knowledge Part
1. Find the value of $a
Copy Code code as follows:
$a = "Hello";
$b = & $a;
Unset ($b);
$b = "World";
echo $a;
2. Find the value of $b
Copy Code code as follows:
$a = 1;
$x = & $a;
$b = $a + +;
Echo $b;
3. Write out a function implementation deletes the specified directory including all subdirectories under it and the file
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 basic Knowledge part
1. Talk about the implementation of JS several ways to inherit, and write demo
2. Talk about your familiar JS framework and achieve the following DOM element acquisition
<div drag= "true" index= "1" ></div>
<div drag= "true" index= "2" ></div>
<div drag= "true" ></div>
requires that you find a div that drag= "true" and index= "1" or no index attribute
tip: If you can't write one at a time, please complete the steps
1. Find drag= "true" and index= "1"
2.
with drag= "true" and no index attribute found
3. Put the two together to get
3. Implements a matte layer effect, requiring that the element to be displayed be centered on the page
4. Closure Knowledge Inspection
Copy Code code 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 Part
1. In a content management system, the table message has the following fields
ID Article ID
Title Post
Content Articles
category_id article Category ID
Hits Click Amount
Create the above table and write the MySQL statement
2. The same content Management system: Table comment Record user reply content, the field is as follows
comment_id Reply ID
ID article ID, ID in the associated message table
comment_content Reply Content
is now through the query database needs 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 quantity Reply Quantity
the above query with an SQL statement, and if the article does not reply, the number of responses is shown as 0
3. The above content management system, the table category saves the classification information, the field is as follows
category_id Int (4) not NULL auto_increment;
categroy_name varchar () not NULL;
the user enters the article, select the article category by selecting the Drop-down menu
write out how to implement this Pull-down menu [use php,javascript,html]
Mysql Knowledge Extension part
4. The system needs to extend the classification table to enable it to support infinite levels of classification, design this table structure and complete the following scenarios according to your design
1. Find all articles under the specified category (including all articles under subcategories)
2. Finds the hierarchy of the specified article's classification to the root category, such as:
article "Mysql optimization Experience" It corresponds to "programming/mysql//" under
3. Delete the classification requirements can also delete all of its sub categories
5. The system needs to add the label function to the article, (the label and the article is the many-to-many relationship), is used to realize "related article" function. Please design this table structure,
and complete the following scenarios according to your design.
1. Find the five articles closest to the specified article (the algorithm of similarity is based on the number of the same label, the larger the number indicates the more similar)
Integrated Knowledge Part:
1. Talk about your understanding of cookies and sessions, what their scenarios are, and how they might be shared in a variety of applications, if possible
2. Talk about your understanding of single sign-on, such as principle and implementation, and what are the issues to be aware of in the implementation process
3. Talk about your understanding of MVC, what are the drawbacks of MVC, and how do you want to implement an MVC framework?
4. How do you understand and implement the Rights Management section that you have used in your normal work?
