问创建带有页面的网站，以显示在线用户，包括用户名和图片

EN

//JAVASCRIPT
<script>
    $(document).ready(function() {
        setInterval(function() {
            $.post('Path To PHP File', {x : Pass Variables, y: If You Want}, function(res)
                //Do something with the result (res)
            );
        }, 5000);
    });
</script>

//PHP FILE
<?php
//If you passed any variables to the script:
$x = $_POST['x'];
$y = $_POST['y'];

//Connect to your database
$dbConn = "I hope you're using PDO for this.";

//Create your query
$sql = "SELECT * FROM users WHERE status=1";
$res = $dbConn->prepare($sql);
$res->execute();

//Return/echo results
foreach($res as $x) {
    echo "<div id='useTheIdToStyleTheResults'>".$x['name']."</div>";
}
?>

//Define Variables
$hostname = '127.0.0.1';
$username = 'userName';
$password = 'passWord';
$dbname = 'database in use';

//Create Connection
try {
    $con = new PDO("mysql:host=$hostname;dbname=$dbname",$username,$password);
    $con->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);
    //echo "Connected to database";  //Uncomment statement to the left to check for connection
} catch (PDOException $e) {
    print "Unable to connect: " . $e->getMessage();
    mysql_close($con);
    die();
}
?>