'128245333876633', 'secret' => 'f51afc7e04289db62448edd8b70d83bf', 'cookie' => true, 'domain' => 'yournextread.com' )); $session = $facebook->getSession(); if (!$session) { $proceed = false; $url = $facebook->getLoginUrl(array( 'canvas' => 1, 'fbconnect' => 0, 'req_perms' => 'email,user_birthday,publish_stream' )); echo ""; } else { //login user try { $uid = $facebook->getUser(); $me = $facebook->api('/me'); include "../../private/db.php"; $Email = $me['email']; $FirstName = $me['first_name']; $Surname = $me['last_name']; //echo $Email; $sql1="SELECT FirstName, Surname, DisplayName, UserID from user WHERE Email ='$Email'"; //echo $sql1; $result1=mysqli_query($link,$sql1); // If successfully queried if($result1){ $count=mysqli_num_rows($result1); if($count==0){ //User doesn't already exist $add="CALL addNewUser('$Email', 'facebook', '$FirstName', '$Surname', 0, '', 0)"; //echo $add; $result2 = mysqli_query($link, $add); //reset connection mysqli_close($link); include "../../private/db.php"; $sql3="SELECT FirstName, Surname, DisplayName, UserID from user WHERE Email ='$User'"; //echo $sql3; $resultFull=mysqli_query($link,$sql3); } else{ $resultFull = $result1; } if($resultFull){ //User Exists //echo "ResultFull!"; $line=mysqli_fetch_array($resultFull, MYSQLI_ASSOC); $firstName=$line['FirstName']; $surname=$line['Surname']; $displayName=$line['DisplayName']; $id=$line['UserID']; if($displayName == "") { if($firstName == "") $displayName=$Email; else $displayName = $firstName; } $_SESSION['displayName']=$displayName; $_SESSION['email']=$Email; $_SESSION['surname']=$surname; $_SESSION['UserID']=$id; $_SESSION['receiveEmail']=$receiveEmail; $_SESSION['GRState']=$GRState; $_SESSION['Loc']=$LocID; } } } catch (FacebookApiException $e) { error_log($e); } } } } echo ""; if($proceed) { echo ""; echo ""; echo ""; echo "Invite your Friends to YourNextRead!"; echo ""; echo ""; echo "
"; echo ""; echo " " ; } ?>