get data from database using curl and json

Question

Do any of you know a way to get datas from a database of a website? I already studied and made a program that POST data using json. It gets the shipment status of a certain tracking number and if it's shipped, it will be changed to delivered. And I already done that.

Now what I'm trying to do is get all the datas, or the row of that tracking number and then encode it to JSON. But I don't know what to do.

This is how I did the first program: on getting a specific tracking number and update the status to delivered.

<?php

$url='https://sample.com.ph';
$apikey='apikey';
$method ='SendPackageStatus';


    $data = array(
        'package'   => array(
             'tracking_number'  =>  '735898532',
             'package_status'    => 'delivered',
             'failed_reason'     => '',
             'updated_at'        => '2014-01-01 07:02:14'
         )
     );
     $check=json_encode($data);

     $postdata = "&data=$check&apikey=$apikey&method=$method";
     $ch = curl_init();

    curl_setopt_array(
        $ch,
        array(

            CURLOPT_URL => $url.'/webservice/',
            CURLOPT_SSL_VERIFYPEER => false,
            CURLOPT_FOLLOWLOCATION  => true,
            CURLOPT_VERBOSE         => true,
            CURLOPT_POST => 1,
        CURLOPT_POSTFIELDS      => $postdata,
        CURLOPT_RETURNTRANSFER => 1,
            CURLOPT_HTTPHEADER => array('Content-type:  application/x-www-form-urlencoded', 

            )
        )
    );


     $result = curl_exec($ch);
     curl_close($ch);
     echo $result;



?>

Jentel · Accepted Answer · 2014-01-30 06:43:25Z

1

Why not use mysql?... you can store json string on db (as..strings). I dont follow what you are trying to do.

answered Jan 30, 2014 at 6:43

Jentel

1542 silver badges19 bronze badges

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

4 Comments

nicole101 Over a year ago

I'm building an adapter. And what I would try to do is to connect the database of a website to the program, get the rows I needed and then pass it to another website's database. I tried POSTing first and I did it. Now I need to get the rows that I needed.

Jentel Over a year ago

you can connect to a remote database. thats not a problem. php.net/mysql_connect

nicole101 Over a year ago

then, I can connect to the database of that website? will I need passwords or something?

Jentel Over a year ago

of course.. database is confidential.. if you dont have its credentials, you wont be able to watch, add or change data inside of it.

Collectives™ on Stack Overflow

get data from database using curl and json

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related