Find Jobs
Hire Freelancers

Custom build bulk database upload script in PHP / MySQL

$30-100 USD

Completed
Posted about 10 years ago

$30-100 USD

Paid on delivery
Hi, I have a online yellow pages website. I want PHP / MYSQL Expert to create a small standalone script of bulk uploading the business listenings and dump into database directly. Script should have admin userid and password to access The script should able to allow the following 1. Select file CSV from computer 2. Dropdown field Load automatic Categories from category table and add category id while uploading the listening. 3. Dropdown Sub Categories under main category and add sub category ID while uploading the listening. 4. Dropdown Country then state then city the fields from my excel sheet should map along with above mentioned Category, Sub Category, Country, State and City ID selected from dropdown and upload the listenings into business_master table. There is table in mysql named "business_master" Business Master Table contains following fields id (auto increment) mem_id title (from csv file) category (ID auto get from dropdown) sub_category (ID auto get from dropdown) country (ID auto get from dropdown) state (ID auto get from dropdown) city (ID auto get from dropdown) locality pin code (from csv file) address_1 (from csv file) address_2 (from csv file) fax (from csv file) toll_free (from csv file) email (from csv file) website (from csv file) phone (from csv file) phone_2 (from csv file) contact_name_1 (from csv file) contact_phone_1 (from csv file) contact_name_2 (from csv file) contact_phone_2 (from csv file) status verified viewed created_on (from csv file) created_ip agree description (from csv file) services (from csv file) logo type priority long (from csv file) lat (from csv file) like I have attached all the tables in SQL for you to understand the structure. The script should show the preview before dump the final data into mysql tables. I cannot give access to the whole script or database directly due to security reason. Thats why i have attached the SQL tables how they look like.
Project ID: 5800361

About the project

5 proposals
Remote project
Active 10 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
I have read your project details, and I am interested in offering my services. I provide 100% satisfaction guaranteed on all my work. I have good level of experience in Core PHP , OpenCart , Magento, Wordpress, Drupal ,Joomla, Codeigneter and more. Aim to deliver quality products. Thanks
$80 USD in 2 days
5.0 (20 reviews)
4.1
4.1
5 freelancers are bidding on average $84 USD for this job
User Avatar
Ive checked the structures and can complete the upload along with the dependent drop down. Looking forward to discussing this with you.
$100 USD in 4 days
5.0 (1 review)
2.3
2.3
User Avatar
Dear Sir I have checked your attachment and understand what you wanted I can do this Waiting for your response to talk in details Thanks
$100 USD in 3 days
4.9 (6 reviews)
2.2
2.2
User Avatar
Hi sir! I have installed your database table. I can finish this job in 5 hours. I will not talk about me anymore. Please contact me! Thanks..
$88 USD in 0 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED ARAB EMIRATES
Dubai, United Arab Emirates
5.0
1
Member since Mar 27, 2014

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.