Advertisement
MorganF

Simple private user page

Mar 28th, 2015
1,911
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.62 KB | None | 0 0
  1. <?php
  2.    
  3.     session_start();
  4.    
  5.     $_SESSION['user_id'] = "2"; //THIS IS SET DURING LOGIN!
  6.    
  7.     if(!isset($_SESSION['user_id'])) { die("Not logged in!"); };
  8.    
  9.     $requested_user = $_GET['id'];
  10.    
  11.     $db = new PDO('mysql:host=localhost;dbname=testdb;charset=utf8', 'root', 'MyPassword');
  12.    
  13.     try {
  14.        
  15.         $stmt = $db->prepare("SELECT * FROM c_userpage WHERE id = ?");
  16.        
  17.         $stmt->execute(array($_SESSION['user_id']));
  18.        
  19.         $mydata = $stmt->fetch();
  20.        
  21.     } catch (Exception $e) {
  22.        
  23.         //error with mysql
  24.         die();
  25.        
  26.     }
  27.    
  28.     echo "Hello! my name is {$mydata['username']}!\n";
  29.     echo "About Me: {$mydata['custom_data']}";
  30.    
  31. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement