Update Mysql from Curl using php

Question

I have a php curl script

$ch = curl_init();
$fp = fopen("cache/temp_file.txt", "w");
curl_setopt($ch, CURLOPT_POST, 1);
curl_setopt($ch, CURLOPT_URL, "https://upload.wistia.com" );
curl_setopt($ch, CURLOPT_POSTFIELDS, $data);    
curl_setopt($ch, CURLOPT_PROGRESSFUNCTION, 'progressCallback');
curl_setopt($ch, CURLOPT_BUFFERSIZE, (1024*1024*512));
curl_setopt($ch, CURLOPT_NOPROGRESS, FALSE);
curl_setopt($ch, CURLOPT_FAILONERROR, 1);
curl_setopt($ch, CURLOPT_FOLLOWLOCATION, 1);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($ch, CURLOPT_TIMEOUT, 15);
curl_setopt($ch, CURLOPT_USERAGENT, 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.13) Gecko/20080311 Firefox/2.0.0.13');
$result = curl_exec($ch);
echo $result; 
fwrite($fp, $result);
curl_close($ch);
fclose($fp);

which returns a string

 $result={"id":5966875,"name":"php3il8M4","type":"Video","created":"2014-02-18T10:00:57+00:00","updated":"2014-02-18T10:00:57+00:00","duration":10.29,"hashed_id":"772ecmi61h","description":"","progress":0.0,"status":"queued","thumbnail":{"url":"http://embed.wistia.com/deliveries/a351871a559000f83c39f3e84b33a491c5e5224a.jpg?image_crop_resized=100x60&video_still_time=5","width":100,"height":60}}

I would like to only write to mysql the value after the "name":" eg. php3il8M4

And update my mysql db eg

 UPDATE $table SET code='$name' WHERE id=$id

I'm not sure what is the best way to do this.

Abhik Chakraborty · Accepted Answer · 2014-02-18 10:10:00Z

4

You can use as

$data = json_decode($result,true);
$name = $data["name"];

Here $name will contain the name and you can use it in the query

answered Feb 18, 2014 at 10:10

Abhik Chakraborty

44.9k6 gold badges56 silver badges63 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

zzlalani Over a year ago

cannot believe it.. o_O

zzlalani Over a year ago

you were the first ;)

Abhik Chakraborty Over a year ago

I would say sensitive mind think alike since GREAT is a very heavy weighted word for me :)

Collectives™ on Stack Overflow

Update Mysql from Curl using php

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related