MorganF icon

Simple private user page

MorganF | PRO | 03/29/15 12:30:36 AM UTC | 0 ⭐ | 2122 👁️ | Never ⏰ | []
PHP |

620 B

|

None

|

0 👍

/

0 👎

<?php
    
    session_start();
    
    $_SESSION['user_id'] = "2"; //THIS IS SET DURING LOGIN!
    
    if(!isset($_SESSION['user_id'])) { die("Not logged in!"); };
    
    $requested_user = $_GET['id'];
    
    $db = new PDO('mysql:host=localhost;dbname=testdb;charset=utf8', 'root', 'MyPassword');
    
    try {
        
        $stmt = $db->prepare("SELECT * FROM c_userpage WHERE id = ?");
        
        $stmt->execute(array($_SESSION['user_id']));
        
        $mydata = $stmt->fetch();
        
    } catch (Exception $e) {
        
        //error with mysql
        die();
        
    }
    
    echo "Hello! my name is {$mydata['username']}!\n";
    echo "About Me: {$mydata['custom_data']}";
    
?>

Comments