enter php code to import member data to ucenter

The member table structure we want to use

Copy the codeThe 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 codeThe code is as follows:

$host ='localhost';
$db ='abc ';
$user='root';
$password ='root';
//Database tutorial connection configuration, since my ucenter table and the current membership table are in the same database, 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 member data to be imported to ucenter
$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);//Follow ucenter rules Generate user login 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 the uc_members table
mysql_query("insert into uc_memberfields set uid='".$rs['id']."'"); //Update the uc_memberfields table.
}
}
exit('All users have been imported to ucenter');

Summary:
To import data into ucenter and forum, or other cms users only need to operate the two tables of ucenter, uc_members, 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.

The above introduces the code of enter php to import member data into ucenter, including the enter content. I hope it will be helpful to friends who are interested in PHP tutorials.