Advertisement
Guest User

qweq

a guest
Jul 18th, 2017
72
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.69 KB | None | 0 0
  1. <?php
  2.  
  3. function db_connect()
  4. {
  5. $dsn = 'mysql:host=localhost; dbname=shop';
  6. $user = 'root';
  7. $password = '';
  8. $db = new PDO($dsn, $user, $password);
  9. $db->exec('SET CHARACTER SET utf8');
  10.  
  11. return $db;
  12. }
  13.  
  14. $connection = db_connect();
  15. $count = 3;
  16.  
  17. $sql = 'SELECT id, name, price, is_new FROM product WHERE status = 1';
  18.  
  19. $result = $connection->prepare($sql);
  20. $result->setFetchMode(PDO::FETCH_ASSOC);
  21. $result->execute();
  22.  
  23. $productList = [];
  24.  
  25. foreach ($result->fetchAll() as $elem) {
  26.  
  27. $productList['id'] = $elem->id;
  28. $productList['name'] = $elem->name;
  29.  
  30.  
  31.  
  32. }
  33.  
  34. var_dump($productList);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement