function createNewUserProfile($userFBID, $userEmail, $userName, $lang = 'en') { //======= TESTED FINE ====== CHANGED+++++ $dbase = new MyDatabase(DBNAME, DBHOST, DBUSER, DBPASS); $dateRegistered = time(); // output integer number $datestampFull = date("m-d-Y", $dateRegistered); // output date string //---------------------------------------------- $query = "INSERT INTO breakers(socialid, mobile, country, name, username, email, profileimage, dateregistered, datenow, type, lang) VALUES('" . $userFBID . "', '', '', '{$userName}', '', '{$userEmail}', '', '{$dateRegistered}', now(), 'fb','{$lang}')"; $result = $dbase->_query($query); if ($result) { updateUserLatestActivityTime($dbase->_insertid()); $responseJSON = array("key" => "login", "response" => "success", "user_fb_id" => $userFBID, "breaker_id" => $dbase->_insertid(), "break_category_id" => "0", "breaker_category_name" => "", "upper_text" => "", "lower_text" => "", "text_image_path" => "", "plain_image_path" => "", "break_id" => "0", "message" => "User Registration successfull"); } else { $responseJSON = array("key" => "login", "response" => "failed", "message" => "Table breakers insert query error", "query" => $query); //giving JSON resopnse to App } giveResponseToApp($responseJSON); }