会员数据导入uchome程序实例

会员数据导入uchome程序实例

try {
 $uc_db = new DataSource(UC_DBHOST , UC_DBUSER , UC_DBPW , UC_DBNAME,

php, true );
 $uc_query = new DbQueryForMysql($uc_db);

} catch (DbException $e) {
 // php出错处理处
 exit(Database support needed);
}

$sql ="select * from 111cn_member ";
$Db = new Db();
$array = $Db->query($Db,0);

foreach( $array as $_v => $value)
 {
 $data = $Db->query("SELECT * FROM ".UC_DBTABLEPRE."members WHERE

username=".$rs[username]."");
 if($data) {
  $ucuserlist .="username:".$rs[username]." email:".$rs

[email]."rn";
 } else {
  $salt = substr(uniqid(rand()), -6);
  $password = md5($rs[passwd].$salt);
  
  $Db->query("INSERT INTO ".UC_DBTABLEPRE."members SET uid=

".$rs[id].", username=".$rs[username].", password=$password,

email=".$rs[email].", lastlogintime =".$rs[last_login].",

regdate=".$rs[add_time].", salt=$salt");
  $Db->query("INSERT INTO ".UC_DBTABLEPRE."memberfields SET

uid=".$rs[id]."");
 }
 
}
exit("用户导入Ucenter完成");

?>