PHP Developer Interview
Technical interview for a PHP developer position. 350k salary fork. There were two tasks: code review and database design, followed by theoretical questions on SQL, PHP, architecture, and security.
Based on the technical interview, I advanced to the next stage.
My TG - https://t.me/+LRgMEl62vxdmNjZi
Timecodes:
00:00 - Introduction
01:06 - First task (code review)
23:12 - Second task (DB design)
56:18 - How is a left join different from an inner join?
56:53 - Have you heard of a cross join?
57:27 - What's the difference between a WHERE and a HAVING?
58:11 - How do indexes affect insert and update operations?
58:49 - How do indexes work?
59:59 - Have you heard of WITH
01:01:52 - common table expression?
01:02:50 - What mechanisms implement atomicity and isolation at the DBMS level?
01:04:26 - What is the difference between read committed and repeatable read?
01:06:17 - What is autoloading in PHP? And can you implement it yourself?
01:09:48 - What is the unserialize function?
01:10:43 - Are arguments passed by reference or by value in PHP?
01:11:51 - Which architecture do you prefer for your applications?
01:15:24 - How to ensure flexibility when switching DBMSs?
01:17:04 - How to minimize risks/instability of external systems?
01:21:14 - What to do if the message broker crashes?
01:21:02 - What are some ways to protect against vulnerabilities?
01:24:43 - How to protect cookies?
01:26:42 - What is a JWT token?
On this page of the site you can watch the video online PHP Developer Interview with a duration of hours minute second in good quality, which was uploaded by the user Mikhail Savin | PHP 26 October 2025, share the link with friends and acquaintances, this video has already been watched 5,607 times on youtube and it was liked by 151 viewers. Enjoy your viewing!
