Closed

Quick and easy php / json job

I’m not a programmer. So, although this will probably take somebody 10 minutes, it’s over my head.

Basically, I’ve got the code below that downloads account balances from a test account and puts a multidimensional json array into a variable named $obj. (A printout of the data can be seen here: [login to view URL] )

I need someone to write in the lines of code to poplulate/update the fields named ticker, balance, and numshares in the table named “Balances” from the json data using php.

It’s a very small job, but there will be many more to follow. I need an on-going relationship for a bunch of similar jobs.

I’ll release the escrow within 5 minutes of receipt of the completion of the script below.

Thanks and I look forward to working with you!

Todd

//get balance data from bittrex api

$apikey='fc6e38f667114a7cbda1cb6d5f9331f2';

$apisecret='WILLPROVIDEUPONHIRING';

$nonce=time();

$uri='[login to view URL]'.$apikey.'&nonce='.$nonce;

$sign=hash_hmac('sha512',$uri,$apisecret);

$ch = curl_init($uri);

curl_setopt($ch, CURLOPT_HTTPHEADER, array('apisign:'.$sign));

$execResult = curl_exec($ch);

$obj = json_decode($execResult);

//Connect to my database

$mysql_host = 'localhost';

$mysql_user = 'stk1639_todd';

$mysql_pass = 'WILLPROVIDEUPONHIRING';

$mysql_db = 'stk1639_Crypto';

if (!mysql_connect($mysql_host,$mysql_user,$mysql_pass)||!mysql_select_db($mysql_db)){

die (mysql_error());

}

//I guess use a foreach on a $obj to parse the array into the balance table. I got stuck here and need your help, lol!

.

Skills: Javascript, JSON, MySQL, PHP

See more: easy web design job, easy php tracker system, php distance job, easy php website, php based job tracking, easy php forms, php cron job weekly automail group, quick secure php mysql fast, quick easy job info, quick easy job outsourcing, quick scripting php job, quick easy job, ratemyteacher clone easy php mysql job, easy php job, php learn php programming quick & easy

About the Employer:
( 0 reviews ) Navarre, United States

Project ID: #16258540

35 freelancers are bidding on average $76 for this job

rajeshsonisl

Hello Todd, I can get this complete in a few minutes. Just need CPanel access to your server. I have a 99% project completion rate and a 4.99 reputation (out of 5.0 from over a thousand projects. Thanks. Rega More

$35 USD in 0 days
(950 Reviews)
8.5
A2Design

Hello, We are a team of 30 developers based in Russia. If you you need help with: - Website/web application/e-commerce development (any complexity) from scratch or using a premade solution - Front-end and back-en More

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

Hi Todd, I'll be glad yo help you so shoot me a message then. Regards, Amr

$50 USD in 1 day
(99 Reviews)
7.0
tzo

$30 USD in 1 day
(243 Reviews)
6.8
superman1987417

Greetings. Thank you for your job posting. I'm a php/mysql expert and serious bidder. I studied your requirements and understood clearly. I need the code that parse the json and store in db. I already made the cod More

$55 USD in 1 day
(59 Reviews)
6.8
$155 USD in 3 days
(80 Reviews)
6.8
mekiho

Lol!. Hi, Dear Employer! I have worked with json before times and I'm expert handling like this job. Before time I have done json project using recurie. Please contact me so that I could discuss on this project in More

$200 USD in 3 days
(68 Reviews)
6.6
csajit

I am interested in this project. I can populate ticker, balance, and numshares in the table named “Balances” from the json data using php. Having 10+ years of experience in PHP/MYSQL Looking for a long term rel More

$35 USD in 1 day
(279 Reviews)
6.8
pixahex

Hi Todd, you're right, we need a loop to iterate over json data and I can help you with that :) With Love, Maulik

$30 USD in 1 day
(16 Reviews)
6.4
flyoverwebdev

Hello Todd, I would like to build the required PHP code in order to update the table with the results. Thanks, Alex

$35 USD in 1 day
(64 Reviews)
6.1
$155 USD in 3 days
(67 Reviews)
6.3
shijudasan

hi I am a php full stack dev As u said a for loop is necessary to iterate but before we need to make the json into a format iteratable. I would like to do this job quick and easy , The only thing that I need to compl More

$30 USD in 0 days
(29 Reviews)
6.0
abderrahimouakki

Hi I can do this job doe you quickly . contact me via chat to discuss more . I'm a professional php developer .

$45 USD in 0 days
(41 Reviews)
5.8
sharwan47

Hello, Me and my wife work together as full time freelancer, she is a web & graphic [login to view URL] we can take care of both [login to view URL] and Development. I am a passionate, qualified and experienced Web developer an More

$111 USD in 3 days
(20 Reviews)
5.7
monamangal280

Hi I am an experienced PHP developer. I will help you in fixing the issue where you stuck. I am sure you will appreciate my help., Thanks

$83 USD in 1 day
(74 Reviews)
5.7
kazimking

Hello Sir, hope you are fine, i am ready to parse your json i already did similar work in previous here is solution $obj = json_decode($data,'true'); foreach($obj['result'] as $content){ print_r($conte More

$50 USD in 0 days
(39 Reviews)
5.2
hirewordpress

Hi Todd, I have very good expertise with php ,node.js I will do the required function

$100 USD in 2 days
(10 Reviews)
5.2
$30 USD in 1 day
(35 Reviews)
5.1
AutomationAdept

Hello! This is indeed a very simple project. It's just a matter of extracting the variables you want from the JSON object, and using mysqli to add them to a mysql table. I can get this done for you within 10 minutes More

$50 USD in 1 day
(18 Reviews)
4.8
hjvasoya

Hello, I'm well Qualified & Professional Web Developer having 5 years of experience in developing quality Websites that are very much active in the market today. My knowledge, technical skills and attributes lies More

$35 USD in 1 day
(43 Reviews)
4.8