PHP code to import member data into ucenter_PHP tutorial

The member table structure we want to use

Copy code The code is as follows:

create table if not exists `net_111cnnet` (
`id` int(11) not null auto_increment,
`username` varchar(32) default null,
`add_time` int(11) default null,
`email` varchar(50) default null ,
`password` varchar(50) default null,
`last_login` int(4) default null
primary key (`id`)
) engine=myisam default charset=utf8 auto_increment=1 ;

Core code:

Copy code The code is as follows:

$host ='localhost ';
$db ='abc';
$user='root';
$password ='root';
//Database tutorial connection configuration, because my ucenter table is different from the current The membership table is in the same database, so just one connection is enough.

try {
$conn = mysql tutorial_connect($host,$user,$password);
mysql_select_db($db,$conn);
} catch (dbexception $e ) {
exit('database connect fail!');//Database error handling
}

$sql ="select * from net_111cnnet "; //Find out all the data to be imported to ucenter Member data
$query = mysql_query( $sql,$conn);
while( $rs = mysql_fetch_array( $query ))
{
$uc_sql = "select * from uc_members where username=' ".$rs['username']."'";
$data = mysql_query( $uc_sql ) ;
if( $data )
{

}
else
{
$salt = substr(uniqid(rand()), -6);
$password = md5($rs['password'].$salt);//Generate user login according to ucenter rules Password

mysql_query("insert into uc_members set uid= '".$rs['id']."', username='".$rs['username']."', password='$ password', email='".$rs['email']."', lastlogintime ='".$rs['last_login']."', regdate='".$rs['add_time']."' , salt='$salt'"); //Insert data into uc_members table
mysql_query("insert into uc_memberfields set uid='".$rs['id']."'"); //Update uc_memberfields surface.
}
}
exit('All users have been imported to ucenter');

Summary:
Import data to ucenter and forum, or other cms Users only need to operate two tables of ucenter, uc_members and uc_memberfields. There are not many fields involved in updating, so generally speaking, it is very simple to import its system data into ucenter for member synchronization.

http://www.bkjia.com/PHPjc/322247.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/322247.htmlTechArticleThe member table structure we want to use is copied as follows: create table if not exists `net_111cnnet` ( `id` int(11) not null auto_increment, `username` varchar(32) default null, `add...