<?php

// 示例代码：数据库连接配置

$servername = "localhost";

$username = "root";

$password = "";

$dbname = "online_service";

// 创建连接

$conn = new mysqli($servername, $username, $password, $dbname);

// 检测连接

if ($conn->connect_error) {

die("Connection failed: " . $conn->connect_error);

}

echo "Connected successfully";

// 示例代码：用户注册功能

function registerUser($name, $email, $password) {

global $conn;

$hashed_password = password_hash($password, PASSWORD_DEFAULT);

$sql = "INSERT INTO users (name, email, password) VALUES ('$name', '$email', '$hashed_password')";

if ($conn->query($sql) === TRUE) {

echo "New record created successfully";

} else {

echo "Error: " . $sql . "<br>" . $conn->error;

}

}

// 示例代码：查询用户信息

function getUserInfo($email) {

global $conn;

$sql = "SELECT * FROM users WHERE email = '$email'";

$result = $conn->query($sql);

if ($result->num_rows > 0) {

while($row = $result->fetch_assoc()) {

echo "Name: " . $row["name"]. " - Email: " . $row["email"]. "<br>";

}

} else {

echo "0 results";

}

}

?>