public function getUserInfo()
{
# Get the user id
$userId = Self::getUserId();
# the prepared statement
if ($sStmt = $this->mysqli->prepare("SELECT users.id, users_social.facebook, users_social.twitter, users_social.linkedin, \n users_social.website, users_social.instagram, users_info.firstname, users_info.lastname, \n users_info.lang, files.new_name, files_extensions.extension, users_info.job_title, users_info.mobile, \n users_info.about, users.username, users_info.page_slug\n FROM users_info\n LEFT JOIN users on users_info.users_id = users.id\n LEFT JOIN users_social on users_social.users_id = users.id\n LEFT JOIN files on users_info.img = files.id\n LEFT JOIN files_extensions on files.extension = files_extensions.id\n WHERE users.id = ?")) {
# bind
$sStmt->bind_param("i", $userId);
#execute
$sStmt->execute();
# bind result
$sStmt->bind_result($id, $facebook, $twitter, $linkedin, $website, $instagram, $firstname, $lastname, $lang, $new_name, $extension, $job_title, $mobile, $about, $username, $page_slug);
//fetch it
if ($sStmt->fetch()) {
$result = array('id' => $id, 'facebook' => $facebook, 'twitter' => $twitter, 'linkedin' => $linkedin, 'website' => $website, 'instagram' => $instagram, 'firstname' => $firstname, 'lastname' => $lastname, 'lang' => $lang, 'new_name' => $new_name, 'extension' => $extension, 'job_title' => $job_title, 'mobile' => $mobile, 'about' => $about, 'username' => $username, 'page_slug' => $page_slug);
}
// echo "<pre>";
// var_dump($result);
// exit;
return $result;
}
}
