3v4l.org

run code in 300+ PHP versions simultaneously
<?php $_POST['CandidateID'] =987797631; $query = " SELECT w.WorkEligibilityInfoID,w.ApplicantID,e.ReverifyExpDate FROM CandidateApplicant As ca"; $query .= " JOIN WorkEligibilityInfo w"; $query .= " JOIN EmploymentEligibilityI9 e"; $query .= " ON ca.ApplicantID = w.ApplicantID"; $query .= " WHERE ca.CandidateID = " . $_POST['CandidateID']; $query .= " AND w.EmploymentEligibilityI9ID = e.EmploymentEligibilityI9ID"; $query .= " AND e.ReverifyExpDate is NOT NULL"; $query .= " AND e.ReverifyDocType > 0"; print_r($query);
Output for 7.1.0 - 7.1.20, 7.2.0 - 7.2.33, 7.3.16 - 7.3.33, 7.4.0 - 7.4.33, 8.0.0 - 8.0.30, 8.1.0 - 8.1.28, 8.2.0 - 8.2.18, 8.3.0 - 8.3.4, 8.3.6
SELECT w.WorkEligibilityInfoID,w.ApplicantID,e.ReverifyExpDate FROM CandidateApplicant As ca JOIN WorkEligibilityInfo w JOIN EmploymentEligibilityI9 e ON ca.ApplicantID = w.ApplicantID WHERE ca.CandidateID = 987797631 AND w.EmploymentEligibilityI9ID = e.EmploymentEligibilityI9ID AND e.ReverifyExpDate is NOT NULL AND e.ReverifyDocType > 0
Output for 8.3.5
Warning: PHP Startup: Unable to load dynamic library 'sodium.so' (tried: /usr/lib/php/8.3.5/modules/sodium.so (libsodium.so.23: cannot open shared object file: No such file or directory), /usr/lib/php/8.3.5/modules/sodium.so.so (/usr/lib/php/8.3.5/modules/sodium.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0 SELECT w.WorkEligibilityInfoID,w.ApplicantID,e.ReverifyExpDate FROM CandidateApplicant As ca JOIN WorkEligibilityInfo w JOIN EmploymentEligibilityI9 e ON ca.ApplicantID = w.ApplicantID WHERE ca.CandidateID = 987797631 AND w.EmploymentEligibilityI9ID = e.EmploymentEligibilityI9ID AND e.ReverifyExpDate is NOT NULL AND e.ReverifyDocType > 0

preferences:
171.39 ms | 402 KiB | 157 Q