PHP face test Summary, PHP test questions summary
1. The time format of the day before printing with PHP is 2014-01-13 12:10:21 (2 minutes)
2, Echo (), print (), Print_r () difference (3 points)
3, the ability to make HTML and PHP separated from the use of the template (1 points)
4. What tools are used for version control? (1 points)
5, how to implement string rollover? (3 points)
—————————————————————
6, optimize the MySQL database method. (4 points, more write more)
7, the Meaning of PHP (give 1 points)
8. What is the function of MySQL to get the current time?, the function to format the date is (2 points)
9, the implementation of the text string interception without garbled method. (3 points)
—————————————————————
10. Have you ever used version control software? If you have the name of the version control software you are using? (1 points)
11. Have you ever used a template engine? If you have the name of the template engine you are using? (1 points)
12, please briefly describe your most proud of the development of the work (4 points)
13, for the large-volume website, what method do you use to solve the traffic problem? (4 points)
—————————————————————–
14. Use PHP to write the code showing client IP and server IP 1 points)
15. What is the difference between statement include and require? To avoid including the same file multiple times, you can use (?) Statements instead of them? (2 points)
16, how to modify the session's survival time (1 points).
17, there is a web address, such as Collayi home page: http://keleyi.net/default.htm, how to get its content? ($/min)
18, in HTTP 1.0, the meaning of status code 401 is (?); If you get a hint that "file not found" is returned, the header function is available and the statement is (?);( 2 min)
19, in PHP, Heredoc is a special string, its end flag must? (1 points)
20, talk about the advantages and disadvantages of asp,php,jsp (1 points)
21. Talk about MVC (1 points)
——————————————————————-
22, write the number of the top 10 names of SQL, using the following table: Members (Id,username,posts,pass,email) (2 points)
23. Please indicate the difference between the value of the transfer and the reference in PHP. When is the value passed? (2 points)
24. What is the function of error_reporting in PHP? (1 points)
25. Please write a function to verify that the e-mail is in the correct format (2 points)
26. Describe how to get the current execution script path, including the obtained parameters. (2 points)
27. How to modify the lifetime of the session. (1 points)
——————————————————————–
28. JS Form Popup dialog function is? Get the input focus function? (2 points)
29, JS's steering function is? How to introduce an external JS file? (2 points)
30. What is the difference between foo () and @foo ()? (1 points)
31. How do I declare a class with no methods and properties named "MyClass"? (1 points)
32. How to instantiate an object named "MyClass"? (1 points)
33. How do you access and set the properties of a class? (2 points)
34. What is the difference between mysql_fetch_row () and mysql_fetch_array? (1 points)
——————————————————————–
35, what is the GD library for? (1 points)
36. Point out some ways to enter HTML code in PHP. (1 points)
37. Which of the following functions can open a file to read and write to a file? (1 points)
(a) Fget () (b) File_open () (c) fopen () (d) Open_file ()
38. Which of the following options does not add John to the users array? (1 points)
(a) $users [] = ' John ';
(b) Array_add ($users, ' John ');
(c) Array_push ($users, ' John ');
(d) $users | | = ' John ';
39, the following program will enter whether or not? (1 points)
$num = 10;
function Multiply () {
$num = $num * 10;
}
Multiply ();
Echo $num;
?>
40, use PHP to write a simple query, find out all the name "Zhang San" content and print out (2 points)
Table name UserName Tel Content Date
Zhang 313,333,663,366 College Graduation 2006-10-11
Zhang 313,612,312,331 Bachelor's degree 2006-10-15
Zhang Si 021-55665566 secondary school 2006-10-15
Please complete the code according to the above topic:
$mysql _db=mysql_connect ("local", "Root", "pass");
@mysql_select_db ("db", $mysql _db);
41, how to use the following class, and explain what the following mean? (3)
Class test{
function Get_test ($num) {
$num =MD5 (MD5 ($num). " En ");
return $num;
}
}
—————————————————————————-
42. Write the format of the SQL statement: INSERT, UPDATE, delete (4 points)
Table name UserName Tel Content Date
Zhang 313,333,663,366 College Graduation 2006-10-11
Zhang 313,612,312,331 Bachelor's degree 2006-10-15
Zhang Si 021-55665566 secondary school 2006-10-15
(a) A new record (Xiao Wang 13254748547 High school 2007-05-06) please add a SQL statement to the table
(b) Use an SQL statement to update the Zhang San time to the current system time
(c) Please write down all records named Zhang Xi
43. Please write the meaning of the data type (int char varchar datetime text); What is the difference between varchar and char (2 points)
44. MYSQ Self-increment type (usually the table ID field) must be set to (?) Field (1 points)
45, write out the following program output results (1 points)
$b = 201;
$c = 40;
$a = $b > $c? 4:5;
echo $a;
?>
46. Is there a function to detect whether a variable is set or not? is the function empty? (2 points)
—————————————————————————–
47. What is the function that gets the total number of query result sets? (1 points)
48, $arr = Array (' James ', ' Tom ', ' Symfony '); Please print out the value of the first element (1 points)
49. Separate the values of the array of 41 questions with ', ' and combine them into a string output (1 points)
50, $a = ' abcdef '; Please remove the value of $ A and print out the first letter (1 points)
51. Can PHP connect to a database such as SQL Server/oracle? (1 points)
52. Please write out the PHP5 permission control modifier (3 points)
53. Please write the PhP5 constructor and destructor (2 points)
——————————————————————————
54, the following please complete with phpMyAdmin
(a) Create a press release system with the following fields (3 points) for the table named message
ID Article ID
Title of title article
Content article contents
CATEGORY_ID article Category ID
Hits Click Volume
(ii) The same press release system: Table comment Record the user reply content, the field is as follows (4 points)
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
(c) The above Content management system, table category to save the classification information, the field is as follows (3 points)
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
Blank questions
1. In PHP, the name of the current script (not including the path and query string) is recorded in the predefined variable, while the URL linked to the current page is recorded in a predefined variable.
2. The execution of the program segment will be output.
3. In HTTP 1.0, the meaning of status code 401 is; If you return a prompt for "file not found", the header function is available and its statement is.
4. The function of array function arsort is; the function of statement error_reporting (2047) is.
The database connection string format in 5.PEAR is.
6. Write a regular expression that js/vbs all the scripts on the Web page (that is, remove the scrīpt tag and its contents):.
7. Install PHP in the Apache module, in the file http.conf the first to dynamically load the PHP module with a statement, and then use the statement so that Apache will all the files with PHP extension as php script processing.
8. Statements include and require can include another file in the current file, the difference is that, in order to avoid containing the same file more than once, you can replace them with statements.
9. The properties of the class can be serialized and saved to the session so that the entire class can be restored later, which is the function to use.
10. A parameter of a function cannot be a reference to a variable unless it is set to on in PHP.ini.
The meaning of the left join in 11.SQL is. If Tbl_user records the student's name (name) and school number (ID), Tbl_score records the student (ID) and test score (score) and the test subject (subject), which were expelled from the student's exams, without their records. To print out each student's name and the corresponding total, you can use the SQL statement.
12. In PHP, Heredoc is a special string, and its end flag must be.
Programming questions
1. Write a function, as efficiently as possible, to remove the file's extension from a standard URL
For example: http://keleyi.com/a/bjac/4w0otu4n.htm need to remove the HTM or. htm
2. In the HTML language, the meta tag of the header of the page can be used to output the encoding format of the file, the following is a standard META statement
Use the PHP language to write a function that changes the value of the charset part of a standard HTML page like a meta tag to Big5
Please note:
1. The full HTML page needs to be processed, i.e. not only this meta statement
2. Ignore case
3. ' and ' can be interchanged in this place
4. The quotation marks on both sides of ' content-type ' are negligible, but ' text/html; CHARSET=GBK ' on both sides of the No
5. Pay attention to handling extra spaces
3. Write a function that calculates the relative path of the two files
such as $a = '/a/b/c/d/e.php ';
$b = '/a/b/12/34/c.php ';
Calculate $b relative path relative to $a should be: /.. /C/D () Add the
Write a function that can traverse all the files and subfolders under a folder.
http://www.bkjia.com/PHPjc/1083194.html www.bkjia.com true http://www.bkjia.com/PHPjc/1083194.html techarticle PHP Test Questions Summary, PHP Test summary 1, the time format used to print the previous day in PHP is 2014-01-13 12:10:21 (2 minutes) 2, Echo (), print (), Print_r () difference (3 points) 3, can make HTML and PHP separate ...