sql / php查询设置变量的值[关闭]

I have a table called "users" which has columns 'username', 'password' and 'permission'. In the permission column is either 'browse' or 'edit'. Say I have a user logged into my site, I want to select select their permission using their username (which I have stored in a session variable). I want to then set a variable equal to either 'browse' or 'edit' based on their permission, to then use in further logic.

Assuming I have connected to and selected the appropriate database I am pretty sure the php code and query should go something like:

 $u = $_SESSION['username'] ;
 $sql = "SELECT permission FROM users WHERE username = '$u' " ;
 $result = mysqli_query($sql);

But Im unsure how to then set a variable equal to 'browse' or 'edit' accordingly.

Any ideas?

Say you have a connection $con, for using session you have to start your session.

$u = $_SESSION['username'] ;
$sql = "SELECT `permission` FROM `users` WHERE username='$u'";
$result = mysqli_query($con, $sql);
$rows = mysqli_fetch_object($result);

//now its time to set the permission to the variable
echo $permission = $rows->permission;
mysqli_close($con);

you can also set the $permission to a $_SESSION.

$_SESSION['permission'] = $permission;

You have to do it like this:

$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "myDB";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
} 
$u = $_SESSION['username'] ;
$sql = "SELECT `permission` FROM `users` WHERE username='$u'";
$result = mysqli_query($conn, $sql);
$rows = mysqli_fetch_object($result);

//now its time to set the permission to the variable
echo $permission = $rows->permission;
mysqli_close($conn);