Advertisement
irobust

PHP - Query Products from ClassicModels

Nov 29th, 2018
161
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.49 KB | None | 0 0
  1. <?php
  2.     require_once('dbconnect.php');
  3.  
  4.     $productLine = (isset($_GET['product-line']))? $_GET['product-line']: 'Motorcycles';
  5.  
  6.     $sql  = "SELECT productCode, productName, productVendor, productLine";
  7.     $sql .= " FROM products";
  8.     $sql .= " WHERE productLine LIKE :line";
  9.  
  10.     $stmt = $conn->prepare($sql);
  11.     $stmt->execute([':line' => "%{$productLine}%"]);
  12.  
  13.     $result = $stmt->fetchAll(PDO::FETCH_ASSOC);
  14.  
  15. header('Content-Type: application/json');
  16. echo json_encode($result);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement