會員資料匯入uchome程式執行個體_PHP教程

會員資料匯入uchome程式執行個體

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

'mysql', true );
$uc_query = new DbQueryForMysql($uc_db);

} catch (DbException $e) {
// 資料庫出錯處理處
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完成");

?>

http://www.bkjia.com/PHPjc/445014.htmlwww.bkjia.comtruehttp://www.bkjia.com/PHPjc/445014.htmlTechArticle會員資料匯入uchome程式執行個體 ?php try { $uc_db = new DataSource(UC_DBHOST , UC_DBUSER , UC_DBPW , UC_DBNAME, 'mysql', true ); $uc_query = new DbQueryForMysql($uc_db); } cat...

