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


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

Keahlian: JSON, MySQL, PHP

Lihat lebih lanjut: 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

Tentang Pemberi kerja:
( 10 ulasan ) Mechanicsburg, United States

ID Proyek: #17763927

16 freelancer menawar dengan rata-rata $315 untuk pekerjaan ini


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 Lebih banyak

$350 USD dalam 3 hari
(110 Ulasan)

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 Lebih banyak

$155 USD dalam 3 hari
(75 Ulasan)

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 Lebih banyak

$250 USD dalam 3 hari
(127 Ulasan)

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 Lebih banyak

$155 USD dalam 3 hari
(78 Ulasan)

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 dalam 8 hari
(58 Ulasan)

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 Lebih banyak

$250 USD dalam 7 hari
(43 Ulasan)

--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 & Lebih banyak

$500 USD dalam 10 hari
(44 Ulasan)

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 Lebih banyak

$155 USD dalam 3 hari
(26 Ulasan)

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 Lebih banyak

$200 USD dalam 3 hari
(21 Ulasan)

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. Lebih banyak

$1500 USD dalam 11 hari
(45 Ulasan)

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 dalam 1 hari
(14 Ulasan)

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 Lebih banyak

$250 USD dalam 7 hari
(76 Ulasan)

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 Lebih banyak

$148 USD dalam 5 hari
(8 Ulasan)

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 Lebih banyak

$155 USD dalam 3 hari
(4 Ulasan)

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 dalam 3 hari
(1 Ulasan)
$155 USD dalam 3 hari
(0 Ulasan)