Collection of classic PHP interview questions_PHP tutorial-PHP Tutorial-php.cn

Table of Contents

Collection of classic PHP interview questions

Home

Backend Development

PHP Tutorial

Collection of classic PHP interview questions_PHP tutorial

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jul 13, 2016 am 10:02 AM

php main common tidy article of classic test questions

Collection of classic PHP interview questions

This article mainly introduces the collection of classic PHP interview questions. It collects and organizes common PHP interview questions and related reference answers for your reference. , friends in need can refer to it

This article analyzes classic PHP interview questions in more detail. Share it with everyone for your reference. The details are as follows:

I did some PHP questions on the Internet, and I have reached this point without realizing it...posting the answers for reference.

1. Use PHP to print out the time of the previous day in the format of 2006-5-10 22:21:21 (2 points)

1 2	$a = date("Y-m-d H:i:s", strtotime("-1 day")); print_r($a);

1 2

$a = date("Y-m-d H:i:s", strtotime("-1 day"));

print_r($a);

2. The difference between echo(), print() and print_r() (3 points)

echo and print are not a function, but a language structure

int print(string $arg), only one parameter

echo arg1,arg2; can output multiple parameters and return void

1 2	$arr = array("key"=>"value"); print_r($arr);

echo and print can only print out strings, not structures print_r can print out the structure For example

1 2	$arr = array("key"=>"value"); print_r($arr);

function reverse($str)

{

$ret = "";

len=mbstrwidth(str,"GB2312");

for(i=0;i< len;i )

{

arr[]=mbsubstr(str, $i, 1, "GB2312");

}

return implode("", array_reverse($arr));

}

print_r(reverse("你好"));

3. A template that allows HTML and PHP to be used separately (1 point)

smarty,phplib

4. What tools are used for version control? (1 point)
svn,git,cvs

5. How to implement string flipping? (3 points)
English:
strrev($a)
Chinese or other text:

Chinese: GB2312, the code is encoded using GB2312

CURRENT_TIMESTAMP()

DATE_FORMAT()

select DATE_FORMAT("2011-11-21 10:10:10", "%Y-%m-%d");

1	mb_substr($str, 1, 1, "GB2312");

9<🎜> <🎜>10<🎜> <🎜>11<🎜> <🎜>12<🎜>

<🎜> <🎜> <🎜>function reverse($str)<🎜> <🎜>{<🎜> <🎜>$ret = "";<🎜> <🎜>len=mbstrwidth(str,"GB2312");<🎜> <🎜>for(i=0;i< len;i )<🎜> <🎜>{<🎜> <🎜>arr[]=mbsubstr(str, $i, 1, "GB2312");<🎜> <🎜>}<🎜> <🎜>return implode("", array_reverse($arr));<🎜> <🎜>}<🎜> <🎜>print_r(reverse("Hello"));<🎜> <🎜>

<🎜> <🎜> <🎜> <🎜>6. Methods to optimize MYSQL database. (4 points, write more and get more)<🎜> In terms of sentences: <🎜> 1 Use indexes to increase query efficiency<🎜> 2 Optimize query statements and improve index hit rate<🎜> Database involved: <🎜> 1 Construct sub-databases and sub-tables to improve the storage and expansion capabilities of the database <🎜> 2 Use different storage engines as needed <🎜> <🎜>7. What does PHP mean (get 1 point)<🎜> HyperText Preprocessing Language<🎜> Hypertext PreProcessor<🎜> <🎜>8. What is the function of MYSQL to obtain the current time?, and the function of formatting date is (2 points) <🎜> <🎜> <🎜> <🎜> <🎜>?<🎜>

<🎜>1<🎜> <🎜>2<🎜> <🎜>3<🎜>

<🎜> <🎜>CURRENT_TIMESTAMP()<🎜> <🎜>DATE_FORMAT()<🎜> <🎜>select DATE_FORMAT("2011-11-21 10:10:10", "%Y-%m-%d");<🎜> <🎜>

<🎜> <🎜> <🎜> <🎜>9. A method to intercept Chinese text strings without garbled characters. (3 points)<🎜> <🎜> <🎜> <🎜> <🎜>?<🎜>

<🎜>1<🎜>

<🎜> <🎜>mb_substr($str, 1, 1, "GB2312");<🎜> <🎜>

10. Have you ever used version control software? If so, what is the name of the version control software you used? (1 point)
svn
git

11. Have you ever used a template engine? If so, what is the name of the template engine you used? (1 point)
smarty

12. Please briefly describe your most proud development work (4 points)
XXX

13. For websites with high traffic, what methods do you use to solve the traffic problem? (4 points)
1 Use cache effectively to increase cache hit rate
2 Use load balancing
3 Use CDN to store and accelerate static files
4 ideas to reduce database usage
5 Check where the statistical bottlenecks are

14. Use PHP to write the code to display the client IP and server IP 1 point)
$_SERVER["REMOTE_ADDR"]
$_SERVER["SERVER_ADDR"]

15. What is the difference between the include and require statements? To avoid including the same file multiple times, you can replace them with (?) statements? (2 points)
On failure:
include generates a warning, while require generates an error interrupt
require is loaded before running
include is loaded at runtime
require_once
include_once

16. How to modify the survival time of SESSION (1 minute).
session_set_cookie_params

17. There is a web page address, such as the PHP Research Laboratory homepage: http://www.jb51.net/index.html, how to get its content? ($1 point)
file_get_contents
curl

18. In HTTP 1.0, the meaning of status code 401 is (?); if the prompt "File not found" is returned, the header function can be used, and its statement is (?); (2 points)
Unauthorized

1	header("HTTP/1.0 404 Not Found");

header("HTTP/1.0 404 Not Found");

fast CGI:

1	header("Status: 404 Not Found");

1	header("Status: 404 Not Found");

$a = <

good test

EOD;

19. In PHP, heredoc is a special string, and its end mark must be? (1 point)

Appear in pairs

$a = <
good test

EOD;

20. Talk about the advantages and disadvantages of asp, php and jsp (1 point)

asp needs to rely on IIS and is a language developed by Microsoft

PHP and JSP can rely on other servers such as apache or nginx

$str = "jianfeng@126.com";

regex="([a−z0−9.−] )@([da−z.−] ).([a−z.]2,6)" ; //正则

return preg_match(regex,str)

21. Talk about your understanding of mvc (1 point)<🎜> model: data structure layer<🎜> view: show <🎜> control: Receive and judge processing input<🎜> <🎜>22. Write the SQL of the names of the ten people with the most posts, using the following table: members (id, username, posts, pass, email) (2 points) <🎜> select top 10 id,username from members order by posts desc<🎜> <🎜>23. Please explain the difference between passing by value and passing by reference in PHP. When to pass by value and when to pass by reference? (2 points)<🎜> & means passing a reference<🎜> Passing parameters by reference in a function will change the parameters<🎜> Generally, you can consider using references <🎜> when there are multiple output parameters. <🎜>24. What is the function of error_reporting in PHP? (1 point)<🎜> Set the display level of error <🎜> <🎜>25. Please write a function to verify whether the format of the email is correct (2 points)<🎜> <🎜> <🎜> <🎜> <🎜>?<🎜>

<🎜>1<🎜> <🎜>2<🎜> <🎜>3<🎜>

<🎜> <🎜>$str = "jianfeng@126.com";<🎜> <🎜>regex="([a−z0−9.−] )@([da−z.−] ).([a−z.]2,6)" ; //Regular <🎜> <🎜>return preg_match(regex,str)<🎜> <🎜>

26. Briefly describe how to get the current execution script path, including the obtained parameters. (2 points)
$argc --Get the number of parameters
$argv --Get parameter list

27. How to modify the survival time of SESSION. (1 point)
session_set_cookie_params

28. What is the function to pop up a dialog box in a JS form? What is the function to get input focus? (2 points)

alert()
confirm()
promopt()
focus()

29. What is the redirection function of JS? How to introduce an external JS file? (2 points)

30. What is the difference between foo() and @foo()? (1 point)

1 2	window.location.href="#"

1 2

window.location.href="#"

class myclass

{

}

@ stands for all warnings and is ignored 31. How to declare a class named "myclass" without methods and attributes? (1 point)

1	$myclass = new myclass();

2 3

class myclass

{

}

class A

{

public $name = "A";

}

$a = new A();

n=a->name;

print_r($n);

32. How to instantiate an object named "myclass"? (1 point)

mysql_connect("localhost", "mysql_user", "mysql_password") or

die("Could not connect: " . mysql_error());

mysql_select_db("mydb");

$result = mysql_query("SELECT id, name FROM mytable");

while (row=mysqlfetcharray(result, MYSQL_ASSOC)) {

printf ("ID: %s Name: %s", row["id"],row["name"]);

}

mysql_free_result($result);

$myclass = new myclass();

33. How do you access and set the attributes of a class? (2 points)

echo "{html}"

echo <

{html}

EOD;

1<🎜> <🎜>2<🎜> <🎜>3<🎜> <🎜>4<🎜> <🎜>5<🎜> <🎜>6<🎜> <🎜>7<🎜> <🎜>8<🎜>

<🎜> <🎜> <🎜>class A<🎜> <🎜>{<🎜> <🎜>public $name = "A";<🎜> <🎜>}<🎜> <🎜>$a = new A();<🎜> <🎜>n=a->name; print_r($n);

34. What is the difference between mysql_fetch_row() and mysql_fetch_array? (1 point) mysql_fetch_array() is an extended version of mysql_fetch_row(). In addition to storing data in an array as a numerical index, you can also store data as an associative index, using the field name as the key. ?

1 2 3 4 5 6 7 8 9

<🎜>mysql_connect("localhost", "mysql_user", "mysql_password") or<🎜> <🎜>die("Could not connect: " . mysql_error());<🎜> <🎜>mysql_select_db("mydb");<🎜> <🎜>$result = mysql_query("SELECT id, name FROM mytable");<🎜> <🎜>while (row=mysqlfetcharray(result, MYSQL_ASSOC)) {<🎜> <🎜>printf ("ID: %s Name: %s", row["id"],row["name"]);<🎜> <🎜>}<🎜> <🎜>mysql_free_result($result);<🎜> <🎜>

<🎜> <🎜> <🎜> <🎜>35. What is the GD library used for? (1 point)<🎜> <🎜>Dynamic open image processing library<🎜> <🎜>36. Point out some ways to enter a piece of HTML code in PHP. (1 point)<🎜> <🎜> <🎜> <🎜> <🎜>?<🎜>

<🎜>1<🎜> <🎜>2<🎜> <🎜>3<🎜> <🎜>4<🎜>

<🎜> <🎜>echo "{html}"<🎜> <🎜>echo < <🎜>{html}<🎜> <🎜>EOD;<🎜> <🎜>

37. Which of the following functions can open a file to read and write the file? (1 point) c
(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 point) b
(a) $users[] = ‘john’;
(b) array_add($users,'john');
(c) array_push($users,‘john’);
(d) $users ||= ‘john’;

39. Will the following program be input? (1 point) 10

$num = 10;

function multiply(){

num=num * 10;

}

multiply();

echo $num;

1 2

3

4

5

$num = 10;

$mysql_db=mysql_connect("local","root","pass");

@mysql_select_db("DB",$mysql_db);

$sql = sprintf("select * from %s where UserName = '%s'",

"表名",

"张三");

values=mysqlquery(sql);

while(item=mysqlfetchqueryarray(values))

{

echo sprintf("用户名：%s, 电话 %s, 学历： %s, 毕业日期： %s",

item['UserName'],item['Tel'], item['Content'],item['Date']

);

}

function multiply(){ num=num * 10;

}

multiply();

echo $num;

class test{

function Get_test($num){

num=md5(md5(num)."En");

return $num;

}

$test = new test();

ret=test->Get_test(11);

print_r($ret);exit;

40. Use PHP to write a simple query to find out all the content named "Zhang San" and print it out (2 points) Table Name UserName Tel Content Date Zhang San 13333663366 Graduated from college 2006-10-11 Zhang San 13612312331 Bachelor degree 2006-10-15 Zhang Si 021-55665566 Graduated from technical secondary school 2006-10-15 Please complete the code according to the above question: ?

1 2 3 4 5 6 7 8 9 10 11 12

$mysql_db=mysql_connect("local","root","pass"); @mysql_select_db("DB",$mysql_db); $sql = sprintf("select * from %s where UserName = '%s'", "table name", "Zhang San"); values=mysqlquery(sql); while(item=mysqlfetchqueryarray(values)) { echo sprintf("Username: %s, phone number %s, education: %s, graduation date: %s", item['UserName'],item['Tel'], item['Content'],item['Date'] ); }

41. How to use the following classes and explain what they mean? (3) ?

1 2 3 4 5 6 7 8 9

class test{ function Get_test($num){ num=md5(md5(num)."En"); return $num; } } $test = new test(); ret=test->Get_test(11); print_r($ret);exit;

Associate the 32-bit string a1 generated after num is MD5 encoded with "En" and then perform MD5 encoding again

42. Write the format of SQL statements: insert, update, delete (4 points)
Table Name UserName Tel Content Date
Zhang San 13333663366 Graduated from college 2006-10-11
Zhang San 13612312331 Bachelor degree 2006-10-15
Zhang Si 021-55665566 Graduated from technical secondary school 2006-10-15
(a) There is a new record (Xiao Wang 13254748547 graduated from high school 2007-05-06). Please use SQL statements to add it to the table
insert into table name values('Xiao Wang', '13254748547', 'High School Graduation', '2007-05-06')
(b) Please use sql statement to update Zhang San’s time to the current system time
update table name set Date = GETDATE() where UserName = "Zhang San"
(c) Please write to delete all records named Zhang Si
delete from indicates where UserName = "张思"

43. Please write the meaning of data type (int char varchar datetime text); what is the difference between varchar and char (2 points)
int integer
char storage fixed length
varchar storage variable length
datetime time
text stores variable-length
varchar is variable length
char(20) fixed length

44. MySQ auto-increment type (usually table ID field) must be set to (?) field (1 point)
auto_increment
45. Write the output of the following program (1 point)

$b=201;

$c=40;

a=b>$c?4:5;

echo $a;

1 2

3

4

$b=201;

$c=40;

a=b>$c?4:5;

1	mysql_num_rows()

echo $a;

46. Is there a function that detects whether a variable is set? What is the function that detects whether it is empty? (2 points)

isset()

empty()

47. What is the function to obtain the total number of query result sets? (1 point)

print_r($arr[0]);

reset($arr);

print_r(current($arr));

print_r(array_shift($arr));

1	mysql_num_rows()

1 2	$a[0]; substr($a, 0, 1);

48. $arr = array('james', 'tom', 'symfony'); Please print out the value of the first element (1 point)

1

2

print_r($arr[0]);

reset($arr);

public function __construct()

{

}

public function __destruct()

{

}

print_r(current($arr)); print_r(array_shift($arr));

49. Please separate the array values in question 41 with ',' signs and merge them into string output (1 point) implode 50. a='abcdef'; Please take out the value of a and print out the first letter (1 point) ?

1 2	$a[0]; substr($a, 0, 1);

51. Can PHP be connected to databases such as sql server/oracle? (1 point) Yes There are ready-made libraries 52. Please write the PHP5 permission control modifier (3 points) public private protected 53. Please write the constructor and destructor of php5 (2 points) ?

1 2 3 4 5 6

public function __construct() { } public function __destruct() { }

Programming questions:

1. Write a function to retrieve the file extension from a standard URL as efficiently as possible
For example: http://www.sina.com.cn/abc/de/fg.php?id=1 You need to remove php or .php

$url = "http://www.sina.com.cn/abc/de/fg.php?id=1";

arr=parseurl(url);

pathArr=pathinfo(arr['path']);

print_r($pathArr['extension']);

1 2

3

4

$url = "http://www.sina.com.cn/abc/de/fg.php?id=1";

$a = '/a/b/c/d/e.php';

$b = '/a/b/12/34/c.php';

//获取path相对于conpath的相对路径

function sGetRelativePath(path,conpath)

{

pathArr=explode("/",path);

conpathArr=explode("/",conpath);

$dismatchlen = 0;

for(i=0;i < count(pathArr);i )

{

if(conpathArr[i] != pathArr[i])

{

dismatchlen=count(pathArr) - $i;

arrLeft=arrayslice(pathArr, $i);

break;

}

ret=strrepeat("../",dismatchlen).implode("/", $arrLeft);

return $ret;

}

print_r(sGetRelativePath(b,a));

arr=parseurl(url); pathArr=pathinfo(arr['path']);

print_r($pathArr['extension']);

function aGetAllFile($folder)

{

$aFileArr = array();

if(is_dir($folder))

{

handle=opendir(folder);

while((file=readdir(handle)) !== false)

{

//如果是.或者..则跳过

if(file=="."||file == "..")

{

continue;

}

if(is_file(folder."/".file))

{

aFileArr[]=file;

}

else if(is_dir(folder."/".file))

{

aFileArr[file] = aGetAllFile(folder."/".file);

}

closedir($handle);

}

return $aFileArr;

}

$path = "/home/test/sql";

print_r(aGetAllFile($path));

3. Write a function to calculate the relative paths of two files Such as $a = '/a/b/c/d/e.php'; $b = '/a/b/12/34/c.php'; Calculate the relative path of b relative to a should be http://www.jb51.net/12/34/c.php and add ?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22

3. Write a function that can traverse all files and subfolders in a folder. ?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29

I hope this article will be helpful to everyone’s PHP programming design.

Statement of this Website

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress images for free

Clothoff.io

AI clothes remover

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

How to fix KB5055523 fails to install in Windows 11?

3 weeks ago By DDD

How to fix KB5055518 fails to install in Windows 10?

3 weeks ago By DDD

Roblox: Dead Rails - How To Tame Wolves

4 weeks ago By DDD

Strength Levels for Every Enemy & Monster in R.E.P.O.

4 weeks ago By 尊渡假赌尊渡假赌尊渡假赌

Roblox: Grow A Garden - Complete Mutation Guide

2 weeks ago By DDD

Hot Tools

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

God-level code editing software (SublimeText3)

Hot Topics

Java Tutorial

1659

CakePHP Tutorial

1415

Laravel Tutorial

1309

PHP Tutorial

1257

C# Tutorial

1231

Related knowledge

How do you parse and process HTML/XML in PHP? Feb 07, 2025 am 11:57 AM

This tutorial demonstrates how to efficiently process XML documents using PHP. XML (eXtensible Markup Language) is a versatile text-based markup language designed for both human readability and machine parsing. It's commonly used for data storage an

Explain JSON Web Tokens (JWT) and their use case in PHP APIs. Apr 05, 2025 am 12:04 AM

JWT is an open standard based on JSON, used to securely transmit information between parties, mainly for identity authentication and information exchange. 1. JWT consists of three parts: Header, Payload and Signature. 2. The working principle of JWT includes three steps: generating JWT, verifying JWT and parsing Payload. 3. When using JWT for authentication in PHP, JWT can be generated and verified, and user role and permission information can be included in advanced usage. 4. Common errors include signature verification failure, token expiration, and payload oversized. Debugging skills include using debugging tools and logging. 5. Performance optimization and best practices include using appropriate signature algorithms, setting validity periods reasonably,

Explain late static binding in PHP (static::). Apr 03, 2025 am 12:04 AM

Static binding (static::) implements late static binding (LSB) in PHP, allowing calling classes to be referenced in static contexts rather than defining classes. 1) The parsing process is performed at runtime, 2) Look up the call class in the inheritance relationship, 3) It may bring performance overhead.

PHP Program to Count Vowels in a String Feb 07, 2025 pm 12:12 PM

A string is a sequence of characters, including letters, numbers, and symbols. This tutorial will learn how to calculate the number of vowels in a given string in PHP using different methods. The vowels in English are a, e, i, o, u, and they can be uppercase or lowercase. What is a vowel? Vowels are alphabetic characters that represent a specific pronunciation. There are five vowels in English, including uppercase and lowercase: a, e, i, o, u Example 1 Input: String = "Tutorialspoint" Output: 6 explain The vowels in the string "Tutorialspoint" are u, o, i, a, o, i. There are 6 yuan in total

What are PHP magic methods (__construct, __destruct, __call, __get, __set, etc.) and provide use cases? Apr 03, 2025 am 12:03 AM

What are the magic methods of PHP? PHP's magic methods include: 1.\_\_construct, used to initialize objects; 2.\_\_destruct, used to clean up resources; 3.\_\_call, handle non-existent method calls; 4.\_\_get, implement dynamic attribute access; 5.\_\_set, implement dynamic attribute settings. These methods are automatically called in certain situations, improving code flexibility and efficiency.

PHP and Python: Comparing Two Popular Programming Languages Apr 14, 2025 am 12:13 AM

PHP and Python each have their own advantages, and choose according to project requirements. 1.PHP is suitable for web development, especially for rapid development and maintenance of websites. 2. Python is suitable for data science, machine learning and artificial intelligence, with concise syntax and suitable for beginners.

PHP: A Key Language for Web Development Apr 13, 2025 am 12:08 AM

PHP is a scripting language widely used on the server side, especially suitable for web development. 1.PHP can embed HTML, process HTTP requests and responses, and supports a variety of databases. 2.PHP is used to generate dynamic web content, process form data, access databases, etc., with strong community support and open source resources. 3. PHP is an interpreted language, and the execution process includes lexical analysis, grammatical analysis, compilation and execution. 4.PHP can be combined with MySQL for advanced applications such as user registration systems. 5. When debugging PHP, you can use functions such as error_reporting() and var_dump(). 6. Optimize PHP code to use caching mechanisms, optimize database queries and use built-in functions. 7

PHP in Action: Real-World Examples and Applications Apr 14, 2025 am 12:19 AM

PHP is widely used in e-commerce, content management systems and API development. 1) E-commerce: used for shopping cart function and payment processing. 2) Content management system: used for dynamic content generation and user management. 3) API development: used for RESTful API development and API security. Through performance optimization and best practices, the efficiency and maintainability of PHP applications are improved.

See all articles