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() .
"
");
?>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
