直接执行即可批量导入。
代码如下:
<?php
/**
* 密码转换
*/
require_once 'globals.php';
$User_Model = new User_Model();
$db = mysql_connect('localhost','root','') or die ('error to link!');
mysql_select_db('ayshop',$db) or die(mysql_error($db));
$query='SELECT *
FROM `ayit_trans`
ORDER BY `ayit_trans`.`name` ASC ';
$result = mysql_query($query,$db) or die(mysql_error($db));
while($row = mysql_fetch_assoc($result)){
extract($row);
echo 'sucess of:'.$name.'_'.$pass.'_'.$rou.'<br/>';
$login = $name;
$password = $pass;
$role = $rou;
$PHPASS = new PasswordHash(8, true);
$password = $PHPASS->HashPassword($password);
$User_Model->addUser($login, $password, $role);
$CACHE->updateCache(array('sta','user'));
//emDirect('./user.php?active_add=true');
}
echo '<font color=red>Hi_net is so naive ,But you insert data to mysql sucessful !</font><br/>';
echo '<a href="../">back to ayshop</a>';
?>