PHP API Mysql url

Asked Oct 14 '15 at 15:23

Active Oct 14 '15 at 17:09

Viewed 48 times

I am using the PHP API to get count information of images with their URL from other hosts updated to my database.

How can I fix the following error:

PHP Notice:  Undefined variable: c in /var/www/xxx_api.php on line 40
It failed to send query? SQL:UPDATE items SET count =   WHERE url="http://xx/img/beauty.jpg"

Line 40 is here:

   $sql = 'UPDATE items SET count = '.$c.'  WHERE url ="'.$p.'"';

This is the full code:

   while ($row = mysql_fetch_assoc($result)) {

    $p = $row["url"];

    $c = file_get_contents('http://xxxxx.jp/app/api/count?`
url='.rawurlencode($p));

    $sql = 'UPDATE items SET count = '.$c.'  WHERE url ="'.$p.'"';

    $result = mysql_query($sql, $link) or die("It failed to send query?<br `
/>SQL:".$sql);

}

edited Oct 14 '15 at 17:09

CodeMouse92

6,840
14
73
130

asked Oct 14 '15 at 15:23

2015

`file_get_contents()` returns no value. Are you sure you can access other domains using `file_get_contents()` with your hosting? – Sirko Oct 14 '15 at 15:25
Here is into my hosting =>$p = $row["url"]; – 2015 Oct 14 '15 at 15:33
Your code is vulnerable to SQL injection. – Boann Oct 15 '15 at 00:10
@Boann How can i improve that code and fix that can you help me ?? – 2015 Oct 15 '15 at 07:50
Thanks everyone , I was able to resolve their ！！ – 2015 Oct 15 '15 at 13:56

PHP API Mysql url

0 Answers0