Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- require_once('dbconnect.php');
- $productLine = (isset($_GET['product-line']))? $_GET['product-line']: 'Motorcycles';
- $sql = "SELECT productCode, productName, productVendor, productLine";
- $sql .= " FROM products";
- $sql .= " WHERE productLine LIKE :line";
- $stmt = $conn->prepare($sql);
- $stmt->execute([':line' => "%{$productLine}%"]);
- $result = $stmt->fetchAll(PDO::FETCH_ASSOC);
- header('Content-Type: application/json');
- echo json_encode($result);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement