Find Jobs
Hire Freelancers

use php to download csv, and import into mysql

$30-250 USD

完了済み
投稿日: 5年近く前

$30-250 USD

完了時にお支払い
script language: PHP database: mysql NO FRAME WORKS Table name varchar state (varchar) 2 letter us state code type varchar(city, county, school district, university, college) url varchar id (auto insert) createddate (auto insert) modifieddate (auto update) the script will need to do the following actions: 1 create the table 2 download the 4 csv file mentioned below 3 import the data into the table A [login to view URL] get the unique LEA_NAME for the name value. Each of the LEA_NAME values is in the csv multiple times. i only want each unique entry in the database once. populate type = "school district" put LEA_NAME into name columnn put ST imto state column put website into url column B [login to view URL] populate type = "county" put the first column into name column convert the state from full name to 2 letter acronym put second column in the state column C [login to view URL] populate type = "city" put NAME into name column put USPS into state column D [login to view URL] populate type = "university" ignore any row where the first column is not US put second column into name column put third column into url column
プロジェクト ID: 20114278

プロジェクトについて

49個の提案
リモートプロジェクト
アクティブ 5年前

お金を稼ぎたいですか?

Freelancerで入札する利点

予算と期間を設定してください
仕事で報酬を得る
提案をご説明ください
登録して仕事に入札するのは無料です
アワード者:
ユーザーアバター
Hi there So I can create PHP script which will download zip files with csv, unpack and import data to created mysql tables in accordance with your project description. Will deliver in an 2 hours or less. Regards, Vladimir
$50 USD 1日以内
4.9 (358 レビュー)
7.6
7.6
この仕事に49人のフリーランサーが、平均$158 USDで入札しています
ユーザーアバター
Hello, I can create this using pure PHP (no framework). It should be run as cron or only one time? I can complete in 24 hours.
$120 USD 1日以内
5.0 (991 レビュー)
8.4
8.4
ユーザーアバター
Hello Nice to meet you. I am a PHP expert with over 10 years experience. I will do my best to satisfy you. I promise quick turnaround times, great customer service and 100% quality work. I look forward to hearing from you. Good luck
$155 USD 3日以内
5.0 (187 レビュー)
7.5
7.5
ユーザーアバター
Hello! Hopefully you are fine! I am a freelancer PHP developer and have experience in PHP script writing. You can view my profile regarding this and can view ther following project as an example: https://www.freelancer.com/projects/php/simple-php-file-handling-task/ Regards Mushrraf Baig
$175 USD 3日以内
5.0 (164 レビュー)
7.6
7.6
ユーザーアバター
Dear client PHP, MySQL expert with 8+ years of experience. Please contact me and let me know your job in detail I can start right now Thanks Regards. Widad
$140 USD 3日以内
5.0 (91 レビュー)
7.3
7.3
ユーザーアバター
Greetings. I'm very happy to have a chance of bidding your project. I am serious bidder here and I have a deep understanding with 11 years of experience in this industry and can deliver as you have mentioned. I can surely do this job and give you an excellent result that will be very acceptable and presentable. Please give me 10 minutes of yours and share your work in more details. Hope your kind contact. Regards. Lian.
$140 USD 7日以内
4.9 (107 レビュー)
6.8
6.8
ユーザーアバター
Dear Sir! I’d like to describe myself as someone who is versatile and determined and someone who loves learning. I am creative, open-minded and easy going and I enjoy working with others. And I tried to use all these qualities in my professional life. Right now, I am looking for an opportunity to apply my technology expertise along with my creative problem solving skills and experiences and passion. I read your job description carefully and I am very interested in your job. My major skills for your job are as following: - HTML5/CSS3(Responsive as well on all devices and all browsers) - Javascript Frameworks and libraries(Angular for 5 years, React.js for 3 years, Vue.js for 3 years, various Jquery Plugins, Bootstrap 3&4) - PHP MVC Frameworks(Laravel, Codeigniter for 7 years, core PHP) - CMS(Wordpress, Magento theme and custom plugin development as well) ... Reading after your job post, I am sure of the success of your project. I promise I will keep the deadline, fix bugs and deliver a qualified code so that you will be satisfied with my work. And I do believe that I can make a positive impact and that’s why I am bidding on your project at the moment. I hope you will also get interested in my proposal and keep in touch with me so that we can discuss the project further more and then start working asap. Looking forward to hearing from you. Best regards.
$150 USD 3日以内
4.9 (93 レビュー)
7.0
7.0
ユーザーアバター
Hello Sir, I can deliver simple php based code to do database insert in 1 day. I am willing to start right away. Please check my profile for work and experience. Regards Ashwin
$120 USD 1日以内
5.0 (276 レビュー)
6.8
6.8
ユーザーアバター
Hello, I read your requirements and understand very-well and ready to start work from now. Thank you
$250 USD 4日以内
4.8 (151 レビュー)
7.1
7.1
ユーザーアバター
⭐Dear Hiring Manager, Thanks for your positng. I have read your description carefully with good experiences in the skills for your project. I hope work for you because my skill set is very suitable to your project. I am confident to handle this project according to your expectations perfectly. I want you visited my profile. https://www.freelancer.com/u/harrysart Please send message so we can discuss further. Best regards.
$150 USD 1日以内
4.9 (133 レビュー)
6.7
6.7
ユーザーアバター
I can do it for you. Please check my reviews and then decide on me. Looking for a long term relationship. Thanks, Ajit
$100 USD 3日以内
4.9 (278 レビュー)
6.8
6.8
ユーザーアバター
Hi there, I am expert level of PHP/Mysql developer. I have already done similar kind of work many times , i mean import csv or excel file into Mysql database in specific manners. Not only import i can make it so you can also export the database into csv so you will get formatted data. I have few things to ask before starting. Thank you
$120 USD 2日以内
5.0 (87 レビュー)
6.5
6.5
ユーザーアバター
Hi. thanks for your posting. I'm very happy to have a chance of bidding your project. I have experience in development of the projects like yours If you hire me, I'll do my best for your project and finish greatly in a short time. I'm sure I can satisfy for you as you want. best regards.
$140 USD 7日以内
5.0 (55 レビュー)
6.0
6.0
ユーザーアバター
Hello Thanks for your good description and i understood what you want. As an experienced developer. I have strong skills and experience in development for 9 years. if have time,visit my profile now. I hope work for you because our skill set is very suitable to your project. If you hire me,you will get good result. I are confident to handle this project according to your expectations perfectly. Please send message so we can discuss more Best regards. RenHu
$140 USD 7日以内
5.0 (39 レビュー)
6.2
6.2
ユーザーアバター
Hello! I am a web developer. I have checked your project description. I can do it fast If you hire me, I am gonna do my best for our project. I guarantee the good result. I will wait for your reply. Thank you.
$140 USD 7日以内
4.9 (26 レビュー)
5.6
5.6
ユーザーアバター
Hi, How are you? Hope you are going well! I checked your project carefully, so that i feel very confident in your project because I am talented web and mobile app developer with 6 years experiences. If you give me all data for the project, I will start working immediately. Also if you want, i will show you my previous projects. I think that you will be get "Best Result" with my working. i would like to discuss about the project over chat. I am waiting for your response. Best regards.
$155 USD 3日以内
5.0 (10 レビュー)
5.2
5.2
ユーザーアバター
Hello, I'm a full time freelancer and am free now. I have read your project description I am very interested in this project. I have a lot of experience in this type of work. I'm sure I can complete it on time with high quality according to your request please get in touch so that we can discuss more and I can start to work immediately. I'm always ready.
$140 USD 3日以内
5.0 (19 レビュー)
5.3
5.3
ユーザーアバター
Hello, I have studied your requirement very well .I can definitely help you out to import csv into mysql and auto create tables. I always prefer client final requirement.I have worked in various web application of different complexity . Please ping me when you have a minute to discuss the project in detail. Thanks.
$120 USD 7日以内
5.0 (27 レビュー)
5.2
5.2
ユーザーアバター
Hello sir, After reviewing your post, I am very interested in that due to my experience. I'm expertise in php, core php, CMS, HTML5, bootstrap, wordPress and many other technologies. I have 8+ year of experience in development & designing. Just give me a response and I assure you won't be disappointed. Looking forward to hear from you and hoping for a long term work relationship. I will satisfy you. Best regards,
$87 USD 7日以内
4.6 (42 レビュー)
5.3
5.3
ユーザーアバター
Hello! I think your project is best for me and send you a bid. I am a web expert who knows the value of time, working hard and always working on time. My motivation is to make my employer feel the greatest satisfaction at a low price. One of my strongest skills is to quickly recognize something new. To confirm this, please see the link below. https://www.freelancer.com/u/finaldragon123?w=f I'd love to hear from you. ⭐⭐⭐⭐⭐ Kind regards! ⭐⭐⭐⭐⭐
$50 USD 3日以内
5.0 (17 レビュー)
4.9
4.9
ユーザーアバター
Hi sir, I can create this script in PHP in max one day. I got what you want. Please let me know if I can help you in that. Thanks a lot..
$140 USD 7日以内
4.6 (21 レビュー)
5.3
5.3

クライアントについて

UNITED STATESのフラグ
Kennesaw, United States
5.0
24
お支払い方法確認済み
メンバー登録日:4月 15, 2008

クライアント確認

ありがとうございます!無料クレジットを受け取るリンクをメールしました。
メールを送信中に問題が発生しました。もう一度お試しください。
登録ユーザー 投稿された仕事の合計
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
プレビューを読み込み中
位置情報へのアクセスが許可されました。
あなたのログインセッションの有効期限がきれ、ログアウトされました。もう一度ログインしてください。