1. 連接數據庫：

$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database";
$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
die("連接失敗: " . $conn->connect_error);
}

2. 查詢數據庫：

$sql = "SELECT * FROM table_name";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
while($row = $result->fetch_assoc()) {
echo "字段1: " . $row["column1"]. " - 字段2: " . $row["column2"]. "
";
}
} else {
echo "0 結果";
}

3. 插入數據到數據庫：

$sql = "INSERT INTO table_name (column1, column2, column3)
VALUES ('value1', 'value2', 'value3')";
if ($conn->query($sql) === TRUE) {
echo "新記錄插入成功";
} else {
echo "Error: " . $sql . "
" . $conn->error;
}

4. 更新數據庫中的數據：

$sql = "UPDATE table_name SET column1='new_value' WHERE condition";
if ($conn->query($sql) === TRUE) {
echo "記錄更新成功";
} else {
echo "Error: " . $sql . "
" . $conn->error;
}

5. 刪除數據庫中的數據：

$sql = "DELETE FROM table_name WHERE condition";
if ($conn->query($sql) === TRUE) {
echo "記錄刪除成功";
} else {
echo "Error: " . $sql . "
" . $conn->error;
}

6. 獲取當前日期和時間：

$currentDateTime = date('Y-m-d H:i:s');
echo $currentDateTime;

7. 獲取客戶端IP地址：

$ip = $_SERVER['REMOTE_ADDR'];
echo $ip;

8. 文件上傳：

$target_dir = "uploads/";
$target_file = $target_dir . basename($_FILES["fileToUpload"]["name"]);
if (move_uploaded_file($_FILES["fileToUpload"]["tmp_name"], $target_file)) {
echo "文件上傳成功";
} else {
echo "文件上傳失敗";
}

9. 發送電子郵件：

$to = "recipient@example.com";
$subject = "郵件主題";
$message = "郵件內容";
$headers = "From: sender@example.com" . "\r\n" .
"Reply-To: sender@example.com" . "\r\n" .
"X-Mailer: PHP/" . phpversion();
if (mail($to, $subject, $message, $headers)) {
echo "郵件發送成功";
} else {
echo "郵件發送失敗";
}