Swift 2 - 使用PHP在数据库中插入设备令牌

Question

EDIT: I'm developing an iOS application, which uses a webview, that has push notification and I'm trying to pass the device token to a php file (sampleIndex.php) for database registration.

My attempt on posting the device token isn't working. Here's the code:

EDIT (2): My current code is based from @mat 's answer (same concept, but cleaner)

extension NSData {
func hexString() -> String {
    // "Array" of all bytes:
    let bytes = UnsafeBufferPointer<UInt8>(start: UnsafePointer(self.bytes), count:self.length)
    // Array of hex strings, one for each byte:
    let hexBytes = bytes.map { String(format: "%02hhx", $0) }
    // Concatenate all hex strings:
    return (hexBytes).joinWithSeparator("")
  }

}


func application(application: UIApplication, didRegisterForRemoteNotificationsWithDeviceToken deviceToken: NSData) {

    let session = NSURLSession.sharedSession()
    let tk = deviceToken.hexString()
    let postBody = NSString(format: "token=%@", tk)
    let endBody = NSURL(string: "http://samplesite.com/subfolder/subfolder2/sampleIndex.php")
    let request = NSMutableURLRequest(URL: endBody!, cachePolicy: NSURLRequestCachePolicy.ReloadIgnoringLocalCacheData, timeoutInterval: 30.0)
    request.HTTPMethod = "POST";
    request.HTTPBody = postBody.dataUsingEncoding(NSUTF8StringEncoding)
    request.setValue("application/x-www-form-urlencoded", forHTTPHeaderField: "Content-Type")
    let dataTask = session.dataTaskWithRequest(request) { (data:NSData?, response:NSURLResponse?, error:NSError?) -> Void in

        if data != nil {

            print("data: \(response)")

        } else {

            print("failed: \(error!.localizedDescription)")

        }

    }//closure

    dataTask.resume()
}

Why can't I get the value of tk? (token device). Am I missing something? Sorry, I'm just new to this.

EDIT (3) Here's the php code (sampleIndex.php) where the token is being requested:

<?php 
  include_once("includes/myConnect.php");
  $token = $_REQUEST['token'];

if (empty($token)) {
  $sql = "UPDATE sampleDB . sampleTB SET token= '0' WHERE id='8982'";
  $result = mysqli_query($conn, $sql);
}else{
  $sql = "UPDATE sampleDB . sampleTB SET token= '1' WHERE id='8982'";
  $result = mysqli_query($conn, $sql);
}

?>

(token sets to value " 0 " which proves that the device token fails to be passed on sampleIndex.php)

Answer 1

First make sure that you don't get the following error "failed: The resource could not be loaded because the App Transport Security policy requires the use of a secure connection" if you do, add this to your plist:

The following code works for me. I have just changed the postBody and URL to answer your question but doing that I am able to save the token to my database.

extension NSData {
func hexString() -> String {
    // "Array" of all bytes:
    let bytes = UnsafeBufferPointer<UInt8>(start: UnsafePointer(self.bytes), count:self.length)
    // Array of hex strings, one for each byte:
    let hexBytes = bytes.map { String(format: "%02hhx", $0) }
    // Concatenate all hex strings:
    return (hexBytes).joinWithSeparator("")
  }

}


@UIApplicationMain


class AppDelegate: UIResponder, UIApplicationDelegate {

var window: UIWindow?


func application(application: UIApplication, didFinishLaunchingWithOptions launchOptions: [NSObject: AnyObject]?) -> Bool {
    // Override point for customization after application launch.


    //request notification
    let type: UIUserNotificationType = [UIUserNotificationType.Badge, UIUserNotificationType.Alert, UIUserNotificationType.Sound];
    let setting = UIUserNotificationSettings(forTypes: type, categories: nil);
    UIApplication.sharedApplication().registerUserNotificationSettings(setting);
    //register for remote notification - push notification
    UIApplication.sharedApplication().registerForRemoteNotifications();

    return true
}

fun application(application: UIApplication, didRegisterForRemoteNotificationsWithDeviceToken deviceToken: NSData) {

 let session = NSURLSession.sharedSession()
 let userId = "12345" // not sure you have a userId at this point but you can remove that line and also remove it from postBody
 let tk = deviceToken.hexString()
 let postBody = NSString(format: "user=%@&token=%@", userId, tk)
 let endBody = NSURL(string: "http://www.sampleurl.com/sampleIndex.php")
 let request = NSMutableURLRequest(URL: endBody!, cachePolicy: NSURLRequestCachePolicy.ReloadIgnoringLocalCacheData, timeoutInterval: 30.0)
 request.HTTPMethod = "POST";
 request.HTTPBody = postBody.dataUsingEncoding(NSUTF8StringEncoding)
                                                    request.setValue("application/x-www-form-urlencoded", forHTTPHeaderField: "Content-Type")
     let dataTask = session.dataTaskWithRequest(request) { (data:NSData?, response:NSURLResponse?, error:NSError?) -> Void in

         if data != nil {

          print("data: \(response)")

           } else {

           print("failed: \(error!.localizedDescription)")

           }

       }//closure

       dataTask.resume()
}

To insert the token in the database I strongly suggest you to use prepare statement. I use OOP Php so I have a class Database that handle all the connections but I simplified the code:

sampleIndex.php

<?php 

$userid = $_REQUEST['user'];
$token = $_REQUEST['token'];

    if (empty($userid) || empty($token)) {
    return;
}else{

    saveTokenToDatabase($userid, $token);
}


function saveTokenToDatabase($user, $token){

    $username = 'youDatabaseUsername';
    $password =  'yourPassword';

$dbh = new PDO('mysql:host=localhost;dbname=database_name', $username, $password);

// first verify if the token is already in the database 
$sth = $dbh->prepare("SELECT token 
        FROM user_tokens 
        WHERE user_id = ? 
          AND token = ? LIMIT 1");

$sth->bindParam(1, $user, PDO::PARAM_INT);
$sth->bindParam(2, $token, PDO::PARAM_STR);
$sth->execute();
$tokenExists = ($sth->fetchColumn() > 0) ? true : false;

//if token is not already there 
if(!$tokenExists){

$now = date("Y-m-d H:i:s");
$query = $dbh->prepare("INSERT INTO user_tokens (user_id, token, datecreated)  VALUES(?,?,'".$now."')");
$query->bindParam(1, $user, PDO::PARAM_INT);
$query->bindParam(2, $token, PDO::PARAM_STR);       
$query->execute();

// determine if token already exists
}
    //close the connection 
    $dbh = null;
}