Closed

PHP Job Board APIs save to MySQL

• 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

NOTE: existing api calls/code already exists for these job boards: see: https://github.com/jobapis

Skills: JSON, MySQL, PHP

See more: job board php auction, job board php auction joomla reverse, job board php script, php feed xml save mysql, simple php message board uses php mysql, browsing xls php save mysql database example, php job board example, php mysql ajax job board script, php ajax job board, php job board scrape, php mysql create job board, php mysql create job board scratch, php mysql job board, best php job board, php job board reviews, php job board search joomla, open source php job board script

About the Employer:
( 10 reviews ) Mechanicsburg, United States

Project ID: #17763927

17 freelancers are bidding on average $305 for this job

A2Design

Hello! We are A2 Design, a Russian-Canadian web development company. We are very interested in developing your project and will be glad to assist you. We provide the whole package: project manager, front-end develo More

$350 USD in 3 days
(110 Reviews)
8.6
extreamcode

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: h More

$155 USD in 3 days
(73 Reviews)
7.5
iquallinfo

Hello , I have read your project post description regarding write PHP script for job board API and saved it into MySQL database. I am available to work with you on this project. Please share details in message so we More

$250 USD in 3 days
(124 Reviews)
7.2
bestit4u

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 s More

$155 USD in 3 days
(75 Reviews)
6.7
coolrankit

--6YEARS EXPERIENCED PHP, MySQL, WORDPRESS, HTML5, CSS, WEB & MOBILE APP DEVELOPING EXPERT-- Hi, I just gone through your requirements, I can achieve these with perfection. I am confident about my quality work & More

$500 USD in 10 days
(44 Reviews)
6.0
amitpandeyposin

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
(47 Reviews)
5.7
Programmer59

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 wa More

$250 USD in 7 days
(41 Reviews)
5.5
leemilun

Thank you for posting. I have read your post carefully. I have many experiences about the similar project with your post. And also my skill is talented. If you need, i can show you my success project sources. Plea More

$155 USD in 3 days
(18 Reviews)
4.5
mayankinnovative

Dear Client, We are expertise in php, core php, CMS, HTML5, CSS3, bootstrap, WordPress, OpenCart, Magento, PSD to HTML, Angular JS, Node JS photoshop, OPencart, Codeignitor, Laravel and many other technologies. We have More

$250 USD in 7 days
(76 Reviews)
4.4
Vedtechnology

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. More

$1500 USD in 11 days
(43 Reviews)
4.3
julienmoutier

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
(13 Reviews)
4.2
dzheng0206

Hi, I'm interested in your job post. Because I am an experienced professional who has been working with Web Project for over 3 years. So, I have no matter in any project. Please send me your requirement. As you can More

$200 USD in 3 days
(14 Reviews)
4.2
Codiggin

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 More

$148 USD in 5 days
(5 Reviews)
3.8
Apurva510

Hello, Hope you are doing well. I have analysed your job requirements for a PHP developer >> I have extensive expertise in PHP framework, Core PHP, Cake PHP, Codeigniter, Zend, Yii, Mysql, Jquery, JS, HTML a More

$155 USD in 3 days
(3 Reviews)
3.0
nguyentam

Hello, I'm a professional programmer for web programming with php language to build the system website, Besides, I'm also expert in MySQL , HTML,HTML5,CSS, JS I'm always top in Vietnam freelancer [login to view URL] More

$155 USD in 3 days
(1 Review)
2.5
ewr4fd4r3435re

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
(0 Reviews)
0.0
$155 USD in 3 days
(0 Reviews)
0.0