Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- function db_connect()
- {
- $dsn = 'mysql:host=localhost; dbname=shop';
- $user = 'root';
- $password = '';
- $db = new PDO($dsn, $user, $password);
- $db->exec('SET CHARACTER SET utf8');
- return $db;
- }
- $connection = db_connect();
- $count = 3;
- $sql = 'SELECT id, name, price, is_new FROM product WHERE status = 1';
- $result = $connection->prepare($sql);
- $result->setFetchMode(PDO::FETCH_ASSOC);
- $result->execute();
- $productList = [];
- foreach ($result->fetchAll() as $elem) {
- $productList['id'] = $elem->id;
- $productList['name'] = $elem->name;
- }
- var_dump($productList);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement