PHPize Online / SQLize Online  /  SQLtest Online

<?php $user_name = 'Floris'; $user_pass = 'abcd'; $previousLevels = [ 'bronze' => ['blue'], 'silver' => ['blue', 'bronze'], 'gold' => ['blue', 'bronze', 'silver'], 'diamond' => ['blue', 'bronze', 'silver', 'gold'], ]; $curLevel = 'gold'; // $previousLevelString = $previousLevels[$curLevel]; // Split the previous levels string into an array // $previousLevelsArray = explode(', ', $previousLevelString); $previousLevelsArray = $previousLevels[$curLevel]; // Database connection using PDO try { // Set PDO to throw exceptions on error $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); } catch (PDOException $e) { die("Connection failed: " . $e->getMessage()); } // Generate named placeholders for the IN clause $placeholders = array_map(function($index) { return ":prev_level_$index"; }, array_keys($previousLevelsArray)); // Prepare the SQL query with the dynamically generated named placeholders $query = "SELECT * FROM users WHERE current_level = :cur_level AND previous_level IN (".implode(', ', $placeholders).")"; // Prepare the query $stmt = $pdo->prepare($query); // Bind parameters $stmt->bindValue(':cur_level', $curLevel); foreach ($previousLevelsArray as $key => &$value) { $stmt->bindValue(":prev_level_$key", $value); } // Execute the query $stmt->execute(); // Fetch the result set $result = $stmt->fetchAll(PDO::FETCH_ASSOC); // Output each row foreach ($result as $row) { print_r($row); }