Ditutup

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

Kemahiran: JSON, MySQL, PHP

Lihat lagi: 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 Majikan:
( 10 ulasan ) Mechanicsburg, United States

ID Projek: #17763927

16 pekerja bebas membida secara purata $315 untuk pekerjaan ini

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 Lagi

$350 USD dalam 3 hari
(110 Ulasan)
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 Lagi

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

$250 USD dalam 3 hari
(127 Ulasan)
7.3
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 Lagi

$155 USD dalam 3 hari
(78 Ulasan)
6.7
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 dalam 8 hari
(58 Ulasan)
6.1
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 Lagi

$250 USD dalam 7 hari
(43 Ulasan)
5.9
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 & Lagi

$500 USD dalam 10 hari
(44 Ulasan)
6.0
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 Lagi

$155 USD dalam 3 hari
(26 Ulasan)
5.4
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 Lagi

$200 USD dalam 3 hari
(21 Ulasan)
5.0
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. Lagi

$1500 USD dalam 11 hari
(45 Ulasan)
4.4
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 dalam sehari
(14 Ulasan)
4.4
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 Lagi

$250 USD dalam 7 hari
(76 Ulasan)
4.4
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 Lagi

$148 USD dalam 5 hari
(8 Ulasan)
3.9
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 Lagi

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