Advertisement
Strider64

pdo_blog_functions.php

Sep 15th, 2017
301
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.40 KB | None | 0 0
  1. <?php
  2.  
  3. use Library\Database\Database as DB;
  4.  
  5. function getUserInfo() {
  6.     $db = DB::getInstance();
  7.     $pdo = $db->getConnection(); // I am assuming you know how to write a PDO connection string:
  8.     $query = 'SELECT id, username, full_name, security_level, private FROM users';
  9.     $stmt = $pdo->prepare($query);
  10.     $stmt->execute();
  11.     $data = $stmt->fetchAll(PDO::FETCH_ASSOC);
  12.     return $data;
  13. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement