setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING); $cursor = $db->prepare($sql); $cursor->execute($params); return $cursor; } if(isset($_GET['q'])) { $q = $_GET['q']; $params = ["%$q%"]; $sql = "SELECT * FROM country WHERE name LIKE ?"; } else { $q = ''; $params = []; $sql = 'SELECT * FROM country'; } $data = query($sql, $params)->fetchAll(); ?>
| = $row['name'] ?> | = $row['continent'] ?> | = $row['capital'] ?> |