PHP Basic Knowledge Section
1. Ask for a value of $ A
Copy the Code code as follows:
$a = "Hello";
$b = & $a;
Unset ($b);
$b = "World";
echo $a;
2. Find the value of $b
Copy the 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
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 the steps
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
Copy the 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 Section
1. In a content management system, the table message has the following fields
ID Article ID
Title of title article
Content article contents
CATEGORY_ID article Category ID
Hits Click Volume
Create the table above and write out the MySQL statement
2. Same above Content management system: Table comment Record user reply content, the fields are as follows
comment_id Reply ID
ID article ID, ID in the associated message table
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 assigned category (including all articles under subcategories)
2. Find the classification of the specified article to the hierarchy of the root category, for example:
The article "Mysql optimization Experience" It corresponds to "program Design/mysql/Operations/"
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 according to your design to complete the following scenarios.
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?
The above describes the interview problem color finishing PHP test paper collection, including the interview questions, I hope the PHP tutorial interested in a friend helpful.
