Find Jobs
Hire Freelancers

PHP Job Board APIs save to MySQL

$30-250 USD

Closed
Posted over 5 years ago

$30-250 USD

Paid on delivery
• MUST HAVE CLEAN (reasonably) documented PHP and MYSQL code! • Need .php 7 script written to pull from various Job Board APIs (plenty of source code examples on the web, many from job api providers themselves) and save results to mySQL • I’ll provide the mysql IP, username, password for your development; will already have tables and sprocs for you to use/refine • Job Boards needed (I will provide affiliate/user/auth key/ID for each as needed): o ZipRecruiter (already have working code, you just need to integrate it into your script) o Jobs2Careers o CareerBuilder o JuJu o SimplyHired o Jobs2Web o [login to view URL] - [login to view URL] • Once completed and I can see all works from mysql, zip up directory so that I can upload to my webserver and run ok. Tables provided 1. tapipull_runhistory 2. tapipull_jobs 3. tAPI_SearchTerms sprocs provided/to-be created 1. usp_jobs_apipull_getsearchterms 2. usp_jobs_apipull_begin 3. usp_jobs_apipull_addnewjobs 4. usp_jobs_apipull_end Steps 1. Via SPROC (that is already created named `usp_jobs_beginsearch`), Get Search Term (e.g., “Computer Programmer”), Search Location (e.g., “Dallas, TX” or “US”) + Posting Timeframe (e.g., last 3 days), Job APIs to Search (e.g., “ZipRecruiter, USA Jobs, careerjet”), and max_number_results (e.g., 150) 2. Record startdatetime, search_term_id, api_source in table `tapipull_runhistory` (table already created) using sproc (you need to create with name `usp_jobs_apipull_begin`) and return run_history_id (pkey that will be used to update with “enddatetime” at end of process) 3. Collect info from each api to search for that search term (up to max_number_results, may need to use api paging); add individual job records using a sproc (that you create with name `usp_jobs_apipull_addnewjobs`) into table `tapipull_jobs` (provided) 4. Using sproc that you create (to name `usp_jobs_apipull_end`) Update table `tapipull_runhistory` (from step #2) with enddatetime ,num_records_available, num_records_returned, machine_name (domain name where php script is run), software_version (hard-coded/variable into your php script, e.g., “1.0”), request_detail (the api url created for the pull); will use run_history_id as update pkey 5. Go to next api listed and loop back to step #2 above until all api’s have been pulled
Project ID: 17763927

About the project

14 proposals
Remote project
Active 5 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
14 freelancers are bidding on average $334 USD for this job
User Avatar
HI There, I can assist you with job board Api. I am very passionate about quality of my work, You will be pleased working with me. Let's have a quick chat to discuss it further. You can check my sample work at: https://www.freelancer.com/u/extreamcode.html
$155 USD in 3 days
4.9 (82 reviews)
7.6
7.6
User Avatar
Hi. I am very interested in your project, because I have much experience in such projects. I have good skills with the program language including C/C++, C#, java, php, asp.net, python, VB.NET. So I have expert and smart technic with web scraping (1000 over projects for scraping), automation and bot(500 over projects for automation and bot), selenium, mobile (android, ios native and others). Especially, I am an expert in betting project and gambling games and sites(bet365, bwin, pinnacle, betfair...) ,,, shopping auto buyer(adidas, footlocker, eastbay, supreme and etc) So, I can solve the captcha automatically. Please contact me, then we can discuss about the details and the price. And I am free in recent days, so I can do my best for your project. Thanks.
$155 USD in 3 days
4.9 (91 reviews)
6.9
6.9
User Avatar
Hello there, We are expert in Php and we have 7-year experience in JSON, MySQL, PHP. Please message us for detail discussion. We need to discuss in deep.
$500 USD in 8 days
4.8 (125 reviews)
7.1
7.1
User Avatar
Hello Sir, We are team of experts developers We have more than 10 year's experience. We read your project description and We are happy to work on this project also we are ready to discuss the project thank you I am waiting for your response We need some more information thank you Regards Jawad Ahmed
$250 USD in 7 days
4.8 (51 reviews)
6.0
6.0
User Avatar
I have gone through your requirements and would like to be considered to work on your projects. Having been in the Software Industry since a while, I have worked on websites previously for a variety of products. The technologies used for your projects will be PHP and MYSQL for the backend with HTML,CSS,jQuery and Bootstrap (to make the site responsive) serving as the frontend. Once the contract has been finalized, we’ll discuss timelines, further needs etc. I’m glad to answer any questions you may have! I am Good at JSON, MySQL, PHP. HiSteelersFan! Please Send me a message so that we can discuss more about this project. Looking forward to work on this project. PHP Job Board APIs save to MySQL
$1,500 USD in 11 days
4.9 (52 reviews)
5.1
5.1
User Avatar
Hi, i'm expert in API integration and available right now for your project. Feel free to contact me to discuss about it, it's doable quickly !
$155 USD in 1 day
4.9 (27 reviews)
5.1
5.1
User Avatar
Hi. how are you ? As a full stack web developer, i have very valuable experience for about 7 years. I can help you.
$155 USD in 3 days
4.9 (7 reviews)
3.9
3.9
User Avatar
Hi there, This is a job for me ! I am an absolute expert in Web Scraping (I know this is a bit different since we have official APIs but it's still sending HTTP requests and parsing HTTP responses into a database) I am a passionate web developper. I would do this job for fun but I still need to earn money. I am ready to start now and spend the night on it
$148 USD in 5 days
3.3 (12 reviews)
4.6
4.6

About the client

Flag of UNITED STATES
Mechanicsburg, United States
5.0
10
Payment method verified
Member since Jul 17, 2009

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.