Cancelled

Convert PHP script to MySQL Stored Procedure

Hello, I need help converting 2 PHP scripts into a MySQL stored procedure.

In a nutshell:

SCRIPT 1: [url removed, login to view]

1. The script reads from a the database to get a list of "EVENT_ID"s to update

2. For each of the EVENT_IDs, the script calls a STUBHUB API to retrieve latest TICKETs

3. The scripts reads the JSON result and writes the results to the database.

4. The script then calls a STUBHUB API to update the EVENT table with the lastest information

SCRIPT 2: [url removed, login to view]

1. This script reads the MYTICKETS table to identify tickets to update.

2. The script then updates the record with the latest run date for the EVENT_ID (Events Table) and the TICKET_ID (tickets table).

Skills: MySQL, PHP

See more: json calls, stored, php json , json script, json php, script event, php list json, php json list, need help php script, php api date, mysql help table, stored procedure list, php json mysql table, php json api, convert stored procedure, json api php, stubhub php script, mysql update table, convert json mysql database, php json mysql, database procedure, php api json, script php json, mysql api php, stored procedure php mysql

About the Employer:
( 4 reviews ) New York, United States

Project ID: #4449904

12 freelancers are bidding on average $187 for this job

toinnisfree

pls chk pmb

$262 USD in 3 days
(536 Reviews)
7.9
pan09

I am interested to work on this project

$231 USD in 6 days
(158 Reviews)
7.1
srinichal

I can deliver the project to your specs

$330 USD in 3 days
(81 Reviews)
6.9
leomedina01

Hi sir, building mysql stored procedures is not a issue for me, since I have lots of experience on this, however to access an API from MySQL, we will need to take some actions before. I have sent you a proposal and a More

$105 USD in 3 days
(53 Reviews)
5.8
seekdeveloper

Hi, Consider its done! I would love to get this opportunity of working with you. I can guarantee complete satisfaction if you select me to execute this project. Please check your private message board. Thanks

$216 USD in 3 days
(20 Reviews)
5.7
scriptphp87

Hello Please read more than private message thank you

$206 USD in 3 days
(41 Reviews)
5.6
kchg

Hello I'm interested with your project. I'll do it for you. Regards.

$185 USD in 5 days
(26 Reviews)
4.7
farhaoui

Hello, I have over 8 years experience in web developing. I can do this job. Please feel free to ask if you have any questions. Thank You

$147 USD in 3 days
(39 Reviews)
4.7
diamond1027

Hi, I am a expert of PHP and Mysql. I can start justnow. Regards.

$140 USD in 5 days
(22 Reviews)
4.5
ForeignTree

hello sir, We can convert your both scripts in Mysql stored procedures easily. Please provide the details. Thanks.

$93 USD in 2 days
(5 Reviews)
3.6
jdkavar

Php Experts are here....Please see your inbox...

$220 USD in 3 days
(2 Reviews)
3.0
ShrineWeb

plz chk pmb

$154 USD in 2 days
(9 Reviews)
2.7
Warrior8101

Please see my details. Thanks.

$105 USD in 2 days
(0 Reviews)
0.0
poojakalra

Six years of experience in software development with fortune 500 company. Ensure best quality and low turnaround time.

$187 USD in 3 days
(0 Reviews)
0.0
vpgrmer

I am interested in your project. This bid will include the creation of the stored procedure and the first run of data testing of the first run.

$154 USD in 2 days
(0 Reviews)
0.0