[RESOLVED] Reading an API result

Dudaa

I want to enter into my database the results I get from an external api. The results are in the format: date(comma)IP(comma)interger(space) etc as show in the example below. The last four digits of the IP returned are always .XXX for security.

2010-04-14,208.120.29.XXX,16822 2010-04-14,207.255.139.XXX,4933389 2010-04-14,75.138.118.XXX,837202 2010-04-14,74.103.14.XXX,55335 2010-04-13,207.255.139.XXX,5095034 2010-04-13,98.202.1.XXX,739088 2010-04-13,74.103.14.XXX,220200 2010-04-12,141.165.135.XXX,7574145 2010-04-11,141.165.135.XXX,4858152

I not really sure how to do this but was thinking something like explod the space and then a foreach list($time,$ip,$amount) or something.

then do something like

INSERT INTO table_name ('date', 'ip' , 'amount') VALUES ('date', 'ip', 'amount');

for each of them.

Any advice on how to do this or go about it, as my PHP knowledge is really basic, would be greatly appreciated.

Thanks in advance.

laserlight

That sounds like a plan, as in explode on space, and then for each element in the resulting array, explode on comma and assign to list($time, $ip, $amount).

Dudaa

Thanks laserlight, so this is what I have so far but it's entering blank data into the database.

$url=file("http://api.expmple.com?data=valuelogs&login=$login&password=$pass");

$temp = explode(' ', $url);
    foreach($temp as $data)
    {
        $data = list($time,$ip,$amount) = explode(',',$temp);
		$res = mysql_query("INSERT INTO vip_logs (time,ip,amount) VALUES ('$time','$ip','$amount')") or die(mysql_error());
    }
    unset($temp);

Do you've any idea where I'm making the mistake or any suggestions?

laserlight

That makes it look like the format also consists of lines. If so, something like this might work:

$lines = file("http://api.expmple.com?data=valuelogs&login=$login&password=$pass");
foreach ($lines as $line)
{
    foreach (explode(' ', $line) as $data)
    {
        list($time, $ip, $amount) = explode(',', $data);
        $sql = sprintf("INSERT INTO vip_logs (time, ip, amount) VALUES('&#37;s', '%s', %d)",
            mysql_real_escape_string($time),
            mysql_real_escape_string($ip),
            $amount);
        mysql_query($sql);
    }
}

Dudaa

It worked 😃

Thanks you so much laserlight. Really applicate it. That would have taken me days to figure out.