curl image into mysql.
| From: | richard lee | Date: | Sun, 23 Mar 2008 03:08:06 +0000 |
| Subject: | curl image into mysql. | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-44762@lists.php.net to get a copy of this message | ||
hi, i got a problem insert a image that downloaded into mysql database,
because when i echo $sqlCmd, it output $data in binary file, please help
thanks
<?php
require ('dbconf.inc.php');
$table="myTable";
makeConnection($dbHost, $dbUser, $dbPasswd);
$url = 'http://www.google.com/intl/en_ALL/images/logo.gif';
$curl_handler = curl_init();
curl_setopt($curl_handler, CURLOPT_URL, $url);
curl_setopt($curl_handler, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($curl_handler, CURLOPT_BINARYTRANSFER, 1); //return the transfer
in a binary format .
$data = curl_exec($curl_handler);
curl_close($curl_handler);
$sqlCmd ="INSERT INTO $table(pid,city,cat,title,info,img1)
values('10','mycity','apa','me','yo',$data)";
mysql_query("$sqlCmd", $link) or die(mysql_errno() . ": " . mysql_error() .
"
");
?>
