search

Home >Backend Development >PHP Tutorial >PHP interview questions and answers sharing

PHP interview questions and answers sharing

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
2016-07-25 08:53:451086browse
  2. $img = file_get_contents('http://www.baidu.com/img/baidu_logo.gif');
  3. file_put_contents('1.gif',$img);
  4. echo ' ';
  5. ?>
Copy code

3.

  3. function is_gfriend($na,$nb)

  4. {
  5. $random1=rand(1,5);//Calculate that they have 1/5 fate
  6. $ random2=rand(1,5);
  7. if ($random1==$random2)
  8. return $na."+".$nb."You are destined";
  9. else
  10. return $na."+".$nb ."It's a pity that there is no fate";

  11. }

  12. echo is_gfriend(a,b);
  13. ?>

Copy code

4,

Company interview questions: Baidu web development engineer written test questions】

Part one: 1. Explain the meaning of the following statement: document.form["formname"].submit;

2. There are the following statements: Write code so that when the mouse moves over the text box, the content in the text box is automatically selected.

3. Convert character 09 into decimal number.

4. Convert 1234567890 into 1,234,567,890 by separating every 3 digits with commas.

5. I forgot about html and css.

6. Enter a year in the text box, determine its zodiac sign, and output it next to the text box. Both html and javaservlet are required to be written.

7.ajax retrieves data from the server {id:123, name:"baidu", username:"mm",checked:true}; Analyze the value corresponding to name ("baidu"). (The question is long, I can’t remember)

8. Talk about customer experience. (Edited and compiled by Scripting School bbs.it-home.org)

Answer: 1. Get the formname form submit button element.

2,

Copy code

3、

  2. $a="09";
  3. echo ( int ) $a;
  4. echo "
    ";
  5. echo intval("09" ; ])(?=(?:[0-9]{3})+(?![0-9]))/', ',', $num);
  6. echo $num; ?>
Copy code

6,

  2. $t= 1986;
  3. switch ($t)
  4. {
case 1986:
echo "cow";break;case "":
break;

case " ":

break;
...
}
  2. Copy code
  5. 8. Analysis from satisfaction, tolerance, and feedback.
  7. Part 2:
  9. 1. Common ideas of ajax, database trigger, gui, and interrupt mechanism. Let’s talk about this idea (mechanism).
  11. 2. Convert the first letters of all words in an English document to uppercase, and the document is stored in doc.txt. You can choose from a variety of programming languages ​​​​(cc++, java, php...) to write out your ideas and try to optimize your program.
  13. 3. About the data structure of tree.
4. Database optimization: There is a table product(id,name,price,count); When executing the following query, the speed is always very slow: select * from product where price=100; Adding a non-clustered index to the price field, the query speed is still very slow. (1) Analyze the reasons for slow query. (2) How to optimize. 5.

create table topid{

topicid int not null primary key auto_increment,

title text,

author varchar(30),

content blob,

isdeleted int

...... //It seems An index is defined on author

}

create table reply{

topicid int foreign key,
replyid int primary key auto_increment,
replyauthor varchar(30),
    replytime datetime,
  1. context blob
  2. ..../ / Define an index and key
  3. }
  7. Copy the code
  10. One is the topic table and the other is the reply table.
  12. 1. Ask what are the shortcomings of doing this in terms of performance. 2. Query the topics whose reply time does not exceed a specific time period and the author's name of the reply starts with mike title, query as follows: (Edited and compiled by Programmer’s Home bbs.it-home.org)
  18. select * from topic where replyid in (select replyid from reply where
replyauthor like 'mike%' and (currenttime()-replytime
Copy code

What are the shortcomings of the above query statement in terms of performance? How to optimize?

Answer: 1. The database trigger and interrupt mechanism are automatically completed by the database, while the ajax trigger is triggered by the user. Ajax optimizes the GUI and the database asynchronously.

2.

  2. $fp=fopen("aa.txt",'r'); //English document aa.txt
  3. while(!feof($fp)){
  4. $char=fgets ($fp);
  5. }
  6. $e= explode(",",$char);
  7. $write=fopen("doc.txt",'w');//If there is no doc.txt, create
  8. foreach ($ e as $w)
  9. {
  10. if($w==$e[count($e)-1])//The last word is entered without a comma if($w==end($e))
  11. $w= ucwords($w);//Convert the first letter to uppercase
  12. else
  13. $w=ucwords($w).",";
  14. echo $w;
  15. fwrite($write,$w);//Write doc .txt document
  16. }
  17. fclose($write);
  18. fclose($fp);
  19. ?>
Copy code


Statement：
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
Previous article：PHP picture background filling exampleNext article：PHP picture background filling example

Related articles

See more