推薦9個常用的php代碼

173次閱讀

共計 1452 個字符，預計需要花費 4 分鐘才能閱讀完成。

連接數據庫：

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

查詢數據庫：

$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 結果";}

插入數據到數據庫：

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

更新數據庫中的數據：

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

刪除數據庫中的數據：

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

獲取當前日期和時間：

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

獲取客戶端 IP 地址：

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

文件上傳：

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

發送電子郵件：

$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 "郵件發送失敗";}

丸趣 TV 網 – 提供最優質的資源集合！

正文完