Writing a simple script in PHP
File names are digital "articles" of goods, the content of the files is the "description" field.You need a simple script: in the file recovery cycle we update the MySQL "products_description" type TEXT field with the content of the text file on the condition of the file name - the VARCHAR field "products_model_descr". We have a log of success and a log of errors in the same folder.
80 thousand files.
UPDATE products_description SET products_description = содержимое_файла WHERE products_model_descr = имя_файла_без_txt;
ну и в отдельный лог записывать имена обработанных файлов и в отдельный ошибки
Client's review of cooperation with freelancer
Writing a simple script in PHPthank you. Artem did everything quickly and quality.
![]()
Freelancer's review of cooperation with client
Writing a simple script in PHPEverything was easy and clearly explained, quickly understood in any emerging issues.
![]()
-
Hi, ready to help, write to Skype andriy-kuzjmych or here )
-
1 day6 USD
626 76 1 1 day6 USDGood day, I will do it in a half hour, call me.
–
by Skype: fpbeat
Posts Tagged: t.me/fpbeat
-
67 Hello to you! I am a developer with experience. I do as quickly as possible. It takes several files for the example, the structure of the database. Go to turn!
Telegram - @Sasha2018RL
HTTPS://t.me/Sasha2018RL
-
6146 86 0 Hello Andrei. I am a full-steck developer, I can implement your task quite quickly. You will need a couple of files for the example and the database that you need to enter the data.
-
236 1 0 Good day .
I will help you solve your question.
Experience in PHP development.
The connection:
here in personal messages;
by: @Gercee
-
2641 427 9 1 Сделаю
==- =-= -=- =-=- =- =- =-= -=-= -= -=- =- =- =- =- =- =- =- =- =- =- =- =- =- =-= -= -
Current freelance projects in the category Databases & SQL
Resolve the loading issue on the PrestaShop website hostingThe website requires more and more resources each month. The host's response: During the server check, increased load from the MySQL database server was recorded. At times of the 500 error, the MySQL process uses a significant portion of CPU resources, which can lead to unstable… PHP, Databases & SQL ∙ 20 hours 22 minutes back ∙ 26 proposals |
Setting up a backup system and optimizing server infrastructureObjective of the work: Ensure reliable data storage for the CRM system and application by implementing an automated backup system, as well as carry out a series of server improvements to enhance the stability, security, and performance of the infrastructure. DevOps, Databases & SQL ∙ 21 hours 52 minutes back ∙ 23 proposals |
PIM system
225 USD
A PIM system needs to be created. The number of products is several million. There are several suppliers providing data in different formats: csv, xml, API. The data is limited, and often it is necessary to find product characteristics from other sources and supplement them. A… Databases & SQL, Web Programming ∙ 23 hours 49 minutes back ∙ 39 proposals |
Integration of BAS Shveyka 8
225 USD
Good day, it is necessary to integrate BAS Shveyka 8, connect the website and CRM Sales Drive, set up reports and other data. Databases & SQL ∙ 1 day back ∙ 9 proposals |
Create a dashboard in https://airtable.com/ for the performance of advertising creatives from Facebook ads.Full specification https://docs.google.com/document/d/1_n_oYRNZWYxalUA---DM5AD1b5ZSrtePw5J4G42svGw/edit?usp=sharing Databases & SQL, Data Parsing ∙ 1 day 19 hours back ∙ 17 proposals |