I'd like to ask you some thoughts on the questions of today's php interview.

the written questions for today"s php interview do not have a lot of experience in data processing. I look confused. I would like to ask you some ideas on these questions

.

clipboard.png

question 1: filter out the records in the 5 million data that contain "test" in the memo field and save them in the: output.txt file.
question 2: the first 100000 pieces of data are formatted, and the suffix is output as ID.jpg:1, http://www.test.com/1.jpg. Test data 1 is saved in output2.txt

.
Php
Jan.13,2022

read line by line + regular extract or replace

What's wrong with

?

  1. awk'/ Test / 'demo.txt > > output.txt
    grep' Test 'demo.txt > > output.txt
  2. this is not very [embarrassing]

the subject may want to pay attention to whether the interview focuses on code solving or other methods. If it is a code solution, you can refer to this article: https://codeshelper.com/a/11., which focuses on the reading of very large files by PHP. If you can do it in other ways, you can use awk coding to solve it.

give you the answer to the first question: 

$f  = fopen('body.txt', 'r');
$f2 = fopen('output.txt', 'w');
while (!feof($f)) {
    $line = fgets($f);
    if (mb_stripos($line, '') !== false) {
        fwrite($f2, $line . "\n");
    }
}

the second question can be counted on the basis of the first question, to the end of 10W, each read a comma syncopation, parsing the second URL can.

if you can't answer such a simple question, the result of your interview will be worrying.

Previous: How to achieve the charCodeAt effect in js by php

Next: What is the specification for creating html tags within a rich text editor? What kind of tag will the rich text editor create when you press enter? How can I modify the specification in which it creates tags?

css mysql arrays josn react html typescript webpack npm sass R objective-c .net sql-server jquery python-3.x angularjs django angular excel regex iphone ajax linux xml pandas vba spring database wordpress string wpf xcode windows bash postgresql oracle multithreading eclipse list firebase algorithm macos forms image scala visual-studio azure bootstrap spring-boot react-native python-2.7 docker performance function winforms matlab powershell apache dataframe api sqlite numpy rest shell selenium flutter dart maven loops qt swing android-studio csv express file class tensorflow sorting codeigniter perl
MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1e4486a-44300.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1e4486a-44300.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?