Test for trying to gain a vacancy of PHP-developer
NOTE: Tasks order present as its appears in the test file.
- REGEXP
Run testRegexp.php
file
For online version use next links:
Matched case:
Unmatched case:
- https://regex101.com/r/V6OYY0/1
- https://regex101.com/r/7Vz7Ex/1
- https://regex101.com/r/WlGKMh/1
- https://regex101.com/r/qIqhoa/1
- TRANSLITERATION
Run testTransliteration.php
file
As output, it must show a transliterated string.
NOTE: Because of quite unclear problem conditions some moments I'm added on my own.
- ARRAYS
Run testArrays.php
file
As output the elements of the result array must be shown.
- RENAME FILES
Run testRenameFiles.php
file
At first all files inside ./TestFList directory will rename. Second, show all files with '.jpg' extension.
NOTE: Full list of directories structure can be found at ./Data/RenameFilesTaskList.txt
- CSV
Run testCSV.php
file
The result file './Data/test.csv' must be created.
- Parser
Run testParser.php
file
NOTE: after run the file, another file ./Data/raw_data_to_parse.txt
will be crated for debug purpose.
-
MySQL. Query associated data
DATABASE TYPE: MySQL DATABASE NAME: testdb
To fill the database use the test_associated.sql
dump file;
IMPORTANT! Before run test file, please specify proper user and password values for $user and #password variables!
Run testMySQL_associated.php
file
If query succeed, the result will print to the stdout and the file './Data/data_db_associated.txt' will create at the same time.
-
MySQL. Remove duplicate record from table
DATABASE TYPE: MySQL DATABASE NAME: testdb
To fill the database use the test_duplicates.sql
dump file.
To delete duplicates directly from MySQL use the delete_duplicates.sql
file.
IMPORTANT! Before run test file, please specify proper user and password values for $user and #password variables!
Run testMySQL_duplicates.php
file
If query succeed, the success message will print to stdout.