Interview experience for a PHPer _ MySQL

Source: Internet
Author: User
In fact, this is not a glorious thing. my original company died because of the highest mortality rate of private enterprises: capital chain break. After nearly half a year, I finally decided to find a new job before the company's office is about to expire. First, let me introduce myself. I am a leader and one of the core developers in the open-source CMS development group. I developed about 70% core interviews.


In fact, this is not a glorious thing. my original company died because of the highest mortality rate of private enterprises: capital chain break. After nearly half a year, I finally decided to find a new job before the company's office is about to expire.
First, let me introduce myself. I am a leader and one of the core developers of an open-source CMS development group and have developed code of about 70% core parts. Able to complete daily work except image processing in linux. I dare not say anything about proficiency, but at least it will happen. Personal abilities:
PHP
XHTML + CSS
JAVAScript
C
Shell
Other requirements for development and work in linux.
My salary requirement: After tax, more than 5 k.
My short-term goals: 2 ~ Three years later, I used c or c ++ to write a program similar to ruby in linux. of course, the syntax must be similar to C and PHP.

Ad Time: ^_^ If you are interested in me, if you can meet my requirements, and your company will not work overtime every day, not every Saturday for free, you can send me a recruitment email jstel # 126.com.


I submitted several copies of my resume. Among them, there are well-known websites in China and unknown small enterprises.

On the first day, I went to A company:
After entering, I found this company as a liar> _
My experience: the company that collects money when it goes in is a liar company.

The next day, a large private company
After entering, Aunt ^_^ of the personnel department gave me a question for me to do. after browsing the question, I found my biggest deficiency: the PHP manual I left is even unable to tell the order of parameters #_#. it is also strange that I have been using my own class libraries without using those functions. This is a big failure, and the questions on this paper are all strange and uncommon questions.
For example:
$ A = 'sb ';
$ A = 'Ni shi ';
Write the print $ sb. $ a result.

Maybe the people who came out with this question are also mixed on chinaunix, which was discussed the day before! -0_0 -!
Then
& $ A = 'BB ';
Write print $ sb. $. $ A result

There is also print < I encapsulated a template class library myself, so I haven't written this for a long time. However, the answer is correct. What's more, they gave me an error ......

What is the difference between single quotation marks and double quotation marks (it is hard to remember whether this company has come out)? do you know this? Please tell me that my mailbox is jstel # 126.com achieverain. I only know that single quotes do not need to be escaped. As for the speed difference between them, sorry, I really don't know.

I lost my temper in the last big question. All three questions are joined by multiple tables for complex queries. I am completely dizzy. If our CMS program has a large number of multi-table joint queries, we can only prove one problem: our database structure design fails.

The final result is not bad. However, their salary is too low, only 3 k, and the project share may just exceed 4 k, which is far from enough for me. So everyone broke up.
The third day, a previous Portal
My most depressing question was my question in this company. I directly gave me a set of C questions, and the results should be miserable. I haven't written C programs for a long time. Although the program knows each other, I don't know if I write it right.
Even more depressing: the first question is to fill in the blank question, which generally means that computer software is divided into _________ software and _____ software, which is indispensable for computers. Without ____ software, the computer cannot complete normal functions. And so on.
This question reminds me of the question required in every computer competition in the school: What is the size of the first computer on Earth? (Don't tell me you don't know # _ %)

After reading my answers and my salary requirements, we continue to break up.

On the fourth day, a startup team got an investment in advance

I did not have any questions, but the engineer responsible for website development chatted with me for a while. He is the Banzhu ^ o ^ Of Joy International Village. I demonstrated the CMS we developed to him. of course, the program for stress testing was not back yet. I only showed the internal demo version. So I promised to try it there.
I have been working here for a day. I found that the organizational management of this team is very good. And the internal culture is well positioned. Everyone's ideas are consistent. Naturally, it will take a lot of detours. I was prepared to stay even if my salary was lower. I wanted to discuss the salary and treatment details the next day, but I am sorry. I am allergic to my company. The next day, my whole body was a little red dragonfly, and no allergens were found. I only had to follow the doctor's advice: stay away from allergic sources #_# break up with this company reluctantly

After a week of rest, I continue to submit my resume.

I have to go to an interview for the most popular website,

The reason why I put them in advertising is: high-paying recruitment, 5 ~ 8 K per month.
I went to the company for an interview and made a set of interview questions. the scope of the study was good. I had a hand-written HTML and simple program analysis. For simple database operations, I did not make a regular expression to determine the legitimacy of the email. I still use my own function library. There are many functions to determine the legitimacy. Unfortunately, this function is in it, I haven't written it for a long time (I haven't written it since I wrote the function Library)
I talked to the owner for a while. I found that he did not ask me to accept me, but also wanted to know how to design a good CMS >_< ~~ I carefully explained to him the design idea and structure of our program. then, he asked me to wait for the following within a week ......
By the way, BS will not recruit PHP programmers on this website, because there are no 5 k persons in charge of the development department interviewing me. how can ordinary soldiers get higher salaries than the person in charge? Maybe they recruit more C developers than 8 K in linux, but for me, they do fake ads.

Finally, a Canadian company's wholly owned subsidiary in China
This company has been tossing me for almost a month.
The interview questions I did there are totally different from those I did before. The five questions are from simple to difficult cases, and they feel good. Then I spoke good English when chatting with my boss. Then I contacted Canada and chatted with foreigners. Unexpectedly, we had a very speculative chat. he also liked fantasy ^_^ and assigned me two cases as the review questions. During the review, I had a great chat with a few foreigners in charge.
The company's questions reflect the style of foreigners. they only depend on your ability to complete tasks.


Summary:
Candidates for PHP programmers should:
English (whether you say he is a bird or an e-language, in short, this is a must. at this stage, all the materials read are in english, and Chinese documents cannot be found,)
PHP (nonsense ),
HTML,
JAVAScript,
The so-called AJAX (of course, you can directly use the xajax Library ),
Smarty, I really don't want to change my habits, so I tried my best to encourage my companies to give up smarty ^ o ^. To be honest, smarty is too powerful. We may only use 30% of its functions. why not write a template class with only 30% functions directly ?),
Regular expressions (I often use the previously encapsulated libraries, so I suffered a huge loss ),
SQL (including common queries and common function usage, such as password and left join) and etc...
If you are applying for some depressing companies, all photoshop and dreamweaver skills will be required.
For some jobs, it is best to have relevant experience, such as database optimization under large loads, multi-server load balancing, and server security maintenance.
There is also some common sense: such as bug management, version control, precautions for multi-person cooperation, code style, etc.

There are many companies I have interviewed. the above are some typical examples. In general, some company's questions come out in a strange way, such as the first one. I may not be able to encounter any problems in my life. (have you noticed that single quotes and double quotes are faster ?) Some companies come at will. for example, the second company has taken a set of C questions directly. if they have never learned C before, or have used C as a project, they simply cannot do it. Although everyone said that the process-oriented part of PHP is directly copied from C, there is a difference after all. don't expect that you have never learned C, but what memcpy () will be used only by PHP users (), and the first blank question is too bullshit... Some companies have good questions, such as the third. As for the fourth place, I like it very much. they created a good atmosphere. They were originally prepared. as a result, my body was not allowed. Foreign companies are very practical. there is nothing strange about it. it depends on your ability to solve problems.
Maybe I have a higher requirement, but I think: I am worth the money. At least one of them has experience in project management, collaborative programming, and server maintenance (although only familiar with win and red hat linux ), people who are used to using cvs and bugzilla are not that easy
Alas, achieverain is still unemployed... continue to write my website management system. or that sentence, if you want to find a studio to help you solve website problems. Just look for me. if you think you can meet my requirements, just look for me. if you have an outsourcing project, just look for me, if you want to buy a php website management system, just look for me. @ Just look for me infinitely ......

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.