ucenter数据库

// 示例配置
$db_host = 'localhost';
$db_user = 'ucenter_db_user';
$db_pass = 'ucenter_db_password';
$db_name = 'ucenter_db';

// 示例认证代码
$user = $_POST['username'];
$pass = md5($_POST['password']);

$sql = "SELECT * FROM uc_user WHERE username = '$user' AND password = '$pass'";
$result = mysqli_query($conn, $sql);

if (mysqli_num_rows($result) > 0) {
    echo "认证成功";
} else {
    echo "认证失败";
}

// 示例同步脚本
$source_db_host = 'source_db_host';
$source_db_user = 'source_db_user';
$source_db_pass = 'source_db_password';
$source_db_name = 'source_db_name';

$target_db_host = 'target_db_host';
$target_db_user = 'target_db_user';
$target_db_pass = 'target_db_password';
$target_db_name = 'target_db_name';

// 连接源数据库和目标数据库
$source_conn = mysqli_connect($source_db_host, $source_db_user, $source_db_pass, $source_db_name);
$target_conn = mysqli_connect($target_db_host, $target_db_user, $target_db_pass, $target_db_name);

// 执行同步操作
$sql = "SELECT * FROM uc_user";
$result = mysqli_query($source_conn, $sql);

while ($row = mysqli_fetch_assoc($result)) {
    $insert_sql = "INSERT INTO uc_user (username, password) VALUES ('$row['username']', '$row['password']')";
    mysqli_query($target_conn, $insert_sql);
}

mysqli_close($source_conn);
mysqli_close($target_conn);