note 130065 added to refs.database

<?php $search = isset($_GET['search']) ? trim($_GET['search']) : ""; $query = "SELECT * FROM products"; if (!empty($search)) { $query .= " WHERE productName LIKE :search"; } $stmt = $conn->prepare($query); if (!empty($search)) { $stmt->bindValue(':search', "%" . $search . "%", PDO::PARAM_STR); } $stmt->execute(); $result = $stmt->fetchAll(PDO::FETCH_ASSOC); ?> ---- Server IP: 45.112.84.4 Probable Submitter: 80.90.5.137 (proxied: 193.170.70.27) ---- Manual Page -- https://php.net/manual/en/refs.database.php Edit -- https://main.php.net/note/edit/130065 Del: integrated -- https://main.php.net/note/delete/130065/integrated Del: useless -- https://main.php.net/note/delete/130065/useless Del: bad code -- https://main.php.net/note/delete/130065/bad+code Del: spam -- https://main.php.net/note/delete/130065/spam Del: non-english -- https://main.php.net/note/delete/130065/non-english Del: in docs -- https://main.php.net/note/delete/130065/in+docs Del: other reasons-- https://main.php.net/note/delete/130065 Reject -- https://main.php.net/note/reject/130065 Search -- https://main.php.net/manage/user-notes.php