寻求PHP脚本开发协助：随机数生成与数据库循环查询逻辑

Got it, let's build this script step by step—since you already have the individual pieces down, we just need to tie them together with a loop that keeps running until we hit our target status.

Core Logic Breakdown #

• We'll use an infinite loop (with a safety escape option) to repeat the random ID generation and database check
• Leverage PDO for secure database interactions (no SQL injection risks)
• Add clear feedback so you can track what the script is doing at each step
• Include a fallback for cases where the random ID doesn't exist in the database

Complete Working Script #

<?php
// First, set up your database connection (update these values to match your DB)
$dbHost = 'your_db_host';
$dbName = 'your_db_name';
$dbUser = 'your_db_username';
$dbPass = 'your_db_password';

try {
    // Initialize PDO connection (safer than mysqli for prepared statements)
    $pdo = new PDO("mysql:host=$dbHost;dbname=$dbName;charset=utf8mb4", $dbUser, $dbPass);
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch (PDOException $e) {
    die("Failed to connect to database: " . $e->getMessage());
}

// Optional: Add a max attempt limit to avoid infinite loops (just in case all records are status 1)
$maxAttempts = 200;
$attemptCount = 0;

// Loop until we find a status 0 record or hit max attempts
while ($attemptCount < $maxAttempts) {
    $attemptCount++;
    
    // Step 1: Generate secure random number between 1-100
    $randomId = random_int(1, 100);
    echo "Attempt $attemptCount: Checking record ID $randomId\n";

    // Step 2 & 3: Fetch the status for this ID
    $stmt = $pdo->prepare("SELECT status FROM your_table_name WHERE id = ?");
    $stmt->execute([$randomId]);
    $record = $stmt->fetch(PDO::FETCH_ASSOC);

    // Handle cases where no record exists for the random ID
    if (!$record) {
        echo "No record found for ID $randomId—skipping to next attempt\n";
        continue;
    }

    $status = $record['status'];

    // Step 4: Act based on status value
    if ($status === 0) {
        echo "Success! Found record ID $randomId with status 0.\n";
        
        // Replace this block with your "specified operation"
        echo "Executing your custom operation now...\n";
        // Example operation: Update the record or trigger an action
        // $updateStmt = $pdo->prepare("UPDATE your_table_name SET processed = 1 WHERE id = ?");
        // $updateStmt->execute([$randomId]);

        echo "Operation completed. Exiting script.\n";
        exit;
    } else {
        echo "Record ID $randomId has status 1—repeating loop\n";
    }
}

// If we exit the loop without finding status 0
echo "Max attempts ($maxAttempts) reached without finding a status 0 record. Exiting.\n";
?>

Key Tips for Production Use #

• Security: Never skip prepared statements (like we used here) — concatenating the random ID directly into the query would open you up to SQL injection attacks.
• Loop Safety: The $maxAttempts variable is crucial to prevent an infinite loop if all 1-100 records happen to have status 1. Adjust the number based on your needs.
• Randomness: random_int() is preferred over rand() because it’s cryptographically secure. If you’re stuck on PHP <7.0, use mt_rand(1,100) instead.

内容的提问来源于stack exchange，提问作者Richard