PHPize Online / SQLize Online  /  SQLtest Online

<?php $user_id = 2; $lastName = "gigi_ln_2"; $firstName = "gigi_fn_2"; $created_at = "2025-01-02 09:10"; $sql = "SELECT * FROM Persons"; $condition = ''; $conditionParameters = array(); if (isset($user_id) && ($user_id != '')) { $condition .= "AND Persons.PersonID = ? "; $conditionParameters[] = $user_id; } if (isset($lastName) && ($lastName != '')) { $condition .= "AND Persons.LastName LIKE ? "; $conditionParameters[] = "%".$lastName."%"; } if (isset($firstName) && ($firstName != '')) { $condition .= "AND Persons.FirstName LIKE ? "; $conditionParameters[] = "%".$firstName."%"; } if (isset($created_at) && ($created_at != '')) { $condition .= "AND TIMESTAMPDIFF(SECOND, Persons.CreatedAt, ?) < 0 "; $conditionParameters[] = date("Y-m-d H:i", time()); } if (strlen($condition) > 0) { $condition = " WHERE " . substr($condition, 3); } $sql .= $condition." ORDER BY Persons.PersonID DESC"; $parameters = array(); foreach ($conditionParameters as $param) { $parameters[] = $param; } print($sql); print_r($parameters); $stmt = $pdo->prepare($sql); $stmt->execute($parameters); $rs = $stmt->fetchAll(PDO::FETCH_ASSOC); print($stmt->debugDumpParams()); print_r($rs);