36行 $query = "INSERT INTO crm(name,old,sex,addr) values('$name','$old','$sex','$addr')"; mysql_query($query); 如果ASSESS中的字段都不为空,则可以顺利的导入到MYSQL中,但是我把其中的任一字段设为空就提示“Catchable fatal error: Object of class variant could not be converted to string in ...\asstomysql.php on line 36”
$conn = @new com("ADODB.Connection") or die("ADO连接创造失败"); $connstr = "Provider=MSDASQL.1;Data Source=asstomysql"; $conn->open($connstr); $rs = @new com("ADODB.RecordSet") or die("ADO记录集创建失败"); $db = "SELECT * FROM stu"; $rs->Open($db,$conn,1,1); $conn = mysql_connect("localhost","root","") or die("连接主机失败"); mysql_select_db("aaa") or die("打开数据库失败");//循环取出,插入到MYSQL数据表的相应字段中! $i=0;while(!$rs->eof) { $name=$rs->Fields[1]; $old=$rs->Fields[3]; $sex=$rs->Fields[2]; $addr=$rs->Fields[4];
$name=$rs->Fields[1];
$old=$rs->Fields[3];
$sex=$rs->Fields[2];
$addr=$rs->Fields[4];
36行 $query = "INSERT INTO crm(name,old,sex,addr) values('$name','$old','$sex','$addr')";
mysql_query($query);
如果ASSESS中的字段都不为空,则可以顺利的导入到MYSQL中,但是我把其中的任一字段设为空就提示“Catchable fatal error: Object of class variant could not be converted to string in ...\asstomysql.php on line 36”
$connstr = "Provider=MSDASQL.1;Data Source=asstomysql";
$conn->open($connstr);
$rs = @new com("ADODB.RecordSet") or die("ADO记录集创建失败");
$db = "SELECT * FROM stu";
$rs->Open($db,$conn,1,1);
$conn = mysql_connect("localhost","root","") or die("连接主机失败");
mysql_select_db("aaa") or die("打开数据库失败");//循环取出,插入到MYSQL数据表的相应字段中!
$i=0;while(!$rs->eof)
{
$name=$rs->Fields[1];
$old=$rs->Fields[3];
$sex=$rs->Fields[2];
$addr=$rs->Fields[4];
36行 $query = "INSERT INTO crm(name,old,sex,addr) values('$name','$old','$sex','$addr')";
mysql_query($query);
echo $query . "<br>";
mysql_query($query) or die(mysql_error());
$i++;
$rs->MoveNext();
}
echo "完成".$i;
?>上面是完整的代码,其实我也是从网上找的