不是啊,我只是觉得只是很简单的读取、插入,用不着贴出来啊。 我觉得这其中还是少了处理读出来的图片的一步。问题也就是该怎么处理<? require ("include/config.inc.php"); mysql_connect("$dbhost","$dbuser","$dbpasswd") or die("不能打开mysql,连接出错!"); mysql_select_db("$dbname"); $sql="select * from pro where id=17 order by proid desc"; $query =mysql_query("$sql")or die("query is error!"); $data = mysql_result($query,1,"IMG"); $type = mysql_result($query,1,"imgtype"); mssql_connect("DA","sa","") or die("不能打开mssql,连接出错!"); mssql_select_db("do"); $sql="insert into img (id,IMG,imgtype) values ('17','$data','$type')"; mssql_query("$sql")or die("insert is error!"); ?>
但结果是什么都没有插入。如果把$tmp改成字符串,则可以插入。还有,在insert前,我输出图片,结果是正确的。
我觉得这其中还是少了处理读出来的图片的一步。问题也就是该怎么处理<?
require ("include/config.inc.php");
mysql_connect("$dbhost","$dbuser","$dbpasswd") or die("不能打开mysql,连接出错!");
mysql_select_db("$dbname"); $sql="select * from pro where id=17 order by proid desc";
$query =mysql_query("$sql")or die("query is error!");
$data = mysql_result($query,1,"IMG");
$type = mysql_result($query,1,"imgtype"); mssql_connect("DA","sa","") or die("不能打开mssql,连接出错!");
mssql_select_db("do");
$sql="insert into img (id,IMG,imgtype) values ('17','$data','$type')";
mssql_query("$sql")or die("insert is error!");
?>