Problem PHP with cURL

Question

hi i have a problem with cURL and php. I use an API and i want to display only the results. Here is my php + curl script

<?php
$file = "http://api.openkvk.nl/php/".rawurlencode("SELECT * FROM kvk WHERE kvks='20147376'");
$ch = curl_init();

// set URL and other appropriate options
curl_setopt($ch, CURLOPT_FOLLOWLOCATION, 1);
curl_setopt($ch, CURLOPT_URL, $file);
curl_setopt($ch, CURLOPT_HEADER, 0);

// grab URL and pass it to the browser
curl_exec($ch);

// close cURL resource, and free up system resources
curl_close($ch);
?>

and the result what i get is this:

array(
array("RESULT" => array(
 "TYPES"=>
    array(
        "int", "bigint", "varchar", "varchar", "varchar", "varchar", "varchar", "int", "int", "smallint", "smallint", "int"
    ),
 "HEADER"=>
    array("id", "kvk", "bedrijfsnaam", "adres", "postcode", "plaats", "type", "kvks", "sub", "bedrijfsnaam_size", "adres_size", "verhuisd"),
 "ROWS"=>
    array(
        array("1008714", "20147376", "Stichting OpenGeo", "Spinellihof 44", "4463GP", "Goes", "Rechtspersoon", "20147376", NULL, "17", "14", "0")
    )
 )));

What's the problem you are having?

Ikke
– Ikke

2010-03-24 12:49:32 +00:00
Commented Mar 24, 2010 at 12:49 — Ikke
– Ikke, Commented Mar 24, 2010 at 12:49
Clarify your question, what are you asking here?

Vicary
– Vicary

2012-12-07 06:36:17 +00:00
Commented Dec 7, 2012 at 6:36 — Vicary
– Vicary, Commented Dec 7, 2012 at 6:36

Silver Light · Accepted Answer · 2010-03-24 13:03:39Z

2

Your script outputs data, instead of returning it. Add this line:

curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);

And then assign curl_exec to some variable:

$result = curl_exec($ch);

It seems that API returns some META information, such as field types. If you don't need it, the just work with 'ROWS' element

print_r($result['ROWS']);

It will look like this:

array(
"1008714","20147376","Stichting OpenGeo","Spinellihof 44","4463GP","Goes","Rechtspersoon","20147376",NULL,"17","14","0"
)

You can iterate through it:

for($i=0; $i<count($result['ROWS']); $i++)
{
    echo $result['HEADER'][$i].': '.$result['ROWS'][$i].'<br />';
}

edited Mar 24, 2010 at 13:03

answered Mar 24, 2010 at 12:49

Silver Light

46.3k36 gold badges126 silver badges165 bronze badges

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

2 Comments

Pekka Over a year ago

@djairo we can't know, it's up to you what you'll do with the data isn't it? Or is $result["ROWS"] not what you want?

x4tje Over a year ago

Hello, we tried it but it prints an 'a' if i do a > var_dump($result['ROWS']); it give me > string(1) "a"

Collectives™ on Stack Overflow

Problem PHP with cURL

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related