Default page

Your IP: 216.73.216.124
Server IP: 50.28.103.30
Server: Linux host.jcukjv-lwsites.com 4.18.0-553.22.1.el8_10.x86_64 #1 SMP Tue Sep 24 05:16:59 EDT 2024 x86_64
Server Software: nginx/1.28.0
PHP Version: 8.3.12
Buat File | Buat Folder

Dir : ~/www/wwwroot/ef.electronharmony.com/1/T5/

Edit File: submit_powerball.php

<?php
// 包含数据库配置文件
include 'db_config.php';

if ($_SERVER["REQUEST_METHOD"] == "POST") {
    // 获取表单输入
    $num1 = filter_input(INPUT_POST, 'num1', FILTER_VALIDATE_INT);
    $num2 = filter_input(INPUT_POST, 'num2', FILTER_VALIDATE_INT);
    $num3 = filter_input(INPUT_POST, 'num3', FILTER_VALIDATE_INT);
    $num4 = filter_input(INPUT_POST, 'num4', FILTER_VALIDATE_INT);
    $num5 = filter_input(INPUT_POST, 'num5', FILTER_VALIDATE_INT);
    $powerball = filter_input(INPUT_POST, 'powerball', FILTER_VALIDATE_INT);

// 自定义日期输入
    $custom_date_input = filter_input(INPUT_POST, 'custom_date', FILTER_SANITIZE_SPECIAL_CHARS);

// 转换日期为标准格式
    $custom_date = false;
    try {
        $date = new DateTime($custom_date_input);
        $custom_date = $date->format('Y-m-d'); // 转换为 YYYY-MM-DD 格式
    } catch (Exception $e) {
        // 日期格式无效
        echo "Invalid date format! Please enter a valid date.";
        exit;
    }

// 验证输入是否有效
    if (
        $num1 >= 1 && $num1 <= 69 &&
        $num2 >= 1 && $num2 <= 69 &&
        $num3 >= 1 && $num3 <= 69 &&
        $num4 >= 1 && $num4 <= 69 &&
        $num5 >= 1 && $num5 <= 69 &&
        $powerball >= 1 && $powerball <= 26 &&
        $custom_date
    ) {
        try {
            // 准备 SQL 语句
            $stmt = $conn->prepare("INSERT INTO powerball_entries (num1, num2, num3, num4, num5, powerball, custom_date) 
                                    VALUES (:num1, :num2, :num3, :num4, :num5, :powerball, :custom_date)");

// 绑定参数
            $stmt->bindParam(':num1', $num1, PDO::PARAM_INT);
            $stmt->bindParam(':num2', $num2, PDO::PARAM_INT);
            $stmt->bindParam(':num3', $num3, PDO::PARAM_INT);
            $stmt->bindParam(':num4', $num4, PDO::PARAM_INT);
            $stmt->bindParam(':num5', $num5, PDO::PARAM_INT);
            $stmt->bindParam(':powerball', $powerball, PDO::PARAM_INT);
            $stmt->bindParam(':custom_date', $custom_date, PDO::PARAM_STR);

// 执行 SQL
            $stmt->execute();
            header("Location: index.php");

echo "Powerball entry added successfully!";
        } catch (PDOException $e) {
            echo "Error: " . $e->getMessage();
        }
    } else {
        echo "Invalid input! Please ensure numbers are within the correct range and the date is valid.";
    }
}
?>