PHP: Download data from Excel (xlsx) to MySQL base
45 USD HTML Form No. 1 :
1 .The user through Form No. 1 downloads the xlsx file to the server.(the car stock)
2ndThe script takes the first tab, with the name OPEL_******, sets the filter by columns: Dealer name: empty, Vehicle Status: 4.C, 5.1.
ThreeFiltered data upload the first MySQL table lines with the fields: Model, Commercial code, Commercial Description, VIN, Color, Target Build Period (only year of release 12/2020 CW52).Before each file processing, the MySQL table is cleaned.In the application file to test STOCK_27042021OV.xlsx
HTML Form No. 2
1 .The user through Form No. 2 downloads the xlsx file to the server.(the price of the model)2ndThe script downloads to another MySQL table the data: Commercial code, Price.Before each file processing, the MySQL table is cleaned.In the application file to test price.xlsx
It also requires a SQL request to create two tables for the above data.We will then draw these data on the WordPress website.
Applications 4
Client's review of cooperation with Aleksey Maslov
PHP: Download data from Excel (xlsx) to MySQL baseThe task is done quickly, even eye quickly. satisfied with the result. I recommend this specialist!
Freelancer's review of cooperation with Yevgeny Galkin
PHP: Download data from Excel (xlsx) to MySQL baseEverything is great! Thank you for the project. pleasure of cooperation. I recommend it.
-
Winning proposal1 day45 USD
571 22 0 Winning proposal1 day45 USD
I make a form and a script. Processing xls with the PHPExcel library. (I will drop it as well)
Applications to create tables are downloaded.
-
5 days89 USD
3507 128 2 4 5 days89 USD
I have worked in web programming for more than three years and have worked with various companies and customers. I can implement your project and re-realize your web programming ideas. Working with me you will get high-quality code and new technology system with modern standards and processing.
Why choose me?
1 . I work without prepaid.
2nd Free support on the site after ordering
Three I will complete my order in the shortest possible time.
-
2. Скрипт берет первую вкладку, с названием OPEL_******, устанавливает фильтр по колонкам: Dealer name: пусто, Vehicle Status: 4.С, 5.1.
-
Всегда один фильтр? Или его нужно указывать в форме?
-
Yevgeny Galkin Мережа автоцентрів "ЛИГА"
Всегда один фильтр.
-
На вордпресс сами будете интегрировать, нужна просто форма без стилей + php скрипт?
-
Yevgeny Galkin Мережа автоцентрів "ЛИГА"
Да, форма без стилей + php скрипт для загрузки.
На интеграцию будем искать наверное другого исполнителя. Или вы с WordPress тоже работаете? 🙂
-
Нет, я с вордпрессом не работаю. Форму и скрипт могу сделать.
-
Yevgeny Galkin Мережа автоцентрів "ЛИГА"
указывайте ставку и сроки
-
Сделал ставку.
-
Если таблицы должны очищаться при новом импорте - то можно их удалять и создавать при отправке формы. Тогда запросы на создание таблиц будут в скрипте.
-
Если таблицы должны очищаться при новом импорте - то можно их удалять и создавать при отправке формы. Тогда запросы на создание таблиц будут в скрипте.
-
Yevgeny Galkin Мережа автоцентрів "ЛИГА"
Нет, не стоит их удалять и создавать. Просто очищать от данных.
-
Current freelance projects in the category PHP
Integration of the "Where to Watch" block (Laravel / Livewire)It is necessary to implement the integration of an external streaming platform for a website about movies and series on Laravel / Livewire. What needs to be done: Implement the import of an external content catalog that is updated once a day. Match content by IMDb ID and/or TMDB… PHP, Web Programming ∙ 8 hours 50 minutes back ∙ 22 proposals |
Refinement of the existing project on Laravel (PHP)Need to refine an existing project on Laravel (PHP). The project includes a ready-made admin panel that has a builder inside it for creating pages through it with layout (html+css+js) using PHP code for data output. In the project, it is necessary to implement 2-3 pages based… Content Management Systems, PHP ∙ 12 hours 26 minutes back ∙ 30 proposals |
New store on Woocommerce
2314 USD
Looking for a developer to create an online store on Woocommerce. Project - a store for daily promotions, popular products in limited quantities. What is already available: layout of all pages (showcase, checkout, content pages, customer account), corporate identity, logo,… PHP, Web Programming ∙ 14 hours 47 minutes back ∙ 89 proposals |
Need to make improvements on the Modx Evolution CMS 3.1.7 site.
22 USD
The design refinement and layout of the website are being developed, and these works will need to be implemented on the site.Also, some adjustments need to be implemented on the site. HTML & CSS, PHP ∙ 18 hours 52 minutes back ∙ 22 proposals |
Implementation of a technical SEO audit on OpenCartGood day. Need to implement technical SEO fixes on the site softugo.com. The site is already developed but not fully launched yet. Platform: ocStore 3.0.2.0 / OpenCart + custom code. Hosting: Hostinger. Current PHP version: 7.3. (transition to PHP 8.2 is planned) A checklist… PHP, Web Programming ∙ 1 day 16 hours back ∙ 58 proposals |
Khmelnitskyi