会员データベース导入uhome程序实例
try {
$uc_db = new DataSource(UC_DBHOST , UC_DBUSER , UC_DBPW , UC_DBNAME,
'mysql', true );
$uc_query = new ql($uc_db) ;
} catch (DbException $e) {
// データ库出错处理处
exit('データベースサポートが必要');
}
$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完了");
?>