Advertisement
Guest User

Untitled

a guest
Sep 21st, 2017
76
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.83 KB | None | 0 0
  1. <?php
  2.  
  3. $host = 'localhost';
  4. $db = 'myDB';
  5. $user = 'myUser';
  6. $pass = 'myPass';
  7. $charset = 'utf8';
  8.  
  9. $dsn = "mysql:host=$host;dbname=$db;charset=$charset";
  10. $opt = [
  11. PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
  12. PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
  13. PDO::ATTR_EMULATE_PREPARES => false,
  14. ];
  15.  
  16. $pdo = new PDO($dsn, $user, $pass, $opt);
  17.  
  18. $response = array();
  19.  
  20. $result = $pdo->query("SELECT * FROM c068t_k2_items where catid = 6");
  21. $response["items"] = array();
  22. while ($row = $stmt->fetch()) {
  23. $product = array();
  24. $product["id"] = $row["id"];
  25. $product["title"] = $row["title"];
  26. $product["catid"] = $row["catid"];
  27. $product["published"] = $row["published"];
  28. $product["introtext"] = $row["introtext"];
  29. array_push($response["items"], $product);
  30. }
  31. $response["success"] = 1;
  32. echo json_encode($response);
  33.  
  34. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement