curl image into mysql.

[email protected] ("richard lee")
Newsgroups php.db
Message-ID <[email protected]>
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() . 
"
");

?>
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.