不显示用户名

Question

I'm trying to display username (cocname), but nothing happened. Do you see why? there is no error but the username is missing also and "Hello" is not displayed.Thank you.

<?php
session_start();
include_once 'config.php';
$prepend = "<span class='cocname'>";
$append = "</span>";
if (!isset($_SESSION['email'])) {
header("Location: signin.php");
}
$query = "SELECT cocname FROM users WHERE email=".$_SESSION['email'];
$result = $connect->query($query);
if ($result->num_rows > 0) {
while($row = $result->fetch_assoc())
    {
        echo $prepend."Hello ".$row['cocname'].$append;
    }

}
?>

Answer 1

Well you need to use sessions here. For all the pages where you need login to work. Add this statement.

session_start();

Now, add session_start(); as the first line of your login page. Update your login page as below.

if ($result->num_rows > 0) 
{
//user logged in
$_SESSION['logged'] =1;
$_SESSION['email']=$user;
//now since this would only return 1 result, you don't need to use a white loop.
 $user_details = $result->fetch_assoc();
}

Read more :- http://www.w3schools.com/php/php_sessions.asp