The error reported:
FATAL ERROR syntax error, unexpected 'is' (T_STRING), expecting ',' or ')' on line number 3
My code is below:
<?php
if(isset($_SESSION['id'])){
$id = $_SESSON['id'];
$sqlQuery = "SELECT * FROM * users WHERE id = :id";
$statement = $db->prepare($sqlQuery);
$statement->execute(array(':id' => $id));
while($rs = $statement->fetch()){
$username = $rs['username'];
$email = $rs['email'];
$date_joined = strftime("%b %d, %Y", strtotime($rs["join_date"]));
}
$encode_id = base64_encode("encodeuserid{$id}");
}
My aim is to catch fields from mySQL such as email
, username
, join_date
.