alert("用户名不能为空！");';
}
if (!$password) {
echo '';
}
if ($username && $password) {
// 修改密码
$sql = "UPDATE ay_user SET password='" . md5(md5($password)) . "' where username='$username'";
if ($db['database']['type'] == 'sqlite' || $db['database']['type'] == 'pdo_sqlite') {
$conn = get_sqlite(__DIR__ . $db['database']['dbname']);
$result = $conn->exec($sql) or $conn->lastErrorMsg();
if ($conn->changes()) {
echo '';
echo '';
} else {
echo '';
}
} else {
$conn = get_mysql($db['database']);
$result = $conn->query($sql) or mysqli_error($conn);
if ($conn->affected_rows > 0) {
echo '';
echo '';
} else {
echo '';
}
}
}
}
// 连接数据库，接受数据库连接参数，返回数据库连接对象
function get_sqlite($dbfile)
{
if (extension_loaded('SQLite3')) {
try {
$conn = new SQLite3($dbfile);
$conn->busyTimeout(15 * 1000); // 设置繁忙延迟时间
} catch (Exception $e) {
die("读取数据库文件失败：" . iconv('gbk', 'utf-8', $e->getMessage()));
}
} else {
error('未检测到您服务器环境的SQLite3数据库扩展，请检查php.ini中是否已经开启该扩展！');
}
return $conn;
}
// 连接数据库，接受数据库连接参数，返回数据库连接对象
function get_mysql($cfg)
{
if (!extension_loaded('mysqli')) {
die('未检测到您服务器环境的mysqli数据库扩展，请检查php.ini中是否已经开启该扩展！');
}
// 优化>php5.3版本 在win2008以上服务器连接
if ($cfg['host'] == 'localhost') {
$cfg['host'] = '127.0.0.1';
}
$conn = @new Mysqli($cfg['host'], $cfg['user'], $cfg['passwd'], $cfg['dbname'], $cfg['dbport']);
if (mysqli_connect_errno()) {
die("连接数据库服务器失败：" . iconv('gbk', 'utf-8', mysqli_connect_error()));
}
$conn->set_charset('utf8'); // 设置编码
return $conn;
}
// 获取用户名
$sql = 'select username from ay_user';
if ($db['database']['type'] == 'sqlite' || $db['database']['type'] == 'pdo_sqlite') {
$conn = get_sqlite(__DIR__ . $db['database']['dbname']);
$result = $conn->query($sql) or $conn->lastErrorMsg();
$rows = array();
while (!!$row = $result->fetchArray(1)) {
if ($row) {
$out = new \stdClass();
foreach ($row as $key => $value) {
$out->$key = $value;
}
$row = $out;
}
$rows[] = $row;
}
} else {
$conn = get_mysql($db['database']);
$result = $conn->query($sql) or mysqli_error($conn);
$rows = array();
if ($conn->affected_rows > 0) {
while (!!$objects = $result->fetch_object()) {
$rows[] = $objects;
}
}
}
?>
PbootCMS - 密码重置